On Fri, June 17, 2011 07:11, Jerry Schwartz wrote:
>>-Original Message-
>
>
>>What I was really trying to figure out was why it takes me 4
hours to
>>add a new column to my 22-million-row table, and
whether a different
>>table design can avoid that problem.
That reply in the forum says
>-Original Message-
>What I was really trying to figure out was why it takes me 4 hours to
>add a new column to my 22-million-row table, and whether a different
>table design can avoid that problem. That reply in the forum says,
>"ALTER TABLE ... ADD COLUMN will always copy the entire ta
At 10:47 PM 6/16/2011, Johan De Meersman wrote:
- Original Message -
> From: "Bennett Haselton"
>
> Do you happen to know the answer to my other problem -- if I have
> TEXT and BLOB columns but all my other columns are fixed-length, can
> I still get the benefit of faster lookups resul
- Original Message -
> From: "Bennett Haselton"
>
> Do you happen to know the answer to my other problem -- if I have
> TEXT and BLOB columns but all my other columns are fixed-length, can
> I still get the benefit of faster lookups resulting from fixed-length
> rows, if each row just c
At 11:45 AM 6/14/2011, Johan De Meersman wrote:
- Original Message -
> From: "Bennett Haselton"
>
> modifications. (For example, the question I asked earlier about
> whether you can declare extra space at the end of each row that is
> "reserved for future columns".)
That question I c
- Original Message -
> From: "Bennett Haselton"
>
> modifications. (For example, the question I asked earlier about
> whether you can declare extra space at the end of each row that is
> "reserved for future columns".)
That question I can answer: you can't "reserve" space, but if you
At 05:46 AM 6/14/2011, Carlos Eduardo Caldi wrote:
Hello Bennett
On the Mysql developer site have a grate documentation, try the
links above.
http://dev.mysql.com/doc/refman/5.0/en/optimizing-database-structure.html
http://dev.mysql.com/doc/refman/5.0/en/data-size.html
Thanks, this gets me
