At 10:47 PM 6/16/2011, Johan De Meersman wrote:
- Original Message -
From: Bennett Haselton benn...@peacefire.org
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
-Original Message-
snip
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
On Fri, June 17, 2011 07:11, Jerry Schwartz wrote:
-Original Message-
snip
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 -
From: Bennett Haselton benn...@peacefire.org
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
At 11:45 AM 6/14/2011, Johan De Meersman wrote:
- Original Message -
From: Bennett Haselton benn...@peacefire.org
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
I'm looking for some tips tricks documentation that explains how
different data types in rows are stored at the file level (in MyISAM
tables, at least), and how to optimize tables for faster queries,
updates, table definition modification, etc. based on this knowledge.
For example, I've
-0700
To: mysql@lists.mysql.com
From: benn...@peacefire.org
Subject: optimization strategies based on file-level storage
I'm looking for some tips tricks documentation that explains how
different data types in rows are stored at the file level (in MyISAM
tables, at least), and how to optimize
- Original Message -
From: Bennett Haselton benn...@peacefire.org
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,