• What storage engines does MySQL have? What’s the difference?
  • What are dirty reads, phantom reads, and unrepeatable reads? How do you deal with it?
  • What are the basic characteristics and isolation levels of transactions?
  • What are the locks in MySQL? What is a gap house?
  • What is the index structure of MySQL? What are clustered and non-clustered indexes?
  • How is MySQL cluster set up? How does read/write separation work?
  • Talk about how to divide the database into separate tables? How much data should be stored and tabulated? What are the methods of dividing database and dividing table and sharding strategy? What is the execution flow of SQL after database and table?