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 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users