Question About "Index Length"

This is a discussion on Question About "Index Length" within the MySQL Database forums, part of the Database Forums category; hey there I was just perusing a database with the MySQL Administrator tool, and I noticed that some of my ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 06-06-2007
Good Man
 
Posts: n/a
Default Question About "Index Length"

hey there

I was just perusing a database with the MySQL Administrator tool, and I
noticed that some of my tables have larger Index Length's than Data
Length's... for example:

80kB index vs 15kB data (76 rows so far)
73kB index vs 42kB data (2827 rows so far
7.1MB index vs 6.5MB data (77,241 rows so far)


Generally, I've created indexes on all columns that could be JOINed/WHEREd
in a query...

Is this a problem? Are there negative implications for this (aside from
taking up space on the server)?

Thanks.

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:37 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0