Below are the answers

Best Regards
-----Mensaje original-----
De: David Griffiths [mailto:[EMAIL PROTECTED] 
Enviado el: Miércoles, 30 de Junio de 2004 01:29 p.m.
Para: [EMAIL PROTECTED]
Asunto: Re: Index problem


What's the definition of the table? IE are you indexing an INT, VARCHAR, 
etc?
3 fields
Folio, Vacante, int
Folio2 char(10)

What's the definition of the index? Is it unique, composite, etc?
Nonunique, single column (folio2)

What's the storage engine in use? InnoDB? MyISAM?

Myisam

Can you show the relevant parts of your my.cnf file?

I have the standard My-huge.cnf

What operating system are you using?

Redhat Linux 7.3 
David

Oropeza Querejeta, Alejandro wrote:

>Hi, i'm trying to create an index on a table with 199 million records. 
>The problem is that is taking too long (8 hours and is not yet 
>finnished).
> 
>does anyone have any idea?
> 
>the server is 2Xeon 2.8 gigs with 6 Gb of ram.
> 
>Best regards
> 
>Alejandro
>
>  
>


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


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

Reply via email to