I have a Windows 2008 R2 server on which I host my clients websites, web applications and their associated MySQL databases. The applications and associated databases work fine, but I want to ensure that I have got the MySQL databases as optimally designed as possible for reliability and speed of searching. For example, correct choice of table type, field types for the various data types stored, etc. If this is done for one database, I can use that as a good worked example to review my other databases.
I have read through a number of tutorials, but these databases are used daily so I can't get this wrong.
If I upload a .sql dump of a current database, is there a MySQL Database Structure expert willing to advise me?