MySQL

First, MySQL introduction two, MySQL installation 1. Linux installation MySQLInstalling with the Yum packageYum Install Mysql-server mysql-y2. Windows install MySQLDownload the Windows version of MySQL (MySQL Community Server) installation package

Fe_group User NameFe database name123456 Password1. Create a new userLogin mysql@>mysql-u root-p@> Password//create user mysql> insert into Mysql.user (Host,user,password) VALUES (' localhost ', ' Fe_group ', password (' 123456 '));//Refresh the

Create a new test table, three fields, Id,title,uid, ID is the self-increment primary key, UID is the unique index;Insert two piece of data insert into test (TITLE,UID) values ( ' 123465" 1001 "insert into test (TITLE,UID) values ( ' 123465" 1002

I used MySQL to know that she had a good function of group_concat function, which is very convenient.Click (here) to collapse or open SELECT * From Group_test; SELECT Id Group_concat (sub_id) From '

MySQL's semi-synchronous replication IntroductionMySQL enables high availability of storage systems through replication (Replication). Currently, MySQL supports replication in the following ways: Asynchronous Replication (Asynchronous

MySQL database CPU Spike emergency handling methodRun a smooth database, if you encounter CPU hurricane, to 80% or so, it must be developed to write bad SQL caused, the DBA first to ensure that the database does not run off, so we have to put those

1. Insert Chinese Error:Add after database name? Charset=utf8Engine = Create_engine ("mysql+pymysql://root:[email protected]/data?charset=utf8", echo=true)2. Normal insertion, but prompt for the following warning:2018-06-06 16:28:39,789 INFO

MySQL service is a true multi-threaded, multi-user SQL database service that is the most popular open source database system in the server domain with its high performance, reliability, and ease of use features. To ensure the integrity of MySQL

1. The leftmost principle notice encounters > 2. Invalid left-most index encountered for like query3.SQL Performance Optimization Goal: at least the range (range lookup to index) level is required to be a ref (normal index) level, preferably consts (

MHA is currently a relatively mature solution for MySQL high availability, developed by the Japanese Dena company Youshimaton, and is an excellent set of highly available software for failover and master-slave upgrading in MySQL high-availability

MySQL study, this blog is about the current hot on the market of the relational database MySQL learning record.1, about the installation of MySQL, self-Baidu.2,sql:structure Query Language structured queries language.SQL classification:1,DDL (data

DELIMITER $$Use ' TestDB ' $$CREATE EVENT IF not EXISTS ' create_partition 'On SCHEDULEEvery 1 hourDo BEGINSet @starttime =now ();Set @[email protected]-interval date_format (@starttime, '%s ') Second-interval date_format (@starttime, '%i ') minute +

View query cache condition:mysql> show variables like '%query_cache% ';  (Query_cache_type for on indicates already on) +------------------------- -----+----------+| Variable_name                | Value    |+------------------------------+----------+

Index similar to the bibliographic index of university library, it can improve the efficiency of data retrieval and reduce the IO cost of database. MySQL in the 3 million records around the performance began to gradually decline, although the

I. Pre-installation inspection1. when downloading, pay attention to the 32-bit or 64-bitLinux views the number of commands is uname-a, if there is x86_64, that is 64 bits.I686 is 32-bitLinux view version of command cat/etc/system-release2. Check if

What is the concept of Gtid GITDGTID (Global transaction Identifier) is the global transaction identifier that was introduced as a super feature in the MySQL5.6 version. The transaction ID is unique not only to the Master (Origin) server, but also

Test environment for this experiment: Windows 10+cmd+mysql5.6.36+innodbI. Basic elements of a transaction (ACID)　　1, atomicity (atomicity): All operations after the start of the transaction, or all done, or all do not, it is impossible to stagnate

First, uninstall the MySQL software in the Control Panel, remove all files under the MySQL installation directory after uninstallingSecond, Windows+r run the "regedit" file, open the registryThird, delete the registry:

Open My.ini Find[Mysqld]port=3306Basedir= "D:\MySQL Server 5.5"Datadir= "C:/programdata/mysql/mysql Server 5.5/data/"Character-set-server=utf8Default-storage-engine=innodb#支持 INNODB engine mode. Modify to Default-storage-engine=innodb.#如果 INNODB

Pooling: Whether to use thread pool, default TrueMinimumpoolsize, min Pool size: The minimum number of threads allowed in the thread pool, default 0Maximumpoolsize,max Pool Size: The maximum number of threads allowed in a thread pool, default