MySQL Questions

Box owns heap data. Rc is single-thread reference counting. Arc is atomic thread-safe reference counting.

Page 10

MySQL is a relational database that stores structured data in tables and uses SQL for queries.

Primary key uniquely identifies row. Foreign key links row to primary key in another table and maintains relationship integrity.

INNER JOIN returns matching rows from both tables. LEFT JOIN returns all left table rows and matched right table rows, otherwise

NULL.

Index speeds up reads by creating searchable structure, but slows writes and uses storage.

Organizing data to reduce duplication and improve integrity using related tables.