…. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but this involves… why that is the case. Maybe someone more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of…/audit.sock #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record_cmds=connect,Quit Notice the audit…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… Mysqldump works well for this, but can quite slow on larger schemas. One of the downsides …the dirty tablespace files while streaming the redo-logs to ensure that all transactions are also captured. …sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, …
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… MySQL slow logs during rotation Flushing logs takes time. Meanwhile, queries are still being executed. To prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs temporarily during log…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… in order to log every query. (See part two for handling massive slow log volume.) The slow logs are served, via HTTP, by mysql_slowlogd. This daemon is similar to running `tail -f slow.log`, except that…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… you run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest should…, you won’t be able to have access to the slow query log file, so pt-query-digest is often used with… the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who attended…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
“To prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs temporarily during log rotation.” Wouldn’t that be in the prerotate section? I don’t see one in the stanza provided.
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… pt-upgrade a try. It also reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t have… on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also… a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u…
Comment: Rotating MySQL slow logs safely
April 19, 2013 By 7 Comments
…astrostl, the slow logs are disabled in the postrotate stanza. The order of operations is: 1. logrotate renames the log file. MySQL continues to… stanza 2a. Slow logging is paused (set global long_query_time=2000;) 2b. There is a small wait for buffered logs to be flushed (select sleep(2);) 2c. File handles are reopened (FLUSH LOGS 
2d. Slow logging resumed (set global…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…. Bug fixed #1116177. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening… the log copying thread which could cause XtraBackup to crash. Bug fixed #1166888. Package dependency has been changed from abstract mysql to…. Percona XtraBackup would fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced… the log copying thread. Percona XtraBackup now stores the GTID value in the xtrabackup_binlog_info when doing the backup of MySQL…. Bug fixed #1079135. If there are thousands of tables and slow IO then XtraBackup can spend a lot of time opening…
