We have a server with the following specs:
Windows Server 2003 Standard
1 x Quad Core Xeon 1.86Ghz
3Gb RAM (Actually 5Gb, but windows can only use 3gb)
Raid 5 - SATA 250Gb
All the tables and database being used is about 40Gb with one busy table being 13Gb
We cannot set the InnoDB buffer larger than 640Mb, otherwise the DB does not start.
Most of the heavy traffic tables are bigger than 640Mb, and this just tells me that the tables will not one fit into the innodb buffer.
Would I be better off converting all tables to MyIsam, or should I leave it on Innodb, I am currently not happy with the performance at all, and we are running a failry busy website.
Any suggestions, and please don’t tell me to install Linux, its just not an option at this stage. We have to be on windows for a while longer since a lot of applications was developed in .NET (
I need to get the most out of the system I have and would love some tips in this area.
Thanks a million in advance