…, I described a solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set… logging a high volume of queries to the slow log. Do not use copytruncate Logrotate offers two techniques for log rotation… practices: /var/mysql/slow_query.log { nocompress create 660 mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… the allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer… S3. Why? The push to S3 was especially puzzling since MySQL was not involved. The server was running with nearly 7GB… a lot (~150MB/s) but doing very little physical writes. The writes were cached and the write cache was causing the problem. It…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… memory (Battery or capacitor-backed write cache), etc., but the principle is basically the… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL …? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements SET count = $last_count where …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the first post: single SELECT queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed inside single-statement transactions… innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… doing a manual cache flush with vCache, this is a blocking operation. With FlashCache, echoing “1″ to the do_sync sysctl of the cache device triggers a cache flush, but it happens in the background…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…. Now, before looking at the graph, please do not jump to conclusions, as the graph is…4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_…myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… how memcached cache time expiry being apply into MySQL 5.6 memcached. e.g. if i want to store a cache object for… I can set cache life time as 12hours. Can this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain permanent? for doing cache clearing…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… the size of the partitions, the whole partition can be cached, as opposed to a single table, where probably only recently read records will be cached, resulting in more disc reads. 2. If you need to…. If you do queries on any other column, these could easily be quicker on a partitioned table, as Mysql can fire off…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… have item invalidated from query cache and there are multiple connection requesting the same item. What MySQL will do ? It will allow all… if it is worth doing or if delayed invalidation is enough. Improve Manageability What is in the MySQL Query Cache ? How many hits… thing about MySQL Query Cache is it knows exactly what is needed to refresh its content and so it can do it automatically…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… constantly referring to the amazing MySQL manual, especially the option and variable reference table. But…Binlog_cache_disk_useblogpercona.commanual binlog_cache_sizeblogpercona.commanual Binlog_cache_useblogpercona.commanual binlog_direct_non_transactional_updatesblogpercona.commanual binlog_do_…
