…mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_top_customers’)); Query OK, 0 rows affected (5.73 sec) It only took… customer. Notice how you can…time: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'complete_example2′)); Query OK, 0 rows affected (42 min 42.14 sec) mysql…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…time, datasize and query time to Google Spreadsheet so you can easy compare with previous results. There are different sheets for queries, datasize and time…query to run in row-by-row mode. but query took 667 sec : so I skip queries…Query Q4: mysql…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… parse_mysql_slow_log by Nathanial Hendler) which allows you to filter out only queries which took more than certain amount of time or… query log format and which gives samples of queries after aggregation. Here is how its output looks like: ### 3579 Queries ### Total time: 3.348823, Average time…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…: use “mk-query-digest –filter ‘$event->{time} && $event->{time} > 1′” to exclude all queries which it believes took longer than the servers long-query-time of 1… flaw — if your long-query-time is 1 second, and mkqd believes that a query which actually took 10ms instead took 0.9s, the results…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
…bit of information about queries that mysql-proxy can, …how to gather queries and do something useful with them. I’ll just watch the queries…used # 0% No_index_used # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms … it’s no surprise the query took a tenth of a…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… how we can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and… lot. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat… took 49 CPU seconds per 181243 select queries which is about 270us per select query. We can also get “BUSY TIME” here, subtracting CPU time…
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
… variation on MySQL Sandbox to set up a little throw-away MySQL instance — that took ten seconds…. queries? This time I’ll add LIMIT 2 to the query, because there are lots of them: mysql>… for queries 6095451542512376951 and 11680437198542055892. I think you can see how this goes — you can query …
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…MySQL Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries…queries pile up because query took many resources they will have time to resolve before next portion of the query takes place. Time…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…like to see how many connections and queries page generated and how long they took – I will place…helpful for simple applications which may run query several times per page. I however would … Multiple concurrent queries I would like to be able to run multiple queries for multiple MySQL connections …
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…my laptop: mysql> set @a := repeat(‘a’, 1024 * 1024 * 100); Query OK, 0 rows affected (2.34 sec) mysql> select … variable and a 100M lock key. Note how long it took to run these statements! And now mysqld … to watch the actual memory usage over time and see how it varies. When I’m initially setting …
