MySQL service not responding
Posted by: Richard Sandison
Date: July 29, 2013 02:16PM

Hi

We have been using MySQL 5.5.16 for ages without any problems.

For some reason today our MySQL began slowing and then ground to a halt. I tried to restart the service, restarting the server and it now refuses to start. I have uninstalled MySQL and reinstalled. Uninstalled, deleted files and reinstalled. Installed a newer version and nothing seems to work.

I've looked in the log file and it seems to relate to INNODB. I played aruond with the INNODB log file size, setting it up to 1G and I ended up with two log files (ib_logfile0 and ib_logfile1) both at 1GB size.

The latest attempt to start creating these log entries:-
130729 20:57:31 [Note] Plugin 'FEDERATED' is disabled.
130729 20:57:31 InnoDB: The InnoDB memory heap is disabled
130729 20:57:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130729 20:57:31 InnoDB: Compressed tables use zlib 1.2.3
130729 20:57:31 InnoDB: Initializing buffer pool, size = 4.0G
130729 20:57:32 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file D:\Data\ibdata1 did not exist:
InnoDB: a new database to be created!
130729 20:57:32 InnoDB: Setting file D:\Data\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130729 20:57:32 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 1024 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
130729 20:58:06 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 1024 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130729 20:58:39 InnoDB: Waiting for the background threads to start
130729 20:58:40 InnoDB: 5.5.32 started; log sequence number 0
130729 20:58:40 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3307
130729 20:58:40 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130729 20:58:40 [Note] Server socket created on IP: '0.0.0.0'.

I can see mysqld.exe running in task manager and is utilising around 467K memory.

However, in Services MySQL does not show as running.

Any ideas where to start with resolving this problem?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL service not responding
3180
July 29, 2013 02:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.