June 19, 2013

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

sets of queries. Each set is known as a “flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERYcache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer_size=10G # Disabling symbolic-links is recommended

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

my 5.6 instance is 128MB – smaller than the size of my… FTS_00000000000000ad_BEING_DELETED_CACHE.ibd -rw-rw—-. 1…_names = 1 in /etc/my.cnf), but I think it… rows in set (0.00 sec) mysql> delete from dir_test_innodb LIMIT 200000; Query …have a hard time recommending this feature to my customers, and …

Post: How Percona does a MySQL Performance Audit

recommendationsmy.cnf files. In fact my.cnf files are usually one of the smallest levers we can pull for server optimization. Schema and query….022 cache size : …settings and status, these setquery log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries

Post: Heikki Tuuri answers to Innodb questions, Part II

… wondering if you would recommend using SSD for this…cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnfsize Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries… what are the limits of different operations for…

Post: Review of MySQL 5.6 Defaults Changes

… would recommend adding support for value 0 which would mean limit disabled…default. query_cache_size = 1M Query cache remains off by default but default size is …settings. James also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my

Comment: Database problems in MySQL/PHP Applications

my.cnf to set global options, # mysql-data-dir/my.cnf to setquery-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_sizerecommended