I installed Windows Server 2008 and MySQL 5.5.
Now I need configure MySQL for huge InnoDB tables and a lot of connections.
I see that on my Windows Server, there is a my-huge
file(configs files that come with mysql :my, my-huge,my-large .ini) with configuration inside the mysql directory.
How can the my-huge configuration be enabled?
Best Answer
You need to stop mysqld, swap in my-huge.ini, and start up mysqld
This will only work if you do not have to resize the log files.
If you have to resize ib_logfle0 and ib_logfile1, rename them before startup
Give it a Try !!!