… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort…://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-setup.html As a quick benchmark, I ran some batches of fetch and store against both a standard memcached instance and a minimally tuned MySQL 5.6 instance running…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… update much faster. I see this tuning very frequently for “performance” reasons when …, and possibly some poor user experience. batch writes Instead of updating global counters …
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many cases. Whatever powerful and well tuned system…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | | INNODB_PURGE_BATCH_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB…_batch_size have been increased from 20 to 300 which I guess is one of the component of purging fine tuning in MySQL…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql…) is not pushed from buffer pool at all. For advanced tuning you might also look into changing how buffer pool is… in default configuration MySQL has buffer pool which can be easily washed away by large table scans or heavy batch jobs. If…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… In MySQL 5.1+ it is also possible to fix this problem for cases when number of rows in auto-increment batch… patch out where already which may come in MySQL 5.2 or even MySQL 5.1. I surely would like to see… needs to test properly before really enabling it. Innodb IO Tuning I should also mention Paul Tuckfield Keynote about Scaling Innodb…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… the relevance sorting by default, adding relevance sorting to the MySQL queries would make them even slower, I’m sure. Indeed… individually as you add new data to the MySQL database or else periodically batch-insert data that has changed since last time… with MySQL and it wouldn’t be as flexible and customizable as Solr. With Solr, I was able to fine tune search…
Post: How expensive is MySQL Replication for the Master
January 16, 2010 By 13 Comments
I generally thought about MySQL replication as being quite low overhead on Master, depending on … replication threads to be woken up in the batches. For example we could tune the system to wake up the thread feeding…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… No PZ: Another possible area of optimization. I frequently see batch jobs killing server performance overtaking buffer pool. Though full …5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/entry/server_defaults_changes_in_mysql , in documentation now at http://dev.mysql.com/doc/refman/5.6/…. QC off tends to be best for well tuned OLTP and web sites using queries that mostly … slower by increasing the global value. innodb_purge_batch_size is a performance enhancement, Should also be …
