… the entire cache is cleared (think restarting a memcache node). This is where a persistent cache can be invaluable. Enter MySQL 5.6… store against both a standard memcached instance and a minimally tuned MySQL 5.6 instance running the memcached plugin. Here are some… replaced $cache->load() with $db->query(“SELECT * FROM memcached.container WHERE id=’key_id’”); id is PK of the container table While…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=…connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = …out-of-box, but I am ready to tune something if there …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… or capacitor-backed write cache), etc., but the principle is…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… separate tables and there also exists a users_groups table to define… faster. I see this tuning very frequently for “performance”…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… and data about Query Cache content and operation can be presented as some INFORMATION_SCHEMA tables. Self Refresh MySQL Query Cache causes not uniform… query cache manageability and make stats available this can even be done by external script which can have application-specific tunings to…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… number. So if you tune table cache is “normal” case and is able to bring down your miss rate (opened_tables) to 10/sec… was fixed in MySQL 5.1 – in this version table_cache was significantly redone and split in table_open_cache and table_definition_cache and I assumed the behavior may be different as well. MySQL…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… to deliver huge wins. If MySQL is actually badly configured, you …what happens when you have query cache contention, DNS problems, or very slow… The queries The schema design (table design, data types, indexing, etc) …I prefer to avoid the word “tuning,” because database tuning is an activity that can…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…_pct=80 innodb_file_format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server 5.1 Results For better… to not to penalize further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6.2. It is important… by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge Sleeps Removed I’ve…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
… claim that somewhere around of 99% of advice about tuning MySQL‘s key cache hit ratio is wrong, even when you hear it… a long time before the MySQL world started to come around. There are even tuning utilities (anti-tuning anti-utilities?) for Oracle, specifically… sound like on a machine that’s dedicated to MyISAM tables. Consider your mixture of storage engines (some InnoDB, some MyISAM…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…_size This is very important variable to tune if you’re using Innodb tables. Innodb tables are much more sensitive to buffer size… case MySQL Server crashes. Value 2 only cause data loss with full OS crash. table_cache – Opening tables can be expensive. For example MyISAM tables mark MYI header to mark table as currently in use…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… better to disable them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included… table_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=200M log-output = FILE log-slow-queries=/tmp/mysql-slow…
