469,645 Members | 1,193 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

How do I create an index without using all available connections?

Hi, All!

I've got a very large table (149 fields -- I know, I didn't create it,
and I'm working on changing it...) and I need to add an index to speed
up a join query.

However, when I run the "create index `index_name` on
table(`column`)", MySQL uses every available connection to attempt the
creation of the index, and does not allow the web site to access the
database.

If this was a short period of time (a couple of minutes), I could
stand it. Unfortunately, this is a live production server, and I'm
guessing it will take an hour or two to create the index.

Does anyone know how I can run the "create index" query while limiting
the number of connections the query uses?

The version is: mysql Ver 12.22 Distrib 4.0.16, and "max_connections"
is currently set to 100.

Please email me at kevin--atnospam--insuremytrip--dotnospam--com.

Thanks in advance for any assistance!

KJJ
InsureMyTrip.com
Jul 20 '05 #1
0 1614

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Guy Deprez | last post: by
1 post views Thread by D. Lee Christopher | last post: by
9 posts views Thread by WalterR | last post: by
3 posts views Thread by efiryago | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.