… in the graph as the blue line – SSD config) which shows the most consistent performance. The others all have assorted performance… –num-threads=32 –test=tests/db/oltp.lua –oltp_tables_count=32 \ –oltp-table-size=10000000 –rand-init=on –report-interval=1…=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… also show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput, and on data size: InnoDB table: 58GB and 244.980.192 records TokuDB table: 15GB… –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… views. However, the more general descriptors optimization in Percona Server showed fairly close results in our tests. In Dimitri’s tests… –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1 –rand… –num-threads=<1..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-interval=1 –rand…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… any node by simply by running “FLUSH TABLES WITH READ LOCK”, or perhaps by “LOCK TABLE“, in which case flow control will… key lookups into the certification index, which is a hash table. A small fc_limit does however keep the certification index… tell flow control came from this node because ‘Flow snt’ shows a message sent as soon as flow control is engaged…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… = $timer->stop(); $avgTimeFetch = $totalTimeFetch / 1000000; While this benchmark doesn’t show any multi-threading or other advanced operation, it is using… fetch operation was 20% higher (~.06 ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced… WHERE id=’key_id’”); id is PK of the container table While there are increases in both operations, there are some…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due to… the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… been deprecated. Feature has been removed because the upstream DROP TABLE implementation has been improved. (Laurynas Biveinis) Bugs Fixed: Due to… the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… library will be available for download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be… it will still replicate in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo Jaakola). In case… slave crash. Fixed by using primary key of the child table when appending exclusive key for cascading delete operation. Bug fixed…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup… backups has been merged. Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug fixed… binaries, the –version message which should include the revision was showing “undefined”. Bug fixed #1171721. Other bugs fixed: bug fixed #1088307…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup… backups has been merged. Fixed by removing files corresponding to tables that are missing in the incremental backup directory. Bug fixed… binaries, the –version message which should include the revision was showing “undefined”. Bug fixed #1171721. Redundant code has been removed from…
