MariaDB 10.5 Tutorial - New Features for Troubleshooting

on YouTube ↗57m

" summary

MariaDB 10.5 actually adds measurable troubleshooting tooling: ~270 new instrumentation points in Performance Schema, parity with many MySQL 5.7 tables plus a change so the schema can allocate more memory after startup, and per-statement and per-transaction timing including prepared-statement and stored-procedure internals. Visibility for the generic thread pool appears as four new INFORMATION_SCHEMA tables showing groups, queues and per-connection waits. Caveats: Performance Schema stays disabled by default, docs are incomplete, and a few instrumentation bugs remain.

AI-written summary · about

" chapters (29)

1. 0:00Intro
2. 3:05What is this session about? • MariaDB 10.5 new features that may help DBAs and application developers to find out what's going on when a problem occurs: Performance Schema updates to match MySQL 5.7
3. 5:16Performance Schema: 10.5 vs MySQL 5.7 vs 10.
4. 6:25What's new in Performance Schema?
5. 7:54P_S Memory Instrumentation: Instruments
6. 10:36P_S Memory Instrumentation: Summary Tables
7. 12:56P_S Memory Instrumentation: Tables Structure
8. 14:57P_S Memory Instrumentation: Example
9. 17:37P_S Memory Instrumentation in MariaDB 10.5
10. 18:44P_S Memory Instrumentation: Problems
11. 22:08Performance Schema: MDL Instrumentation
12. 25:15MDL Instrumentation: Problems
13. 28:12Performance Schema: PS Instrumentation
14. 32:22Status Variables Instrumentation: Example
15. 36:06P_S Stored Procedures Instrumentation: Details
16. 39:59Performance Schema: SX-locks Instrumentation
17. 42:50Performance Schema: Transactions Instrumentation
18. 43:34Transactions Instrumentation: Example Lors consider an example (demo) of getting the sequence of statements executed in frames of current active transactions With proper instrumentation and consumers enabled
19. 45:12Performance Schema: User Variables Instrumentation
20. 46:11P_S User Variables Instrumentation: Example
21. 46:41Performance Schema: Replication Instrumentatio
22. 47:56Replication Instrumentation: Examples
23. 48:35What's new in Thread Pool?
24. 51:14Thread Pool Instrumentation: Groups
25. 52:32Thread Pool Instrumentation: Queues
26. 53:24Thread Pool Instrumentation: Waits
27. 54:19What's new in ANALYZE?
28. 55:06ANALYZE FORMAT=JSON: Example
29. 56:24Thank you! Questions and Answers?

" related talks

• 19mMariaDB ObservabilityPeter Zaitsev · FOSDEM 2021
• 24mMySQL Performance SchemaMayank Prasad · FOSSASIA 2015 DevOps Track
• 53mMariaDB Server 10.2: The Complete GuideColin Charles · Percona Live Open Source Database Conference 2017
• 29mMySQL Performance Schema : A great insight of running MySQL serverMayank Prasad · FOSSASIA Summit 2017
• 43mUsing MySQL Performance Schema to debug performance issuesDanil Zburivsky · HighLoad++ 2012
• 27mMySQL 8 ObservabilityPeter Zaitsev · Percona Tech Days 2020
• 27mState of MariaDBMichael Widenius · O'Reilly MySQL Conference & Expo 2011
• 50mDiagnosing Database Issues With MySQL 8.0’s Performance SchemaRobert Mandeville · Percona Live 2022