Hi All
I have a MYSQL 5.5.20 database with a PHP 5.39 application running on a locally hosted (same network 192.168.1.70-server) windows Vista box with 10GB of Ram and oodles of disk space.
I have approx 10/15 users at any one time all running queries. From time to time the application just stops and the web clients just show web page can not be reached. A simple restart of the services (WAMPSERVER 2.2) gets it back up and running again.
I ahve checked the MYSQL log and it says nothing meaningful as below
20705 21:42:30 [Note] wampmysqld: Normal shutdown
120705 21:42:30 [Note] Event Scheduler: Purging the queue. 0 events
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 66 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 65 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 64 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 63 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 62 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 61 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 60 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 56 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 55 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 54 user: 'root'
120705 21:42:32 [Warning] wampmysqld: Forcing close of thread 53 user: 'root'
120705 21:42:32 InnoDB: Starting shutdown...
120705 21:42:33 InnoDB: Shutdown completed; log sequence number 1595675
120705 21:42:33 [Note] wampmysqld: Shutdown complete
120705 21:45:01 [Note] Plugin 'FEDERATED' is disabled.
120705 21:45:01 InnoDB: The InnoDB memory heap is disabled
120705 21:45:01 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120705 21:45:01 InnoDB: Compressed tables use zlib 1.2.3
120705 21:45:01 InnoDB: Initializing buffer pool, size = 128.0M
120705 21:45:01 InnoDB: Completed initialization of buffer pool
120705 21:45:01 InnoDB: highest supported file format is Barracuda.
120705 21:45:02 InnoDB: Waiting for the background threads to start
120705 21:45:03 InnoDB: 1.1.8 started; log sequence number 1595675
120705 21:45:03 [Note] Event Scheduler: Loaded 0 events
120705 21:45:03 [Note] wampmysqld: ready for connections.
Version: '5.5.20-log' socket: '' port: 3306 MySQL Community Server (GPL)
120705 21:46:15 [Note] wampmysqld: Normal shutdown
120705 21:46:15 [Note] Event Scheduler: Purging the queue. 0 events
120705 21:46:17 InnoDB: Starting shutdown...
120705 21:46:18 InnoDB: Shutdown completed; log sequence number 1595675
120705 21:46:18 [Note] wampmysqld: Shutdown complete
Is there somewhere I can start to debug this. Should there be a log other than the MYsql log that will give me anything I can start with. I have looked at the apache error log and there are no fatal errors in there either.
Are there any utilities I could use to track down the crash. I had a look at “SHOW PROCESSLIST” and there were about 10 listings with sleep values from only a few seconds to well over 1000
Sorry, Although I have been writing PHP for a while I am still a nube at MYSQL server administration.
Thanks in advance
Keith