Skip navigation links

MySQL Forums :: InnoDB :: MySQL 5.5.8 - Configuration Settings Suggestions


Advanced Search

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)"
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_thread_concurrency



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

Options: ReplyQuote


Subject Views Written By Posted
MySQL 5.5.8 - Configuration Settings Suggestions 1285 Samir Dash 06/19/2012 03:53AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 686 Aftab Khan 06/25/2012 05:44AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 1012 Samir Dash 06/25/2012 11:00AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 730 Samir Dash 06/25/2012 11:01AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 578 Samir Dash 06/25/2012 11:03AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 751 Aftab Khan 06/25/2012 12:23PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 647 Samir Dash 06/26/2012 02:20AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 688 Aftab Khan 06/26/2012 03:18AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 971 Samir Dash 06/26/2012 03:36AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 676 Aftab Khan 06/26/2012 05:01AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 641 Samir Dash 06/28/2012 02:01AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 871 Aftab Khan 06/29/2012 12:59AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 633 Samir Dash 06/29/2012 01:12AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 641 Samir Dash 06/29/2012 02:14AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 774 Aftab Khan 06/29/2012 02:46AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 638 Samir Dash 06/29/2012 03:27AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 664 Aftab Khan 06/29/2012 07:43AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 671 Samir Dash 06/29/2012 07:22PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 700 Rick James 06/29/2012 06:14PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 666 Samir Dash 06/29/2012 07:39PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 698 Aftab Khan 06/30/2012 01:27AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 604 Samir Dash 06/30/2012 01:48AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 605 Aftab Khan 06/30/2012 01:53AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 586 Samir Dash 06/30/2012 02:20AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 575 Aftab Khan 06/30/2012 02:39AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 660 Samir Dash 06/30/2012 04:35AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 641 Aftab Khan 06/30/2012 06:02AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 690 Samir Dash 07/03/2012 09:57AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 636 Rick James 07/04/2012 06:39AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 625 Aftab Khan 07/05/2012 02:18AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 606 Peter Brawley 07/05/2012 11:01AM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 622 Aftab Khan 07/05/2012 12:53PM
Re: MySQL 5.5.8 - Configuration Settings Suggestions 613 Rick James 07/06/2012 03:41PM


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.