MySQL Forums
Forum List  »  InnoDB

Re: Need HELP: Server hang
Posted by: Rick James
Date: January 16, 2009 12:25AM

Let's fix those queries!

Turn on the slowlog; set long_query_time=2. Soon, look at the slowlog with mysqldumpslow. Tell us what the naughty queries are. Please add SHOW CREATE TABLE and EXPLAIN and SHOW TABLE STATUS surrounded by [ code ] and [ /code ] for ease of reading.

Even if you don't go the slowlog route, you can do SHOW FULL PROCESSLIST to the the entire query.

Can it handle several queries at once? Depends. Suppose they are all doing table scans on one huge table. They could be competing for the disk and/or the cpu. Effectively each is slowing down the others, especially when an impatient user hits refresh.

Also, what are your hardware specs? How many cores? SATA/SCSI? RAID? RAM? And the settings of key_buffer_size and innodb_buffer_pool_size.

Options: ReplyQuote


Subject
Views
Written By
Posted
2580
January 15, 2009 06:30AM
Re: Need HELP: Server hang
1647
January 16, 2009 12:25AM


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.