MySQL

Chapter One, DBA5 minute ExpressThe knowledge points in this chapter are as follows: Look for a statement that runs slow sql: Show full processlist view all executing processes and the execution of the statement time-consuming;

Could not start the service MySQL. Error 0 installation does not start when you reload the MySQL database after uninstalling, be sure to remove the MySQL related services, folders, registry removal before completely reloading the steps:1. Turn on

Suddenly received Zabbix alarm, said MySQL server/directory disk space is insufficient.Log on to the server, looked at the root of the discovery 100GB, incredibly used almost 90GB. This server only ran a MySQL, should not log not clean up and other

Multi-instance installation with multiple different server ports open at the same time 3306 3307Large company installation database is generally compiled and installed, and will be made into RPM packages after optimization for uniform useInstall

Specifies the innodb_file_per_table=1 parameter, which is primarily to prevent the Ibdata file from being too large and all databases are stored in the file. The above problem does not occur after you specify this parameter. Specify the default

Tag: NEC command csdn Plain Connect reset Connect method tailReprint http://blog.csdn.net/wulantian/article/details/9670957Ax_connect_errors is a security-related counter value in MySQL that is responsible for blocking excessive attempts by clients

Four virtual machines650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M02/99/77/wKioL1lIvNmjKJ7OAAMiAURuImg967.png "style=" float : none; "title=" 1.png "alt=" Wkiol1livnmjkj7oaamiauruimg967.png "/>Master and slave Configuration please check

The storage engine in the database is actually a set of tables that use the engine, and the table in the database sets what storage engine, so the table has different "effects" in terms of how the data is stored, how the data is updated, the

Mysql SQL statements Daquan1, Description: Create DATABASE dbname;2. Description: Delete database drop DB dbname;3. Description: Creating a new Table CREATE table tabname (col1 type1 [NOT NULL] [primary key],col2 type2 [NOT NULL],..);4. Description:

This is the Windows Server AH. I use the visual interface SQLyog, you can also use Navicat even DOS interface canAfter logging in with the root account, write the following code on the query pageGRANT all privileges on * * to MX @ '% ' identified by

MySQL Database backup Use the mysqldump command to back up:Command line: >--Use the root user to back up the person table under the test database; Copy the entire database directory directly:Copy the database files from MySQL

Method of Import:AB, mysql-u root-d test When importing data, if the target database or table is the UTF-8 character set, and the imported SQL has Chinese in it, it may be garbled in the final result, just add the following in the first line of the

1. Download the MySQL installation package to the specified file:For example, I extracted the contents of the downloaded MySQL zip into this file, the specific file content is as follows:My.ini needs to create its own, the contents are as follows:==3

1. Delete MySQL1 sudo apt-get autoremove--purge mysql-server-5.02 sudo apt-get remove mysql-server3 sudo apt-get autoremove mysql-server4 sudo apt-get remove Mysql-common (very important)In fact, some of the above is redundant, it is recommended to

1. Log in to the MySQL server[Email protected] ~]# mysql-u root-pEnter Password://Follow the prompts to enter the correct password2. Execute the MySQL action statementExecute "show master Logs" after logging into "mysql>" environment with Root;

MySQL log type:     1, query log (usually not turned on, not recommended)     2, slow query log (recommended)      3, error log (recommended)     4, binary log (recommended)     5, relay log     6 , transaction log (Help transactional storage engine

One, what is GTID (Global transaction identifiers): MySQL-5.6.2 start support, MySQL-5.6.10 perfect, GTID into two parts, part of the service UUID, The UUID is stored in the MySQL data directory in the auto.cnf file, This is a very important file,

In the MySQL execution plan:IDID used to indicate the order of execution, ID the same as a group, first execute ID A large number of groups, and then a small group of numbers are executed. within a group with the same ID, the order is executed

Mysql 5.7.18 installation-free window configuration method, mysql5.7.18 The first blog is probably about to start learning the database, and then downloading all kinds of questions by myself. Baidu is not very easy to use. After asking, there is no

Mysql replace into instance details, mysqlreplace Mysql replace into instance details Replace into is similar to insert. The difference is that replace into first tries to insert data into the table. 1. If this row of data is found in the table