I work for a company developing a CMS in .Net. We’ve used SQL Server so far, but we have recently added MySQL support as well. Now we want to test how it performs compared to the SQL Server version in production use, but we feel a bit lost when it comes to optimizing all the different settings in MySQL.
Do you have suggestions on values for the most important settings on a server with 2x quad core Shanghai processors and 16GB RAM, with 15K SCSI disks? We have 95-99% reads from the database. We intend to use MyISAM.