How to quickly get to know your MySQL server

1. View the status of the database server:

MySQL Server Status under Linux

The list mainly includes the MySQL version (for version 5.1.61), therunning platform (Debian-linux-gnu (i686)), the database connection ID, the current connected user, and how to connect (this connection uses a UNIX socketinstead of SSL), the character set of the server, theMySQL runtime, and some parameters of the thread, query, table.

MySQL Server Status under Windows

This is the version of MySQL5.5.

2, after understanding the overall situation of MySQL, you need to understand the MySQL support storage engine:show engines;

In the MySQL5.1 version, the MyISAM engine is supported by default .

MySQL5.5 supports many storage engines and, compared to the 5.1 version, has changed the default storage engine to InnoDB, and theInnoDB engine supports transactions, row-level locks, and foreign keys. At the same time, it can be found thatMySQL5.5 more than one storage engine, namely Performance_schema; This engine is used to collect database server performance-related parameters and users cannot create tables of this kind of storage engine.

Performance_schema mainly offers the following three functions:

1 provides details of the process waiting, such as locks, mutex variables, and file information.

2 provides a summary of historical information.

3 New and deleted monitoring incidents, and can change the monitoring cycle of the MySQL server.

Performance_schema function: (This function cannot be turned on dynamically)

Add the following statement to the MY.CNF :[MySQLd] performance_schema, restart MySQL.

Check to see if this feature is turned on:

the value of Performance_schema is on , which indicates thatthe feature is turned on.

Specifically, the data in these tables how to use, when to use, and later.

For this step, as long as you know the MySQL version, these content is naturally should understand.

3. View Plugin engine:show plugins;

Here, I have installed InnoDB plugin , the reason for installing this plugin, because this plug-in than the MySQL comes with the InnoDB performance better, as to how to install, online a lot of introduction.

It is important to note that before the plugin is installed, it is necessary to determine whether the MySQL boot supports dynamic loading, and the way to see it is to use:

Show variables like ' hava% '; dynamic loading is supported if the have_danamic_loading value is Yes .

However, for the general MySQL version, basically support.

4, view is a single machine or cluster:show variables like ' Hava_ndbcluster ';

5, whether to configure replication:show master status;show slave status;

6. See what triggers and stored procedures are currently available under MySQL. Show triggers;show procedure status;

7, whether to support zoning:show variables like ' hava_part% ';

Summary: A few common commands to view MySQL server:

1, status;

2, Show status;

3, Show engines;

4, Show plugins;

5, Show engine InnoDB status;

6, Show master status;

7, Show slave status;

8, Show procedure status;

9, Show table status;

10, Show variables;

Ext.: http://www.cnblogs.com/benshan/archive/2013/01/09/2853097.html

How to quickly get to know your MySQL server