… or bad changed page data. Bug fixed #1108613. Percona Server wouldn’t start if the XtraDB changed page tracking was enabled and variable innodb… a bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t have the path separator… fixed #1132412, bug fixed #1153651. Release notes for Percona Server for MySQL 5.1.69-17.4 are available in our online…
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 2 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 server starting if the innodb_data_home_dir variable didn’t have the path separator at the end. Bug fixed #1181887. Changed… fixed #1177780, bug fixed #1154954. Release notes for Percona Server for MySQL 5.6.11-60.3 are available in our online…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…MySQL server on a node is hung. As a consequence clustercheck script would never fail-over that server. Bug fixed #1035927 (Raghavendra D Prabhu). High values in variables evs….-Cluster-server package, /usr/bin/clustercheck script would get overwritten, and any changes (such …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… (0.04 sec) mysql> show slave status\G Empty set (0.00 sec) mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO…-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…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… — New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be… Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable… lead to assertion errors in the log parser or bad changed page data. Bug fixed #1108613 (Laurynas Biveinis). Ported a fix…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be… Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling variable… lead to assertion errors in the log parser or bad changed page data. Bug fixed #1108613 (Laurynas Biveinis). Ported a fix…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…change). Here are some highlights: Official support for MySQL 5.6 and Percona XtraDB Cluster We started beta support for MySQL…MySQL 5.5) for metadata locks. Now –set-vars is used to set both of these (or any) system variables… results from running queries on a server. Granted, this can take a lot…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…server Innodb, we’d get: [On a single node Innodb server…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… times specified by this variable (default is 1 retry). …$last_count where achievement = ‘killed_troll’”; } change your schema In Example 2…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
MySQL Server has tons of variables which may be adjusted to change behavior or for performance purposes. They are documented in the … and HEAP for in memory tables. So first MySQL versions did not bother naming variables with storage engines prefix. This is why… it mean MyISAM variables are not important ? Not really. You still have some tables in MyISAM format in “mysql” database. Plus HEAP…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
MySQL Settings (also known as Server Variables) have interesting property. When you set variable in running server this change is not persisted in any way and server… such change easily because MySQL Server does not seems to have an easy way to check what was the default value for given Server Variable…
