Please login or register.

Login with username, password and session length
Advanced search  

News:

You need/want an older version of sNews ? Download an older/unsupported version here.

Author Topic: MySQL Optimization - Indexing  (Read 4661 times)

Keyrocks

  • Doug
  • ULTIMATE member
  • ******
  • Karma: 449
  • Posts: 6020
  • Semantically Challenged
    • snews.ca
MySQL Optimization - Indexing
« on: February 07, 2008, 08:34:54 pm »

Indexing - MySQL Optimization - one of many articles explaining the virtues of Indexing to help MySQL run your applications a little quicker.

From the Official MySQL User Guide:
    15.1. Introduction to Indexing
    15.2. Types of Indexes
    15.3. Choosing Columns to Index
    15.4. Displaying Table Indexes
    15.5. Creating Indexes
    15.6. Creating and Using Composite Indexes
    15.7. Dropping Indexes
    15.8. Using FULLTEXT Indexes
    15.9. Using EXPLAIN to Optimize Indexing

The Complete MySQL 5.1 Reference Manual
« Last Edit: February 07, 2008, 09:44:18 pm by Keyrocks »
Logged
Do it now... later may not come.
-------------------------------------------------------------------------------------------------
sNews 1.6 MESU | sNews 1.6 MEMU

henrich

  • Sr. Member
  • ****
  • Karma: 23
  • Posts: 381
  • Passion for quality and excellence!
    • My personal blog and portofolio
Re: MySQL Optimization - Indexing
« Reply #1 on: February 07, 2008, 09:01:09 pm »

Very good article Keyrocks, very good! I am planning that in one day to print out all this important articles and read all of them, and learn them :)

Do you know more similar articles?
Logged
By(e) Henrich :)
------------------------------
IT related blog

codetwist

  • Hero Member
  • *****
  • Karma: 50
  • Posts: 940
Re: MySQL Optimization - Indexing
« Reply #2 on: February 07, 2008, 09:24:28 pm »

Just one link of obviously not so prominent source ... errr ... I meant ... from official MySQL documentation on UPDATE execution speed.
Logged

Keyrocks

  • Doug
  • ULTIMATE member
  • ******
  • Karma: 449
  • Posts: 6020
  • Semantically Challenged
    • snews.ca
Re: MySQL Optimization - Indexing
« Reply #3 on: February 07, 2008, 09:35:21 pm »

Sure... check the list in the first post. I'll try to remember to gather more useful links together there... such as the one Codie just provided.
Logged
Do it now... later may not come.
-------------------------------------------------------------------------------------------------
sNews 1.6 MESU | sNews 1.6 MEMU

codetwist

  • Hero Member
  • *****
  • Karma: 50
  • Posts: 940
Re: MySQL Optimization - Indexing
« Reply #4 on: February 07, 2008, 10:07:43 pm »

Particularly, chapter named Optimization in any of MySQL Reference Manuals (in 5.1. quoted by Keyrocks it's Chapter 6. Optimization).

P.S. IMHO those user guides are kind of not so informative in comparison with Reference Manuals.
Logged

maxou

  • Jr. Member
  • **
  • Karma: 5
  • Posts: 81
  • Bug's Finder
Logged
Work on XAMPP.

Joost

  • Guest
Re: MySQL Optimization - Indexing
« Reply #6 on: February 08, 2008, 03:56:58 am »

Take a look at these case studies in human readable format on hackmysql.com
Logged