…changed page data. Bug fixed #1108613. Percona Server wouldn’t start if the XtraDB changed page tracking was enabled and variable innodb_flush…5627 vulnerability, where an unprivileged MySQL account owner could …changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack…, this setting really does no more than to change if the fc_limit is dynamically resized or … node by simply by running “FLUSH TABLES WITH READ LOCK”, or perhaps by “LOCK TABLE“, in which case flow …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… changed page data. Bug fixed #1108613 (Laurynas Biveinis). Ported a fix from MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer satisfied mysql dependency which… xtrabackup_56. Bug fixed #1169971. innobackupex would still run with FLUSH TABLES WITH READ LOCK even if xtrabackup would fail when copying…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…in memcache or redis and only flushing to the database periodically? if( $last_count % 100 ==…change your schema In Example 2, above, how above moving the ‘joined’ column to the users_groups table…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… changed page data. Bug fixed #1108613 (Laurynas Biveinis). Ported a fix from MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…_capacity = 30000 innodb_adaptive_flushing_method = keep_average innodb_flush_neighbor_pages=none …(configuration D) which combined the parameter changes from tests B and C. …mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period…. Lets look at what the problem is. As of MySQL 5.5 FLUSH TABLES WITH READ LOCK does not work as optimally as… just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you can…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…, you’d usually ALTER TABLE `huge_table` CHANGE `id` `id` int(6) NOT NULL and then wait hours for table rebuild to complete. If…, (2) flush tables with read lock, (3) swap .frm files while keeping mysql suspended and (4) unlock the tables afterwards: — 1. mysql> CREATE TABLE `huge_table_new…. mysql> FLUSH TABLES WITH READ LOCK; Query OK, 0 rows affected (0.00 sec) — 3. mysql> ^Z [1]+ Stopped mysql test # mv huge_table.frm huge_table…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… which have opened it. Thus, from user perspective nothing has changed after the deletion. By the way, this is a good… and wait until InnoDB flushes all pages. To stop write activity we can either stop application or lock tables: mysql> flush tables with read lock; Query OK, 0 rows affected (0.37 sec) Now let’s wait until all dirty pages are flushed…
