… #1144777 (Ignacio Nin). When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly… from MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait…_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… #1144777 (Ignacio Nin). When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly… from MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait…_view_create_low() in most cases. This significantly improves InnoDB scalability on read-only workloads, especially when the default glibc memory allocator…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…. Binaries are available from the downloads area or from our software repositories. New Features: …the case when DROP TEMPORARY TABLE statement was used, but it will still replicate in case DROP…slave hanging. Bug fixed #1130888 (Seppo Jaakola). If MySQL replication threads were started before running…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… it became a matter of figuring out if the server was hitting its capacity, or if there was another limiting factor in the workload that made it scale poorly. This is when the ‘SHOW… the number of times they appear in processlist. In this case, I extracted the first snapshot from each *-processlist capture (under…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… problem: 1) memory allocation is an costly operation and if memory allocator has scalability problems (like allocator from glibc)… case when we need memory only for a single block this 2 layers approach is quite inefficient and in some cases…no difference in results between runs either with glibc or …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… default values. This means that if you run START SLAVE (or if it’s done automatically, for instance when restarting the server without the… configured as slave; fix in config file or with CHANGE MASTER TO Much better! If we try to restart replication, it fails…, the connection parameters are still held in memory. In any case, you will be able to restart replication, but again as…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… by running “FLUSH TABLES WITH READ LOCK”, or perhaps by “LOCK TABLE”, in which case flow control will kick in just as…_control_sent so you can tell if and when flow control is happening and what node (or nodes) are causing it. Using myq_gadgets, I can easily see flow control if…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… available. The application just waits in those cases. From other nodes: First to commit wins….counter in memcache or redis and only flushing to the database periodically? if( $last_count % 100 == 0 ) …us are used to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… it make more sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage…-based flushing has been disabled. In this case, both systems produce better performance when the dirty-page threshold is set to 50… time; I’m not entirely sure why that’s the case or at what point the performance is going to level off…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…brewing. You pointed out an important use case for PARTITIONing (“uneven reads”, Re: #1); …UPDATE) are similar in speed between PARTITIONed or non-PARTITIONed. When PARTITIONed, first it has to …remove one record. PARTITIONing makes very little difference. * If it cannot prune, then partitioned would …
