Book Image

Mastering MariaDB

By : Federico Razzoli
Book Image

Mastering MariaDB

By: Federico Razzoli

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Mastering MariaDB
Federico Razzoli
Sep, 2014 | 384 pages
No titles found
Table of Contents (19 chapters)
Mastering MariaDB
Mastering MariaDB
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Understanding the Essentials of MariaDB
Understanding the Essentials of MariaDB
The MariaDB architecture
The command-line client
Storage engines
Logs
MariaDB caches
InnoDB data structures
Authentication and security
The information_schema database
The performance_schema database
Compatibility with MySQL and other DBMS
MariaDB resources
Summary
2
Debugging
Debugging
Understanding error conditions in MariaDB
The diagnostics area
The GET DIAGNOSTICS statement
The error log
System logs
The general query log
Maintenance of the server logs
The SQL_ERROR_LOG plugin
Tips on debugging stored programs
Debugging stored programs using the SQL_ERROR_LOG plugin
Summary
3
Optimizing Queries
Optimizing Queries
The slow query log
Explaining the pt-query-digest command from Percona Toolkit
Introducing indexes
Working with the EXPLAIN statement
Summary
4
Transactions and Locks
Transactions and Locks
The InnoDB locks
Reads consistency
Deadlocks
Transactions
Metadata locks
Summary
5
Users and Connections
Users and Connections
User accounts
Setting permissions using roles
Connecting MariaDB through Secure Socket Layer
Authentication plugins
Monitoring connections
Summary
6
Caches
Caches
InnoDB caches
MyISAM key cache
Aria page cache
The query cache explained
The table open cache
Per-session buffers
Summary
7
InnoDB Compressed Tables
InnoDB Compressed Tables
An overview of the InnoDB compression
InnoDB compression requirements
Explaining the file-per-table mode
Creating InnoDB compressed tables
Explaining the implementation of the InnoDB compression
Monitoring the InnoDB compression performance
Other compression solutions
Summary
8
Backup and Disaster Recovery
Backup and Disaster Recovery
Types of backups
Complete and incremental backups
Creating a dump file with mysqldump
Delimited text backups
Physical backups
Using the binary log for incremental backups
Percona XtraBackup
Securing backups
Repairing tables
Summary
9
Replication
Replication
An overview of replication
Choosing a binary log format
Configuring replication
Multisource replication
Replication logs
Checking the replication for errors
Troubleshooting
Summary
10
Table Partitioning
Table Partitioning
Support for partitioning
Partitioning types and expressions
Administering partitioned tables
Partitions' physical files
Query optimizations
Summary
11
Data Sharding
Data Sharding
Distributing files between multiple disks
The FEDERATEDX and CONNECT storage engines
The SPIDER storage engine
Summary
12
MariaDB Galera Cluster
MariaDB Galera Cluster
MariaDB Galera Cluster key concepts
Setting up a cluster
Starting the nodes
Configuring the cluster
Monitoring and troubleshooting
Load balancing
Listing the limitations of Galera Cluster
Galera Load Balancer
Summary
Index
Index

Chapter 2. Debugging

In this chapter, we will discuss the basic techniques that can be used to find problems in the MariaDB server and in SQL statements. The following are some of the basic tools and techniques used:

  • Error conditions

  • The diagnostics area

  • The error log

  • The general query log

  • Maintaining logs

  • The SQL_ERROR_LOG plugin

  • Debugging of stored programs

Previous Section
End of Section 1
Next Section