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
上一章目录下一章