where is the index physically located in MySQL database
-
Just wondering where is the index info physically located in MySQL database if I have indexed a table with ALTER TABLE contacts ADD KEY (columnName); ? it will stay with that table and add a new spacial column to it; stay separately from that table; I think the #2 is the correct answer. Can we index columns from more than one tables? how?
-
Answer:
(This question might better be asked on dba.stackexchange.com) But to answer your questions: For the MyISAM engine, a table's indexes are stored in the .MYI file (in the data directory, along with the .MYD and .frm files for the table). For InnoDB engine, the indexes are stored in the tablespace, along with the table. If innodb_file_per_table option is set, the indexes will be in the table's .ibd file along with the .frm file. No, it's not possible to create an index that references more than one table. An index is specific to a table.
5YrsLaterDBA at Database Administrators Visit the source
Other answers
Using MySQL, all table information, including keys, are located in the INFORMATION_SCHEMA database. For a more detailed answer, you might want to ask on http://dba.stackexchange.com/.
Matt Clark
Related Q & A:
- Where Is The Red River Located?Best solution by Yahoo! Answers
- How to manage MySQL database in Azure?Best solution by stackoverflow.com
- How to do a local mysql database replication on an online server?Best solution by howtoforge.com
- How to Display an Image in PDF, which is retrieved from MySql Database :JSP and iText?Best solution by Stack Overflow
- Where is the Gillette firm located in Bangalore?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.