…customer_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo',... lines. Refreshed both views. Compared the refresh performance and query results. The view type does… in set (0.68 sec) Conclusion Flexviews supports two refresh methods, the complete method and the…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…the aggregated data can significantly improve query response times compared to accessing the non-aggregated … log position. php ./setup_flexcdc.php –ini consumer.ini $ php setup_flexcdc.php setup starting setup… changes, respectively. Finally, note that the two insertions happened inside of the same …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…ICE gets over 16:1 compression ratio(compared to Innodb, 8:1 compared to raw input data), which is …. cd shard-query #generate a config for 20 shards (adjust to your number of nodes) php genconfig 20 > …should run the workers on one or two nodes. You should start two workers per core in the cluster. …
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare full full stack, cached… were running on same system. I used two baselines for comparison. First is speed of PHP Associative array. This is to show… very interesting when it comes to compare it to MySQL Query Cache – It performs faster than Query Cache if TCP/IP socket is…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
… is not helpful as we might want to compare them to the fast transactions to understand why… can report time it took to execute SQL query from PHP application side, but we can’t say…queries you execute. Optional Tracing The information in lower layers logs is very helpful however it typically have two…
Page: Presentations
May 3, 2006 By
… and basic usage patterns Download Query Optimization Web Tuesday , Zurich, Switzerland,… Full Text Search solution and comparing it to the alternatives. Slides … users may find one or two things about Innodb they did…MySQL Performance. Download MySQL and PHP for Web Applications Open Source Revolution…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…limited. Compare this with other OpenSource projects such as PostgreSQL (plugable indexes etc), Apache, PHP or… ourside of storage engines as plugins. Two aspects why I’m especially interested …guys. These would include support for query timeouts, parallel query execution, CONNECT BY support and …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… http://bugs.mysql.com/bug.php?id=29560 Concerning a switch…writes are slower with Flash disks compared to Reads because Flash requires “… main database (from 16GB, 2 two-year old HT’ed XEONs …about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.)….
