INNODB automatically creates an index on foreign key fields. Is there a storage engine that allows me to disable that?
My googling on xtradb doesn't give me positive results. Perhaps, it is possible in Mariadb/Drizzle? Any ideas?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
I don't think this is a bad question, but I do think that disabling indexes on foreign key fields is a bad idea. There is a very good reason why they are there. I have done a fair bit of DB admin work over time, and I have yet to see a situation where not having such an index would help the database perform better.