… ram. Here is our my.cnf # sammple MySQL config file for very large systems. # # # This is for a large system with memory of 1G… long-query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size = 2000M…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… values in the /etc/my.cnf file if you …query-infobright-demo-64bit x86_64 ICE 3.5.2pl1. Requires m1.large or larger ami-8eb648e7 shard-query…cache skip-name-resolve sort-buffer-size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…with powerful hardware and heavy query workloads. Both have a key_buffer_size of 4GB. Now can …caches. But I’ll give the simple version here. In my opinion, you should choose a key_buffer_size that is large…”key cache hit ratio.” This is a shame. When you are new to MySQL, trying to configure my.cnf, …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
…and it is typically best to size your cache so it is large enough to keep most of …operation. query_cache_size If your application is read intensive and you do not have application level caches this ….S Note MySQL distribution contains bunch of sample my.cnf files which may be great templates to use…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode…cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size…_log_file_size = 1600M – another Benchmark optimization. Such large logs typically will…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
….92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql …cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size… should have really interesting effects. Large stripe on the other hand…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
…for large table you should set this variable to some high value. Sample my.cnf values on large memory sizes …drives in RAID0. I’ve used the following query to perform full table scans, with 3 …out smaller table (which fits in OS cache): read_buffer_size impace on in memory tableread_buffer_sizeTime…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf…_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, …database brands. Q37: We have a fairly large Innodb table (150GB) that is showing poor…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… here. Examples include what happens when you have query cache contention, DNS problems, or very slow I/O. … settings, such as making the sort buffer size much too large (a gigabyte comes to mind). As a … simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see …
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…few reading queries but on large tables (~10 millions rows) and a lot lot of insertions queries on …cache is not up to date as we would due to the database latency. To give you more information, this is my.cnf…_buffer_pool_size=4G innodb_additional_mem_pool_size=20M # Set the log file size to about 25…
