MySQL

MySQL Master-slave configurationConfigure to prepare the database to be configured for master-slave synchronization, the master-slave server must have the same databaseFirst, configure the MySQL master server[[email protected] ~]# vim /etc/my.cnf....

Implementation process:(1) Master changes the record to binary log (these are called binary log events, binary logs event);(2) Slave copies the binary log events of master to its trunk logs (relay log);(3) Slave redo the event in the trunk log and

Recently, their business to go online, after the launch, need to consider the various services to monitor, including (httpd services, mysqld services, etc.), now want to take mysqld services as an example to summarize the way the script is the most

MySQL master-slave replication is believed to have been used a lot, but because of the work of the reason has not been used. While this period of time is relatively idle, it will be realized again. Although there are a lot of similar articles on the

MySQL ArchitectureConnection pooling Management tool SQL Interface Analyzer optimizer cache storage engine file systemWhat is a storage engineprocessors with different types of tables, different storage engines have different functions and storage

Recently in doing MySQL master and slave need to make database engine changes, and then sorted out some ways to share with you if you have better ideas can be exchanged in comments.1. View MySQL now provides engines.On the MySQL command line,

Transaction processing in various management systems have a wide range of applications, such as personnel management system, many synchronous database operations need to use the transaction processing. For example, in the Personnel Management system,

To make indexes more efficient to use, you must consider which fields to create indexes on and what types of indexes to create when you create an index. 1. Select a Uniqueness IndexThe value of a uniqueness index is unique and can be used to

MySQL Meta DataYou may want to know the following three kinds of information about MySQL: Query Result information: The number of records affected by the SELECT, UPDATE, or DELETE statement. Database and data table information: contains

　　One, MySQL database backup commandMySQL database using command Line BackupFor example:Database address: 127.0.0.1Database user name: rootDatabase Password: PassDatabase name: MyWebBack up database to D disk and

First, in the Mac, MySQL installed, in order to use MySQL to start the MySQL service, then how to start by the terminal command line form? Here are 2 ways to do it:1.mysql Service Start/stop command: Sudo/usr/local/mysql/support-files/mysql.server

PhpMySQL CREATE Database The database contains one or more tables.You need the Create permission for the MySQL database to be created or deleted. Create a MySQL database using mysqli and PDOThe CREATE DATABASE statement is used for

I. Operating EnvironmentWhen the data reaches hundred w more, our MySQL query will become slower, and if you add a table query, the program may get stuck. Even if you set the index and use the index in the query, the query is still slow. At this

Read-uncommitted (read not submitted)Testing process:1, a set read-uncommitted, start transaction2, b Execute Start transaction, modify a record,3, a query record, got the correct record4, b rollback.Problem: A reads a record of B without committing,

MySQL Replication architecture and optimization########## #原理 ###########1. The primary server writes the SQL statements of the updated data (for example, Insert,update,delete, etc.) to theBinary (opened by the Log-bin option). This binary file is

Overview:When a specific database event occurs for a specific table, the trigger executes the corresponding SQL command.Syntax:The general commands for creating triggers are as follows:CREATE [temp|temporary] Trigger name[Before|after]

Transferred from: http://imysql.com/2015/05/24/mysql-optimization-reference-1.shtmlThis article has compiled some common methods of MySQL optimization, to do a simple summary sharing, to help those who do not have full-time MySQL DBA to do basic

Use python on mac to operate mysql Databases To write a MySQL script with a DB-API, make sure that MySQL is installed. Copy and execute the following code: import MySQLdbIf the output result after execution is as follows, it means that you have not

MySQL 5.7 enhanced version Semisync Replication Performance Optimization This article mainly introduces the performance optimization of MySQL 5.7 enhanced edition Semisync Replication. This article focuses on the support for sending binlog and

Analysis of MySQL replace into statements (1) This article mainly introduces the MySQL replace into Statement Analysis (1). This article describes the principle, usage, use cases, and examples of replace into. For more information, see 1.