Welcome Guest. Please Login or Register  


You are here: Index > Webuzo > General Support > Topic : mysqld service stoped issues



Threaded Mode | Print  

 mysqld service stoped issues (11 Replies, Read 6725 times)
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
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

IP: --   

mysqld service stoped issues
divij
Group: Member
Post Group: Elite Member
Posts: 290
Status:
Hi,

Sir when your service is stoped check the mysql log.

Mysql log is located at /var/log/mysql.log
IP: --   

mysqld service stoped issues
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
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

IP: --   

mysqld service stoped issues
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
can you analize it for me???

-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

mysqld service stoped issues
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
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 :
Facebook
Twitter

IP: --   

mysqld service stoped issues
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
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

IP: --   

mysqld service stoped issues
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
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 :
Facebook
Twitter

IP: --   

mysqld service stoped issues
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
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  :angel:

-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

mysqld service stoped issues
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
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

IP: --   

mysqld service stoped issues
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
The path is correct. You do not have to edit that.

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

mysqld service stoped issues
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
this is my config on vps without webuzo panel.
how to implement it on the right path



-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

mysqld service stoped issues
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
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 :
Facebook
Twitter

IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 28, 2024, 3:26 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.018