…’s a theory that seems to explain the performance you are seeing. The periodic performance variation corresponds to filling up a partition…’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches. So performance gets worse…/head%3A/bench/ibench/iibench.py) is that it measures query performance too, so if you fail to actually index the data…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… cause downward spikes in performance. Other then that, I have also disabled query cache to avoid contention caused by query cache on write… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and… important things to consider when you are concerned with write performance is using partitioning to reduce the size of the B…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
One of the very frequent cases with performance problems with MySQL is what they happen every so often … problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many… too much in this case throttling by having relatively short queries and introducing “sleeps” between them can be a good idea…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
…_CALC_FOUND_ROWS defiantly appears to be situational on the query (at least now on Percona 5.5 server) I have… a table with 10+ million rows. Results are Data & Count Query = 1.8 seconds 1) .90 for the data 2) .90… the data with SQL_CALC_FOUND_ROWS. No performance impact when using SQL_CALC_FOUND_ROWS 2) .013 for FOUND_ROWS() query
Comment: Multi Column indexes vs Index Merge
May 8, 2012 By 30 Comments
… table improve high perfomance in select queries, but worsen perfomance in Insert, Update and Delete queries. Is it true? And if is it, how could i balance the choice??? too many indexes and high performance select…
Comment: Joining many tables in MySQL - optimizer_search_depth
May 12, 2012 By 6 Comments
Ovais, Syntactic hints surely help pushing the performance in case of particular queries but surely cannot be an all-around answer to…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… these rows an index lookup is performed on the second table. This means many point queries, say for example if table1 yields 1000 rows then 1000 index lookups are performed on table2. Of…_buffer_size is not going to provide the best possible query performance. As I mentioned at the start that BKA uses the…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
… have a huge number of concurrent writes and selects and query performance must be consistently fast in this use case – you should… you get the benefits of MyISAM which includes consistently faster query speeds, tables which are easily maintained, is more easily tuned…
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
Don’t forget that Timour and Sergei are giving a 3 hour tutorial on MariaDB 5.3 (and 5.5?) and MySQL 5.6 optimizers: http://www.percona.com/live/mysql-conference-2012/sessions/improving-mysqlmariadb-query-performance-through-optimizer-tuning
