Packt+ | Advance your knowledge in tech

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

MySQL 8 Cookbook

You're reading from MySQL 8 Cookbook Over 150 recipes for high-performance database querying and administration

Product type Paperback

Published in Jan 2018

Publisher

ISBN-13 9781788395809

Length 446 pages

Edition 1st Edition

Tools

MySQL

Concepts

Database Administration

Author (1):

Karthik Appigatla

View More author details

Table of Contents (15) Chapters

Preface

1. MySQL 8 - Installing and Upgrading FREE CHAPTER

2. Using MySQL

3. Using MySQL (Advanced)

4. Configuring MySQL

5. Transactions

6. Binary Logging

7. Backups

8. Restoring Data

9. Replication

10. Table Maintenance

11. Managing Tablespace

12. Managing Logs

13. Performance Tuning

14. Security

Taking backups using mysqlpump

mysqlpump is a very similar program to mysqldump with some extra features.

How to do it...

There are numerous ways to do it. Let's have a look at each one in detail.

Parallel processing

You can speed up the process of dumping by specifying the number of threads (based on the number of CPUs). For example, use eight threads to take a full backup:

shell> mysqlpump --default-parallelism=8 > full_backup.sql

You can even specify the number of threads for each database. In our case, the employees database is very big compared to the company database. So you can spawn four threads to employees and two threads to the company database:

shell> mysqlpump -u root --password --parallel-schemas=4:employees --default-parallelism=2 > full_backup.sql
Dump progress: 0/6 tables, 250/331145 rows
Dump progress: 0/34 tables, 494484/3954504 rows
Dump progress: 0/42 tables, 1035414/3954504 rows
Dump progress: 0/45 tables, 1586055/3958016 rows
Dump progress: 0/45 tables, 2208364...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Karthik Appigatla

Karthik Appigatla

Karthik Appigatla is a highly reputed database architect and is very famous for performance tuning. He has been consulted by many companies all over the world for designing, performance tuning, building database infrastructure, and training. In his decade of experience, he has worked for companies such as Yahoo, Pythian, and Percona. Currently, he is working for LinkedIn, where he has innovated a new way of analyzing queries. He gave a talk about this at SRECon, Dublin in 2017.

See other products by Karthik Appigatla

Other recommended products

Related to this chapter

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 Administrator's Guide

MySQL 8 Administrator's Guide

MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial tasks that you will find useful in your day to day work as a database administrator. From optimizing queries for high performance to making your database secure and highly available, this book includes easy to understand, efficient MySQL administration techniques. By the end of this highly practical book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.

Feb 2018 17h 0m

MySQL 8 for Big Data

MySQL 8 for Big Data

MySQL is one of the most popular relational databases in the world today, and has become a popular choice of tool to handle vast amounts of structured data - that is, structured Big Data. This book will demonstrate how you can dabble with large amounts of data using MySQL 8. It also highlights topics such as integrating MySQL 8 and a Big Data solution like Apache Hadoop using different tools like Apache Sqoop and MySQL Applier. With practical examples and use-cases, you will get a better clarity on how you can leverage the offerings of MySQL 8 to build a robust Big Data solution.

Oct 2017 9h 52m

Advanced MySQL 8

Advanced MySQL 8

Businesses, right from small-sized to large giants are using MySQL to access and manipulate their enterprise database across the world. Advanced MySQL 8 will be your one-stop destination in how to implement and manage large-scale MySQL distributed clusters to run high-volume websites, enterprise systems, and packaged software.

Jan 2019 9h 32m

Personalised recommendations for you

Based on your interests and search pattern

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m

Modern Computer Vision with PyTorch

Modern Computer Vision with PyTorch

This book provides a hands-on approach to solving over 30 prominent real-world computer vision problems using PyTorch 2.x on actual datasets. Here you'll learn to build a neural network from scratch and optimize hyperparameters, perform image classification, multi-object detection, segmentation, and more. You'll also explore facial expression manipulation and combining CV with NLP and RL techniques, build generative AI applications, and take your model to production on AWS. By the end of this book, you'll master modern NN architectures and confidently solve real-world CV problems.

Jun 2024 24h 52m