… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… libdbd-mysql-perl package. Fixed by adding the package dependency. Bug fixed #1003776. XtraDB changed page tracking used to hold the log… the path separator at the end. Bug fixed #1181887. A warning is now returned if a bitmap file I/O error…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] …Changed page tracking used to hold the log system mutex for the log reads needlessly, potentially limiting performance …LSN range was missing. Bug fixed #1179974. A warning is now returned if a bitmap file …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262… key definitions would be lost. Bug fixed #989253 (Alexey Kopytov). Warning about the Percona Toolkit UDFs was omitted when installing from…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… backups. Bug fixed #1079135. Fixed couple of warnings found in innobackupex when all warnings have been made FATAL. Bug fixed #1116177. If… 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 Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… Percona Server for MySQL 5.5.28-29.3 which could cause a server to hang when binary log is enabled. Bug… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262… key definitions would be lost. Bug fixed #989253 (Alexey Kopytov). Warning about the Percona Toolkit UDFs was omitted when installing from…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also… DBD::mysql Perl module that have problems. And there are certain versions of MySQL that have critical bugs. Version check will warn you… a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option and…log_binblogpercona.commanual log_binblogpercona.commanual log_bin_indexblogpercona.commanual log_bin_trust_function_creatorsblogpercona.commanual log_errorblogpercona.commanual log_isamblogpercona.commanual log_outputblogpercona.commanual log…commanual warning…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… logs. General Query Log The first option is the General Query Log. Let’s see an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log… log. We just need to enable log_warnings with a value greater than 1: log_warnings = 2 Then check the error log: 121227 8:44:21 [Warning…
Post: Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
December 19, 2012 By Leave a Comment
… each of those file, a corresponding warning or error message is present in the mysql error log file. Those error can also be… log file: [root@node2 mysql]# ls GRA_*.log GRA_3_3.log [root@node2 mysql]# file GRA_3_3.log GRA_3_3.log: data [root@node2 mysql..._3.log GRA_3_3.log: data [root@node2 mysql]# file GRA_3_3-bin.log GRA_3_3-bin.log: MySQL replication log [root@node2 mysql]# mysqlbinlog…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…mysql-data-201202230155 sb swi-a- 5.00g mysql-data 0.00 mysql-data-201202230157 sb swi-a- 5.00g mysql-data 0.00 mysql-logs… sec) Records: 300024 Duplicates: 0 Warnings: 0 mysql> update employees set age = ((YEAR(CURDATE())-YEAR(…
