MySQL Performance: MySQL => Creating index in large table

Members

Help

Home

Home » Performance » MySQL » Creating index in large table

Show: Today's Messages :: Show Polls :: Message Navigator

Creating index in large table [message #1236]

Fri, 11 May 2007 14:03

mr.lukes
Messages: 1
Registered: May 2007
Location: New York

Junior Member

Hi,

1) I have table that contains 16 million records (16,186,288 ; MyISAM ; latin1_swedish_ci ; 2.8 GiB ), and i need to:

delete one index and
create an index on other column

Any ideas how long it can take...

2)I need to backup 43GB database. What is the best way to do it? Any scripts or tools. The database is all time alive. There are about 2 inserts per second.

[Updated on: Fri, 11 May 2007 14:05]

Report message to a moderator

Previous Topic:	32 -> 64 bit migration, data files
Next Topic:	Transaction Wrapper

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 5 15:38:50 EDT 2009

Total time taken to generate the page: 0.01023 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.