MySQL

Go from:http://www.2cto.com/database/201306/221329.html  overview  mha is a Japanese MySQL Daniel written in Perl a set of MySQL failover scheme, To ensure high availability of the database system. In the time of downtime (usually within 10-30

The difference between char and varchar in MySQL:Char: fixed length, high efficiency, generally used to store the data in the form of constant-size, such as: ID number, mobile phone number, telephone, password, etc.VARCHAR: variable length, low

MySQL table structure table space and indexed queries1. Query the structure of the table informationSQL codeDesc TableName;Show columns from TableName;Describe TableNameThe results above return the same result.2 Query the column information for the

MySQL installed by brew, as if automatically updated onceThen execute mysql_secure_installation again, enter the root password error, reload MySQL or notError:access denied for user ' root ' @ ' localhost ' (using Password:yes)The reason is that the

Public configuration:Running the database serviceThere must be a library on the primary database server from the database server, and the table structure must be consistent.Turn off iptables disable SELinuxConfigure a host master data server:1

Source code address: http://code.taobao.org/p/orzdba/src/trunk/[Email protected] servers]# chmod +x orzdbaConfigure your MySQL authentication information in about 160 lines of code: username, password, socket, host, port[Email protected] servers]#

UNSIGNED:The numeric type is unsigned, which is the same as the unsigned meaning of the C and C + + programming languages.Type range of INT-2 147 483 648~2 147 483 647INT unsigned range 0~4 294 967 295Looks like a good property option, especially

------------------------ LATEST detected DEADLOCK ------------------------ 140824 1:01:24 (1) TRANSACTION: TRANSACTION 110E, active starting SEC index Read # # transaction id=110E, active 73s MySQL tables in use 1, locked 1 Lock WAIT 3

The InnoDB storage engine implements two standard row-level locks:Shared lock S lock allows a transaction to read a row of data exclusive lock X lock allows a transaction to delete or update a row of dataIf it is a transaction T1 the shared lock of

Found that there is a tool mysqlsla, analysis query log than Mysqldumpslow analysis will be more clear!Install Mysqlsla:Download mysqlsla-2.03.tar.gz[Email protected] export]# TAR-XVF mysqlsla-2.03.tar.gz[email protected] export]# Yum install

mysql5.7 adds the SYS system database, which provides a quick overview of the system's meta-data. This library does make it easy for DBAs to discover a lot of information about a database, and it can help to solve performance bottlenecks. This

I have always wanted to use connector to connect, but because the official MySQL file and the local compilation system is not the same, so you need to add connector -stdlib=libc++ recompile again. Hah I don't. What else can I do? Use ODBC!

It's been a couple of hours and it's finally done.garbled root cause or encoding method is caused by different, as long as the encoding method of unification there is no problem1. Go to the MySQL command line and use show variables like '

Install MySQLYum-y Install Mysql-serverModify MySQL ConfigurationVI/ETC/MY.CNF There will be a lot of configuration items to be aware of, followed by special notesTemporarily modify the code (added below the password): Default-character-set =

At that time on a server to open a multi-instance, master-slave replication structure diagram as follows:At that time on the 192.168.10.3 server with show slave status, the display is normal replication, two threads are yes, and the read and write

1.win7 64-bit how to install the configuration mysql-5.7.4-m14-winx641. Mysql-5.7.4-m14-winx64.zip Download2, decompression to d:/mysql. (path itself specified)3. Create a new My.ini configuration file under D:/mysql/mysql-5.7.4-m14-winx64The

Implement master-slave synchronization between two Mysql databases. I. Overview MySQL versions later than 3.23.15 provide the database replication function, which enables the synchronization, master-slave mode, and mutual backup of two databases. II.

Test essential skills Series 1: script data import using mysql commands, essential skills mysql  Sharing TestWhat's the problem solved in the project! Today's sharing: How to pass MysqlHow can I import mysql script file data through the command

Delete a disk from the data disk group (two disks exist in the asmexternaldata disk group) Delete a disk. Note: if data is stored on the remaining disk after the disk is deleted, check whether there is sufficient storage space. If there is not

Configure MySQLGTID master-slave Replication GTID is a global transaction ID generated based on the original mysql server that has been successfully executed. It is composed of the server ID and transaction ID. This global transaction ID is not