The common MySQL table engine has InnoDB and MyISAM, the main difference is that InnoDB is suitable for frequent write database operations, MyISAM suitable for reading the database a little bit more, how to change the table engine InnoDB to MyISAM?
This article mainly introduces the use of basic commands in the MySQL Cluster configuration process. The example of two node connections is provided in the real-time recording. For more information, see the following.
1. check whether you should use
Set Change root passwordNote: How to change the root password, about the root user is the MySQL Super administrator user, it is similar to the root user inside the Linux operating system, to distinguish between the root of MySQL and the system root
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 database programs that can run in the local windows version can be obtained from MySQL AB since MYSQL 3.21, and the percentage of MySQL downloads per day is very large. this section describes how to install MySQL on windows. the installer is
The basic commands used for MySQL cluster configuration and the real-time operation process,
1. Check whether you should use a MySQL cluster.
Reduce the pressure on the data center nodes and process large data volumes. MySQL is distributed and one
1. Find out if you should use MySQL cluster first.
Reduce data Center node pressure and large amount of data processing, using the MySQL distribution, one or more application corresponding to a MySQL database. A few MySQL database common data to
Abstract: This article describes how to optimize SQL queries. You can manually use the EXPLAIN statement to check the efficiency of SQL queries. In addition, some principles for optimizing SQL statements are described, mainly about how to optimize
This article transferred from: HTTPS://WWW.TUICOOL.COM/WX/2EMBFMQObjectiveTalking about MySQL query optimization, I believe you have a collection of artifice: You cannot use SELECT *, do not use null fields, reasonably create an index, select the
First, performance detection and bottleneck analysis
1 common commands for performance detection
Show status
Display status information, reference: Mysql Show status Command detailed
Show Processlist
View current SQL execution, including
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.