Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering MariaDB
  • Table Of Contents Toc
Mastering MariaDB

Mastering MariaDB

By : Razzoli
3.8 (10)
Buy this Book
close
close
Mastering MariaDB

Mastering MariaDB

3.8 (10)
By: Razzoli
Buy this Book

Overview of this book

This book is intended for intermediate users who want to learn how to administrate a MariaDB server or a set of servers. It is aimed at MariaDB users, and hence working knowledge of MariaDB is a prerequisite.
Table of Contents (14 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Understanding the Essentials of MariaDB
Icon
1. Understanding the Essentials of MariaDB
Icon
The MariaDB architecture
Icon
The command-line client
Icon
Storage engines
Icon
Logs
Icon
MariaDB caches
Icon
InnoDB data structures
Icon
Authentication and security
Icon
The information_schema database
Icon
The performance_schema database
Icon
Compatibility with MySQL and other DBMS
Icon
MariaDB resources
Icon
Summary
2
2. Debugging
Icon
2. Debugging
Icon
Understanding error conditions in MariaDB
Icon
The diagnostics area
Icon
The GET DIAGNOSTICS statement
Icon
The error log
Icon
System logs
Icon
The general query log
Icon
Maintenance of the server logs
Icon
The SQL_ERROR_LOG plugin
Icon
Tips on debugging stored programs
Icon
Debugging stored programs using the SQL_ERROR_LOG plugin
Icon
Summary
3
3. Optimizing Queries
Icon
3. Optimizing Queries
Icon
The slow query log
Icon
Explaining the pt-query-digest command from Percona Toolkit
Icon
Introducing indexes
Icon
Working with the EXPLAIN statement
Icon
Summary
4
4. Transactions and Locks
Icon
4. Transactions and Locks
Icon
The InnoDB locks
Icon
Reads consistency
Icon
Deadlocks
Icon
Transactions
Icon
Metadata locks
Icon
Summary
5
5. Users and Connections
Icon
5. Users and Connections
Icon
User accounts
Icon
Setting permissions using roles
Icon
Connecting MariaDB through Secure Socket Layer
Icon
Authentication plugins
Icon
Monitoring connections
Icon
Summary
6
6. Caches
chevron up
Icon
6. Caches
Icon
InnoDB caches
Icon
MyISAM key cache
Icon
Aria page cache
Icon
The query cache explained
Icon
The table open cache
Icon
Per-session buffers
Icon
Summary
7
7. InnoDB Compressed Tables
Icon
7. InnoDB Compressed Tables
Icon
An overview of the InnoDB compression
Icon
InnoDB compression requirements
Icon
Explaining the file-per-table mode
Icon
Creating InnoDB compressed tables
Icon
Explaining the implementation of the InnoDB compression
Icon
Monitoring the InnoDB compression performance
Icon
Other compression solutions
Icon
Summary
8
8. Backup and Disaster Recovery
Icon
8. Backup and Disaster Recovery
Icon
Types of backups
Icon
Complete and incremental backups
Icon
Creating a dump file with mysqldump
Icon
Delimited text backups
Icon
Physical backups
Icon
Using the binary log for incremental backups
Icon
Percona XtraBackup
Icon
Securing backups
Icon
Repairing tables
Icon
Summary
9
9. Replication
Icon
9. Replication
Icon
An overview of replication
Icon
Choosing a binary log format
Icon
Configuring replication
Icon
Multisource replication
Icon
Replication logs
Icon
Checking the replication for errors
Icon
Troubleshooting
Icon
Summary
10
10. Table Partitioning
Icon
10. Table Partitioning
Icon
Support for partitioning
Icon
Partitioning types and expressions
Icon
Administering partitioned tables
Icon
Partitions' physical files
Icon
Query optimizations
Icon
Summary
11
11. Data Sharding
Icon
11. Data Sharding
Icon
Distributing files between multiple disks
Icon
The FEDERATEDX and CONNECT storage engines
Icon
The SPIDER storage engine
Icon
Summary
12
12. MariaDB Galera Cluster
Icon
12. MariaDB Galera Cluster
Icon
MariaDB Galera Cluster key concepts
Icon
Setting up a cluster
Icon
Starting the nodes
Icon
Configuring the cluster
Icon
Monitoring and troubleshooting
Icon
Load balancing
Icon
Listing the limitations of Galera Cluster
Icon
Galera Load Balancer
Icon
Summary
13
Index
Icon
Index

Chapter 6. Caches

Table data and indexes are normally written on mass memories, such as disks, SSDs, or flash memories. However, accessing these media is a slow process; if the server has to do it too often, the input or output is probably the bottleneck. To avoid accessing disks, MariaDB and storage engines have several caches that a DBA should know about. The following topics will be covered in this chapter:

  • The InnoDB buffer pool and doublewrite buffer
  • The MyISAM key cache
  • The Aria page cache
  • The query and subquery cache
  • The table open cache
  • The main per-session buffers

Note

Before beginning our discussion on the caches, a warning is needed. Many authoritative resources, such as the MariaDB Knowledge Base or the MySQL manual, suggest dedicating a huge amount of memory to the InnoDB buffer pool or to the default storage engine's main cache if most tables are not InnoDB tables. Many articles suggest dedicating about 70 percent or even 80 percent of the memory to the buffer pool...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering MariaDB
End of Section 6
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon