…MySQL is resource usage – specifically Memory Usage. I can’t count how many time I had to scratch my head with system configured to consume…to Performance Schema helping to find many performance bottleneck such profiling will help to find a lot of wasteful memory allocation and help to get MySQL…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…MySQL 5.1 get MySQL slow query log logged in mysql…QUERIES and use it instead, just remember unless you add extra indexes this table this can be rather time and resource consuming…to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most…
Post: Color code your performance numbers
June 2, 2010 By 4 Comments
… in aggregate functions. We most likely would like to see some percentile numbers …is ugly and resource consuming. There is however a simple way to get similar data… that will be considered unacceptable: mysql> select sum(wtime=1.0 … by their number and allows to see how good our performance really is…
