TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

MySQL schema changes and pt-online-schema-change

20 pointsby pathdependentabout 13 years ago

2 comments

elbacabout 13 years ago
I've been using pt-online-schema-change for a few months ago. It is a godsend, you have to make sure however that your server can handle the load of copying all the data, IO and memory. Specifically that you have enough buffers to handle duplicating the table.<p>It's great for rebuilding / reindexing tables.
nupark2about 13 years ago
Or, switch to PostgreSQL for new projects and stop throwing good money in after the bad.
评论 #3975545 未加载