AMH 社区首页
AMH社区 - 开放自由有价值的社区
[求助帖] 今天突然打不开网站了 MYSQL 也无法启动 |
|
---|---|
沧桑 |
沧桑 发表于 2013-07-04 09:31:28
[root@localhost ~]# amh mysql restart
============================================================= [LNMP/Nginx] Amysql Host - AMH 3.2 http://Amysql.com MySQL server PID file could not be found! [FAILED] Starting MySQL.The server quit without updating PID file (/usr/local/mysql/data/localhost.localdomain.pid). [FAILED] [OK] MySQL restart [root@localhost ~]# [root@localhost ~]# ps aux |grep mysq* root 4790 0.0 0.0 61188 744 pts/1 S+ 17:30 0:00 grep mysq* [root@localhost ~]# service mysql start mysql: unrecognized service
点赞,加油! (0分)
2013-07-04 09:31:28 1
|
amysql |
改过什么? 看下MySQL错误日志,找下原因。
more /usr/local/mysql/data/*err;
回复
2013-07-04 14:11:22 2
AMH面板 - 好用高效低占用、安全可靠极稳定 |
沧桑 |
什么也没有改 今早就这样了。 先是网站打不开 重启后就什么也不启动了
回复
2013-07-04 15:28:22 3
|
amysql |
回复
2013-07-04 15:39:33 4
|
沧桑 |
130704 17:35:27 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 130704 17:35:27 [Note] Plugin 'InnoDB' is disabled. 09:35:27 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=0 max_threads=151 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 134074 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0 thread_stack 0x40000 /usr/local/mysql/bin/mysqld(my_print_stacktrace+0x2e)[0x76cf4e] /usr/local/mysql/bin/mysqld(handle_fatal_signal+0x386)[0x656a96] /lib64/libpthread.so.0[0x3517e0eca0] The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. 130704 17:35:27 mysqld_safe mysqld from pid file /usr/local/mysql/data/localhost.localdomain.pid ended
回复
2013-07-04 15:51:25 5
|
amysql |
引用: /etc/my.cnf 呢?
回复
2013-07-04 16:16:30 6
|
沧桑 |
[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 [mysqldump] quick [mysql] no-auto-rehash [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout
回复
2013-07-04 16:24:45 7
|
amysql |
回复
2013-07-04 16:44:47 8
|
biner |
唉,我也遇到这个问题了,什么都没有改,就是启动不了,老大解决了吗?
回复
2014-08-23 19:59:28 9
|
zcom |
支持这个问题是由于使用AMH命令建立FTP账户的时候改变了MYSQL所在文件夹权限引起的,把权限加上去就可以了
回复
2014-08-23 20:55:00 10
|