Posted By: andiklive on October 20, 2014, 4:42 am |
Hello,
why MySql service sometime stoped automatically. my usage of ram and cpu is fine, only consume 50%. and im not reboot my vps, so its totally mysql service problem. how to fix this anyway, i lost a lot of visitor daily because mysqld service problem. can you give me sollution, like if mysqld service stoped it will started automatically too. thanks ----------------------- Get Free $50 VULTR Cloud Servers Credit |
Posted By: divij on October 20, 2014, 9:59 am | Post: 1 |
Hi,
Sir when your service is stoped check the mysql log. Mysql log is located at /var/log/mysql.log |
Posted By: andiklive on October 20, 2014, 1:26 pm | Post: 2 |
Quote From : divij October 20, 2014, 9:59 am Hi,
Sir when your service is stoped check the mysql log. Mysql log is located at /var/log/mysql.log here mysql logs http://pastebin.com/Zyn9aZ1v here some line Quote 141019 18:22:37 [ERROR] Plugin 'InnoDB' init function returned error. 141019 18:22:37 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 141019 18:22:37 [ERROR] Unknown/unsupported storage engine: InnoDB 141019 18:22:37 [ERROR] Aborting its look like InnoDB problem, is i must custom my.cnf or use MyISAM ----------------------- Get Free $50 VULTR Cloud Servers Credit |
Posted By: andiklive on October 20, 2014, 1:28 pm | Post: 3 |
can you analize it for me???
----------------------- Get Free $50 VULTR Cloud Servers Credit |
Posted By: valley on October 20, 2014, 1:31 pm | Post: 4 |
Quote From : andiklive October 20, 2014, 1:28 pm can you analize it for me??? Are you running out of resources on your server ? RAM ? Root > free -m ----------------------- Webuzo : Single User Control Panel Join Webuzo : |
Posted By: andiklive on October 20, 2014, 2:46 pm | Post: 5 |
Quote From : valley October 20, 2014, 1:31 pm Quote From : andiklive October 20, 2014, 1:28 pm can you analize it for me??? Are you running out of resources on your server ? RAM ? Root > free -m i think its not, free ram its about 834mb right Quote total used free shared buffers cached Mem: 1006 781 224 0 106 503 -/+ buffers/cache: 171 834 Swap: 0 0 0 ----------------------- Get Free $50 VULTR Cloud Servers Credit |
Posted By: valley on October 21, 2014, 6:38 am | Post: 6 |
PLEASE take a backup of your databases.
Remove the following file from /var/lib/mysql/ and restart the MySQL service * ib_logfile0 * ib_logfile1 * ibdata1 ----------------------- Webuzo : Single User Control Panel Join Webuzo : |
Posted By: andiklive on October 21, 2014, 7:11 am | Post: 7 |
Quote From : valley October 21, 2014, 6:38 am PLEASE take a backup of your databases.
Remove the following file from /var/lib/mysql/ and restart the MySQL service * ib_logfile0 * ib_logfile1 * ibdata1 ok thanks, i will try it ----------------------- Get Free $50 VULTR Cloud Servers Credit |
Posted By: andiklive on October 21, 2014, 7:34 am | Post: 8 |
can you suggest me to modify my.conf
because its look like on different path to /usr/local/apps/mysql/ im just cofused to edit it to the right path thanks ----------------------- Get Free $50 VULTR Cloud Servers Credit |
Posted By: valley on October 21, 2014, 7:37 am | Post: 9 |
The path is correct. You do not have to edit that.
----------------------- Webuzo : Single User Control Panel Join Webuzo : |
Posted By: andiklive on October 21, 2014, 7:41 am | Post: 10 |
this is my config on vps without webuzo panel.
how to implement it on the right path ----------------------- Get Free $50 VULTR Cloud Servers Credit |
Posted By: valley on October 27, 2014, 6:39 am | Post: 11 |
You can edit /etc/my.cnf and add the configurations to suit your requirements.
Please understand the configuration changes well enough. Hope it helps ----------------------- Webuzo : Single User Control Panel Join Webuzo : |