MySQL Forums
Forum List  »  InnoDB

Re: Mass Import Innodb
Posted by: Aftab Khan
Date: January 30, 2012 09:07AM

Can you provide output of /etc/my.cnf?
How much RAM do you have on DB server?
Are you able to share table structure info?

>innodb_flush_method=O_DIRECT

Are you using innodb_file_per_table? using O_DIRECT will reduce double-buffering (OS and MySQL caches), however it serializes writes on to each file conceivably reducing writes / second. The effect is less with innodb_file_per_table as the writes are more spread out but it depends on what is getting written to and how frequently.

>innodb_buffer_pool_size=1024M
>The DB is over 350GB and the biggest table which stores documents is over 150GB long.

Can you provide us output of this:
SHOW GLOBAL STATUS LIKE 'Innodb_%';

Perhaps your Innodb buffer isn't sized properly!
http://mysqlopt.blogspot.com/2012/01/mysql-server-tuning.html

Options: ReplyQuote


Subject
Views
Written By
Posted
3465
January 29, 2012 07:10AM
Re: Mass Import Innodb
1051
January 30, 2012 09:07AM
1048
January 30, 2012 10:24AM
1009
January 31, 2012 07:06AM
964
January 31, 2012 02:51AM
888
January 31, 2012 03:21AM
1029
January 31, 2012 10:20AM
1257
January 31, 2012 10:44AM
963
February 01, 2012 02:22AM
1056
February 01, 2012 04:33AM
999
February 06, 2012 05:59AM
1139
February 07, 2012 10:38AM
1004
February 07, 2012 11:15AM


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.