MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: Server goes too slow (openbsd 3.8 + mysql 5)
Posted by: Ravenous Bugblatter Beast
Date: December 24, 2005 07:26PM

It is probably thrashing your disk - run a SHOW STATUS command and check if the created_tmp_disk_tables variable is large as a proportion of your number of connections - if so you need to optimise your queries and/or buffer sizes. Also read up on using the query cache and key cache and tuning the status variables.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Server goes too slow (openbsd 3.8 + mysql 5)
2212
Fernando sientelo
December 23, 2005 05:10AM
Re: Server goes too slow (openbsd 3.8 + mysql 5)
1216
Ravenous Bugblatter Beast
December 24, 2005 07:26PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.