mysql ibd file in file system I am in searching of where mysql stored its indexes for innodb engine.I found it stores in ibd file but where I will found those files on system.Can anyone help please?
In InnoDB both data and indexes are stored together, there is no separate file for indexes. Within your MySQL install directory you will find directories for each database, and within each database directory will be the tablespace files. Depending on whether you have InnoDB File-Per-Table enabled or not, you will see individual files per table or not.