Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » building new index on big tables
building new index on big tables [message #423] Fri, 24 November 2006 16:53 Go to previous message
rds13 is currently offline rds13
Messages: 1
Registered: November 2006
Junior Member
Hye,

We have tables with over 10 or 20 millions of records (MyISAM tables if that matters).
Building new index, removing old index is taking at least a quarter of hour.
While doing this operation, MySQL seems to lock the table or at least the load is so big that any operations on the table is delayed after the end of index operation.

I wonder how DBA usually deal with this kind of problem on MySQL ?

I cannot imagine a strategy which would help keeping the service a hundred per cent available while achieving an index reconfiguration.
Report message to a moderator
[Message index]

Read Message
Read Message
Read Message
Previous Topic:Normal for mysql to strip trailing spaces?
Next Topic:Creating The right database for hundreds of thousands of Blog Posts?
Goto Forum:

  

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

Current Time: Fri Jul 10 05:01:20 EDT 2009

Total time taken to generate the page: 0.02379 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

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.