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
