Boost MySQL efficiency by adding an index.

EricGregory

New Member
One of our admins, Kevin Quinn took some time to do a nice write up about increasing the efficiency of MySQL by adding an index.  So far, it's been pretty well received.  We just posted it up yesterday, so head over and have a peek if you'd like.  As always, any comments or feedback are certainly welcome.

http://blog.totalserversolutions.com/boost-mysql-efficiency-by-adding-an-index/

Thanks
 

raindog308

vpsBoard Premium Member
Moderator
The hard part is usually figuring out where to add indexes  :D

And of course, every index you add is a tradeoff: faster SELECT speed, slower INSERT/UPDATE speed (because each additional index has to be maintained).
 

marlencrabapple

New Member
The hard part is usually figuring out where to add indexes  :D

And of course, every index you add is a tradeoff: faster SELECT speed, slower INSERT/UPDATE speed (because each additional index has to be maintained).
The tradeoff is minimal in just about everything I've ever written. I usually end up with maybe 3 SELECTs for every INSERT.
 

jarland

The ocean is digital
Good stuff. Over the last few years I've seen people go to incredible lengths, and costs, to compensate for insane MySQL usage rather than spend a single moment optimizing their queries. Just a few minutes running watch on "mysqladmin processlist" can change your perspective about website performance in many common scenarios.
 
Top