MAJOR Slow Queries problem - HELP!

[bigbigsavings]

Hello,

Over the last 24 hours, it seems that our VB has become completely unusable. We have been able to handle up to 600 people online, and now we can't even function at 350 online. The number of slow queries just keeps on increasing and increasing, and things take over 1 minute to load. WHY is this happening and what can we do to fix it?

We have already shut down mysql and ran isamchk and that did not help anything.

Everything WAS working fine yesterday, so this seems like something is wrong with the database, since it can't be the server?

Alex

[eva2000]

i am gonna take a stab at this... warning i am not expert - just someone who has had experienced alot of problems.

From reading the MySQL guide in my sig, Slow queries usually mean one of the settings of your sort buffer, join buffer or record buffer is inadequate (?) or that the table_cache parameter may need increasing

looking at your extended-status display could help

mysqladmin {user/password} extended-status

remember a slow query is set at a default 10 seconds (long_query_time) so even if a query takes 11 seconds it will show up.

what's you 'top' settings like ?

give the guide a read you might understand it better than me - http://vbulletin.com/forum/showthread.php?threadid=3452

hopefully, chris can help you soon :)

[eva2000]

also check out http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#Performance

extended-status
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHOW_STATUS



[Edited by eva2000 on 11-13-2000 at 10:11 AM]

[bigbigsavings]

I have taken off the "Display Logged In" option, and it seems to be working fine now and has been so for about 20-30 minutes. What in that feature could be causing this problem?

Alex

[eva2000]

posting your extended-status output would help chris or anyone else with diagnosing your problem

or install this script which outputs it for you

http://vbulletin.com/forum/showthread.php?threadid=3477