Shulou(Shulou.com)06/01 Report--

Innotop is a real-time monitoring tool for mysql database, which has powerful functions and a wide variety of information, which can reflect the state of the database.

It is actually a perl script that integrates show status/show variables/show engine innodb status output and performs statistics and formatting output.

Installation:

Yum install-y innotop

Usage: (remote connection is only supported in version 1.8 or above)

Innotop-u-p-h-P-d

Interface description: (interactive control, non-fixed interface, multiple pages can be switched)

Shift+B: displays information about InnoDB buffer pools, page statistics, insert buffers, and adaptive hash indexes. This data comes from showing the status of the InnoDB.

Shift+C: summary table by extracting the STATUS_VARIABLES variable. The variable must be numeric and must match the prefix of the given cmd_filter configuration variable. The percentage column is the percentage of the total number of variables in the table, so you can see the relative proportion of the variables. The default prefix is "Com_". You can select the's' key to change the filter prefix.

Shift+D: transactions involved in deadlocks in InnoDB in the past. The second table shows waiting transactions.

Shift+F: displays the error message of the foreign key of the last InnoDB. If there is no error message, it will not be displayed.

Shift+I: displays InnoDB's iUnip O information, including I / O threads, pending iUnip O, file iUnip O, log statistics.

Shift+L: displays information about the current lock. Currently only InnoDB is supported, and by default you only see transactions that are locked and waiting

Shift+M: output the information of SHOW SLAVE STATUS and SHOW MASTER STATUS into three tables, the first two show the status of slave sql and Icano, and finally show the status of the master

Shift+O: output from the SHOW OPEN TABLES command, which, by default, filters out the tables being used by one or more queries, so that you can quickly find out which tables are 'hot'. You can also guess which tables may be locked.

Shift+Q: this mode displays information from SHOW FULL PROCESSLIST, just like mytop's query list mode. There is an information header that displays general status information about the server. You can switch it on or off with'h'. By default, innotop hides inactive processes and its own processes. You can toggle and turn these off with the'i' and'a 'keys. Press e and enter thread ID to show the execution plan or f to display the complete sql statement, or o to display the system optimized statement.

Shift+R: displays InnoDB line operation, row operation miscellaneous, signal, innodb wait information

Shift+S: statistics of queries per second. You can display between absolute values, or incremental values.' The s' key does not have a certain time to print the number to the front. The'g 'key is to print the image. The' v 'key is displayed in the form of a table, refreshing the value periodically.

Shift+T: outputs the transaction from the innodb monitor. You can kill a query or process, through the'k 'and' x 'keys, or you can explain a query through the' e'or'f 'keys. All query transactions will not be output if the query is too long to be truncated. Headers can be turned on or off with the'h' key, and by default, innotop hides inactive processes and its own processes. You can toggle and turn these off with the'i' and'a 'keys.

Parameter description:

Innotop-help

-c specify the configuration file (after the assignment, there is no need to write the user's password and address, which is equal to the common query)

-d specifies the refresh time in seconds

-h specifies the connection address, which can be ip or domain name

-n becomes non-interactive, and the output separates fields with tabs (allows monitoring script calls to extract values)

-p specify the login password for the connection address

-P specifies the login port of the connection address

-S specifies the socket file address of the connection (equal to looking up the local machine)

-t prints timestamps in-n mode (1: per iteration; 2: per line)

-u specifies the login user name of the connection address

-- version to check the version number

Enter after successful connection? You can go to help:

Switch to a different mode: (the above usage is listed)

B InnoDB Buffers I InnoDB I/O Info Q Query List

C Command Summary L Locks R InnoDB Row Ops

D InnoDB Deadlocks M Replication Status S Variables & Status

F InnoDB FK Err O Open Tables T InnoDB Txns

Actions:

A Toggle the innotop process (switch innotop process) k Kill a query's connection (kill a query connection)

C Choose visible columns (visible column selection) n Switch to the next connection (switch to next connection)

D Change refresh interval (change refresh interval) p Pause innotop (pause innotop)

E Explain a thread's query (explain thread's query) q Quit innotop (exit)

F Show a thread's full query (display thread's full query) r Reverse sort order (reverse sort)

H Toggle the header on and off (head toggle and off) s Change the display's sort column (change the sort displayed)

I Toggle idle processes (switch idle process) x Kill a query (kill a query)

Other:

TAB Switch to the next server group / Quickly filter what you see

! Show license and warranty = Toggle aggregation

# Select/create server groups @ Select/create server connections

$Edit configuration settings\ Clear quick-filters

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.