Partitioning probably reduces the stress on the insert buffer. Does XtraDB/Percona Server have an option to use more IO for insert buffer merges when the ibuf gets too big?
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
… disk utilization. Disk throughput: CPU (user) usage: Even with improvements, XtraDB performs less 150MB/s in disk writes (from benchmarks we… summarize MySQL InnoDB/InnoDB-plugin/XtraDB is not fully able to utilize throughput of FusionIO. XtraDB is doing better job with internal… want to use InnoDB-plugin or XtraDB to get better results. Putting logs on separate partition may be good idea, but only…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… using by the partitioning of MySQL. Added the following clause to the HISTORY table definition. “PARTITION BY HASH(REF_OBJECT) PARTITIONS 16″ Now the performance became to “+partitioned” in the graph. Looking the… is dict_operation_lock). It may be partition specific lock contention. The current XtraDB has the variable to tune the contention. innodb…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… stock MySQL server, InnoDB is usually your best bet. (Actually, XtraDB might be very interesting for you, but I digress).Â… that seem “less advanced” than using a database. Sharding and Partitioning Sharding is inevitable if your write workload exceeds the capacity… There are already inconvenient limitations on some key parts of partitioning, such as maintenance and repair commands, that essentially negate the…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
… searches can now be spread across multiple partitions (see Multiple Adaptive Hash Search Partitions. Bug fixed: #688866. (Yasufumi Kinoshita) Information … command was removed. (Vadim Tkachenko) The INFORMATION_SCHEMA table XTRADB_ENHANCEMENTS was removed. (Yasufumi Kinoshita) Several fields in the …
Comment: Maximal write througput in MySQL
March 1, 2010 By 10 Comments
… Vadim! Really cool article! BTW, I was wondering how does XtraDB and the like behaves over different RAID-10 stripe sizes… a lot of Linux distros don’t have their default partition boundaries aligned on raid stripe sizes (due to 63 sector… partition table). Have you ever considered (or have any plans) in making those tests? It would be great to see how XtraDB…
Post: Why you don't want to shard.
August 6, 2009 By 33 Comments
… there are quite a few options available to you: Sharding Partitioning by Application Function – This is usually the best way to… tables, and move them onto their own MySQL server. Partition-by-function keeps the architecture still simple, and should work… that is going to be in the course – “XtraDB: The top 10 enhancements”, and in Part 3 “XtraDB: The top 10 parameters”.
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 31, 2012 By 11 Comments
… p.s. The server does not like –innodb_adaptive_hash_partitions=8 option on command line. I don’t know why… the background threads to start 120131 16:00:44 Percona XtraDB (http://www.percona.com) 1.1.8-20.1 started…] /usr/local/mysql/bin/mysqld: unknown variable ‘innodb-adaptive-hash-partitions=8′ 120131 16:00:44 [ERROR] Aborting 120131 16:00…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
… under-report by 1 the number of rows read from XtraDB tables, which means that single-row lookups don’t increment… augmented: more server versions, tests for export/import, tests for partitioned tables. Bug reported: when filtering by table name, innobackupex doesn’t back up all *.par files for partitions. Also, a few other nuisance usability and functionality bugs were…
Post: FlashCache: tpcc workload
May 25, 2010 By 18 Comments
… allocated for buffer pool and I put 70GB on FlashCache partition ( just to simply test the case when data does not fit into cache partition). Please note in this configuration the benchmark is very write… PRELOAD TABLE / INDEX, and it is in our roadmap for XtraDB. With 80% dirty pages the performance gain in 1.7x…
