From: Christian Koetteritzsch (ckoetteritzsche-humanities.net)
Date: Thu Jun 21 2012 - 12:36:45 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi,

thanks for the hint, I was testing the settings for the
myisam_sort_buffer_size so I totally forgot it.
But I have another three of these databases to do, so next time I do it
with one ALTER statement

Christian

Am 21.06.2012 16:50, schrieb mos:
> At 02:04 AM 6/21/2012, you wrote:
>> Thank you a lot. The first indexing process finished after about 13
>> hours, so I think the problem is solved now.
>> I set the myisam_sort_bufffer_size to 10GB.
>
> The "first indexing process"???
>
> You should have created all of your indexes with one Alter statement.
> Otherwise it will take another 13+ hours to build the second index
> because it has to create a copy of the table all over again.
>
> Mike
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]