产品服务AMH 免费服务器主机面板SSL证书 免费SSL证书申请 担保单 免费安全、零费率交易平台编程助手免费智能写代码、翻译AMYSQL 免费MySQL管理工具

AMH 社区首页

 AMH社区 - 开放自由有价值的社区

[求助帖] 今天突然打不开网站了 MYSQL 也无法启动

沧桑
银牌会员
1030.15 价值分

沧桑 发表于 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


2013-07-04 09:31:28 1

amysql
创始人
16530.81 价值分

改过什么? 看下MySQL错误日志,找下原因。

more /usr/local/mysql/data/*err;
  支持 (0分)  反对 (0分)
回复  2013-07-04 14:11:22 2

AMH面板 - 好用高效低占用、安全可靠极稳定

沧桑
银牌会员
1030.15 价值分

引用:
amysql 发表于 2013-7-4 14:11
改过什么? 看下MySQL错误日志,找下原因。

more /usr/local/mysql/data/*err;


什么也没有改
今早就这样了。 先是网站打不开
重启后就什么也不启动了
  支持 (0分)  反对 (0分)
回复  2013-07-04 15:28:22 3

amysql
创始人
16530.81 价值分

引用:
沧桑 发表于 2013-7-4 15:28
什么也没有改
今早就这样了。 先是网站打不开
重启后就什么也不启动了

看日志了么
  支持 (0分)  反对 (0分)
回复  2013-07-04 15:39:33 4

沧桑
银牌会员
1030.15 价值分

引用:
amysql 发表于 2013-7-4 15:39
看日志了么


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
  支持 (0分)  反对 (0分)
回复  2013-07-04 15:51:25 5

amysql
创始人
16530.81 价值分

引用:
沧桑 发表于 2013-7-4 15:51
130704 17:35:27 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
13070 ...


/etc/my.cnf 呢?
  支持 (0分)  反对 (0分)
回复  2013-07-04 16:16:30 6

沧桑
银牌会员
1030.15 价值分

引用:
amysql 发表于 2013-7-4 16:16
/etc/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

[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分)  反对 (0分)
回复  2013-07-04 16:24:45 7

amysql
创始人
16530.81 价值分

引用:
沧桑 发表于 2013-7-4 16:24
[client]
port = 3306
socket = /tmp/mysql.sock


方便pm root ,我去看看。
  支持 (0分)  反对 (0分)
回复  2013-07-04 16:44:47 8

biner
铁牌会员
10.00 价值分

唉,我也遇到这个问题了,什么都没有改,就是启动不了,老大解决了吗?
  支持 (0分)  反对 (0分)
回复  2014-08-23 19:59:28 9

zcom
银牌会员
1669.33 价值分

支持这个问题是由于使用AMH命令建立FTP账户的时候改变了MYSQL所在文件夹权限引起的,把权限加上去就可以了
  支持 (4.53分)  反对 (0分)
回复  2014-08-23 20:55:00 10
 1  (总1页)
AMH社区列表
用户服务中心