猿问

mysql启动失败,但没有error信息,请问如何解决?

服务器环境:centos6.4
启动代码:
#servicemysqldstart
StartingMySQL...ERROR!TheserverquitwithoutupdatingPIDfile(/mnt/data/mysql/mysql.pid).
检查日志文件,也没有error:
13102611:25:45mysqld_safeStartingmysqlddaemonwithdatabasesfrom/mnt/data/mysql
2013-10-2611:25:460[Warning]TIMESTAMPwithimplicitDEFAULTvalueisdeprecated.Pleaseuse--explicit_defaults_for_timestampserveroption(seedocumentationformoredetails).
2013-10-2611:25:4613682[Note]Plugin'FEDERATED'isdisabled.
2013-10-2611:25:477feddd850720InnoDB:Warning:Usinginnodb_additional_mem_pool_sizeisDEPRECATED.Thisoptionmayberemovedinfuturereleases,togetherwiththeoptioninnodb_use_sys_mallocandwiththeInnoDB'sinternalmemoryallocator.
2013-10-2611:25:4713682[Note]InnoDB:TheInnoDBmemoryheapisdisabled
2013-10-2611:25:4713682[Note]InnoDB:Mutexesandrw_locksuseGCCatomicbuiltins
2013-10-2611:25:4713682[Note]InnoDB:Compressedtablesusezlib1.2.3
2013-10-2611:25:4713682[Note]InnoDB:CPUdoesnotsupportcrc32instructions
2013-10-2611:25:4713682[Note]InnoDB:UsingLinuxnativeAIO
2013-10-2611:25:4713682[Note]InnoDB:Initializingbufferpool,size=10.0M
2013-10-2611:25:4713682[Note]InnoDB:Completedinitializationofbufferpool
13102611:25:47mysqld_safemysqldfrompidfile/mnt/data/mysql/mysql.pidended
检查目录权限:
#ls-l/mnt/data/
总用量656020
drwxr-xr-x7mysqlmysql409610月2611:24mysql
烙印99
浏览 624回答 2
2回答

慕慕森

请给出启动失败与所展示的日志间的时间关系;请检查/var/log下的通用日志,如messages、daemon.log之类;你的服务器启动脚本似乎是自己写的或者修改过,贴一下?

明月笑刀无情

ls-lZ检查mysqldatadir的SELinux权限如果是SELinux权限的问题可以用如下方法恢复假设你的datadir是/var/lib/mysql:semanagefcontext-a-tmysqld_db_t"/var/lib/mysql(/.*)?"restorecon-Rv/var/lib/mysql
随时随地看视频慕课网APP

相关分类

JavaScript
我要回答