… versions of Percona Server. Bug fixed #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force… integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL… by Percona Toolkit. The MySQL server, of course, cannot risk to block directly all cases. A set of MySQL utilities were introduced by Oracle…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… the plugin is its flexibility, and not its performance, which seems to be on par with having… comes from the three variables that can be set to control what is logged by the plugin: -… an important missing feature on the server, which has made using MySQL in PCI or SOX compliant environments,…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…Server for MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release Candidate release of Percona Server…the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed … to indicate an incomplete result set. Bug fixed #1185040. The INNODB_…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…Server for MySQL version 5.5.31-30.3[/caption] Percona is glad to announce the release of Percona Server for MySQL…, where an unprivileged MySQL account owner could perform brute-force password guessing …#1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…So, in effect, you’re adding performance hit to performance hit. The other reason is … to replicate everything EXCEPT a specified set of databases and tables. With this method…in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db under…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…g” /etc/sysconfig/cman And create the cluster, perform the following command on one server only: [root@percona1 ~]# ccs -f /etc/…Slave Set: ms_MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the other servers to s2. This scenario can happen when you want to perform a planned …For s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And… executed: s1> show slave status\G [...] Executed_Gtid_Set: 219be3a9-c3ae-11e2-b985-0800272864ba:1, 3d3871d1…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs… with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs… with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed…
