mysql query log analyzer

As the name suggests, the slow query log records a query with a long execution time. You can set a threshold value and record all SQL statements with a running time exceeding this value to the slow query log file. As the name suggests, the slow

One, slow query log configuration Turn on the slow query log to configure the sample: /etc/mysql/my.cnf[Mysqld]Log-slow-queries Add the above configuration entry in the MY.CNF configuration file and restart the

the configuration ifMax_requestsIf the number is exceeded, the error 502 will also occur. The setting of max_requests is to prevent insecure third-party library scripts.Memory leakageOf course, your own scripts exist.DeadlockThen, there will also be a 502 phenomenon. If you find that the mysql load is not high, but the php-fpm process count and memory usage are too high, congratulations, most of the time it is because the script has a deadlock. Sinc

created under the perfJettyServer/targetdirectory. To build it, run the following command in the top-level directory: mvn clean packageIi. Installation and usage of MySQL Performance Analyzer 1. Extract the myperfserver-server.zip file generated before the upload. 2. By default, this Performance Analyzer also stores test data in

1) First, why should I turn on Binlog log and slow query log?Binlog log will be recorded in the database, so adding and deleting the operation, when accidentally delete, empty data, or database system error, this time you can use the Binlog log to restore the database, simpl

file.While the database is running:Modify global variables to modify log settingsModify the values of General_log, Log_output, general_log_file to modify the relevant settings, for example: SET GLOBAL general_log=1SET GLOBAL log_output= ' FILE '; In addition, you can disable or enable the current connection's general query log by setting the valu

A common web site often need to query n SQL statements to get the results of the page, when the Web site access speed is slow and the front-end done a lot of optimization work, the database bottleneck of the search is also an important part of the Web optimization.MySQL provides a slow query logging function, you can query the SQL statement time is greater than t

[View system settings for slow queries]Mysql>Show variables like '%slow%';+---------------------------+--------------------------------+|Variable_name|Value|+---------------------------+--------------------------------+|Log_slow_admin_statements| OFF ||Log_slow_slave_statements| OFF ||Slow_launch_time| 2 ||Slow_query_log| OFF ||Slow_query_log_