- MariaDB Cookbook
- Daniel Bartholomew
- 90字
- 2021-07-16 12:19:26
Chapter 3. Optimizing and Tuning MariaDB
In this chapter, we will cover the following recipes:
- Using SHOW STATUS to check whether a feature is being used
- Controlling MariaDB optimizer strategies
- Using extended Keys with InnoDB and XtraDB
- Configuring the Aria two-step deadlock detection
- Configuring the MyISAM segmented key cache
- Configuring threadpool
- Configuring the Aria pagecache
- Optimizing queries with the subquery cache
- Optimizing semijoin subqueries
- Creating an index
- Creating a full-text index
- Removing an index
- Using JOINs
- Using microseconds in DATETIME columns
- Updating the DATETIME and TIMESTAMP columns automatically
推薦閱讀
- PWA入門與實踐
- SQL Server 2012數據庫技術及應用（微課版·第5版）
- HTML5 移動Web開發從入門到精通（微課精編版）
- Python網絡爬蟲從入門到實踐（第2版）
- 微服務設計原理與架構
- 零基礎學MQL：基于EA的自動化交易編程
- Visual C#.NET程序設計
- 51單片機C語言開發教程
- Machine Learning in Java
- Hands-On Full Stack Development with Spring Boot 2.0 and React
- Developing SSRS Reports for Dynamics AX
- Ext JS 4 Plugin and Extension Development
- Microsoft HoloLens By Example
- C/C++代碼調試的藝術（第2版）
- Spring Boot從入門到實戰