how many index can a mysql table have

Question

chandbasha 0 Newbie Poster

12 Years Ago

Hi,

how many index i can create for one table in mysql.

mysql php

Edited 12 Years Ago by pritaeas because: Moved to mysql forum.

4 Contributors
3 Replies
220 Views
1 Day Discussion Span
Latest Post 12 Years Ago Latest Post by smantscheff

pritaeas 2,194 ¯\_(ツ)_/¯

12 Years Ago

Depends on your server, but usually 32 or 64 per table. Note that there are also limits on the max index length.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

ankit.jivrani 0 Newbie Poster · Answer 1 · 2012-09-04T16:39:02+00:00

There is No fixed number for indexes and it totally depend on Your queries.

But Make sure that the more indexes you have, the slower inserts and updates will be..(In case of PhpMyAdmin)

Adding an index is a slow operation with big tables.
Adminer allows manipulation with all indexes together.

:)

smantscheff 265 Veteran Poster · Answer 2 · 2012-09-05T09:33:17+00:00

http://lmgtfy.com?q=mysql+number+of+indexes
http://dev.mysql.com/doc/refman/5.5/en/column-indexes.html

The maximum number of indexes per table and the maximum index length is defined per storage engine. See Chapter 14, Storage Engines. All storage engines support at least 16 indexes per table and a total index length of at least 256 bytes. Most storage engines have higher limits.