… the XtraDB changed page tracking was enabled and variable innodb_flush_method was set to ALL_O_DIRECT. Bug fixed #1131949. Fixed… integers now. Bug fixed #714925. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the… to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients to return bogus 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 for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB… #1171941. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… MDEV-3915). Bug fixed #1172090. mysql_set_permission was failing on Debian due to missing libdbd-mysql-perl package. Fixed by adding the…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… general log enabled. The flexibility comes from the three variables that can be set to control what is logged by the plugin… want written to the log (all the lists in these variables are comma separated). As pointed here, anything that would generate… possibilities of extending MySQL‘s behavior in a way that, once set up, is transparent to users, and the McAfee MySQL Audit Plugin…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… it. One way is to set up replication filters on the slave, as described in the MySQL manual. You can configure the… also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is… safe bet that MySQL is up and running. That said, there are plenty of other MySQL and OS-level status variables that you…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 2 Comments
…13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona…server starting if the innodb_data_home_dir variable didn’t have the path separator at the …started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… queue (visible via the wsrep_local_recv_queue global status variable). Donor/Desynced nodes do not apply flow control, though they… few settings that are relevant here, and they are all configured via the wsrep_provider_options global variable. gcs.fc_limit This setting… tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… what you want. So never set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First the master-xxx variables are no longer supported, which is a great improvement. But the RESET SLAVE statement also behaves differently: mysql> stop…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running wsrep…run XtraBackup indefinitely when xtrabackup tmpdir was set up on tmpfs. Bug fixed #1086978 (Alex…found. Bug fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable…_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client to abort… with Perl and Python clients when plugin-dir option was set in the [client] section of the my.cnf. Bug fixed…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
….1-log 1 row in set (0.00 sec) mysql> show variables like ‘%thread_handling%’\G *************************** 1. row *************************** Variable_name: thread_handling Value: one-thread-per-connection 1 row in set (0…
