… one. We can use the new MV (dashboard_top_customers) to list the top 10 customers nearly instantly. Note that every MV gets… aggregate functions. Now I delete some line items from orders: mysql> delete -> from order_lines -> where order_id -> between 1 and 100 -> limit 500; Query OK…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…DELETE poller…top queries, we have 10% in MISC which means that by reviewing these top…MySQL. The end result might be that you end up limiting the number of results returned by the query, by using a LIMIT… # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM …
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 …accumulated in the logs or finding 10 last queries is not fast. The…FROM slow_log ORDER BY start_time DESC LIMIT 100 you would find new queries coming to the top… query is running, neither you can delete rows from it (or do any write …
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…delete‘, ’348788′ ‘Com_delete…top…mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_connections=650 open_files_limit…from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from…
Comment: ORDER BY ... LIMIT Performance Optimization
February 17, 2011 By 100 Comments
…this whole MySQL optimization stuff. Anyways… update/insert/delete queries to …FROM `listings` WHERE `category` = 1 AND `country` = 1 AND `state` = 45 AND `city` = 35859 AND `visible` = 1 ORDER BY `price` ASC LIMIT 0, 10 Now, `category` numbers …order by on top of that….
