Author Topic: alter table for huge site/server  (Read 271 times)

0 Members and 1 Guest are viewing this topic.

Offline scarhandTopic starter

  • Enthusiast
  • Posts: 378
    • View Profile
alter table for huge site/server
« on: July 01, 2009, 05:26:38 PM »
i have an enormous site/server and im trying to do an alter table command

every time i try and run this sql, the server dies

can i just use copy/rename or is there a proper way of doing this for large servers?

Offline fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Posts: 15,444
  • Gender: Male
    • View Profile
Re: alter table for huge site/server
« Reply #1 on: July 01, 2009, 05:35:35 PM »
Show us the table, relevant stats, and the statement in question.
:anim_rules: Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.