Analyze how to design the storage structure, how to manipulate the stored data, and how to reduce the operation cost or cost and minimize the system overhead based on the data access requirements in a real production environment. At the same time,
Compared with other open-source databases,MysqlIt has better scalability. The main reason is that it provides open interfaces for the storage engine. Many programmers likeLinuxInstall mysql on the platform to develop your own programs. This article
BinlogYesMysqlLogs that are printed in binary format are not encrypted by default and are not compressed. Each normal binlog File Header has a four-byte mark with a value of 0xfe 0x62 0x69 0x6e. LOG_EVENT is the unit in binlog. Normally, binlog
MysqlIf you want to record user operation information in the database, you can useAuditAudit function. This function is automatically triggered. You can see more detailed definitions in the plugin_audit.h file. In the audit plug-in, controllable
Install from source code in FC6 SystemMySQLThe error message "Linux thread not found" is displayed. The Code is as follows:
#./configure --prefix=/usr/local/mysql
…
…
checking "LinuxThreads"... "Not found"
In usePHPIntegrationMySQL databaseDuring application development, all table information in the database may be used. This article mainly introduces PHP implementation code for getting all table information, hoping to help readers.
The Code is as
We wantLanAll machines in can be connectedMySQL databaseFirst, enable the remote connection function for MySQL. On the MySQL server, run the following command on the MySQL command line:
The command code is as follows:
Grant all privileges on
We know that in someMySQL databaseVersion in progress,Root UserBy defaultRemote LoginBut sometimes, when we want them to log on remotely, we often do this:
Grant all on *. * to root @ '%' identified by 'yourpassword ';
In this way,
MySQL databaseIn the query process, we can take some measuresImproves query speedTo improve SQL Performance. This article mainly introduces six policies to speed up MySQL database queries. Let's take a look at them!
Policy for improving MySQL query
MySQL databaseDuring the operationBinlogDuring parsing, we found that the dump data had serious out-of-order situations. The time difference was almost 1 s, as shown below:
SET TIMESTAMPE = 1
SET TIMESTAMPE = 0
SET TIMESTAMPE = 1
MySQL databaseBecause of work requirements, we may useENUM typeBut since this type is not very common, we may not be very familiar with it. It doesn't matter. This article will explain the ENUM type in detail, hoping to help you.
The ENUM type is a
MySQLThe database providesQuery BufferMechanism. Using this query buffer mechanism, MySQL stores SELECT statements and query results in the buffer. Later, the same SELECT statements are case-sensitive.) The results will be read directly from the
Sometimes, we need to reconfigure it because of our work needs.MySQLDatabase EngineInnodb. HowLinuxHow can I reconfigure the MySQL database engine innodb in the system? In this article, we will introduce this part of content. Let's take a look at it
MySQL databaseBackup operations includeFull backupAndIncremental BackupThis article describes the principles of Incremental backup and complete backup. Next, let's take a look at this part.
Principle of full backup:
For InnoDB, XtraBackup is backed
MySQL databaseMulti-version Concurrency ControlMVCCThe knowledge is what we will introduce in this article. Let's take a look at this part.
MVCC
Most MySQL transaction storage engines, such as InnoDB, Falcon, and PBXT, do not use a simple row lock
For MySQL 5.5DatabaseMulti-column partitioningThis is what we will introduce in this article. We will introduce this part through an instance. Let's take a look at it!
Multi-column partitioning
The COLUMNS keyword now allows the string and date
We know thatMySQL database OptimizationThere are many methods on the Internet. This article mainly introduces the optimization experience of a MySQL database user, hoping to help you.
Optimization experience:
Run the show variables command to view
Previously we introduced:MySQLDatabaseTIMESTAMPSet the default value for flexible use, this next time we will introduce several MySQL database TIMESTAMP set the default value of several application instances, hope to help you.
#1 check the table
If you do not know the new features and improvements of MySQL 5.6, you can learn from here.
The main purpose of my article is to test the performance.
I use Sysbench workloads (Read-Only/Read-Write) for testing. The following is my test environment:
When Mariadb 5.5.30 is started using the mysql system library of percona 5.5.30, an error is reported.
[ERROR] Incorrect definition of table mysql.event: expected column ‘sql_mode’ at position 14 to have type set ……
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.