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
The bow whispered to the arrow, "Your freedom is mine ". Schema is like an arrow and bows like Python. Choosing Python is the biggest freedom of Schema. Freedom should be an opportunity to make yourself better.(I) MySQLdb SectionTable
MySQL database design-detailed description of Schema operations using Python, pythonschema
The bow whispered to the arrow, "Your freedom is mine ". Schema is like an arrow and bows like Python. Choosing Python is the biggest freedom of Schema.
How to Use pt-online-schema-change to change the primary key of a MySQL table, ptonlinechangeschema
When the service runs for a period of time and finds that the original primary key settings are not reasonable, you want to change the primary key.
Source: http://blog.itpub.net/26515977/viewspace-1208256/SQLAlchemy Part of this article can refer to http://www.liaoxuefeng.com/wiki/ 0014316089557264a6b348958f449949df42a6d3a2e542c000/0014320114981139589ac5f02944601ae22834e9c521415000 Bow before
"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
#!/bin/bash# run the script needs to change 2 places: The first is the basic information, the second is--alter# basic information (need to change) user= ' xxx ' password= ' xxx ' host= ' xxx ' port= xxxxd= ' xxx ' t= ' xxx ' #--alter (need change)
MySQL's online table structure is modified because of inefficient and blocking read and write. has been criticized. As for the principle of alter TABLE, see my previous article. MySQL modifies the large table structure online. After reading, found
MySQL Upgrade Method Guide DaquanHttp://blog.sina.com.cn/s/blog_5a8b8eb80100ld7a.htmlIn general, when upgrading from one release version to another, we recommend that you upgrade the version in order. For example, to upgrade MySQL 3.23, upgrade to
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.