By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,666 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,666 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.