As my tables grew to more than a few hundreds, MySQL performance degraded
- by Mark Austin
As long as my tables were less than 100, MySQL performed reasonably well but when they started to grow to more than a few hundreds, it (MYSQL) has become extremely slow. Now my tables are 1k and are very small and most contain less than 20-30 records.
Is there a specific MySQL setting which I should consider, in order for MySQL to perform better with large numbers of tables?