… MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL … answers. However, this means more latency waiting for a write to go through, and …change your schema In Example 2, above, how above moving the ‘joined’ column to the users_groups table…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available … hanging for unresolved MDL conflict. Fixed by adding a new method to cancel a thread waiting for InnoDB…changes (such as username and password) would be lost. Bug fixed #1158443 (Raghavendra D Prabhu). In case CREATE TABLE…
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…for MySQL was missing help texts in the MySQL client because the help tables…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…tutorial about Percona XtraDB Cluster (PXC) for MySQL. I actually had more material than … really does no more than to change if the fc_limit is dynamically …this case might mean a long wait before flow control gets relaxed again….certification index, which is a hash table. A small fc_limit does …
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… one noticeable omission: pt-table-sync. It’s …wait time between tries for all operations are configurable. Also, we removed –lock-wait-timeout which set innodb_lock_wait…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…changes from tests B and C. The graph below shows the sysbench throughput (tps) for…cache system is being crushed by IO wait. FlashCache and vCache both show improvements,… –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
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…for MySQL was missing help texts in the MySQL client because the help tables…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
… against that table need to wait. This is because MySQL has detected that the underlying table has changed and …TABLES, ALTER, RENAME, OPTIMIZE or REPAIR can cause threads to wait on “Waiting for tables“, “Waiting for table” and “Waiting for table flush”. Conclusion Before running an ANALYZE table…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… did not block waiting for the transaction to commit. For the reasons described above the implementation of Metadata Locking was changed, starting MySQL 5.5… the table otherwise it can easily cause a stall as many threads can get piled up waiting for table metadata lock bringing down the MySQL…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…waiting for hours for this statement to complete. Here is example how it can look: mysql…Waiting for table flush | flush tables with read lock | 0 | 0 | 1 | | 10291 | root | localhost | dumptest | Query | 74 | Waiting for…
