vodyanoi
Contributor
Contributor

Issue on windows with mySQL

We had installed Hyperic4.5.1 and mySQL 5.1 community edition successfully on Windows server 2003.

However after a re-boot of the windows server, due to update installation, mySQL fails to start.

Initial error was returned as follows

110526 13:02:51 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: Unrecognized value O_DIRECT for innodb_flush_method
110526 13:02:51 [ERROR] Plugin 'InnoDB' init function returned error.
110526 13:02:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110526 13:02:51 [ERROR] Unknown/unsupported table type: innodb
110526 13:02:51 [ERROR] Aborting

110526 13:02:51 [Note] D:\MySQL\bin\mysqld: Shutdown complete

quick search around discovered a statement saying under windows the only supported flush method is innodb_flush_method=async_unbuffered

so we amended my.ini and attempted to restart mySQL

we now get this message.
110527 14:27:35 [Note] Plugin 'FEDERATED' is disabled.
110527 14:27:36 InnoDB: Initializing buffer pool, size = 1.0G
110527 14:27:38 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 25165824 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
110527 14:27:38 [ERROR] Plugin 'InnoDB' init function returned error.
110527 14:27:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
110527 14:27:38 [ERROR] Unknown/unsupported table type: innodb
110527 14:27:38 [ERROR] Aborting

110527 14:27:38 [Note] D:\MySQL\bin\mysqld: Shutdown complete

We cannot find either an ib_logfile0 or any .cnf file on the server. We assume we would be looking in my.ini instead of in a .cnf file.
in which case the value for the innodb logfile size is set to 256Mb.

Can anyone suggest how we resolve this.

regards


Spencer
0 Kudos
0 Replies