MySQL Forums
Forum List  »  InnoDB

Re: MySQL 5.5.8 - Configuration Settings Suggestions
Posted by: Aftab Khan
Date: June 26, 2012 03:18AM

>>innodb_buffer_pool_size 12884901888 #12G

Since you have 12G innodb buffer pool, so I assume you have 16G RAM?

>1. Should I need to use multiple innodb_buffer_pool_instances?
At this stage no

>2. Should I need to use the innodb_flush_method=O_DIRECT
What file system are you using ext3?

>3. Should I need to increase the innodb_thread_concurrency?
Value for this option variable is '0' as per provided global variables data.
"A value of 0 (the default) is interpreted as infinite concurrency (no concurrency checking)"

Edited 1 time(s). Last edit at 06/26/2012 03:20AM by Aftab Khan.

Options: ReplyQuote

Written By
Re: MySQL 5.5.8 - Configuration Settings Suggestions
June 26, 2012 03:18AM

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.