HTTP
AMH 社区首页
AMH社区 - 开放自由有价值的社区
|
|
|---|---|
|
wee |
wee 发表于 2014-12-27 18:51:23
最近这几天mysql server经常性当机shutdown，请高手帮忙看以下纪录。
请教如何解决或优化 mysql error 纪录 引用: 141227 01:20:52 mysqld_safe Number of processes running now: 0 141227 01:20:52 mysqld_safe mysqld restarted 141227 1:20:53 [Warning] You need to use --log-bin to make --binlog-format work. 141227 1:20:53 [Note] Plugin 'InnoDB' is disabled. 141227 1:20:53 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 141227 1:20:53 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 141227 1:20:53 [Note] Server socket created on IP: '0.0.0.0'. 141227 1:20:53 [Note] Event Scheduler: Loaded 0 events 141227 1:20:53 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution 141227 3:21:08 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 141227 3:21:08 [Note] Event Scheduler: Purging the queue. 0 events 141227 3:21:10 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 8 user: 'root' 141227 3:21:10 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 141227 03:21:10 mysqld_safe mysqld from pid file /usr/local/mysql/data/Domain.com.pid ended 141227 03:21:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 141227 3:21:11 [Warning] You need to use --log-bin to make --binlog-format work. 141227 3:21:11 [Note] Plugin 'InnoDB' is disabled. 141227 3:21:11 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 141227 3:21:11 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 141227 3:21:11 [Note] Server socket created on IP: '0.0.0.0'. 141227 3:21:11 [Note] Event Scheduler: Loaded 0 events 141227 3:21:11 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34' socket: '/tmp/mysql.sock' port: 3306 Source distribution my.cnf 設定 [client]
port = 3306 socket = /tmp/mysql.sock [mysqld] default-storage-engine = MyISAM innodb = OFF skip-innodb port = 3306 socket = /tmp/mysql.sock skip-external-locking key_buffer_size = 16M max_allowed_packet = 1M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M #log-bin = mysql-bin binlog_format = mixed server-id = 1 thread_concurrency = 4 [mysqldump] quick [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout  点赞，加油！ (0分)
2014-12-27 18:51:23 1
|
|
wee |
mysql server不稳定请教 支持
回复
2014-12-29 01:23:45 2
|
|
wee |
没人回答 支持，都商业化了？
回复
2015-01-06 17:12:49 3
|
|
anneyliu |
具体啥现象勒？
回复
2015-01-06 21:11:58 4
|
|
hanhanwen |
呵呵，都商业化了、、、
你得等Amysql每天回复一次帖子的时间点。
回复
2015-01-06 22:21:29 5
说什么王权富贵，怕什么戒律清规。印画 |
|
hanhanwen |
有没有试过重新安装？？？
回复
2015-01-06 22:22:48 6
|
|
zhengnan0657 |
一模一样的日志,我也这样,现在解决了吗
回复
2015-05-07 19:52:32 7
|
|
iCharlesC |
你这异常一般是连接池中 数据库连接到达设置的过期时间 自动强制回收数据库时抛出的，检查检查你的数据库连接池设置的超时时间
回复
2015-05-07 20:41:54 8
|
[求助帖]
mysql server不稳定请教
