Show status and show variables difference resolution

1.show Status View the real-time status of the system operation, so that the DBA can see the status of the current operation of MySQL, to make the corresponding optimization, dynamic, not considered modified, only the system automatically update.

MariaDB [(None)]> show status like '%conn% ';

+--------------------------+----------+

| variable_name | Value |

+--------------------------+----------+

| aborted_connects |   101 | ----Number of interrupt connections

| Connections |    11066535 | ----Total number of connections

| max_used_connections |    151 | Maximum number of connections-----ever

| ssl_client_connects | 0 |

| Ssl_connect_renegotiates | 0 |

| ssl_finished_connects | 0 |

| threads_connected |    10 | ----The current connection client

+--------------------------+----------+

2.show variables View system parameters, system default settings or DBA tuning parameters after tuning, static. You can modify the MY.CNF configuration file through set or modify.

MariaDB [(None)]> show variables like '%conn% ';

+--------------------------+-----------------+

| variable_name | Value |

+--------------------------+-----------------+

| character_set_connection | UTF8 |

| collation_connection | Utf8_general_ci |

| Connect_timeout |    10 | ---Number of connections time-out

| extra_max_connections |    1 | ---Additional maximum number of connections

|                 Init_connect | |

| max_connect_errors |    10 | ---Allow client maximum number of bad connections

| max_connections |    1500 | ---maximum number of connections

| max_user_connections | 0 |

+--------------------------+-----------------+

Max_connect_errors = 10 Indicates the number of client connections MySQL, if the number of incorrect connections (input password error) 10 times, then MySQL will automatically lock the dead, prevent the client to connect again. Prevents the network connection attack from being exhaustive.

Show status and show variables difference resolution