As my tables grew to more than a few hundreds, MySQL performance degraded
Posted
by Mark Austin
on Server Fault
See other posts from Server Fault
or by Mark Austin
Published on 2010-05-28T08:17:03Z
Indexed on
2010/05/28
8:53 UTC
Read the original article
Hit count: 280
mysql
|Performance
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?
© Server Fault or respective owner