… the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently… log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator…. Fixed the upstream bug #69379 which caused MySQL clients to return bogus error number for host-not-found errors on Ubuntu 13…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… examines very little data. It seems that InnoDB performs better when a larger number of rows must be joined together (Q4.1… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… before it occurs. For example, if you see a large number of long-running queries in the output of SHOW PROCESSLIST… you ever want to use MySQL on top of something like that? I can’t imagine the performance being all that fantastic, and I could see network latency wreaking havoc with MySQL‘s internal understanding…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
…gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, … 50000 with no movies, but your random number generator picks values in that range with … choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… few slave instances each of production database servers and will perform the backups. The write load is not excessive so a…. With LVM, your IO performance drops to 33% after the first snapshot so keeping a large number of snapshots running is simply… is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… monitors the names and number of active cluster nodes …, see bellow how to perform this action [root@percona1 percona]# …MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… to s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations are straightforward… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who…,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
… 2013 Log sequence number 17750417191 Tue May 21 22:24:15 CDT 2013 Log sequence number 17750981011 -rw-rw—- 1 mysql mysql 536870912 May 21 22:24 /var/lib/mysql/ib_logfile0 -rw-rw—- 1 mysql mysql 536870912 May…_faster And from the manual: http://dev.mysql.com/doc/refman/5.5/en/innodb-performance-recovery.html “If you kept the…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… question: why MySQL performance at low concurrency is important for you. I decided to write about this topic as a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer Guide has a number of…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… memory allocators on MySQL performance can be found in this blogpost. This release of Percona XtraDB Cluster has fixed number of foreign key… load. Bug fixed #1080539 (Teemu Ollakka). Standard MySQL port would be used when port number wasn’t explicitly defined in the wsrep… fixed #1164992 (Alex Yurchenko). Percona-XtraDB-Cluster-galera package version number didn’t match the wsrep_provider_version one. Bug fixed…
