You definetely have to tune your my.cnf... use thread and query cache, increase the key buffer, optimize tables very often (I do it every day... takes 7 minutes in a dual xeon 2Ghz), increase sort and join size.
good luck
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>, "Richard" <[EMAIL PROTECTED]> writes:
Does anybody know of any issues when have a large (+1000) databases in MySQL? It will be running on RedHat 9. Would there be any problems running backups with this many DBs on one box?
Some filesystems become slow if you have +1000 subdirectories. ReiserFS doesn't have that problem.
-- -------------------------------------------------------------------------- Gustavo Baratto - Systems Engineer [EMAIL PROTECTED] * (604) 638-2525 ext. 408
Technical support web-site: http://support.superb.net Superb Internet Corp. "Ahead of the Rest" -------------------------------------------------------------------------
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
