MySQL

Http://www.tuicool.com/articles/miuq63Ehttp://www.guokr.com/blog/475765/Http://songwie.com/articlelist/44Https://www.youtube.com/watch?v=5yDO-tmIoXYSingle database = Master/slave = sharding(at stage of Master/slave, you might need to add a

Download MySQL repo source wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm Install RPM source RPM-IVH mysql-community-release-el7-5.noarch.rpm Install MySQL Yum Install Mysql-server

Workaround One , modify the My.ini fileFound itQuery_cache_size =0This is the problem, and the query cache is not open.(1G is 64M cache generally)The memory of my server is 4G,Adjusted to The code is as follows Copy Code

first, the concept of the viewA view is a virtual table whose contents are defined by a query. As with a real table, a view contains a series of column and row data with names. However, the view does not exist in the database as a stored set of data

Simple calculation:http://www.mysqlcalculator.com/Related documents:http://mingxinglai.com/cn/2016/04/mysql-memory-usage-formula/#topHttp://imysql.com/node/97By observing the status tuning:http://5434718.blog.51cto.com/5424718/1207526http://wangwei00

Using transactions in MySQL stored procedures1 DROP PROCEDURE IF EXISTSTEST_SP12 CREATE PROCEDURETest_sp1 ()3 BEGIN 4 DECLARET_errorINTEGER DEFAULT 0; 5 DECLARE CONTINUEHANDLER forSQLEXCEPTIONSETT_error=1; 6 7STARTTRANSACTION; 8

Purpose: Host system/var directory is almost full, the query is the largest file is MySQL ibdata1 file, 17G size, it is necessary to migrate this file to other directories to release the/var directory space.1. It's a good habit to back up the

MySQL version is different, the method of changing passwords is similar, but there are some differences:mysql5.11. First verify that the server is in a secure state, that is, no one can connect to the MySQL database arbitrarily.2. To modify the

---restore content starts---2 better git online repositories: foreign www.github.com domestic git.oschina.net (code cloud)The purpose of the remote repository is to get everyone to exchange code.1. First create a project remotelyOn-line platform

1, the master-slave server for the following actions：1.1. Consistent version1.2. Initialize the table and start MySQL in the background1.3, change the root password2. Modify master server Master:#vi/etc/my.cnf[Mysqld]Log-bin=mysql-bin//[must] enable

$stmt, execute(); //Bind result $stmt-Bind_result($username); //Move cursor Fetch ($stmt); printf("%s is from%s\n", $username, $state); $stmt-close(); } Copy Code13. Non-buffered queriesNormally, when you

The information below I get from http://dev.mysql.com/doc/refman/8.0/en/optimize-overview.htmlOptimization at the database levelDatabase performance depends on several factors at the database level, such as tables, queries, and configuration

Under win system, connect someone else's MySQL or let someone else link their mysql:Open command-line cmdGo to MySQL:Mysql-u root-pMysql>use MySQL;Mysql>select host from user where user= ' root ';Mysql>grant all privileges on * * to [e-mail

One: Uninstall the old versiongrep-E--nodeps xxx (XXX for the list just displayed) # Brute force Delete mode, if you use the above command to delete, prompt to have other dependent files, then use this command can be strong delete rm /etc/my.cnf #删除/

MySQL dual master mutual Standby Architecture modeOperating system CentOS 6.3MySQL version mysql-5.0.56Keepalived keepalived-1.1.19.tar.gz650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/88/6A/wKiom1f2SrfQGcf-AACVzMwJ5yE052.png-wh_500x0-wm_

One. Baidu mysql5.6 ZIP 64-bit free install version of the download and then extract to the D diskTwo.   You can consider modifying the configuration of My.ini inside Character-set-server=utf8 This sentence is the encoding format setting port=. Port

Difference in count (1) count (*) count (field) usage in SQL statements, sqlcount Difference in count (1) count (*) count (field) usage in SQL statements In SQL statements, the count function is one of the most common functions. The count function

After an error occurs in the mysql batch file, mysql continues to execute When upgrading the SQL script for batch processing, we usually want to stop the SQL script after it fails because it is not standardized and cannot be executed repeatedly.

How do I see all foreign keys to a table or column ?, Keyscolumn  Down voteaccepted For a Table:SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAMEFROM INFORMATION_SCHEMA.KEY_COLUMN_USAGEWHERE

SQL Optimization in specific scenarios and SQL Optimization in specific scenarios 1. It is best to modify the data of a large table in batches. Delete and update the 10 million rows record in the 1 million rows record table. Only 5000 rows of