This article is about MySQL database InnoDB storage engine redo log roaming00–undo LogUndo log is for the atomicity of transactions, in the MySQL database InnoDB storage engine, also with the undo log to achieve multi-version concurrency control
Reprint: http://www.cnblogs.com/vicenteforever/articles/1613119.html
MyISAM
InnoDB
the difference in composition:
Each myisam is stored as three files on disk. The first file name begins with the name of the
First, xtrabackup backup recovery principleWhen you back up the InnoDB table, xtrabackup several threads to copy the. ibd file for a stand-alone tablespace, and constantly monitor the changes in the redo log in this process and add it to your own
Write in front: indexes have a critical impact on the speed of queries, and understanding indexes is also a starting point for database Performance tuning. Consider the following scenario, assuming that a table in the database has 10^6 records, the
Can the MySQL default character set be modified? The answer is yes, the following will teach you two ways to modify the MySQL default character set, you want to learn the MySQL default character set can be enlightened.(1) The simplest method of
1. PrefaceActiveMQ is the most popular, powerful, open source messaging bus that Apache has produced. ActiveMQ is a JMS provider implementation that fully supports the JMS1.1 and the Java EE 1.4 specification, although the JMS specification has been
1) interactive_timeout: parameter meaning: The number of seconds that the server waits for activity before closing an interactive connection. The interactive client is defined as a client that uses the Client_interactive option in
Porting the local apache+mysql+php environment to someone else's computer, where data in MySQL is not copied, causing a "system error 1067" error in theMySQL service failing to startwhen someone else's computer is running MySQL.This is because I in
Numeric typeMySQL's numeric data types can be roughly divided into two categories, one is an integer and the other is a floating-point or decimal. Many different subtypes are available for each of these categories, and each subtype supports data of
MySQL dual master architecture, which is supplemented by load balancing devices, can achieve the MySQL database load balancing high performance and high availability, load balancing devices can be based on the algorithm to the load of the database
When you create a temporary table, you can use the TEMPORARY keyword. Such as: Create temporary table tmp_table (name varchar (ten) not null,passwd char (6) NOT null) 'OrCREATE Temporary TABLE IF not EXISTS sp_output_tmp ENGINE = MEMORY SELECT ...
MySQL under Linux database name, table name, column name, alias casing rules are like this:1, database name and table name are strictly case-sensitive;2, the table alias is strictly case-sensitive;3, the column name and the alias of the column in
Many friends in MySQL think that the field auto_increment type self-increment ID value can not be modified, in fact, this understanding is wrong, the following describes the MySQL self-increment ID starting value modification and setting method.The
1, transaction processing InnoDB supports transactional features, MyISAM not supported. Myisam executes faster and performs better. 2,select, UPDATE, INSERT, delete operation MyISAM: if executing a lot of select,myisam is a better choice InnoDB:
In our development of the efficiency has always been a problem, especially for a lot of large data volume operation, today we ran into a random query data, at first we might think of the simplest order by RAND () to operate but the efficiency is not
1. Add header file path (include path in MySQL installation path)2. Add library files (copy libmysql.lib directly from the MySQL installation path)3. Programming Operation DatabaseCodeAccessToMySQL.cpp: Defines the entry point of the console
MySQL series: innodb source code analysis-minitransaction
Log is a very important module of innodb. There are two types of logs in innodb: redo log and undo log. The redolog is used for Data Exception recovery and Data Synchronization recovery of
Ubuntu Mysql maintenance and tumysql MaintenanceInstall MySql
Sudo apt-get install mysql-serverGo to Mysql Shell
Mysql-u root-pQuery a database
Show databases;Create a database
Create database $ DB_NAME;Database Information Retrieval
Use $
Mysql service cannot be started due to an error in the mysql binary log file
I opened phpmyadmin today and found that I couldn't connect to the mysql database. I couldn't restart mysql and found the following error when I checked the log.
mysqld:
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service