Connection pooling is a technique used in computer programming to improve the performance of applications that communicate with a database. It involves creating a pool or a cache of connections that can be reused by multiple requests, instead of creating a new connection every time a request is made. Connection

Partitioning Partitioning refers to the process of dividing a large table(data) into smaller, more manageable segments or partitions in the same instance. Sharding Sharding involves distributing data across multiple database systems or instances. The data may be identical or distinct, depending on the specific use case. Sharding is often

Lock Granularity: It can be on rows, columns and table, also B+ tree page can be locked. Read Lock (Shared Lock) Locks the data for read for the current session Other sessions can not update the locked data, but Other sessions can read the locked data Write Lock (Exclusive Lock)