… this post. Similarly, reloading the data will be a very IO intense operation (redo logs, binlogs, etc) as well further polluting…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to…
Comment: Profiling MySQL Memory Usage With Valgrind Massif
June 5, 2013 By 3 Comments
… this very useful post. I was wondering – what is the performance penalty of running mysqld (or any other program) under Massif…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… have the luxury of not blocking the master from taking writes if bandwidth is constrained and the slaves lag for a…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… of SchemaSpy jar file (5.0.0 at time of writing) Make sure you have latest copy of Java JRE for… /var/www/schemaspy/ The -o directive tells SchemaSpy where to write the output to, make sure this is a directory that… implicit constraints that you might have missed and can then write into your metadata file. Donate – This is free software and…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… best right now with benchmarks showing up to 50% more performance than even lzjb. With future LZ4 compression for L2ARC combined…
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… source database and provisioning clones from those snapshots. We are writing a book on Data Virtualization for Databases meaning using a…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
Here at the MySQL Performance Blog, we’ve been discussing the several new features that …: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other InnoDB and query optimizer… is a waste of resources that could potentially impact our performance, and should be avoided. By the way, a good practice…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… in maintenance mode before the update, see bellow how to perform this action [root@percona1 percona]# yum update -y [root@percona1..._TIMEOUT=0/g" /etc/sysconfig/cman And create the cluster, perform the following command on one server only: [root@percona1 ~]# ccs…
Comment: ZFS on Linux and MySQL
May 29, 2013 By 17 Comments
Nice article! Actually I ran into performance issues during testing ZFS on Linux, it’s true it … implementation has not yet been optimized for performance. As the project matures we can expect performance to improve.” http://zfsonlinux.org/faq…
