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


Code:
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