…the general log enabled. The flexibility comes from the three variables that can be set to control what is logged by the plugin: – audit_record…query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all the…to a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…from the other side, things start to degrade. If you’re just setting up a test environment to get familiar with the…the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables; you can also configure the…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…getting them from the OS cache, which is another advantage of InnoDB. SSB Flight #2 Flight #2 is similar to…the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it, Percona Server 5.6.11-60.3 is the… thus does not need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the LV when we need to and align the…the tpcc test and that’s maybe just normal. We didn’t try too hard to get…record…the data will be read from the other drive in the…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…table, run: ALTER TABLE tblname DISCARD TABLESPACE Copy the .exp and .ibd files from the snapshot to the new instance: cp /tmp/snapshot/2013-06-03_11-30/orig/*[.exp|.ibd] /var/lib/mysql…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… much as you think. While the theoretical limit of 1Gbps is actually 120MBps, I start to get nervous around 100MBps. By default Galera… really much different from standard mysql replication. 1 master with 5 async slaves is going to send a separate replication stream to each, so your…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required, I prefer to create this once so that the…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
….6(clone+0x6d)[0x33dfee890d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona… automatically 130528 09:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another…
