…pt-table-sync. It’s still unclear if or how one would sync a cluster that, in …mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql…to the pt-stalk –no-stalk changes, pt-fk-error-logger and pt-deadlock-logger received mini overhauls in 2.2 to make…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…’”; } change your schema In Example 2, above, how above moving the ‘joined’ column to the users_groups table so we don’t need to update… MySQL Innodb with asynchronous slaves. We may not think about the tradeoffs, but we’re making them (anyone obsessively testing slave position to…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…In some corner cases this could lead to assertion errors in the log parser or bad changed…in the MySQL client because the help tables were missing. Bug fixed #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to… feature has been optimized to make sure no additional work…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…to change if the fc_limit is dynamically resized or not. It contains no other magic that helps single node writing in PXC to…to allow replication to resume as soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…make more sense to configure MySQL as if it were using SSD storage or to…D) which combined the parameter changes from tests B and…massive data set size in relation to both the …mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… user queries, making it ideal…in order to add another layer of protection to the backups. innobackupex now uses Perl’s DBD::MySQL…in Percona XtraBackup 2.1. Percona XtraBackup can use XtraDB changed page tracking feature to…to a typo. Bug fixed #1172016. Percona XtraBackup would assume the table…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the… table with the old structure to the table with the new structure and will only wait at the last step when its about to make changes to table metadata. Let’s see another interesting side-affect of metadata locking. When can ALTER render the table inaccessible? Now…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
…of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot of good changes and …to set max_connections to over 5000 or use more than 5000 tables. There is also little “savings” in…. This means it makes it even more important to set this variable to higher values for sessions …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 8 Comments
… will chose best value automatically. Making this change I could bring optimization, and full query execution time to less than 50ms. Low values… 7 tables in join I think faster execution plan computation would be more important than backward compatibility. In MySQL 5.6 things are likely to…
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… which I think can help to make optimizer in MySQL, MariaDB or Drizzle better. Make it Plugable Every Major optimizer change causes a lot of pain… doing full table scan when Index access is better or because MySQL simply does not have execution method to resolve query in optimal way…
