…query execution time. It may be possible, therefore, to refresh an MV based on a query that takes 45 minutes to execute…showed how you can combine both types of views together. The complete method examples show how to…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…MySQL command line client was used to execute the a script file containing the 11 queries…queries show how performance is improved when Shard-Query…to spread your data over multiple machines, scaling out to improve query response times significantly. These queries are a great test of Shard-Query…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…to show (click show/hide to change the columns) That the “public dns” field is selected SSH to…time). $ echo “select count(*) from ontime_fact;” | ./run_query Array ( [count(*)] => 135125787 ) 1 rows returned (0.084244966506958s, 0.078309059143066s, 0.0059359073638916s) Execute…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
…MySQL 4.1 there were only textual statements and textual protocol for data transfer – query…time to avoid overload. Check execution rate You can take a look at Com_stmt_execute to Com_stmt_prepare ratio to see how many times…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… was previously populated to contain value and measuring how long does it …First is speed of PHP Associative array. This is to show kind of peak …to access same data read from database multiple times. Examining MySQL full query logs from many applications seeing several exactly same queries executed…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
…queries taking 30 seconds it is clearly slow queries. If it is 10.000 queries executed and total response time…MySQL Query Log. What is important is however to be able to connect the data from these logs – glue them together. The easy way to…
