MySQL Forums
Forum List  »  General

MySQL I/O and huge size .ibd file
Posted by: Justin Xu
Date: May 09, 2017 07:50PM

Hello

I have a MySQL 5.5 runs a VMware VM with SAN storage,64GB memory ,Redhat 6.6 OS, 16 CPU cores.,The data are being inserted into DB around 200-300MB/s, total DB size is near 5TB.
Some inserts SQL with bulk data take over 60 seconds . I set innodb_file_per_table=1 , and some tables .ibd files size is over 300GB. IOSTAT often shows near 100% %util.
Are there any method can improve the IO performance by tune the Mysql or Linux parameters? and do the huge .idb file impact the I/O performance ?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
MySQL I/O and huge size .ibd file
May 09, 2017 07:50PM


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.