There are many articles on the Internet that teach you how to configure a MySQL server. However, considering the differences in server hardware configurations and specific applications, the practices in these articles can only be used as a reference
MySQL uses show status to view the status of the MySQL server, statusmysql
During website development in the LAMP architecture, we sometimes need to know the MySQL server status information, such as the running time after MySQL is started and the
Mysql> show global status;
You can list the running status values of the MySQL server. In addition, the statement for querying the configuration information of the MySQL server is as follows:
Mysql> show variables;
1. Slow Query
Mysql> show
Mysql> show global status;
You can list the running status values of the MySQL server. In addition, the statement for querying the configuration information of the MySQL server is as follows:
Mysql> show variables;
1. Slow Query
Mysql> show
Mysql> show global status;
Can list the MySQL server running various status values, in addition, query the MySQL server configuration information statement:
Mysql> Show variables;
One, slow query
Mysql> Show variables like '%slow% ';+ —————— + ——
In the lamp structure of the Web site development process, sometimes we need to understand the MySQL server status information, such as the current MySQL startup running time, the current MySQL client session connection number, the current MySQL
In the lamp architecture of the Web site development process, sometimes we need to understand the MySQL server status information, such as the current MySQL startup run time , the current MySQL client session connections , the current MySQL server
MySQL Error: (2006, ' MySQL server has gone away ') the problem is that the client and MySQL server link between the broken.
The reason for this is that the SQL operation is typically too long, or that the data being transmitted is too large (for
One, running the MySQL server as a non-privileged userBefore discussing how to start the MySQL server, let's consider what the user should be running the MySQL server. The server can be started manually or automatically. If you start it manually,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.