--+--+-+
| person | ref | email1,email2 | email1 | 101 | const |1 |
Using where |
++--+---++-+---+--+-+
I'm curious why this is. (In general, I have been surprised by how often
indices are no
Very unlikely. I'm only using 7% of the disk capacity.
gerald_clark wrote:
Have you run out of free disk space?
Henning Schulzrinne wrote:
Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
lwp_cond
has lots of indices, including a
full-text index.
>How-To-Repeat:
alter table add index (number(4))
>Fix:
>Submitter-Id:
>Originator:Henning Schulzrinne
>Organization:
Dept. of Computer Science, Columbia University
>MySQL support: none
>Synopsis: A