I'm seeing a MySQL server running normally, but once it hits high load, it dies without warning -- instantly crashes. It is supporting both a forum and a chat server. It runs both InnoDB and MyISAM tables. The chat server is the issue, I think.
I am having a hard time determining how to fix the problem, and was wondering what monitoring tools are available for MySQL that would let me specifically determine the cause of the crash (that way I can tweak my.ini settings and hopefully make it go away).
I can't find anything conclusively useful in the appropriate .err file.
I'm seeing Application Event Log 100 messages like this:
Event Type: Information
Event Source: MySQL
Event Category: None
Event ID: 100
Date: 11/13/2009
Time: 3:57:52 PM
User: N/A
Computer: HOST
Description: C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\bin\mysqld-nt.exe: ready for connections. Version: '5.0.45-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
Will no other logged information.
A current show status like '%thread%'; shows this for output, if that helps:
Delayed_insert_threads 0
Slow_launch_threads 0
Threads_cached 1
Threads_connected 7
Threads_created 53033
Threads_running 1
Since it is running as a 32-bit instance on this 64-bit box, perhaps the MySQL instance is simply running out of memory? I'm sure a 64-bit upgrade would help TREMENDOUSLY...but I need to be sure it will fix the problem.
Any help is greatly appreciated, and if you have any questions, ask away!