Roger Ramirez wrote:
>
> Hi,
>
> I'm using MySQL 3.23.39 under Red Hat 7.1 on a Pentium III 600mhz with
> 640MB of Ram. I only 1 table in a database with 5.6 million records and
> I'm currently trying to index a varchar(100) field. I started the query
> "alter table mytable add index myfield (myfield)" at 10am EST this morning
> and 5:45 hours later its still running. If I look in my mysql/var
> directory I have the following.
>
> -rw-rw---- 1 root root 8888 Jul 5 09:44 mytable.frm
> -rw-rw---- 1 root root 689493112 Jul 5 09:58 mytable.MYD
> -rw-rw---- 1 root root 114336768 Jul 5 09:58 mytable.MYI
> -rw-rw---- 1 root root 8888 Jul 5 09:59 #sql-312_9.frm
> -rw-rw---- 1 root root 616317108 Jul 5 11:21 #sql-312_9.MYD
> -rw-rw---- 1 root root 136826880 Jul 5 14:30 #sql-312_9.MYI
>
> The very last file #sql-312_9.MYI has been growing at a rate of about
> 40-50MB/hour.
>
> Is there any way for me to tell how much longer this will go on? I did a
> couple of indexes on two other fields in this table the day
> before yesterday but I issued the commands and walked away from the
> computer. It was a rough day so i don't remember how long it took. The
> other two fields are varchar(5) and varchar(10) and I know for a fact that
> it didn't take more then 24 hours, and I'm pretty sure it was less than 6
> hours.
>
> Thanks,
> Roger Ramirez
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi,
Check your key_buffer_size parameter and try to make it
as big as you can, for best performance it should be big enough
to hold a copy of all your indexes. If your machine is dedicated
to mysql, I would suggest key_buffer_size=256M.
Regards
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php