… InnoDB transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this structure… reason for notable MySQL performance drop. Now in Percona Server, for each connection we use a preallocated read view structure, reuse that…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
Post: Testing the Virident FlashMAX II
March 21, 2013 By 1 Comment
… (maxperformance reserves some additional space internally to provide better write performance). In “maxcapacity” mode, the device tested provides approximately 2200GB of… of predictable performance; the standard deviation on the asynchronous random read throughput measurement is only 5.7MiB/sec. However, the overall read throughput…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… – SSD config) which shows the most consistent performance. The others all have assorted performance drops scattered throughout the graph. We see the… time-based flushing enabled actually produces better and more consistent performance than vCache without time-based flushing, but even at its… = 64M serverid = 101 key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… the server deals with an empty transaction list when creating read views. However, the more general descriptors optimization in Percona Server… variation, e.g. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but…_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested… how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we will need… = 10 #*** MyISAM Specific options key_buffer_size = 8M read_buffer_size = 1M read_rnd_buffer_size = 4M bulk_insert_buffer_size = 8M…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release… Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling… the upstream bug #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were actually asynchronous when Thread…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. (Ignacio Nin) This release… Server for MySQL has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed and its controlling… the upstream bug #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were actually asynchronous when Thread…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… other magic that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls when flow… large receive queue might be the result of some brief performance issue on a given node, or perhaps the effect of… the cluster might have applying cluster transactions. Therefore, it keeps reads more up to date without needing to use wsrep_causal…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_block(buf_pool_t*) | | | |–94.84%– buf_page_init_for_read(dberr_t*, unsigned long, unsigned long, unsigned long, unsigned long… MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance…-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
… on dup key update” statements do a point query to read the row. If the row exists, then the row is… the fractal tree. This can result in dramatic performance increase since the cost of reads is amortized. TokuDB currently detected update expressions…
