Page 1 of 1
MySQL performance
Posted: Mon Feb 10, 2003 4:21 am
by nmotion
Are there any performance gain in spreading your tables over more than one MySQL database or?
Any insight on this is welcome and appreciated.
Posted: Mon Feb 10, 2003 4:55 am
by DaZZleD
mysql works with copy of tables you use. therefore if you use many tables and keep switching from one to another the mysql has to unload one in order to make room for the other.
also mysql uses indexes for referencing data entries so the performance is good with large tables too. however you cannot make very large tables for (once loaded into memory) they might occupy all the free memory and other queries (from other users, on other tables) will have to wait untill the memory is freed.
you have to try and find a ballance between the two.