…the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have …in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up…_refills = 0, which means that the buffer was big enough and only 1 MRR range scan was needed…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… it in Percona Server ? There is whole set of improvement we made, like: Big log files Tuned flushing algorithm Disable flushing of… settings we have following results: As you see with Percona Server we have stable and predictable lines. Now, how to compare these results…, like MariaDB suggests in Benchmarking MariaDB-5.3.4. Raw results and scripts are on Benchmarks Launchpad Follow @VadimTk !function(d…
Post: Large result sets vs. compression protocol
December 20, 2007 By 6 Comments
… worse with compression. The bottom line: if you’re fetching big result sets to the client, and client and MySQL are on different… constant to your application, but the benefit might be pretty big.
Post: Handling big result sets
June 26, 2006 By 13 Comments
… result mode : MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT. (Also there can be used pair mysql_real_query / mysql_use_result or mysql_store_result… use $stmt->store_result(); to buffer the result on client side. The results: with $stmt->store_result(): 55.20s without $stmt->store_result(): 39.77s…
Post: Neat tricks for the MySQL command-line pager
June 23, 2008 By 10 Comments
…’t it?) mysql> pager less mysql> show innodb status\G For big result sets, it’s a pretty handy way to be able to… are any lock waits: mysql> pager /tmp/lock_waits PAGER set to ‘/tmp/lock_waits’ mysql> show innodb status\G ——- TRX HAS… we think of here? mysql> pager mk-visual-explain PAGER set to ‘mk-visual-explain’ mysql> explain select * from sakila.film…
Post: Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
September 17, 2007 By 12 Comments
… | +——+———+ 11 rows in set (29.68 sec) Use of extra temporary table for buffering helps us to get result set we’re looking… completing in 30 seconds rather than 40. Though fetching all result set in this case is still significantly faster. So GROUP BY… 1 row in set (0.00 sec) As I forced FileSort execution method for GROUP BY by using SQL_BIG_RESULT hint I…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…the new SpecJAppServer Results More information from Tom Daly can be found here These results are quite …makes it better to disable them. The MySQL Settings are probably what is the most interesting: …_cache_size = 0M – query cache disabled. Not a big surprise though as this is default value …
Post: SELECT UNION Results INTO OUTFILE
September 14, 2011 By Leave a Comment
… where | | NULL | UNION RESULT | | ALL | NULL | NULL | NULL | NULL | NULL | | +—-+————–+————–+——-+—————+———–+———+——+——+————-+ 5 rows in set (0.00 sec…the resulting files offline if you think the number of resulting rows would be to big to…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… may take long hours (this is indeed one of the big reasons to use Innodb even if you do not care… 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…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… changing only MySQL version on the same hardware with same settings causes regression. You can always improve them later after you… one by using hints such as STRAIGHT_JOIN, FORCE INDEX, BIG_RESULT/SMALL_RESULT. Check whatever stats are the same (run SHOW INDEXES… and increasing innodb-stats-sample-pages to get more accurate results. In recent Percona Server versions and MySQL 5.6 you…
