The following articles mainly introduce three very useful methods to optimize MySQL database queries. We all know that in MySQL database query optimization queries, database applications (such as MySQL (the best combination with PHP) actually mean
I am used to installing MySQL in binary format. today I am eager to install an RPM Package for MySQL. I did not expect that I have encountered some problems. I will share with you the problems I encountered. first, I will download the installation
1. View MySQL server configuration informationMysql> Show variables;2. View the various status values running on the MySQL serverMysql> show global status;3, slow query1. mysql> show variables like ‘%slow%‘; 2. +------------------+-------+ 3. |
mysql> show global status; Can list MySQL server running various status values, my personal preferred usage is show status like ' query value% '; One, slow query mysql> show variables like '%slow% '; +------------------+-------+ | variable_name
Case study of failure to log on to the server using the specified MySQL clientI am used to installing MySQL in binary mode. Today I am eager to install MySQL with an RPM package. I did not expect that I have encountered some problems. I will share
MySQL Study Notes summary, mysql Study Notes
Slow SQL: A Query whose execution time exceeds the specified time range is called a slow query.In MySQL, how does one record slow SQL statements?A: You can set the following information in my.
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
Directory
I. Optimization Overview
Ii. query and index optimization Analysis
1. performance bottleneck locating
Show command
Slow query log
Explain analysis Query
Profiling Analysis Query
2 Index and Query Optimization
Iii. Configuration
This article mainly introduces the MySQL log settings and viewing methods, the need for friends can refer to the following MySQL logs: error log:-log-err query log:-log slow query log:-log-slow-queries update log:- Log-update binary log:-log-bin by
Table of Contents
MySQL Show Status-open database connections
MySQL Show Processlist
MySQL Show Status-summary
MySQL "Show status" Faq:can you demonstrate the MySQL show statuscommand to show MySQL variables and Status
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.