Principles and Application of pt-online-schema-change, ptonlinechangeschema
If it is reprinted, please indicate the source of the blog: www.cnblogs.com/xinysu/. The copyright belongs to xiaoradish in the blog garden. Thank you for your
I have always been interested in Mysql database/table sharding, but I am still at the stage of interest and have not encountered any applicable scenarios. Life is short. Instead of waiting for an opportunity, you can create it yourself. After a
Original source: MySQL 5.5 Reference ManualPart of the translation: "mysql_5.1 Chinese reference Manual"Reprint please specify the original link http://www.cnblogs.com/lenagt/archive/2012/06/06/2538201.html Thank you.---------------------------------
System LockShow processlistStatus entries in Show Processlist output: 5.1 None of the manuals, or the translation of the problem, are accompanied by 5.5 original description:After createThis occurs when the thread creates a table (including internal
13th. The extensible design of MySQL ReplicationObjective:MySQL Replication is a very distinctive feature of MySQL, and he is able to copy the data from one MySQL server Instance to the Instance of another MySQL server. Although the replication
1.MySQL Engine Overview 1.1 What is a storage engineWhen we record a video file, it can be converted to different formats such as mp4,avi,wmv, and on the computer's disk will also exist in different types of file system Windows common Ntfs,fat32,
0. Create a database tableMysql> create database if not exists my_db default charset utf8 COLLATE utf8_general_ci;# Pay attention to the following sentence "COLLATE utf8_general_ci", which
1. Slow QueryWhen a resource becomes inefficient, it should be understood why. Like the following possible causes:1. Resources are overused and the margin is insufficient to work properly.2. Resources are not properly configured3. Resources are
It is said that the Pt-online-schema-change in the Pt-toolkit toolset can modify the table structure on-line without locking the table, so what is the specific principle of this tool, please see below to explain:Restrictions on the use of
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:
and provide relevant evidence. A staff member will contact you within 5 working days.