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.
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.