MySQL

Long wanted to write an article about database master-slave replication, today, using some trivial time to manipulate and record it:First of all, we must think about the master-slave replication of the approximate steps, even if you do not

1. After successful installation, through phpMyAdmin into MySQL, click on the "User" menu above, in the user "root" host "localhost" click Edit permissions, there is an option "Change Password", enter the password you want, such as: 123456.2. Now

The relational database relies on the primary key, which is the cornerstone of the database physical pattern. There are only two uses of the primary key at the physical level:Uniquely identifies a row.As an object that can be effectively referenced

Description, check and repair of MyISAM tables.Used without options all tables on the command would be a checked for errorsUsage:myisamchk [OPTIONS] tables[. MYI] Global Options: -H,--help display this Help and exit. -?,--help display this help and

When dealing with the database pressure, choose Read-write separation is a more common means, the following will summarize, how to configure the read library and write the library, and read and write out of sync, how to keep in sync. Here, we will

MySQL command line, you can modify the MySQL database password, the following for you to detail the MySQL command line, if you are interested, may wish to see.Format: Mysqladmin-u username-P Old password password new password1, add a password to

Environment: WIN8.1+MYSQL5.6.11+XAMPP (v3.2.1)The default encoding is as followsHow to view:Show variables like ' character% ';Results:From the above information, the database is encoded as latin1, which needs to be modified to GBK or UTF8.Among

because the online database is a bit large, the disk does not have a raid, and the server is scarce. Originally wanted to use Xtrabackup to do incremental backup, but a variety of errors, I have lost confidence in it, so, write a script to

A: What is meta data?The so-called meta-data, is the data that represents the data, the data is very varied, in short, as long as it is not our data stored in the database, most can be understood as metadata. Any data that describes the database-as

Installation of navicat_for_mysql_10.0.11 under LinuxOfficial: http://www.navicat.com/cn/download/download.htmlNavicat_for_mysql_10.0.11_cn_linux.tar.gzHow to use:1. Open Terminal: Application---system tools (or accessories), terminal, switch to

--mysql Table Space Set----------------------2014-09-201. The method of shrinking Ibdata, currently MySQL still does not provide the method of contraction ibdata, only refactoring, the following is 5.7 steps.Decreasing the Size ofthe InnoDB

in the case of large database pressure, restart the database, by manually executing the following statements, the thermal data loaded into the Innodb_buffer_pool buffer pool for preheating, so as to avoid the high Peak connection number, program

1. The type of BLOB field in MySQLA field of BLOB type is used to store binary data.In MySQL, BLOBs are a series of types, including: Tinyblob, BLOBs, Mediumblob, Longblob, the only difference between these types is the maximum size of the storage

MySQL connection Mode 1:TCP/IP Socket mode This approach establishes a network-based connection request on a TCP/IP connection, typically a client connection to a MySQL instance running on the server, and 2 machines connected via a TCP/IP network. C:

goldengate ' indicates that goldengate Span style= "font-family: ' The song body '; color: #1f497d;" You need to mysql binlog_format ) set to row , the other two formats ( mixed or STATEMENT "is not supported. ######################

MySQL thing implementation syntax1) Begin SQL statement rollback or commitSTART TRANSACTION SQL statement rollback or commit2) Modify the #本文未涉及 that the autocommit auto-commit is turned onPersonal understanding of this logicStart thingsSubmit each

Hash index and B-Tree index, and hash index B-treeHash Index Because of the particularity of the Hash index structure, the retrieval efficiency is very high, and the index retrieval can be located at a time, unlike B-Tree indexes that need to go

Basic MySQL-basic database operations 1. Delete the database drop database name; Mysql> drop database test; Delete database mode 2. create DATABASE name; Mysql> create database test; In Windows and Linux, database names and table names are

How to delete drop, truncate, and delete table data in an SQL statement Although it is not recommended that you use commands to delete the items in the database table in the small Editor of the green Resource Network, these delete commands are

How to obtain mysql help information When a mysql-related fault occurs in the development or test environment, most of my friends may post on the Forum and discuss the problem with the QQ group. This method is one of the effective ways to get help.