… of improvements available in MySQL 5.6 which I… – Table Access instrumentation – - Statements instrumentation – - Stages Instrumentation – - Aggregations by User, Host etc – - Network IO… Explain for UPDATE/DELETE queries – - JSON output with more information – Optimizer Tracing – Deadlock Logging – …
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… available for this query SELECT whatstheweatherlike(5); Not overly useful for query optimization, is it? Well, I can still aggregate the slow query log with mk-log-parser and find routines that MySQL spends…
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.slow_log table instead of the file as … storage engine for log table which does not optimize TRUNCATE ? I guess it should be blocked as… would allow to aggregate log entirely in SQL finding most frequent slow query types or queries which load server …
Post: How to generate per-database traffic statistics using mk-query-digest
September 16, 2009 By Leave a Comment
… SHOW DATABASES; +———-+ | Database | +———-+ | db1 | | db2 | | db3 | | db4 | | mysql | +———-+ Separating the data in this …query-digest, and that is the –group-by argument. This can be used to aggregate…and the next most useful performance optimization is to migrate a database to…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… explained below. At this point we’ve optimized update complexity significantly however sheer volume of…mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive table and aggregate… has to run rather complicated group by query ? Sure it does but it does not…
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…output of a SQL statement. MySQL even includes a SQL statement… considered to be a performance optimization because: The contents of the…is likely expensive. Views containing grouping, aggregation, sorting, distinct or other conditions… a consistent snapshot of the query result. It is not possible…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 16, 2007 By 22 Comments
… too, in MySQL and in Postgres, it is just one of the tricks of the trade ! I believe the optimizer should be… yourself is the way. Recently I had a huge search query (in Postgres) which was horrendously slow. It has various conditions… a few aggregates. The archive + active is quite common so I’ll drop my way of doing it : – first query the active…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 16, 2007 By 22 Comments
… too, in MySQL and in Postgres, it is just one of the tricks of the trade ! I believe the optimizer should be… yourself is the way. Recently I had a huge search query (in Postgres) which was horrendously slow. It has various conditions… a few aggregates. The archive + active is quite common so I’ll drop my way of doing it : – first query the active…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 1, 2006 By 20 Comments
…aggregate function on some information that’s in main memory. The computer may then be able to optimize… how parallelism allows for smarter caches. More queries being executed simultaneously means you know more…the os cache, the controller cache, etc. If MySQL is able to acheive great performance with…
