MySQL

Mysql master-Slave configuration + read/write separationMySQL starting with version 5.5, the compile configuration via./configure has been canceled and replaced by the CMake tool. Therefore, we first need to compile and install the CMake tool in the

./configure--prefix=/usr/local/mysql--with-extra-charsets=all--with-innodb--with-plugins=partitionThen makeReport the following error.. /depcomp:line 571:exec:g++: Not FoundMAKE[1]: * * * [MY_NEW.O] Error 127MAKE[1]: Leaving directory

Linux Platforms:1. first verify that the server is in a secure state, that is, no one can connect to the MySQL database arbitrarily.Because the MySQL database is completely password-protected during the reset of the root password of MySQLStatus,

Tag:mysql    log     Logs: Log database operation, daily operations, error messages and other MySQL logs: binary logs, error logs, and query logs. Binary log: Records the various operations of the database in binary form, but does not

1, modify the MySQL configuration file, so that MySQL login to skip password verificationSkip-grant-tables2. Restart MySQL ServiceService MySQL Restart3. Go to MySQL and change the password in the user table[Root] #mysql-u rootmysql> show

written in the previous words: In slow-scan optimization 1 and 2 have repeatedly emphasized the importance of explain, but sometimes the naked eye can not see how the explain Results to guide optimization, this time also need some other

https://www.adayinthelifeof.nl/2010/12/04/about-using-utf-8-fields-in-mysql/I sometimes hear: "Make everything utf-8 on your database, and all would be fine". This so-called advice could is further from the truth. Indeed, it'll take care of

MySQL cross-table update has always been a topic of concern to everyone, this article describes the MySQL Multi-table update in practice several different ways of writingSuppose we have two tables, one table for the product table, a product listing

Because see many friends also met me this situation, so take out for everyone to refer to, I use the Loganalyzer version is installed version:3.6.5Here first put: 650) this.width=650; "src="

In order to better optimize MySQL in high concurrency, it is necessary to understand the locking table mechanism when MySQL query is updated.I. OverviewMySQL has three levels of Lock: page level, table level, row level.The MyISAM and memory storage

Add a file Form Add Excel Inbound PHP codeHeader ("Content-type:text/html;charset=utf-8");Import XLS processing flow: Select xls file, upload xls file to server, and resolve excel-> batch storage by Php-excelreader.Include_once ("./reader.php");

MySQL master-slave replication mode is primarily responsible for receiving user requests, DDL,DML,DCL and other operations, slave is mainly responsible for synchronizing master's binary log, in order to back up data. In the case of a larger database

Recently I feel that my skills are learning with the work, there is always some knowledge is not mastered, is prepared based on the "MySQL Authoritative guide" and "high-performance MySQL," The two books to systematically learn, each study of the

mysql> show processlist;+----+------+-----------+------+---------+------+-------+------------------+| Id | User | Host | db | Command | Time | State | Info |+----+------+-----------+------+---------+------+-------+------------------+| 7 | Root |

First, the origin of the problemThere is a clear explanation in the official MySQL documentation that nested transactions are not supported:1. Transactions cannot be nested. This was a consequence of the implicit commit performed for any current

PS aux |grep MySQLKill all the listed processes, and then restartService MySQL StartThe reason may be mysqld did not start; service mysqld start.This problem may persist because the configuration file is not correct.Modify the/USR/MY.CNF

Share a MySQL database/table sharding class (php) When the data record of a table is too large, a performance bottleneck will occur. Generally, the corresponding solution is to either create a partitioned table or a partitioned table, table shards

Mysql study Note 3 (INDEX) Index Database Object Index: A combination of data. By indexing objects, you can quickly query specific records in the database object table. It is the most common way to improve performance. An index contains one or more

High-performance MySQL Reading Notes-Multi-version Concurrency Control Algorithm1. AUTOCOMMITMysql is automatically submitted by default. You can run the following command to view and modify it:Mysql> show variables like 'autocommit ';+ -------------

Comparison of MySQL High Availability Technologies (1) The pictures and materials are from the MYSQL technical insider of Master Jiang chengyao of MYSQL ). Database Reliability refers to data reliability; Database Availability refers to database