In many environments MySQL is not the only technology used to store in-process …-scale or complicated applications, we use MySQL alongside other technologies for certain tasks of reporting, caching as well as main data-store… technologies for data storage and processing do you use alongside MySQL in your environment? Please feel free to elaborate in the…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… a regression that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed the… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb_flush_method=O_DIRECT key_buffer…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… this, maybe it is related to better raid controller write cache use. Even the fairly slow gzip-1 mode works well… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Comment: ZFS on Linux and MySQL
June 8, 2013 By 17 Comments
… illumos ZFS by giving up 10% total ram for metadata caching, but it is just the price you should be willing… OmniOS should only be used as MySQL read slaves behind a pair of Linux based MySQL Masters using Pacemaker. Maybe you guys…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… your mind! There are numerous solutions for MySQL high availability. Many rely on MySQL’s asynchronous replication to maintain a warm standby…_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin… same chunk again. We expected everything to be cached if we warmed the cache with the exact same data. All the graphs…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…, I described a solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set… addition to logs. Flushing tables can impact running queries. Disable MySQL slow logs during rotation Flushing logs takes time. Meanwhile, queries… 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: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or… the entire cache is cleared (think restarting a memcache node). This is where a persistent cache can be invaluable. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5.6…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. … 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…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and…=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only…
