On 10/11/11 11:09, Brian Debelius wrote:
> Hi,
> 
> I have a 5GB database.  The server has 6GB RAM.  These are the settings
> I am using right now.
> 
> default-storage-engine=innodb
> default-table-type=innodb
> query_cache_limit=16M
> query_cache_size=256M
> innodb_log_file_size=384M
> innodb_buffer_pool_size=3G
> innodb_log_buffer_size=2M
> innodb_flush_log_at_trx_commit=2
> 
> Your mileage may vary,

If using MySQL 5.5, do not overlook the innodb_buffer_pool_instances
setting.  (The name is a little misleading, IMHO; they should have
called it innodb_buffer_pool_partitions.)  It is one of the most
important configuration settings for obtaining optimum InnoDB
performance in MySQL 5.5.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2d-oct
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users