MySQL

Mysql Database Installation application1:MySQL is a multi-user, multi-threaded service. Advantages:PerformanceHigh reliability and ease of useDefault Usage TCP 3306 port matching file is /etc/my.cnf2:MySQL Compilation installation process:use

outfile exporting data from a databaseSELECT * into outfile ' e://mysqloutfile//1.txt ' from table name;Backup and restoreNo longer backup in MySQL directory, mysqldump-uroot-p database name + table name > Specific path name (where do you want to

1) Sub-tableObjective: To improve the efficiency of the access operation of massive dataSelect the appropriate sub-table strategy, determine the sub-table strategy, when the data access operations, the requirements are determined to go to that table

#mysql查看连接数SHOW VARIABLES like '%max_connections% ';# max_connections Maximum number of connectionsSHOW VARIABLES like '%connection% ';# processlist;# to judge by observing SQL.SHOW Full ProcesslistSHOW processlist;SHOW STATUS;SHOW processlist#show

MySQL installation goes to MySQL websiteClick ArchivesSelect version Download tarLinux installation MySQL database--tar.gz Package Decompression installation methodMySQL database has a variety of installation methods, this article only describes the

The content of this section: Paramiko Mysql 1.paramikoHttp://www.cnblogs.com/wupeiqi/articles/5095821.htmlParamiko is a module, socket, and SSH protocol that enables remote server operations with Python code using this

-- SET foreign_key_checks= 0 -- delete data truncate table stocktbl; -- set Foreign_key_checks= 1 ; -- to see the value of the current foreign_key_checks, use the following command: select @ @FOREIGN_KEY_CHECKS ; How MySQL

1. Preparation before installation: 1) essential Packages and toolsgcc/g++: MySQL 5.6 starts and needs to be compiled with g++.Starting with Cmake:mysql 5.5, CMake is used for project management, and CMake requires more than 2.8 versions.The

Alter user ' root ' @ ' localhost ' identified by ' root ';mysql> flush Privileges;Show variables like ' version% ';#使用grant方式创建一个新帐户fred, and set the passwordGrant usage on *. * to ' fred ' @ ' localhost ' identified by ' Fred ';#查看刚刚创建的账户Select

One. Database version:Community Edition Enterprise Edition Cluster editionCommunity Edition: Free to use (can be used for personal use, no commercial use)Enterprise Edition: Less expensive than the cluster editionCluster version:Official website:

One or four types of logs1. Error log: Log the start, run, and shutdown process of MySQL server, ending with. Err by defaultMysql> Show variables like ' log_error ';2, binary log * * *Documenting all DDL and DML operations that a user makes to a

[Client]# content in this directory is commonly used for localhost login, generally do not need to modifyPort = 3306# Port numberSocket =/var/lib/mysql/mysql.sock# socket file (localhost login will be generated automatically)[MySQL]# contains some

1.What is Maxscale? After configuring MySQL 's master-slave replication structure, we want to implement read-write separation, spread the reads to the slave server, and load balance multiple slave servers.read-write separation and load balancing are

The latest installation tutorial for mysql 5.7.17 is illustrated in the text. Mysql-5.7.17-winx64 is now the latest version of Mysql, which is free of installation, so some configuration is required : Https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-

How to configure multi-thread master-slave replication in Mysql 5.7 slave node, mysql5.7 Preface Mysql multi-threaded replication is supported since Mysql 5.6. However, Mysql 5.6 has some drawbacks. Although multi-threaded replication is supported,

Implementation principle of Mysql master-slave synchronization and mysql master-slave Synchronization 1. What is mysql master-slave synchronization? When the data in the master database changes, the changes are synchronized to the slave database in

Mysql create routine permission description, mysqlroutine 1. If you have the create routine permission, you can create procedure | function. 2. If you create procedure | function, mysql automatically grants it the alter routine and execute

About MySQL innodb_autoinc_lock_mode, innodbstrictmode The innodb_autoinc_lock_mode parameter controls the behavior of locks when inserting data to a table in the auto_increment column; By setting it, you can achieve a balance between performance

Solve the problem that mac cannot log on when using homebrew to install MySQL, homebrewmysql If your computer is Mac, It is very convenient to install MySQL using homebrew, but there are still some problems; First, make sure that you have installed

Difference between delete and truncate: deletetruncate Similarities: The truncate function is the same as the delete statement without the WHERE clause: both delete all rows in the table. Use truncate with caution. After deletion, it will disappear.