MySQL Forums
Forum List  »  MySQL Administrator

MYSQL database 4.1.19 - crashes and has performance issues
Posted by: Nigu Ramachandran
Date: July 10, 2012 04:46AM

Hi,

I am new to MYSQL database. We have our webhosting application running against MYSQL. There are 289 MYSQL databases on a single server. The server is running on IBM AIX 5.2 TL 9 and has 12GB RAM, 24Gb SWAP space and has 6CPUs. The applications hang intermittently and so far we have been just restarting the database but the problem still persists. We are getting out of memory errors as well.
/usr/local/mysql/bin/mysqld: ready for connections.
Version: '4.1.9-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 Official MySQL-standard binary
120704 20:19:12 [ERROR] /usr/local/mysql/bin/mysqld: Can't open file: 'jos_session.MYI' (errno: 145)
120704 20:19:12 [ERROR] /usr/local/mysql/bin/mysqld: Can't open file: 'jos_session.MYI' (errno: 145)
120704 20:19:12 [ERROR] /usr/local/mysql/bin/mysqld: Can't open file: 'jos_session.MYI' (errno: 145)
120704 20:19:12 [ERROR] /usr/local/mysql/bin/mysqld: Can't open file: 'jos_session.MYI' (errno: 145)
120704 20:19:12 [ERROR] /usr/local/mysql/bin/mysqld: Can't open file: 'jos_session.MYI' (errno: 145)
120704 20:19:12 [ERROR] /usr/local/mysql/bin/mysqld: Can't open file: 'jos_session.MYI' (errno: 145)
mysqld got signal 4;
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=8388600
read_buffer_size=131072
max_used_connections=608
max_connections=1000
threads_connected=608
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2184184 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Regards,
Nigu

Options: ReplyQuote


Subject
Written By
Posted
MYSQL database 4.1.19 - crashes and has performance issues
July 10, 2012 04:46AM


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.