Re: Operating system error number 995 (windows aio) - innodb crashing

[Dave Clayton]

Hi,

Thanks for your response.

We don't appear to have any settings for most of those in our my.ini :( I basically uncommented the default settings. Most of our tables are MyISAM, only a few are InnoDB, so we didn't use the example my-innodb-heavy-4G.ini file.

These are everything we have in my.ini for InnoDB:
innodb_data_home_dir = C:\mysql\data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = C:\mysql\data/
innodb_log_arch_dir = C:\mysql\data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 512M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 50M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout = 50

Thanks for your help.