0

Please don't ask why I need 100+ instances on one server because I cannot say; suffice to say that I'm not impressed. They will be very small databases and not definitely not under any great load (one or two users per instance).

  • The server is Windows 2012R2 64bit with 8GB RAM.
  • The MySQL version is 5.6.26.
  • innodb_buffer_pool_size=415M

After 27 instances are running I get the error in the Windows event log for every instance after that:

InnoDB: Cannot allocate memory for the buffer pool"

The instances will have the most basic of databases, probably no more than 10 records in each and 10 - 15 entries in each record.

If needs be, I can allocate more memory.

1

To reduce the RAM used by each instance from ~450MB to 17MB this setting was required:

performance_schema=off

To fix the

InnoDB: Cannot allocate memory for the buffer pool

...the setting innodb_open_files=300 had to be changed to innodb_open_files=3000.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.