Re: MySQL shutting down because of Operating system error 1784

Ok, it's been some time since this problem, but we could finally resolve it. I wanted to report back here so it gets archived and helps anyone who has a similar problem in the future. Since the server is a virtual server, there is a Sync Driver that quiescies the hard drive before VMWare takes a s

Re: MySQL shutting down because of Operating system error 1784

Hi all, Thanks for your suggestions. The problem is solved I guess, no problems reported after I made the changes. As suggested, increased the log file sizes. Changed innodb_buffer_pool_size from 128M to 256M. Changed innodb_log_file_size from 5M to 64M. Also changed innodb_thread_concurrency f

Re: MySQL shutting down because of Operating system error 1784

Cagdas CUBUKCU gmail.com> writes: > > Hi, > > We are getting "InnoDB: Operating system error number 1784" error on MySQL > and it just shuts down after getting the error. # ERROR_INVALID_USER_BUFFER or ERROR_NOT_ENOUGH_MEMORY Each device

RE: MySQL shutting down because of Operating system error 1784

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 "inno