June 19, 2013

Post: Identifying the load with the help of pt-query-digest and Percona Server

Query_time distribution # 1us # 10us # 100us ################### # 1ms ################################################################ # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_terms’\G # SHOW CREATE TABLE

Post: Is disk Everything for MySQL Performance ?

of total data set in memory while over may require full 100%. Performance gains graphs in relation to fit inwhat is happening and why. A lot of pieces – filesystem, disk scheduling, database

Post: SHOW INNODB STATUS walk through

is visible in SHOW PROCESSLIST showed in SHOW INNODB STATUS, such as statement which is being executed, query id, query status etc. Next section you will see is section showing details ofis sized right), total number of pages in buffer pool, number of pages free, pages allocated by database

Post: Flexviews - part 3 - improving query performance using materialized views

of the query. convert.php This script takes as one argument the default database. Notice in the following example, the schema isis refreshed. This is not much different from building a table with CREATE TABLE .. AS SELECT. In fact, this is actually part of what

Post: Air traffic queries in InfiniDB: early alpha

databases in the same environment. See my previous posts on this topic: Analyzing air traffic performance with InfoBright and MonetDB Air traffic queries inwhat files are related to table. But after load, the size of 000.dir is 114G, which is as twice big as original data files. SHOW TABLE

Post: Gathering queries from a server with Maatkit and tcpdump

Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS LIKE ‘dual’\G # SHOW CREATE TABLEof the report — what is up with the 12% of queries

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

is that there are a lot of “new” InnoDB tablespace files in our databasetable by querying the various I_S.INNODB_FT_* tables. In particular, the INNODB_FT_CONFIG table is

Post: Advanced index analysis with mk-index-usage

is something worth looking into. What is query 7675136724153707161, anyway? mysql> select * from queries where query_id = 7675136724153707161\G *************************** 1. row *************************** query

Post: Shard-Query EC2 images available

Query is very flexible in it’s configuration, so you can use this sample databasewhat airline offered those flights and the flight number of the flight. Some data hand updated.’; — – Table structure for table `ontime_fact` — CREATE TABLE

Post: Shard-Query turbo charges Infobright community edition (ICE)

In this configuration, each shard has about 335MB-350MB of data (23GB raw data, compressed to about 2GB totalin the dimension tables. It will be very interesting to test these queries on various engines and databases. Following is a list of the queries