Help with mysql configuration

[noworyz]

I was wondering if anyone could help with my mysql configuration by looking at the mysql runtime information from my mysql server.

The runtime info is at http://www.missoulamedia.com/mysql.html

The system variables info is at http://www.missoulamedia.com/mysql2.html

Thanks in advance for any suggestions.

 

[Monica@]

What exact help you need? At the first sight the configuration is ok, it should work. Is there any problems with Mysql functioning?

 

[noworyz]

yes, mysql is crashing on a somewhat regular basis. I have to restart mysql for it to work again. I don't see anything in the log files.

 

[Amin Taheri]

Anything in /var/log/messages ?
Anything in /var/log/mysqld.log ?

if not, I doubt anyone can help you.

 

[noworyz]

the major thing in my var/log/message is (quite a few of these messages)

Statistics stack owerflow. Stack contains now 1000 unsaved entries, some of them will be removed.

any idea what that is?

as far as mysqld.log, it has stuff such as... which looks like it has some info for the crash that happened yesterday.

071106 00:59:16 mysqld started
071106 0:59:16 InnoDB: Started; log sequence number 0 483563264
071106 0:59:17 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
071106 1:14:19 [Note] /usr/libexec/mysqld: Normal shutdown

071106 1:14:21 InnoDB: Starting shutdown...
071106 1:14:23 InnoDB: Shutdown completed; log sequence number 0 483566856
071106 1:14:23 [Note] /usr/libexec/mysqld: Shutdown complete

071106 01:14:23 mysqld ended

071106 01:14:23 mysqld started
071106 1:14:23 InnoDB: Started; log sequence number 0 483566856
071106 1:14:24 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
071106 1:17:09 [Note] /usr/libexec/mysqld: Normal shutdown

071106 1:17:11 InnoDB: Starting shutdown...
071106 1:17:14 InnoDB: Shutdown completed; log sequence number 0 483567826
071106 1:17:14 [Note] /usr/libexec/mysqld: Shutdown complete

071106 01:17:14 mysqld ended

071106 01:17:14 mysqld started
071106 1:17:15 InnoDB: Started; log sequence number 0 483567826
071106 1:17:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
071106 17:02:34 [ERROR] Can't create thread to kill server

Number of processes running now: 0
071106 17:13:15 mysqld restarted
071106 17:13:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
071106 17:13:17 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 483599895.
InnoDB: Doing recovery: scanned up to log sequence number 0 483599895
071106 17:13:18 InnoDB: Started; log sequence number 0 483599895
071106 17:13:18 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
A mysqld process already exists at Tue Nov 6 17:13:19 MST 2007
071107 13:51:59 [ERROR] Can't create thread to kill server

Number of processes running now: 0
071107 13:52:01 mysqld restarted
071107 13:52:01 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
071107 13:52:02 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 484329146.
InnoDB: Doing recovery: scanned up to log sequence number 0 484329146
071107 13:52:02 InnoDB: Started; log sequence number 0 484329146
071107 13:52:02 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution