Hi Benjamin, Andre, > > i have a mysql server on a dual xenon with 2GB ram > > with 300 Databases (for each customer one) > > but in the meantime a simple query takes ages to complete >10s
Generally, slow queries are caused by inadequate configuration of the server and/or badly formed queries (sometimes in combination with table design). These two things should always be looked at first. Even if you need to get some additional training or expert support, it will save you heaps of money.... no need for heavier hardware. If you post your table structure and sample query on the list, we could have a quick look at what things can be optimized. I have recently sent a reply to another user on the list which also talks about the basics of server configuration. You may find it of help for your situation too.... Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- 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
