mysql ibdata1 损坏_ibdata1文件损坏时恢复InnoDB单表测试

1 zlm@192.168.56.100:3306 [sysbench]>exit2 Bye3

4 [root@zlm1 14:13:06 ~]5 #mysqladmin shutdown6

7 [root@zlm1 14:13:10 ~]8 #ps aux|grepmysqld9 root 4002 0.0 0.0 112640 960 pts/0 R+ 14:13 0:00 grep --color=auto mysqld10

11 [root@zlm1 14:13:15 ~]12 #./mysqld.sh

13

14 [root@zlm1 14:13:53 ~]15 #mysql16 ERROR 2003 (HY000): Can't connect to MySQL server on'192.168.56.100'(111)

17

18 [root@zlm1 14:13:56 ~]19 #mysql20 ERROR 2003 (HY000): Can't connect to MySQL server on'192.168.56.100'(111)

21

22 [root@zlm1 14:13:58 ~]23 #cd /data/mysql/mysql3306/data24

25 [root@zlm1 14:14:07 /data/mysql/mysql3306/data]26 #tailerror.log27 ... /Omitted.28 2018-08-05T12:13:53.242723Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled29 2018-08-05T12:13:53.242806Z 0 [Note] mysqld (mysqld 5.7.21-log) starting as process 4008...30 2018-08-05T12:13:53.249168Z 0[Note] InnoDB: PUNCH HOLE support available31 2018-08-05T12:13:53.249207Z 0[Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins32 2018-08-05T12:13:53.249213Z 0[Note] InnoDB: Uses event mutexes33 2018-08-05T12:13:53.249218Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used formemory barrier34 2018-08-05T12:13:53.249222Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3

35 2018-08-05T12:13:53.249227Z 0[Note] InnoDB: Using Linux native AIO36 2018-08-05T12:13:53.249426Z 0 [Note] InnoDB: Number of pools: 1

37 2018-08-05T12:13:53.249507Z 0[Note] InnoDB: Using CPU crc32 instructions38 2018-08-05T12:13:53.251488Z 0 [Note] InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size =100M39 2018-08-05T12:13:53.256630Z 0[Note] InnoDB: Completed initialization of buffer pool40 2018-08-05T12:13:53.257913Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the manpage of setpriority().41 2018-08-05T12:13:53.280321Z 0 [Note] InnoDB: Highest supported fileformat is Barracuda.42 12:13:53 UTC - mysqld got signal 11;43 This could be because you hit a bug. It is also possible that this binary44 or one of the libraries it was linked against is corrupt, improperly built,45 or misconfigured. This error can also be caused by malfunctioning hardware.46 Attempting to collect some information that could help diagnose the problem.47 As this is a crash and something is definitely wrong, the information48 collection process might fail.49

50 key_buffer_size=8388608

51 read_buffer_size=2097152

52 max_used_connections=0

53 max_threads=100

54 thread_count=0

55 connection_count=0

56 It is possible that mysqld could use up to57 key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 227127K bytes of memory58 Hope that's ok; if not, decrease some variables in the equation.

59

60 Thread pointer: 0x0

61 Attempting backtrace. You can use the following information to findout62 where mysqld died. If you see no messages after this, something went63 terribly wrong...64 stack_bottom = 0 thread_stack 0x30000

65 mysqld(my_print_stacktrace+0x35)[0xf4a495]66 mysqld(handle_fatal_signal+0x4a4)[0x7ce2f4]67 /lib64/libpthread.so.0(+0xf130)[0x7f6bbee76130]68 mysqld(_Z26page_cur_search_with_matchPK11buf_block_tPK12dict_index_tPK8dtuple_t15page_cur_mode_tPmS9_P10page_cur_tP8rtr_info+0x148)[0x1074478]69 mysqld(_Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_tmPKcmP5mtr_t+0x1598)[0x11806d8]70 mysqld(_Z30btr_pcur_open_on_user_rec_funcP12dict_index_tPK8dtuple_t15page_cur_mode_tmP10btr_pcur_tPKcmP5mtr_t+0x212)[0x1184b62]71 mysqld[0x11df28d]72 mysqld(_Z19dict_load_sys_tableP12dict_table_t+0x69)[0x11e0609]73 mysqld(_Z9dict_bootv+0xdfb)[0x11bf48b]74 mysqld(_Z34innobase_start_or_create_for_mysqlv+0x3212)[0x11150a2]75 mysqld[0x100023a]76 mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x51)[0x819721]77 mysqld[0xd39226]78 mysqld(_Z40plugin_register_builtin_and_init_core_sePiPPc+0x3e4)[0xd397a4]79 mysqld[0x7c48f7]80 mysqld(_Z11mysqld_mainiPPc+0x92f)[0x7c7e9f]81 /lib64/libc.so.6(__libc_start_main+0xf5)[0x7f6bbd857af5]82 mysqld[0x7be479]83 The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

84 information that should help you findout what is causing the crash.85

86 [root@zlm1 14:14:36 /data/mysql/mysql3306/data]87

88 //Okay,becasue of the lack of normal ibdata1 file in datadir,the instance cannot be started again.89 //Then,how can we resuce the data in target table 'sbtest4'?90 //First of all,let's get the ibd and frm file of it from the crashed server.