Packt+ | Advance your knowledge in tech

You're reading from Mastering MariaDB Debug, secure, and back up your data for optimum server performance with MariaDB

Product type Paperback

Published in Sep 2014

Publisher

ISBN-13 9781783981540

Length 384 pages

Edition 1st Edition

Tools

MariaDB

Concepts

Database Administration

Author (1):

Federico Razzoli

View More author details

Table of Contents (14) Chapters

Preface

What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support

1. Understanding the Essentials of MariaDB FREE CHAPTER

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

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

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

The InnoDB locks
Reads consistency
Deadlocks
Transactions
Metadata locks
Summary

5. Users and Connections

User accounts
Setting permissions using roles
Connecting MariaDB through Secure Socket Layer
Authentication plugins
Monitoring connections
Summary

6. 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

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

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

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

Support for partitioning
Partitioning types and expressions
Administering partitioned tables
Partitions' physical files
Query optimizations
Summary

11. 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 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

InnoDB compression requirements

To use the InnoDB compressed tables, at least two requirements must be met:

Each compressed table must be stored in a separate file
The Barracuda file format must be used

Let's discuss how to satisfy these requirements and what they imply.

The rest of the chapter is locked

You're reading from Mastering MariaDB Debug, secure, and back up your data for optimum server performance with MariaDB

Table of Contents (14) Chapters

InnoDB compression requirements

Authors (1)

Personalised recommendations for you

You're reading from Mastering MariaDB Debug, secure, and back up your data for optimum server performance with MariaDB

Table of Contents (14) Chapters

InnoDB compression requirements

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you