MySQL

Database configuration, it is necessary to open the binary log, if the start is not open and then want to open, you must restart.Log-point-based replicationBackup Database Tools-------------------------------------------------------------------------

What is a database?All the information that the computer processes and stores is data.A program used to store data in a computer system.One: There are many kinds of programs that can access data in a computer system.They have their own strengths and

Mysql uses a plug-in storage engineMysql ArchitectureMySQL service layerStorage Engine LayerAll belong to the storage engineMyISAM Storage EngineThe frm is a record structure, myd and MYI are MyISAM special.CasesTable-level locks, which require a

The following respectively create three tables, and insert 1W simple data for testing, the details are as follows: [1] test_a has a primary key but no index CREATE table ' test_a ' (  ' id ' int () unsigned not NULL auto_incr ement,  ' title '

To optimize a query, we need to know exactly where this query's performance bottleneck is, is it consuming too much CPU, or does it require too many IO operations? To be able to understand this information clearly, in MySQL 5.0 and the MySQL 5.1

Copying only a subset of the tables in the database can reduce the pressure on the master and slave serversOn the primary serverBINLOG-BIN-DB only the specified database-related modifications are counted in the binary log (in general)

One, My YS SQ QL L supported data classes 1. For integer data, MySQL also supports specifying the display width within the parentheses following the type name, such as the INT (5) TableDisplays the width before the number when the value width is

(a) Basic introductionSet Sql_mode= "", that is, forced not to set the MySQL mode (such as no input detection, error prompts, grammar mode check, etc.) should be able to improve performance, but the following problems:If inappropriate data is

The system version after the Yum update upgrade isSecond, MySQL installationGenerally, the information given on the Internet is#yum Install Mysql#yum install Mysql-server#yum install Mysql-develBoth MySQL and Mysql-devel were installed successfully,

Database Name list into a file# Cat 00db.txtinformation_schemadb_app_cmsdb_eopdb_leader_cmsdb_leader_commentMysqldump out of the SQL data into a file inside# cat 00dbsql.txt-rw-r--r--1 root root 970701283 may 03:39 information_schema-2017-05-16-03300

Tian Teacher, le Study medical examination of the question statistics,The record has 50w, statistics to more than 20 minutesOptimized SQL and indexed, response in 0.1 secondsSHOW INDEX from ' Exam_question_record ';ALTER TABLE ' Exam_question_record

Log type for MySQLBinary log, transaction log, error log, general query log, relay log, slow query logThe binary log has the following contentsData catalog, usually placed in Mysql-bin. XXXXX number)Scroll: Reach a maximum limit, flush logs, server

First, install Express in front of all said1.express.CNPM | | NPM Install Express--save2. MiddlewareA.CNPM | | NPM Install Body-parser--save When a post is requested, this middleware is needed to process the parametersB.CNPM | | NPM install

Friends who are familiar with MySQL database, will certainly like MySQL powerful plug-in storage engine, can support too many storage engines, when the current storage engine does not meet your needs, you can choose the right engine according to

User account and Rights management:User account: ' username ' @ ' host 'Host: When this user accesses the current MySQL server, which hosts are allowed to remotely create the connection;Representations: IP, network address, host name, wildcard (%

First of all, the reason for the garbled is that the coding method is not uniform, mainly is the MySQL database encoding method and Web project encoding method, only follow the principle of unified coding method, can avoid garbled problem.UTF-8

"Old blog Transfer-posted on September 6, 2015 18:42" The remote client connection does not appear on Linux after it is installed because the MySQL server is only allowed to log on locally to the database server for security reasons. Since I'm not

Create a stored procedure with no parametersCREATE PROCEDURE Procedure name () procedure Body SELECT VERSION ();Call the stored procedureName of the first call procedure (); (Used with parameters)Name of the second call procedure (used without

Career change: Using Max (case and then)SELECT' name ',MAX( Case whenCourse='language' ThenscoreEND ) aslanguages,MAX( Case whenCourse='Mathematics' ThenscoreEND ) asMathematics,MAX( Case

1 Brief introduction1.1 Overview1.2 Permissions Classification2 adding usersThe 2.1 syntax is for example the following:CREATE user user_specification [, user_specification] ... user_specification: user [ | Identified with Auth_plugin [as