Database Performance Tuning: Best Practices & Pitfalls
Ensuring optimal performance of business-critical applications is one of the most important goals for IT leaders. But even in today’s modern IT environment, performance management is often conducted reactively instead of proactively. With the rise in pressure across industries for doing more with less, it is especially critical now to consider how much you’re getting out of your database infrastructure. Everyday, the demand for more and more data-intensive apps is putting more and more pressure on your systems. This is where database optimization comes in.
Join Rob Reid, Tech Evangelist and Software Developer and Glenn Fawcett, CockroachDB DBMS Performance Specialist in this tech talk, as they discuss:
The fundamentals of database performance
How to identify improvement opportunities (including indexes, queries, clusters, schemas)
Real-world lessons from CockroachDB customers
Performance differentiators for a distributed SQL database
Database Performance Tuning: Best Practices & Pitfalls
00:00 Introduction
02:44 What is the 100ms rule?
03:18 How performance impacts user retention
04:11 What is the CockroachDB Standard Tier?
09:21 Columnar block format explained
10:15 Admission control on writes
11:15 Disallow full table scans explained
14:58 How to design primary keys
18:48 Upsert vs Insert Into
19:31 What is row level TTL
20:20 Column Families
22:41 How to disallow full table scans
25:54 Constraints for more advanced use cases
28:05 Explain Plan
29:52 Index scan + PK Join / Index scan only w/ STORING clause
30:55 Schemas and Queries
32:19 How to observe improvements
33:42 Real world screenshots
41:02 Key takeaways
#databaseperformance #distributedsql #databaseconcepts
About Cockroach Labs:
Cockroach Labs is a pioneering software company at the forefront of database technology, dedicated to delivering resilient and scalable database solutions to run mission-critical workloads for the world's most important businesses. With a mission to scale when others fail, Cockroach Labs is revolutionizing the way businesses manage their data with its innovative cloud native distributed SQL database, CockroachDB.