…query_time), ‘ Lock_time: ‘, TIME_TO_SEC(lock_time), ‘ Rows_sent: ‘, rows_sent, ‘ Rows_examined: ‘, rows_examined, CHAR(10), ‘SET timestamp=’, UNIX_TIMESTAMP(start_time), ‘;’, CHAR… ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in my bk-…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… examine …mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row…echo “select count(*) from ontime_fact;” | ./run_query Array ( [count(*)] => 135125787 ) 1 rows…
Post: Distributed set processing performance analysis with ICE 3.5.2pl1 at 20 nodes.
May 14, 2011 By Leave a Comment
…ICE to 2.5GB. Many of these queries examine the entire data set doing origin/count(distinct …fi for i in `seq 1 $workers` do echo “Launching benchmark worker #$i with $iterations iterations” ./bench_… -p “results/$2/” ./run_query < queries.sql |egrep "rows|^-” > results/$2/raw.$$.$i.txt done; Query …
