Mysql is frequently getting restarted
Hi,
I have a MySQL version 5.0.22, it is getting frequently restarted. I went through the logs and found that that is with due to performance.
We have few tables with MyISAM and FullText indexed, now the problem I observed that Few times MySQL server is automatically restarting when executing procedure which uses CURSORS with update operations.
MySQL is hosted on CentOS Linux 32bit Hardware.
Not sure what is causing this restarts, Could you please guide and help us to resolve the issue?
Below are the configuration and log statements:
key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=9
max_connections=100
threads_connected=8
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
if there is any problem with the configuration please mail me the good configuration to solve this problem.
Subject
Views
Written By
Posted
Mysql is frequently getting restarted
4350
June 18, 2009 12:41AM
2909
June 19, 2009 10:15PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.