Is there a measurable performance difference between using INT vs. VARCHAR as a primary key in MySQL? I’d like to use VARCHAR as the primary key for reference lists (think US States, Country Codes) and a coworker won’t budge on the INT AUTO_INCREMENT as a primary key for all tables. My argument, as detailed here, … Read more
Here is a gross oversimplification of an intense setup I am working with. table_1 and table_2 both have auto-increment surrogate primary keys as the ID. info is a table that contains information about both table_1 and table_2. table_1 (id, field) table_2 (id, field, field) info ( ???, field) I am trying to decided if I … Read more
This question already has answers here: MyISAM versus InnoDB [closed] (25 answers) Closed 9 years ago. I understand that this question has been asked before, but most of the time it is asked in relation to a specific database or table. I cannot find an answer on this site that describes the two engines and … Read more
My MySQL database contains several tables using different storage engines (specifically myisam and innodb). How can I find out which tables are using which engine? 14 Answers 14
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 3 years ago. Improve this question I’m working on a projects which involves a lot of database writes, I’d say (70% inserts … Read more
