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个回答

InnoDB相关参数

innodb_additional_mem_pool_size=3M # InnoDB用于存储元数据信息的内存池大小,一般不需修改

innodb_flush_log_at_trx_commit =1 # 事务相关参数,如果值为1,则InnoDB在每次commit都会将事务日志写入磁盘(磁盘IO消耗较大),这样保证了完全的ACID特性。而如果设置为0,则表示事务日志写入内存log和内存log写入磁盘的频率都为1次/秒。如果设为2则表示事务日志在每次commit都写入内存log,但内存log写入磁盘的频率为1次/秒。

innodb_log_buffer_size=2M # InnoDB日志数据缓冲大小,如果缓冲满了,就会将缓冲中的日志数据写入磁盘(flush)。由于一般至少都1秒钟会写一次磁盘,所以没必要设置过大,即使是长事务。

innodb_buffer_pool_size=105M # InnoDB使用缓冲池来缓存索引和行数据。该值设置的越大,则磁盘IO越少。一般将该值设为物理内存的80%。

innodb_log_file_size=53M # 每一个InnoDB事务日志的大小。一般设为innodb_buffer_pool_size的25%到100%

innodb_thread_concurrency=9 # InnoDB内核最大并发线程数

上网百度查“ The InnoDB memory heap is disabled”

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问