MySQL Forums
Forum List  »  Performance

Re: MySQL 5.1.61 caused high disk IO wait
Posted by: Rick James
Date: June 13, 2012 07:45PM

He meant to suggest mysqldumpslow, not mysqldump.

What values changed in SHOW VARIABLES?

Are you using MyISAM? Or InnoDB? Or both?
See http://mysql.rjweb.org/doc.php/memory

This is excessive; 10 should be enough:
> thread_cache_size | 1024

> Current max_heap_table_size = 200 M
Be careful. Multiple copies of this could be created in RAM simultaneously, thereby leading to swapping. Swapping is I/O, and _really_ hurts MySQL performance.

> | Created_tmp_disk_tables | 601941 |
> | Created_tmp_tables | 980086 |
That is a big percentage, and a big number. We really need to see the digest of the slowlog to discuss this further. percona.com also has a nice tool for digesting the slowlog.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.1.61 caused high disk IO wait
2656
June 13, 2012 07:45PM


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.