VPS侦探论坛

 找回密码
 注册
查看: 4005|回复: 2

请教关于mysql....err的日志

[复制链接]
发表于 2016-4-12 10:29:55 | 显示全部楼层 |阅读模式

以下是nxkcZ.err,请问一下这些报错如何处理?每重新启动一次就产生这些日志
  1. 160412 10:21:58 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

  2. 160412 10:21:58 [Note] Event Scheduler: Purging the queue. 0 events
  3. 160412 10:22:00 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 4  user: 'root'

  4. 160412 10:22:00  InnoDB: Starting shutdown...
  5. 160412 10:22:01  InnoDB: Shutdown completed; log sequence number 1595675
  6. 160412 10:22:01 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

  7. 160412 10:22:01 mysqld_safe mysqld from pid file /home/data/mysql/iZ239ljpp3gZ.pid ended
  8. 160412 10:22:03 mysqld_safe Starting mysqld daemon with databases from /home/data/mysql
  9. 160412 10:22:03 [Warning] 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.
  10. 160412 10:22:03 InnoDB: The InnoDB memory heap is disabled
  11. 160412 10:22:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
  12. 160412 10:22:03 InnoDB: Compressed tables use zlib 1.2.3
  13. 160412 10:22:03 InnoDB: Initializing buffer pool, size = 16.0M
  14. 160412 10:22:03 InnoDB: Completed initialization of buffer pool
  15. 160412 10:22:03 InnoDB: highest supported file format is Barracuda.
  16. 160412 10:22:03  InnoDB: Waiting for the background threads to start
  17. 160412 10:22:04 InnoDB: 5.5.42 started; log sequence number 1595675
  18. 160412 10:22:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
  19. 160412 10:22:04 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  20. 160412 10:22:04 [Note] Server socket created on IP: '0.0.0.0'.
  21. 160412 10:22:04 [Note] Event Scheduler: Loaded 0 events
  22. 160412 10:22:04 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
  23. Version: '5.5.42-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
复制代码


同时也修改了my.cnf中的
[mysqld]
port        = 3306
socket        = /tmp/mysql.sock
datadir = /home/data/mysql
这里也添加了慢查询
long_query_time = 1
log-slow-queries = /home/data/mysql/mysql-slow.log
  1. # Uncomment the following if you are using InnoDB tables
  2. innodb_data_home_dir = /home/data/mysql
  3. innodb_data_file_path = ibdata1:10M:autoextend
  4. innodb_log_group_home_dir = /home/data/mysql
  5. # You can set .._buffer_pool_size up to 50 - 80 %
  6. # of RAM but beware of setting memory usage too high
  7. innodb_buffer_pool_size = 16M
  8. innodb_additional_mem_pool_size = 2M
  9. # Set .._log_file_size to 25 % of buffer pool size
  10. innodb_log_file_size = 5M
  11. innodb_log_buffer_size = 8M
  12. innodb_flush_log_at_trx_commit = 1
  13. innodb_lock_wait_timeout = 50
复制代码

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有账号?注册

x
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
 楼主| 发表于 2016-4-12 10:35:17 | 显示全部楼层


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?
Linux下Nginx+MySQL+PHP自动安装工具:https://lnmp.org
发表于 2016-4-12 17:48:58 | 显示全部楼层

日志没有问题

innodb是mysql存储引擎不是程序
美国VPS推荐: 遨游主机LinodeLOCVPS主机云搬瓦工80VPSVultr美国VPS主机中国VPS推荐: 阿里云腾讯云。LNMP付费服务(代装/问题排查)QQ 503228080
您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|VPS侦探 ( 鲁ICP备16040043号-1 )

GMT+8, 2024-9-29 03:27 , Processed in 0.026522 second(s), 18 queries .

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

快速回复 返回顶部 返回列表