WampServer

What could the problem be? It's running on a XP machine. Sometimes MySQL crashes every month, sometimes every week but the last week every day. Gets annoying.

Take a look at your mysql error log
also check the event viewer in windows.


Then get back with some info that could help.

msql log:

120418 13:41:10 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
120418 13:41:10 InnoDB: Initializing buffer pool, size = 128.0M
120418 13:41:10 InnoDB: Completed initialization of buffer pool
120418 13:41:10 InnoDB: highest supported file format is Barracuda.
120418 13:41:14 InnoDB: 1.1.4 started; log sequence number 8740018
120418 13:41:14 [Note] Event Scheduler: Loaded 0 events
120418 13:41:14 [Note] wampmysqld: ready for connections.
Version: '5.5.8-log' socket: '' port: 3306 MySQL Community Server (GPL)
120419 3:03:13 [Note] wampmysqld: Normal shutdown

120419 3:03:13 [Note] Event Scheduler: Purging the queue. 0 events
120419 3:03:14 InnoDB: Starting shutdown...
120419 3:03:15 InnoDB: Shutdown completed; log sequence number 8740706
120419 3:03:15 [Note] wampmysqld: Shutdown complete

120419 13:43:32 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
120419 13:43:32 InnoDB: Initializing buffer pool, size = 128.0M
120419 13:43:32 InnoDB: Completed initialization of buffer pool
120419 13:43:32 InnoDB: highest supported file format is Barracuda.
120419 13:43:35 InnoDB: 1.1.4 started; log sequence number 8740706
120419 13:43:38 [Note] Event Scheduler: Loaded 0 events
120419 13:43:38 [Note] wampmysqld: ready for connections.
Version: '5.5.8-log' socket: '' port: 3306 MySQL Community Server (GPL)
120420 3:03:19 [Note] wampmysqld: Normal shutdown

120420 3:03:19 [Note] Event Scheduler: Purging the queue. 0 events
120420 3:03:19 InnoDB: Starting shutdown...
120420 3:03:20 InnoDB: Shutdown completed; log sequence number 8745092
120420 3:03:21 [Note] wampmysqld: Shutdown complete

120423 12:17:11 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Compressed tables use zlib 1.2.3
120423 12:17:12 InnoDB: Initializing buffer pool, size = 128.0M
120423 12:17:12 InnoDB: Completed initialization of buffer pool
120423 12:17:12 InnoDB: highest supported file format is Barracuda.
120423 12:17:15 InnoDB: 1.1.4 started; log sequence number 8745092
120423 12:17:15 [Note] Event Scheduler: Loaded 0 events
120423 12:17:15 [Note] wampmysqld: ready for connections.
Version: '5.5.8-log' socket: '' port: 3306 MySQL Community Server (GPL)
120424 3:03:10 [Note] wampmysqld: Normal shutdown


*No shutdowns were initiated by me*

you turn on your pc at 12-2pm? and turn it off at 3am every night????

is this correct? then mysql is not shutting itself down

defrag? updates?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]