If you have a lot of InnoDB transactions, maybe your ib_logfile0 and ib_logfile1 are too small.
Transactional data are written in these files in a circular fashion. You may have run out of space in these. If you want to make these files bigger, simply do the following: 1) Use the setting "innodb_log_file_size=<Number>" in my.ini 2) net stop mysql 3) del D:\MySQLlog\ib_logfile* 4) net start mysql (during startup of mysqld, ib_logfile0 and ib_logfile1 are recreated) As a rule of thumb, set innodb_log_file_size = (25% of innodb_buffer_pool_size) BTW the combined total of all ib_logfiles cannot exceed 4GB. Example: if innodb_buffer_pool_size=1G, then set innodb_log_file_size=256M Example: if innodb_buffer_pool_size=512M, then set innodb_log_file_size=128M Example: if innodb_buffer_pool_size=256M, then set innodb_log_file_size=64M Etc... Rolando A. Edwards MySQL DBA (SCMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM & Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -----Original Message----- From: Cagdas CUBUKCU [mailto:cagdascubu...@gmail.com] Sent: Monday, November 30, 2009 1:19 PM To: mysql@lists.mysql.com Subject: MySQL shutting down because of Operating system error 1784 Hi, We are getting "InnoDB: Operating system error number 1784" error on MySQL and it just shuts down after getting the error. This happens once every 2 days or so. We are using MySQL 5.0.51b-community-nt. I was wondering if anyone had this problem before? Here's the full error output: InnoDB: Operating system error number 1784 in a file operation. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html InnoDB: File name D:\MySQLlog\ib_logfile0 InnoDB: File operation call: 'Windows aio'. InnoDB: Cannot continue operation. InnoDB: Log scan progressed past the checkpoint lsn 35 1443981126 Is it because of not being able to write log files for some reason? Is InnoDB logs required? Thanks! Cagdas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
