请教关于mysql....err的日志
以下是nxkcZ.err，请问一下这些报错如何处理？每重新启动一次就产生这些日志160412 10:21:58 /usr/local/mysql/bin/mysqld: Normal shutdown
160412 10:21:58 Event Scheduler: Purging the queue. 0 events
160412 10:22:00 /usr/local/mysql/bin/mysqld: Forcing close of thread 4user: 'root'
160412 10:22:00InnoDB: Starting shutdown...
160412 10:22:01InnoDB: Shutdown completed; log sequence number 1595675
160412 10:22:01 /usr/local/mysql/bin/mysqld: Shutdown complete
160412 10:22:01 mysqld_safe mysqld from pid file /home/data/mysql/iZ239ljpp3gZ.pid ended
160412 10:22:03 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql
160412 10:22:03 The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
160412 10:22:03 InnoDB: The InnoDB memory heap is disabled
160412 10:22:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160412 10:22:03 InnoDB: Compressed tables use zlib 1.2.3
160412 10:22:03 InnoDB: Initializing buffer pool, size = 16.0M
160412 10:22:03 InnoDB: Completed initialization of buffer pool
160412 10:22:03 InnoDB: highest supported file format is Barracuda.
160412 10:22:03InnoDB: Waiting for the background threads to start
160412 10:22:04 InnoDB: 5.5.42 started; log sequence number 1595675
160412 10:22:04 Server hostname (bind-address): '0.0.0.0'; port: 3306
160412 10:22:04 - '0.0.0.0' resolves to '0.0.0.0';
160412 10:22:04 Server socket created on IP: '0.0.0.0'.
160412 10:22:04 Event Scheduler: Loaded 0 events
160412 10:22:04 /usr/local/mysql/bin/mysqld: ready for connections.
Version: '5.5.42-log'socket: '/tmp/mysql.sock'port: 3306Source distribution
同时也修改了my.cnf中的
port = 3306
socket = /tmp/mysql.sock
datadir = /home/data/mysql
这里也添加了慢查询
long_query_time = 1
log-slow-queries = /home/data/mysql/mysql-slow.log
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /home/data/mysql
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /home/data/mysql
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50 which InnoDB
/usr/bin/which: no InnoDB in (/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin)
提示没有innoDB？ 日志没有问题
innodb是mysql存储引擎不是程序
页:
[1]