…”flight”. I have labeled each query as Q{FLIGHT_NUMBER}.{QUERY_NUMBER}. In general, each …the filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For…mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…” width=”247″] Percona Server for MySQL version 5.6.11-60…in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS,…after an INNODB_CHANGED_PAGES query started returning data to indicate…cause small tablespaces to expand too fast around 500KB tablespace size. Bug …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…test we used a PowerEdge R720 box with a fast PCI-e flash card as storage. By default …to BUG#67808. For MySQL 5.6.11 top mutexes is &buf_pool->mutex,&new_index->lock. I profiled 5…table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema=0 #56only…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… ” NOT NULL, PRIMARY KEY (id) ) CREATE INDEX k on sbtest$I(k) …is low selectivity is not good for fast inserts, but it is suitable for…4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word…threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had … with no indexes typical operations like finding how many queries were accumulated in the logs or finding 10 last queries is not fast. The good thing however you’re allowed to change table to other storage engine and add extra indexes…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… any one of these factors (schema, queries, indexing) in isolation, because they are tightly …criteria. Both types of queries matter. Some may be extremely fast, but run very …
Post: Is it query which needs to be optimized ?
March 6, 2007 By 9 Comments
…MySQL Performance Forum as well as from our customers regarding query optimization… which had one thing in common – It is not query…sure all where clauses are using indexes, try to have queries index covered and avoid joins as much …BY LIMIT can be very fast… if it is done using Index or it can be…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… both directions for different queries. This will use fast primary key for some queries and use key K as covering index for lookup in… query is only selecting on vendor, will the index have any impact on the speed of the query? A: If you extend the index… more details. Q: how mysql use index for group by? A: If you have Index on the column MySQL can avoid temporary table or…
Post: Descending indexing and loose index scan
May 9, 2006 By 6 Comments
…. This is how MySQL will optimize indexed ORDER BY col DESC queries for example. Reverse scan could be as fast as forward scan – this… databases. Designing the indexes for MySQL you should only make sure queries use “=” for all keyparts in the last of index. Only last one… queries. In general complete loose index scan implementation is one of my most wanted features for MySQL optimizer. P.S If you post queries…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the….commanual innodb_fast_shutdownblogpercona.commanual …query_cache_limitblogpercona.commanual query_cache_min_res_unitblogpercona.commanual query_cache_sizeblogpercona.commanual query_cache_typeblogpercona.commanual query_cache_wlock_invalidateblogpercona.commanual query…
