00–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 (abbreviation: MVCC). -Atomicity of the transaction (atomicity)All operations
Empty cache Primary Execute flush command, must have reload permissionFlush hosts empties the host cache table. If the host changes IP, or receives an error host...is blocked, empty the host table. When connecting to a MySQL server, a specified host
Introduction: Principle and mechanism of master-slave replicationto implement replication, you must first open The binary log(bin-log) function on the Master side , otherwise it cannot be implemented. Because the entire replication process is
Introduction: Principle and mechanism of master-slave replicationto implement replication, you must first open The binary log(bin-log) function on the Master side , otherwise it cannot be implemented. Because the entire replication process is
First,Common topologies for replicationThe architecture of replication has the following basic principles:(1) Each slave can have only one master;(2) Each slave can only have a unique server ID;(3) Each master can have a lot of slave;(4) If you set
Start MySQL Error:[[email protected] ~]#/etc/init.d/mysqld startSocket File/tmp/mysql_slave.sock exists. is another MySQL daemon already running with the same UNIX socket?Cause multiple MySQL processes use the same socket.Two ways to solve:The first
MySQL study--"Too many connections" error solutionThe error message is as follows :Can not connect to MySQL serverError:too Many connectionsErrno.: 1040Similar Error Report have beed dispatched to administrator before.The following is a description
The last time I encountered MySQL master server data consistency problem, think of it was a few years ago, but also vaguely remember the panic scene, fortunately, finally with the help of Maatkit solve the problem. A few years later, when I faced
First, maintain the partitionFor the maintenance of the table, we generally have the following methods: CHECK table, OPTIMIZE table, ANALYZE table and Repair table.In these ways, the same applies to partitions. Below, we explain the various roles.1.
MySQL database, as one of the most basic data storage services, has a very important position in the whole system, so it is understandable to ask for high availability. There are many solutions that can implement different SLAs (service level
Installing MySQL on Ubuntu is very simple and requires just a few commands to complete.1. sudo apt-get install mysql-server 2. Apt-get Isntall mysql-client 3. sudo apt-get install Libmysqlclient-dev the installation process will prompt to set a
MEM_ROOT for MySQLThis article will describe in detail the widely used MEM_ROOT struct in MySQL, while saving the debugging information. It will only analyze the memory allocation in mysql under normal conditions.Before the specific analysis, we set
Why does MySQL rollback cause an increase in the ibd file ?, Mysqlibd
A simple test:
start transaction;insert into tb1 values(3, repeat('a', 65000),'x',1);--commit;rollback;
These are the sizes of files after tb1.ibd is inserted, before rollback,
MySQL partition summary, mysql Partition
MySQL supports four partitions: RANGE, LIST, HASH, and KEY. Each partition has a special type. For RANGE partitions, there are range columns partitions. LIST partitions have list columns partitions. For HASH
Linux keepalived + LVS implements mysql slave database load balancing and keepalivedlvsPrerequisites:
Reference link:
Http://www.osyunwei.com/archives/7464.html
Ps: the above are the main references for this operation. I am very grateful for the
How to enable MySQL to store emoji characters,
MySQL must support emoji Versions later than 5.5.3, and set the character set to utf8mb4.
What is the difference between utf8mb4 and utf8? In the past, mysql utf8 had a maximum of 3 characters, while
Create, modify, and delete mysql triggers.
// Make a simple exercise. When creating a simple trigger to add an article, the time is automatically added. By default, the author is 'memories of the records'
Show columns from test; // view the table
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