… is the disk IO performance hit that comes with DRBD. When you run a virtual machine, in most cases your virtual disk… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… should state an obvious disclaimer here in that the aforementioned statements reflect only my opinion and not any official Percona position…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… READ ONLY MySQL transactions created by a non-locking SELECT statement in the autocommit mode. The relevant optimization in MySQL 5…, i.e. all queries are single-statement SELECT statements in autocommit. Which is the perfect case for read-only optimization in MySQL 5… alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This release of Percona…). In case CREATE TABLE AS SELECT statement was running in parallel with the DDL statement on the selected table, in some cases first statement could…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… lower bound on performance, only a upper bound. The best performance you can expect …available. The application just waits in those cases. From other nodes: First to commit wins…statement transactions since it cannot be assumed that those are not applying application logic in between the statements…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed…the same name. Fixed by detecting such cases and omitting the corresponding secondary keys from…Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed…the same name. Fixed by detecting such cases and omitting the corresponding secondary keys from…Bug fixed #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… inside single-statement transactions (TPS mode, see the original post on why this case is relevant). Dimitri didn’t touch case #2 and… some minor variation, e.g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10… does 9 primary key SELECTs followed by a PK UPDATE statement in each thread in a loop, which is probably a…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…(I will use INSERT .. ON DUPLICATE KEY UPDATE statements for that), so it will produce all good…write intensive. So what are results in this case: InnoDB gradually declines as data growth (which is …InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
… how much extra performance can you get by using prepared statements ? Results can vary. In certain cases I’ve seen 5x+ performance improvements when… see performance of simple query (single row point select) using standard statement, prepared statement and have it served from query cache. Prepared statements give…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… them. TRIGGERS When a statement activates a Trigger only the original query is logged not the subsequent triggered statements. If you want… but not the statement that the trigger executed. We have a trigger that calls a the procedure. In this case neither the… when using SET user-variables and then using it to perform writes. The issue is fixed only in Percona server 5…
