Hi list, I still have performance problem with my big MyISAM table. In fact, mysql keep locking my table, even for doing select :( I don't know why but it's very very annoying. 1% of my query are search ones. Theses queries are slow, too slow.
So i'm thinking about splitting my table to lot of little tables. Can i have around 5000 Tables under the same database ? Or should i keep my big table and do not split ? Thanks David Config : Mysql 3.23.45 ( tar.gz binary ) Linux Red-hat 7.1 kernel 2.4.19 1Go ram --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php