OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” 2.6.2 Features that are different from MySQL 2.6.2.1 Auto-increment ID • In near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput import ( "context" "database/sql" ) type TiDBSqlTx struct { *sql.Tx conn *sql.Conn pessimistic bool } func TiDBSqlBegin(db *sql.DB, pessimistic bool) (*TiDBSqlTx, error) { ctx := context.Background()

OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” • Descending Index #2519 • SKIP LOCKED syntax #18207 • Lateral derived tables #40328 near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput tables in a way that can improve the performance of certain queries. The term clustered in this context refers to the organization of how data is stored and not a group of database servers working together

OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” • Descending Index #2519 • SKIP LOCKED syntax #18207 • Lateral derived tables #40328 near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput tables in a way that can improve the performance of certain queries. The term clustered in this context refers to the organization of how data is stored and not a group of database servers working together

OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” 2.4.2 Features that are different from MySQL 2.4.2.1 Auto-increment ID • In near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput tables in a way that can improve the performance of certain queries. The term clustered in this context refers to the organization of how data is stored and not a group of database servers working together

OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” 2.4.2 Differences from MySQL 2.4.2.1 Auto-increment ID 96 • In TiDB, the auto-incremental near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput tables in a way that can improve the performance of certain queries. The term clustered in this context refers to the organization of how data is stored and not a group of database servers working together

OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” • Descending Index #2519 • SKIP LOCKED syntax #18207 • Lateral derived tables #40328 near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput tables in a way that can improve the performance of certain queries. The term clustered in this context refers to the organization of how data is stored and not a group of database servers working together

OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” • Descending Index #2519 • SKIP LOCKED syntax #18207 • Lateral derived tables #40328 near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput tables in a way that can improve the performance of certain queries. The term clustered in this context refers to the organization of how data is stored and not a group of database servers working together

- �→ type Modified This configu- ration item now also controls the com- pression algo- rithm of response messages sent from TiKV to TiDB. Enabling compres- sion might consume more CPU re- sources. TiFlash OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” • Descending Index #2519 • SKIP LOCKED syntax #18207 • Lateral derived tables #40328 near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput

OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” • Descending Index #2519 • SKIP LOCKED syntax #18207 • Lateral derived tables #40328 near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput tables in a way that can improve the performance of certain queries. The term clustered in this context refers to the organization of how data is stored and not a group of database servers working together

OPTIMIZE TABLE syntax • HANDLER statement • CREATE TABLESPACE statement • “Session Tracker: Add GTIDs context to the OK packet” • Descending Index #2519 • SKIP LOCKED syntax #18207 • Lateral derived tables #40328 near-linear scalability. The number of TiFlash nodes should be tuned based on expected performance and response time. • If the OLTP throughput is relatively high (for example, the write or update throughput tables in a way that can improve the performance of certain queries. The term clustered in this context refers to the organization of how data is stored and not a group of database servers working together