… lag for a bit, not so in Galera. So, let’s see this effect in action. I have a simple script… DOWN:24 KB/s UP:174 KB/s eth1 DOWN:25 KB/s UP:172 KB/s eth1 DOWN:27 KB/s UP:196 KB/s eth1 DOWN:27 KB/s UP:195 KB… mysql 20u IPv4 39685 0t0 TCP *:3306 (LISTEN) Now, let’s re-do our above test: # 2 nodes in the cluster…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which l2arc and deduplication both need plenty…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… in the Percona Server 5.6 series. All of Percona’s software is open-source and free, all the details of…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…-checker will not be necessary for MySQL 5.6? Let’s have a look at the code implementing this feature. The… keys, but not redundant ones. What is the difference? Let’s see an example. If we execute: mysql> ALTER TABLE test…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…_size)*max_threads = 4432877 K bytes of memory Hope that’s ok; if not, decrease some variables in the equation. Thread…-xtrabackup-2.0.7-552.rhel6.x86_64 and it’s working perfectly. Best regards, Azigui
Comment: Is there a performance difference between JOIN and WHERE?
May 29, 2013 By 30 Comments
… wildly deviating what he needs on a continual basis, he’s either incompetent, lazy, abusive, or just plain stupid. Yes, there…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…@percona2 ~]# chkconfig corosync off [root@percona3 ~]# chkconfig corosync off Let’s specify that the cluster can start without quorum: [root@percona1.../cluster.conf --setcman keyfile="/etc/corosync/authkey" transport="udpu" Let's check if the configuration file is OK: [root@percona1 ~]# ccs…
Comment: ZFS on Linux and MySQL
May 29, 2013 By 17 Comments
… ran into performance issues during testing ZFS on Linux, it’s true it was some months before so maybe I should…
Comment: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
May 28, 2013 By 3 Comments
I backed port percona’s perf tuning for read_view to AliMySQL-5.5, with 1K connections case, RO 13187 -> 40797, RW QPS 2W -> 3W TPS 5K-> 8.5K Amazing ~
