… and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was… fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… and omitting the corresponding secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was… fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… it were using SSD storage or to just use an optimized HDD storage configuration? After creating a vCache device with the… this configuration B. The next one contained four SSD-specific optimizations based partially on some earlier work that I’d done…’d determined that configuration C appeared to produce the most optimal results, I moved on to reviewing FlashCache performance versus that…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 9, 2013 By 32 Comments
… upserts that avoids the point query in some cases. This optimization was not used in the benchmark. Since TokuDB does not currently support the VALUES update expression, the optimization was turned off. We are adding this to our code…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… fixed #1031427 and #1051874. When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when there… secondary keys from deferred key creation optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
Rich, Was this upsert optimization used in Vadim’s tests? If not how do you turn this optimization on?
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 8, 2013 By 32 Comments
Hello Vadim, TokuDB supports an upsert optimization that is applicable to your second test. Typically, the “insert … is updated. Otherwise, the row is inserted. TokuDB has an optimization in which the point query is avoided and replaced by…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… heap area and then creates requested block(s) there. That optimization helps to avoid fragmentation in case of many small allocations… with transaction list scanning (due to the read-only transactions optimization), but it still allocates/frees memory for read view structure…
Post: What I'm looking forward to at Percona Live (MySQL Users Conference)
April 4, 2013 By 1 Comment
… will give an Innodb and Performance Optimization Tutorial as well as talk about Goal-Driven Performance Optimization and Choosing storage systems for…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… select the queries you should try to improve to get optimal response times pt-archiver, to efficiently purge purge data from… challenges, such as: Selecting which queries you should try to optimize to get better response times How to efficiently purge data…
