Reputation
211
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 5
Newest
 Yearling
Impact
~17k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Apr
8
awarded  Yearling
Apr
8
awarded  Nice Answer
Sep
24
awarded  Autobiographer
Apr
12
awarded  Necromancer
May
6
awarded  Supporter
Sep
9
comment Online Schema Change Strategies for Large MySQL Tables
Your solution is quite wrong, I'm afraid. Disclaimer: I am author of the openark-kit discussed above. The online alter table operation is MUCH more complicated than presented in your answer. What happens for UPDATEs? for DELETEs? It seems you assume you never delete or purge rows from your table. How do you copy 100 million rows? In one single transaction? You also assume an AUTO_INCREMENT PRIMARY KEY. The general solutions assume nothing of the above, and handle the general case where the PK is of any type and number of columns, and where rows are deleted and updated.
Jul
18
awarded  Teacher
Jul
16
awarded  Editor
Jul
16
revised Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances'
Added note on the time of answer w/r time of question
Jul
16
answered Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied for 'cond_instances'