Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • MariaDB Cookbook
  • Toc
  • feedback
MariaDB Cookbook

MariaDB Cookbook

By : Daniel Bartholomew
4.2 (9)
close
MariaDB Cookbook

MariaDB Cookbook

4.2 (9)
By: Daniel Bartholomew

Overview of this book

Table of Contents (20 chapters)
close
MariaDB Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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

bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete