Daevid Vincent wrote:
We currently have some tables that are approaching 1 BILLION rows (real
Billion, with nine zeros, not that silly six zero version). Trying to do an
ALTER on them to add a column can sometimes take hours.
A few years ago I have tested possible table structures for an
I had to do this trick with a few million rows in the table, and what
I did was to create a new table with the required structure, then did
insert into select from, starting with the newest data first, cause
that made sense for my application. Then, renamed the old table and the
new.
YMMV
andu
-Original Message-
From: Rob Wultsch [mailto:wult...@gmail.com]
Sent: Thursday, August 05, 2010 6:05 PM
To: Daevid Vincent
Cc: MySQL List
Subject: Re: Possible tricks to ALTER on huge tables?
Having significant amount of overhead for unused columns will without
doubt harm
Daevid Vincent wrote:
I'm wondering if we had the foresight to create the tables, and then tack
on extra dormant columns of various common types, such as:
Nothing beats empirical evidence. Why don't you try it and find
out (and report back)!
--
MySQL General Mailing List
For list archives:
On Thu, Aug 5, 2010 at 5:07 PM, Daevid Vincent dae...@daevid.com wrote:
Driving to work today, I had an epiphany thought, but wanted to see if
anyone could prove my theory or not.
We currently have some tables that are approaching 1 BILLION rows (real
Billion, with nine zeros, not that silly