…result set…Compared the refresh performance and query results…mysql> select sum(total_lines) from complete_example2 ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.68 sec) Conclusion Flexviews supports two…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare full full… same system. I used two baselines for comparison. First is speed of PHP Associative array. This …/sec and it is almost doubled if result sets are cached from query cache. Pretty impressive. …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…compression ratio(compared to Innodb, 8:1 compared to …php genconfig 20 > shards.ini Running the test For best performance, you should run the workers on one or two…results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results & …mysql wait-timeout=86400 To be continued You can now set…
Page: Presentations
May 3, 2006 By
…comparing it to the alternatives. Slides by Andrew Aksenoff, Russian Language. Download MySQL…results outdate pretty quickly. Download MySQL Performance 5.0 vs 4.1 MySQL…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…ahead depth here. These settings mean there can …, crashes, or wrong query results get the highest priority…fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning…are slower with Flash disks compared to Reads because Flash …Mysql server for a client, upgrading their main database (from 16GB, 2 two…
