… features even higher QPI speed (and thus, faster inter-… trx_list overhead created by concurrent updates. Once …= 2000M innodb_log_files_in_group = 2 innodb_file_per_…mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple-ranges=0 –oltp-sum-ranges=0 –oltp-order-ranges=0 –oltp-distinct…
Post: Speeding up GROUP BY if you want aproximate results
March 7, 2008 By 24 Comments
… temporary table was required (there were about 5 million of distinct pages visited during that day) which resulted in on disk… figure so I could trick MySQL to do group by a hash of the page instead of page itself: mysql> select sum(cnt) from (select count(*) cnt from performance_log_080306 group by…
Post: Just do the math!
July 6, 2009 By 4 Comments
…reports from your apache log files – how many distinct visitors hit the page and stuff like that….like “SELECT page,count(*) cnt FROM logs GROUP BY page ORDER BY cnt DESC LIMIT 100″ to find the…which affects scan speed. Another aspect is the temporary table – the number of rows MySQL can insert/update…
