June 18, 2013

Post: How to convert MySQL's SHOW PROFILES into a real profile

February 20, 2012 By 12 Comments

….18 seconds. Where did the time go? mysql> SHOW PROFILE FOR QUERY 1; +———————-+———-+ | Status | Duration | +———————-+———-+ | starting | 0.000032… | 0.0001336667 | | Creating tmp table | 0.000548 | 0.32 | 1 | 0.0005480000 | | Opening tables | 0.000196 | 0.11 | 1…

Filed Under: Insight for Developers, MySQL

Post: Innodb vs MySQL index counts

November 29, 2011 By 6 Comments

…Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL…error only happened when the table was opened and not on every table access.  So, it … a way to compare the output of SHOW CREATE TABLE to what Innodb thinks.  What …

Filed Under: MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…, sounds easy enough: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row *************************** Table: innodb_myisam_stopword Create Table: CREATE TABLE `innodb_myisam_stopword`… with this. These tools are free and open source, please use them. You, and your …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Be productive with the MySQL command line

December 21, 2012 By 14 Comments

…mysql> pager grep sequence PAGER set to ‘grep sequence’ mysql> show engine innodb status\Gselect sleep(60);show… you simply call edit: mysql> edit and it will open your default text…mysql> tee queries.log Logging to file ‘queries.log’ mysql> use sakila Reading table information for completion of table…

Filed Under: Insight for DBAs, MySQL

Post: AUTO_INCREMENT and MERGE TABLES

September 11, 2008 By Leave a Comment

…mysql> show create table am; +——-+————————————————————————————————————————————————————————+ | Table | Create Table…

Filed Under: Insight for DBAs Tagged With: ,

Comment: MySQL Server Memory Usage

September 1, 2006 By 21 Comments

…show_open_tables‘, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave_status’, ’13834′ ‘Com_show_status’, ’194766′ ‘Com_show…

Filed Under: Insight for DBAs Tagged With: , ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…

Filed Under: Insight for Developers Tagged With:

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL… show innodb status —TRANSACTION 0 80157600, ACTIVE 4 sec, process no 3396, OS thread id 1148250464, thread declared inside InnoDB 442 mysql tables… queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 10099, id 88021936, state…

Filed Under: Insight for DBAs Tagged With:

Post: How to Monitor MySQL with Percona's Nagios Plugins

February 22, 2012 By 11 Comments

…-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql-processlist plugin checks SHOW…, a pile-up of connections all trying to open or close tables can indicate LOCK_open contention. Replication is delayed or stopped. Our…

Filed Under: Insight for DBAs, MySQL

Post: How innodb_open_files affects performance

November 18, 2009 By 4 Comments

Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I … keep open file descriptor when table is open – open table is purely logical state and appropriate .ibd file may be open or closed. Furthermore besides MySQL table_cache…

Filed Under: Insight for DBAs, MySQL Tagged With:
« Older Posts
Newer Posts »