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 MariaDB High Performance
  • Table Of Contents Toc
MariaDB High Performance

MariaDB High Performance

By : Pierre Mavro
4.3 (13)
Buy this Book
close
close
MariaDB High Performance

MariaDB High Performance

4.3 (13)
By: Pierre Mavro
Buy this Book

Overview of this book

This book is aimed at system administrators/architects or DBAs who want to learn more about how to grow their current infrastructure to support larger traffic. Before beginning with this book, we expect you to be well-practiced with MySQL/MariaDB for common usage. You will be able to get a grasp quickly if you are comfortable with learning and building large infrastructures for MariaDB using Linux.
Table of Contents (13 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. Performance Introduction
Icon
1. Performance Introduction
Icon
MariaDB history
Icon
Choosing the appropriate hardware
Icon
Architecture types and performances
Icon
BIOS power management optimization
Icon
Migrating from MySQL to MariaDB
Icon
Introduction to MariaDB engines
Icon
Summary
2
2. Performance Analysis
chevron up
Icon
2. Performance Analysis
Icon
Slow queries
Icon
The explain command
Icon
Slow query logs
Icon
The show explain command
Icon
Profiling
Icon
Performance schema
Icon
User statistics
Icon
Sysbench
Icon
Percona Toolkits
Icon
Process list progression
Icon
mytop
Icon
innotop
Icon
mysqlsla
Icon
Summary
3
3. Performance Optimizations
Icon
3. Performance Optimizations
Icon
Resetting statistics
Icon
Global statistics
Icon
DNS connections
Icon
Maximum connections
Icon
The binlogs cache
Icon
Temporary tables
Icon
Open tables
Icon
The query cache
Icon
Optimizing storage engines
Icon
Index
Icon
mysqltuner
Icon
Summary
4
4. MariaDB Replication
Icon
4. MariaDB Replication
Icon
How replication works
Icon
GTID replication
Icon
Migrating from classical to GTID replication
Icon
Parallel replication
Icon
Load balancing read transactions
Icon
Use cases and troubleshooting
Icon
Summary
5
5. WAN Slave Architectures
Icon
5. WAN Slave Architectures
Icon
Cascade slaves
Icon
Restricting replications
Icon
Designing slave in multiple continents
Icon
SSL replication
Icon
Compression options
Icon
Summary
6
6. Building a Dual Master Replication
Icon
6. Building a Dual Master Replication
Icon
Dual master replication and risks
Icon
Installing and configuring a dual master
Icon
Automatic management
Icon
How to repair a dual master replication
Icon
Summary
7
7. MariaDB Multimaster Slaves
Icon
7. MariaDB Multimaster Slaves
Icon
Multimaster slave replication
Icon
Summary
8
8. Galera Cluster – Multimaster Replication
Icon
8. Galera Cluster – Multimaster Replication
Icon
How Galera Cluster works
Icon
Galera Cluster limitations
Icon
The basics of installation and configuration
Icon
Usages and understandings
Icon
Designing redundant architectures
Icon
Tests and issues
Icon
Summary
9
9. Spider – Sharding Your Data
Icon
9. Spider – Sharding Your Data
Icon
Configuring Spider
Icon
Creating your first shard
Icon
Sharding replication
Icon
Performance tuning
Icon
Summary
10
10. Monitoring
Icon
10. Monitoring
Icon
Single instance
Icon
Replication
Icon
Galera Cluster
Icon
Other monitoring solutions
Icon
Summary
11
11. Backups
Icon
11. Backups
Icon
Using mysqldump
Icon
Using mysqlhotcopy
Icon
LVM
Icon
Xtrabackup
Icon
Galera backup
Icon
Summary
12
Index
Icon
Index

Sysbench

Sysbench is a benchmarking tool that has several modes to bench:

  • - fileio: This performs the file I/O test

  • - cpu: This performs the CPU performance test

  • - memory: This performs the memory functions speed test

  • - threads: This performs the thread subsystem performance test

  • - mutex: This performs the mutex performance test

  • - oltp: This performs the OLTP test

To install it, run this command:

> aptitude install sysbench

The common test is to use the Online Transaction Processing (OLTP) scenario with small transactions to hit an optimized database. We will pass arguments to the command to simulate application threads (the --num-threads argument).

You can run this OLTP test with two kinds of scenarios:

  • Read only (14 SELECT queries per transaction)

  • Read/Write (14 SELECT, 1 INSERT, 1 UPDATE, and 1 DELETE queries per transaction)

The available version in Debian Wheezy is 0.4. A newer version exists with more interesting results such as a reporting interval every x sec. In addition, you can...

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.
MariaDB High Performance
End of Section 2
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