MySQL performance tuning and Architecture design--9th chapter The performance optimization of MySQL database schema designPreface: Many people think that performance is optimized in the process of writing code (program code or database code), in
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
[MySQL] online table redefinition-pt-online-schema-change bitsCN.com
MySQL does not support online table redefinition like Oracle itself, but we can use the open-source software percona-toolkit tool pt-online-schema-change for online
Pt-Online-schema-change of MySQL online DDL Tool
MySQL DDL:DDL is a feature that makes all MySQL ddbas criticized, because in MySQL, when dDDL is performed on a table, it locks the table. When the table is small, such as less than 1 W rows, it has
Traditional method to modify table structure similar to ALTER TABLE XX Modify, you need to lock the table structure, if the table is large, the operation time will be longer. At present, the vast majority of business requirements 24*7 Non-stop
Pick to: This paper describes the problemof MySQL DDL , thept-online-schema-change of the work principle , and the actual use of The pt-online-schema-change tool modifies the 160 million-level data table structure on-line in the production
"MySQL" High performance MySQL learning notes, fourth, schema and data type optimizationGood logical and physical design is the cornerstone of high performance, and the schema should be designed according to the query statement that the system will
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
"Use" online change chart"Note the risk" because it involves modifying the table's data and structure, so be careful to test and backup before use, the tool will not change the table by default, unless you add the--execute parameter"Introduction to
The following examples are to copy old_table to new_table.
To start with the conclusion, the most recommended practice is the following two lines:
The code is as follows
CREATE TABLE new_table like
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.