Hi!
>>>>> "Sinisa" == Sinisa Milivojevic <sinisa@stripped> writes:
Sinisa> Adam Douglas writes:
<cut>
>> Another thing that happens is when I tried to ALTER PostalCodeInfo and
>> PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage
>> at 99.0% to 99.02% (never ending it seems). Both those tables only have
>> 42657 rows each. Any ideas why these two tables seem to hang when anything
>> major is done on them? Funny thing is it seems to be random when you execute
>> a query that uses these two tables. Is there something I'm missing for MySQL
>> configuration or bad table design? I'll post the table schema's below the
>> explain query.
<cut>
Sinisa> Regarding ALTER TABLE, that is also expected behaviour, as MySQL is
Sinisa> re-building indices and has to use lot's of CPU.
Of course the ALTER TABLE should not take forever.
How long did you try this ?
If MySQL really would hang doing this, we would really like to take a
look a this to find out what's wrong!
Please check that you don't get 'disk full' when doing the ALTER
TABLE.
If you are sure this is a bug, please ftp the tables to
ftp://support.mysql.com/pub/mysql/secret
together with a description of how to repeat the problem.
Regards,
Monty
PS: I assume you are using MySQL 3.23.40; If not, try to upgrade
before submitting the files to us!
