June 19, 2013

Comment: Database problems in MySQL/PHP Applications

November 6, 2006 By 13 Comments

… 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…

Filed Under: Insight for Developers Tagged With: , ,

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…

Filed Under: MySQL

Post: Review of MySQL 5.6 Defaults Changes

October 8, 2012 By 10 Comments

… even more would be good default. query_cache_size = 1M Query cache remains off by default but default size is raised to 1M which is probably… also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my-large etc referring to…

Filed Under: Insight for DBAs, MySQL

Post: Why you should ignore MySQL's key cache hit ratio

February 28, 2010 By 28 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, …

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: What to tune in MySQL Server after installation

September 29, 2006 By 118 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…

Filed Under: Insight for DBAs Tagged With:

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…

Filed Under: Benchmarks

Post: Aligning IO on a hard disk RAID – the Benchmarks

June 9, 2011 By 13 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…

Filed Under: MySQL

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…

Filed Under: Benchmarks, Insight for DBAs Tagged With:

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…

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…full-text search), that’s largely where the similarities end. NOTE… The second part will compare query results between MyISAM FTS …for my 5.6 instance is 128MB – smaller than the size of my …09 FTS_00000000000000ad_BEING_DELETED_CACHE.ibd -rw-rw—-. 1 …table_names = 1 in /etc/my.cnf), but I think it’s…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,
« Older Posts