Hi, if you have a lot of indexes on your table, it's normal that they consume more than data. That's the general case in a lot of databases.
You've just to monitor index usage and drop the unused ones, before they impact the insert/update/delete performance. Mathias Selon Michael Gale <[EMAIL PROTECTED]>: > Hello, > > Currently I have a large mysql table (36 million rows) and according to > the mysql-admin the data length is 6.5GB and my index length is 8.8GB. > > I am new to mysql, but I would assume that my index should not consume > more space then my data ? > > But in order to provide the data in a timely manner I do not believe I > can remove any of my indexes as there were all added as a result of a > query taking 30-40 minutes. > > Michael > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
