Monitor SQL statement execution efficiency based on mysql slow logsEnable MySQL log-slow-queries (slow query records ).In Linux, find my. cnf file (usually in/etc/mysql/), and you may find that the file cannot be saved after modification, because
Log_slow_queries must be enabled for a slow query output. You can set it in the MySQL configuration file (my. ini/my. cnf) or through the MySQL client. The advantage of the second method is that the setting takes effect without restarting the MySQL
Developers often find that they do not use indexed or limit n statements, which will have a great impact on the database, for example, a large table with tens of millions of records needs to be fully scanned, or filesort is constantly performed,
Friends who are used to other tools such as phpmyadmin do not have the command at all. If you have a written test to interview me and see what you do, it is very useful to study it, you can also know what the tool did when you used the GUI tool.
1. Check the system status Check the status of the system by using some operating system tools, such as CPU, memory, swap, and disk utilization. Based on experience or compared with the normal status of the system, sometimes the system looks idle on
Later, I was working on WordPress. I didn't know that WordPress was using the InnoDB Data Engine at the beginning, so I built a database in the original database. I didn't find any problems at the beginning, it's okay to import the SQL statement. I
Recently, I am working on a large concurrent project and tried InnoDB's Installation File of MySQL5.5 and less than 30 m, which is no inferior to the huge Oracle or MSSqlServer. We believe that MySQL is widely used in Windows because it is
Problem (Multiple Primary auto-growth IDs are repeated)1: First, we use the test table structure of A and B.2: Drop A, insert the data table test (with an auto-increment ID) on B, and return the insert ID as 1.3: Stop B and insert the data table
Modify my. ini and add
Default-storage-engine =INNODB
The red font indicates the engine name to be specified.
Use SQL statements to modify the engine of a table:
Alter table tableName type = InnoDB
My. ini file for reference
1. Use mysqldump1. mysqldump backup database1. Go to the bin directory of the mysql installation file, for example, D: \ mysql5.5 \ bin>2. Use the mysqldump-uroot-p123 qh> d: \ qh. SQL command to back up the database.Mysqldump-uroot-p123 login to
Solution 1:Recursive Algorithms are also the most frequently used. Most open-source programs do the same, but generally only use level 4 classification. The database structure design of this algorithm is the simplest. Id of a field in the category
1. Add default-character-set = gb2312 to the [client] In my. ini under the mysql installation directory.[Client]Default-character-set = gb2312Port = 33062. Copy my. ini to the c root directory and change the name to my. cnf.3. When configuring the
In MySQL database operations, we often write some SQL statements to implement the functions we want. However, it seems difficult for beginners of MySQL databases. This article summarizes six useful SQL statements. Beginners can use the following
MySQL supports several storage engines as processors for different table types. The MySQL storage engine includes the engine for processing transaction security tables and the engine for processing non-transaction security tables:
◆ MyISAM manages
One master and one slave:Master:OS: centos release 5.6 DB: mysql 5.5.8 IP: 192.168.1.2Slave:OS: centos release 5.6 DB: mysql 5.5.8 IP: 192.168.1.3Modify the host Master configuration file (/etc/my. cnf)Copy codeThe Code is as follows:[Mysqld]// At
First, open the mysql console through WAMP.
Prompt to enter the password. Because it is empty, press Enter.
Then enter"Use mysql", Which means to use the mysql Database and prompt" Database changed.
Then enter the SQL statement"Update user
WINDOWS1. MySQL has some environment variables that can be set,You can enter show variables to view the current environment variable settings;2. Some of these variables have character-related settings,You can enter: show variables like 'character % '
Run the cd command on the terminal to enter the file directory.Note: here is an example of the project.1. create a project: Enter zf create project Airline in the format of zf create action project-name in the terminal. Note: You can enter zf in the
After installing mysql, the preparation file should be in the/usr/local/mysql/share/mysql directory. There are several preparation files, including my-huge. cnf my-medium.cnf my-large.cnf my-small.cnf, different traffic of the site and different
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service