Create your own
teaching resources

Sign up for a free account to try! It takes less than 20 seconds

Create free account
Teacherbot 23 May, 05:21:10
  1. Concurrency - (p. 267) - the ability of multiple users to access the same data at the same time without interfering with each other.
  2. Deadlock - (p. 271) - a situation where two or more transactions are waiting for each other to release locks, causing them to be stuck indefinitely.
  3. Isolation - (p. 273) - the degree to which one transaction is isolated from the effects of other concurrent transactions.
  4. Durability - (p. 276) - the property of a database system that ensures that once a transaction is committed, its changes are permanent and will survive any subsequent failures.
  5. Replication - (p. 280) - the process of copying data from one database server to another in real-time.
  6. Master-slave replication - (p. 282) - a type of replication where one server (the master) is responsible for writing data, while one or more other servers (the slaves) are responsible for reading data.
  7. Binary log - (p. 284) - a log file that contains a record of all changes made to a MySQL database.
  8. Point-in-time recovery - (p. 288) - the ability to restore a database to a specific point in time, using the binary log.
  9. Slow query log - (p. 292) - a log file that contains a record of all queries that take longer than a certain threshold to execute.
  10. Query cache - (p. 296) - a caching mechanism that stores the results of frequently executed queries in memory, to speed up subsequent executions.