Hi I'm having a very weird problem. I switched my MySQL server from Solaris to Linux on Compaq. I applied the same configuration file but I'm experiencing problems. The new Compaq / Linux server is many times faster than the Solaris I had But when load comes, it crashes. It works great for a day but at pick hours If I run a report that lasts for a 15-20 seconds and this report takes the Average queries per second from 100 to 300 the load on the server sky rockets And it stops responding. It seems that MySQL on Solaris managed this much better.
MySQL Ver : Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 Any ideas? Thanks berber --------------------------------------------------------------------- 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
