…can be set to control what is logged by the plugin: – audit_record_cmds : This is the list of commands you…you can control if it gets written on not with this list. I tested this with “connect,Quit” to log successful and failed…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
…”Conquering BigData with MySQL and Shard Query” Daniel Nichter, lead of the Percona Toolkit development team, will survey Percona Toolkit Command Line Tools -… MySQL, then this is an event you can‘t afford to miss… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…You can use the following information to find out where mysqld died. If you see no messages after this…you identify the cause of the crash. 130528 09:53:56 mysqld_safe Number of processes running now…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…command is not present any more 
It’s still possible to find the command…mysql): Slave percona3 (unmanaged) And now you are able to stop maintenance mode: [root@percona2 percona]# pcs property set maintenance-mode=false You can…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…now the current stable release in the 5.5 series. All of…of the release can…query …fail on CentOS 5 and Debian squeeze due to older OpenSSL version. Bug fixed #1183610. If a slave was running…This bug fix comes originally from MariaDB (see MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE tblname IMPORT TABLESPACE Now, you have a old version of the schema running… corrupted via user error or other issues) with SQL rather than needing to import from a remote server. This can allow for more…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…of requested LSN range was missing. Bug fixed #1179974. A warning is now returned if a bitmap file I/O error…t be queried if the log tracker wasn’t running…MySQL 5.6.11-60.3 are available in our online documentation. Bugs can…
Post: Percona MySQL University @Portland: June 17
May 22, 2013 By 1 Comment
…MySQL University event scheduled for June 17. We run this event in partnership with MySQL…you‘re not in Portland and would like Percona MySQL University to come to your city, please fill out…Now…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…now a continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL…of queries were tested on the SSB at SCALE FACTOR: 20. This means there is approximately 12GB of data in the largest table. You can…error=/var/log/mysqld.log pid-file=/var/run…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…can execute all events and be in sync…mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error…you can have some slaves using file-based positioning and some other slaves using GTID-based positioning. This answers the second question: we can…
