ÇÁ·Î±×·¡¹Ö
ù ÆäÀÌÁö ·£´ý ±Û ȸ¿ø°¡ÀÔ ·Î±×ÀÎ
ºñ°ø°³ ¼Õ´Ô ¡¦ 2015-06-09 23:54:37
URL https://te31.com/rgr/view.php?id=study&no=1266 ¸ð¹ÙÀÏ È­¸é
innoDB ½ÃÀÛÇÒ¶§¸¶´Ù ...

150609 18:48:05 [Note] InnoDB: The InnoDB memory heap is disabled
150609 18:48:05 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150609 18:48:05 [Note] InnoDB: Compressed tables use zlib 1.2.3
150609 18:48:05 [Note] InnoDB: Using Linux native AIO
150609 18:48:05 [Note] InnoDB: Using CPU crc32 instructions
150609 18:48:05 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150609 18:48:05 [Note] InnoDB: Completed initialization of buffer pool
150609 18:48:05 [Note] InnoDB: Highest supported file format is Barracuda.
150609 18:48:05 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1663111328882
150609 18:48:05 [Note] InnoDB: Database was not shutdown normally!
150609 18:48:05 [Note] InnoDB: Starting crash recovery.
150609 18:48:05 [Note] InnoDB: Reading tablespace information from the .ibd files...
150609 18:48:05 [Note] InnoDB: Restoring possible half-written data pages
150609 18:48:05 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1663116571648
InnoDB: Doing recovery: scanned up to log sequence number 1663121814528
InnoDB: Doing recovery: scanned up to log sequence number 1663127057408
InnoDB: Doing recovery: scanned up to log sequence number 1663130434955
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 955039 row operations to undo
InnoDB: Trx id counter is 16152968960
150609 18:48:06 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
150609 18:48:09 [Note] InnoDB: 128 rollback segment(s) are active.
InnoDB: Starting in background the rollback of uncommitted transactions
2015-06-09 18:48:09 7fe39fbff700  InnoDB: Rolling back trx with id 16146471558, 955039 rows to undo

InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76









ÀÌ·±½ÄÀ¸·Î Á¸³ª ¸®Ä¿¹ö¸®°°Àº°É Çϴµ¥¿ä.....ÀÌ°Å ¸øÇÏ°Ô ¸øÇϳª¿ä ½Ã¹ß Áö±Ý start ½ÃŲÁö 5½Ã°£ Áö³²..

Áú¹® | 1765¸íÀÌ Àоú¾î¿ä. 52.14.1.136

0
1 ºñ°ø°³ ¼Õ´Ô ¡¦ 2015-06-10 08:01:51
http://chepri.com/mysql-innodb-corruption-and-recovery/
2 ºñ°ø°³ ¼Õ´Ô ¡¦ 2015-06-11 18:55:57
1 ¿ª½Ã ÁøÁ¤ÇÑ ´É·ÂÀÚ ÄÚ¸Û´Ô
´ñ±ÛÀ» ÀÛ¼ºÇÏ½Ç ¼ö ¾ø½À´Ï´Ù.
(±ÇÇÑÀÌ ¾ø´Â ȸ¿ø·¹º§)
¸ñ·ÏÀ¸·Î
¡â ÀÌÀü±Û: mysql innoDB ¹é¾÷ ½ºÅ©¸³Æ®ÀÔ´Ï´Ù. [2]
¡ä ´ÙÀ½±Û: java poi excel download °ü·Ã Áú¹®µå¸³´Ï´Ù. [4]
ÀÌ¿ë¾à°ü | ±¤°í/Á¦ÈÞ | °³ÀÎÁ¤º¸Ãë±Þ¹æħ | ¹®ÀÇ/½Å°í | ¸ð¹ÙÀÏ TE31 | ¼­¹ö ºÎÇÏ : 14.5%
½Ç½Ã°£ Issue Ä¿¹Â´ÏƼ TE31 [¾ËÁö·Õ] ¨Ï 2002-2024
TOP arrow_upward