| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Brian Dunning | Date: | June 13 2007 4:54pm |
| Subject: | Before I shoot myself in the foot... | ||
| View as plain text | |||
...if I add a column to a table with 40,000,000 records, will it cause that table to hang for any significant amount of time, and prevent other transactions? It's a MyISAM table and I was going to add a varchar(20) column, NULL. It's a very busy table, constant searches and inserts.
| Thread | ||
|---|---|---|
| • Before I shoot myself in the foot... | Brian Dunning | 13 Jun |
| • Re: Before I shoot myself in the foot... | Baron Schwartz | 13 Jun |
| • Re: Before I shoot myself in the foot... | Brent Baisley | 13 Jun |
| • Re: Before I shoot myself in the foot... | Brian Dunning | 13 Jun |
| • Re: Before I shoot myself in the foot... | Ananda Kumar | 14 Jun |
| • Re: Before I shoot myself in the foot... | Baron Schwartz | 14 Jun |
| • Re: Before I shoot myself in the foot... | Ananda Kumar | 14 Jun |
| • Re: Before I shoot myself in the foot... | Martijn Tonies | 14 Jun |
| • Re: Before I shoot myself in the foot... | Martijn Tonies | 14 Jun |
| • Re: Before I shoot myself in the foot... | Baron Schwartz | 13 Jun |
