…is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute… Now let’s come down to the interesting part. Results With the table purchases_noindex, that has no secondary…we can see the impact of growth in data-set on the insert rate. We can see that …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… you have a small buffer pool and a very large number of rows from table2 that do not fit… the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used… in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up,…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used TPC…. Note that as mentioned at the start of the benchmark results section, the InnoDB dataset size is ~5G. Ok so now…. The query time is reduced further when buffer size is set large enough so that the index tuples fit in the buffer…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…causes. Is it working with large blobs ? Using user variables ? Prepared Statements ?…_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.98 sec) This … global memory allocation and will result in increased memory allocation until …
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… WITH READ LOCK can be quite large because of the time it may …| 0 | 0 | 1 | +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ 5 rows in set (0.00 sec) As result this means single run …
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… preparing for massive growth. To make sure it handles large data sets as part of the process we work on generation test… by default mysql_query uses mysql_store_result C library call and buffers all result set in the process memory. Not good if…. This call users underlying mysql_use_result API call which does not store all result set in memory but instead streams it from…
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
… with compression. The bottom line: if you’re fetching big result sets to the client, and client and MySQL are on different…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… with smaller data sets to play with different schema designs and index structures… this however results in the challenge as results you’ve gotten for small data set may not apply to large data set so you need to re-test your “final design” again with large set. One thing…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…(pad) from large; +————+ | count(pad) | +————+ | 31457280 | +————+ 1 row in set (4 min 58.63 sec) mysql> select count(pad) from large where val… aggregate result sets. So if you’re dealing with large data sets and complex queries here are few tips Try to fit data set you… table scan may be faster. Avoid joins to large tables Joining of large data sets using nested loops is very expensive. Try to…
Comment: MySQL Query Cache
January 23, 2011 By 69 Comments
…, best to avoid caching large batch which run maybe once a day. Also for queries which return large result sets but are run infrequently…
