chenyinjin
chenyinjin
2015-04-30 06:59

MYSQL 在做查询表信息的时候数据库重启!!比较急,在线

  • 数据库

如下是日志,麻烦哪位大神帮忙下,谢谢

150430 14:03:09 mysqld_safe Starting mysqld daemon with databases from /data/mongo_dev/mysqldb
150430 14:03:09 InnoDB: The InnoDB memory heap is disabled
150430 14:03:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150430 14:03:09 InnoDB: Compressed tables use zlib 1.2.3
150430 14:03:09 InnoDB: CPU supports crc32 instructions
150430 14:03:09 InnoDB: Initializing buffer pool, size = 128.0M
150430 14:03:09 InnoDB: Completed initialization of buffer pool
150430 14:03:09 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150430 14:03:09 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
150430 14:03:09 InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
150430 14:03:09 InnoDB: File name ./test/net_mac_log_bak#P#p0.MYI
150430 14:03:09 InnoDB: File operation call: 'stat'.
InnoDB: Error: os_file_readdir_next_file() returned -1 in
InnoDB: directory ./test
InnoDB: Crash recovery may have failed for some .ibd files!
150430 14:03:09 InnoDB: Operating system error number 5 in a file operation.
InnoDB: Error number 5 means 'Input/output error'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
150430 14:03:09 InnoDB: File name ./mysql.sock
150430 14:03:09 InnoDB: File operation call: 'stat'.
InnoDB: Error: os_file_readdir_next_file() returned -1 in
InnoDB: directory .
InnoDB: Crash recovery may have failed for some .ibd files!
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
150430 14:03:10 InnoDB: 128 rollback segment(s) are active.
150430 14:03:10 InnoDB: Waiting for the background threads to start
150430 14:03:11 InnoDB: 1.2.4 started; log sequence number 109555758
Warning: World-writable config file './auto.cnf' is ignored
150430 14:03:11 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 94d0a4e5-eefe-11e4-9ea2-40f2e9631adc.
150430 14:03:11 [Note] Event Scheduler: Loaded 0 events
150430 14:03:11 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.4-m7' socket: '/data/mongo_dev/mysql.sock' port: 3306 Source distribution
150430 14:04:05 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

150430 14:04:05 [Note] Giving client threads a chance to die gracefully
150430 14:04:05 [Note] Event Scheduler: Purging the queue. 0 events
150430 14:04:05 [Note] Shutting down slave threads
150430 14:04:05 [Note] Forcefully disconnecting remaining clients
150430 14:04:05 [Note] Binlog end
150430 14:04:05 [Note] Shutting down plugin 'partition'
150430 14:04:05 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_FT_DELETED'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_FT_INSERTED'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_METRICS'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_CMPMEM'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_CMP_RESET'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_CMP'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_LOCKS'
150430 14:04:05 [Note] Shutting down plugin 'INNODB_TRX'
150430 14:04:05 [Note] Shutting down plugin 'InnoDB'
150430 14:04:05 InnoDB: FTS optimize thread exiting.
150430 14:04:05 InnoDB: Starting shutdown...
150430 14:04:05 InnoDB: Shutdown completed; log sequence number 109555768
150430 14:04:05 [Note] Shutting down plugin 'MEMORY'
150430 14:04:05 [Note] Shutting down plugin 'CSV'
150430 14:04:05 [Note] Shutting down plugin 'MyISAM'
150430 14:04:05 [Note] Shutting down plugin 'MRG_MYISAM'
150430 14:04:05 [Note] Shutting down plugin 'mysql_old_password'
150430 14:04:05 [Note] Shutting down plugin 'mysql_native_password'
150430 14:04:05 [Note] Shutting down plugin 'binlog'
150430 14:04:05 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

150430 14:04:05 mysqld_safe mysqld from pid file /data/mongo_dev/mysqldb/log01.pid ended
150430 14:04:06 mysqld_safe Starting mysqld daemon with databases from /data/mongo_dev/mysqldb
150430 14:04:06 InnoDB: The InnoDB memory heap is disabled
150430 14:04:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150430 14:04:06 InnoDB: Compressed tables use zlib 1.2.3
150430 14:04:06 InnoDB: CPU supports crc32 instructions
150430 14:04:06 InnoDB: Initializing buffer pool, size = 128.0M
150430 14:04:06 InnoDB: Completed initialization of buffer pool
150430 14:04:06 InnoDB: highest supported file format is Barracuda.
150430 14:04:06 InnoDB: 128 rollback segment(s) are active.
150430 14:04:06 InnoDB: 1.2.4 started; log sequence number 109555768
Warning: World-writable config file './auto.cnf' is ignored
150430 14:04:06 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: b5b184b2-eefe-11e4-9ea3-40f2e9631adc.
150430 14:04:06 [Note] Event Scheduler: Loaded 0 events
150430 14:04:06 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.6.4-m7' socket: '/data/mongo_dev/mysql.sock' port: 3306 Source distribution

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

2条回答

为你推荐