… might want to increase it. Do not set it too high however as it would be waste of memory – it is flushed… queries there is no reason to increase sort_buffer_size even if you have 64GB of memory to waste. Furthermore doing so… I can analyze workload. P.S Note MySQL distribution contains bunch of sample my.cnf files which may be great templates to use…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some people having a lot of memory and… really strange. Performance indeed grows by few percent as you increase buffer to 128K but after that instead of improving any… fits in OS cache): read_buffer_size impace on in memory tableread_buffer_sizeTime (sec)82004.1516K4.1532K4.1264K4.11128K4.11256K4…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… may need to increase size of your Innodb log files to be able to use a lot of memory for write buffering… for these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for… innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB’s buffer pool…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…be open or closed. Furthermore besides MySQL table_cache Innodb maintains its own … of memory – In my case after reading all tables I got “Dictionary memory allocated…innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file …tables and you can also safely increase this number if you like – …
Comment: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… maximum always increases on my servers. I mean I’m certainly hitting a MySQL/InnoDB memory leak because whatever values I put in my my.cnf, I always end-up a few weeks after restart with 2 or 3 extra GB of memory used than… in this aspect, MySQL is not really good to display information about where it spends all the used memory 
If you Percona…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
…when you need a major performance increase and do not have a time…also can be done easily. Is MySQL, Queries, Architecture optimized well enough ? …you can triple performance by simple my.cnf change. Well enough is a tricky …to be done (gettings SSD, upgrading memory, upgrading CPUs). There are number …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…, 48 bits virtual power management: I tested MySQL-5.1.30 with InnoDB plugin, …buffer_pool (split_buffer_pool_mutex patch). my.cnf is [mysqld] user=root binlog_cache_…days but as number of cores is increasing now at the same pace as …be not a lot database fits “in-memory” cases – but on other hand 64-…
