All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Newsletters

Free Learning

You're reading from MySQL 8 Administrator???s Guide

Product type Book

Published in Feb 2018

Publisher Packt

ISBN-13 9781788395199

Pages 510 pages

Edition 1st Edition

Languages

SQL

Concepts

Database Administration

Authors (4):

Chintan Mehta

Ankit K Bhavsar

Hetal Oza

Subhash Shah

View More author details

Table of Contents (17) Chapters

Preface

1. An Introduction to MYSQL 8

2. Installing and Upgrading MySQL 8

3. MySQL 8 – Using Programs and Utilities

4. MySQL 8 Data Types

5. MySQL 8 Database Management

6. MySQL 8 Storage Engines

7. Indexing in MySQL 8

8. Replication in MySQL 8

9. Partitioning in MySQL 8

10. MySQL 8 – Scalability and High Availability

11. MySQL 8 – Security

12. Optimizing MySQL 8

13. Extending MySQL 8

14. MySQL 8 Best Practices and Benchmarking

15. Troubleshooting MySQL 8

16. Other Books You May Enjoy

Leave a review - let other readers know what you think

Optimizing tables

Database tables are the most basic building blocks for any database. In this section of the chapter, we will focus on optimizing tables. The section provides detailed guidelines for improving performance through table optimization techniques.

Optimization for InnoDB tables

The InnoDB storage engine is preferred in production environments in situations where reliability and concurrency are important. It is the default storage engine for MySQL tables. This section focuses on optimizing database operations for InnoDB tables.

The following are the guidelines to optimize InnoDB tables:

Use of the OPTIMIZE TABLE statement should be considered to reorganize the table and compact the wasted space once the data reaches...

The rest of the chapter is locked

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 $15.99/month. Cancel anytime}

Authors (4)

Chintan Mehta

Chintan Mehta is a co-founder of KNOWARTH Technologies and heads the cloud/RIMS/DevOps team. He has rich, progressive experience in server administration of Linux, AWS Cloud, DevOps, RIMS, and on open source technologies. He is also an AWS Certified Solutions Architect. Chintan has authored MySQL 8 for Big Data, Mastering Apache Solr 7.x, MySQL 8 Administrator's Guide, and Hadoop Backup and Recovery Solutions. Also, he has reviewed Liferay Portal Performance Best Practices and Building Serverless Web Applications.

See other products by Chintan Mehta

Ankit K Bhavsar

Ankit Bhavsar is a senior consultant leading a team working on ERP solutions at KNOWARTH Technologies. He received an MCA from North Gujarat university. He has had dynamic roles in the development and maintenance of ERP solutions and astrology portals Content Management that including OOP, technical architecture analysis, design, development as well as database design, development and enhancement process, data and object modeling, in order to provide technical and business solutions to clients.

See other products by Ankit K Bhavsar

Hetal Oza

Hetal Oza an MCA from a reputable institute of India, is working as a lead consultant at KNOWARTH Technologies. She has rich experience in Java-based systems with various databases. Her 10 years of experience covers all stages of software development. She has worked on development of web-based software solutions on various platforms. She has good exposure to integration projects with web-service-based and thread-based architecture. Her knowledge is not bound to any single field because she has worked on wide range of technologies and tools.

See other products by Hetal Oza

Subhash Shah

Subhash Shah is an experienced solution architect. With 14 years of experience in software development, he works as an independent technical consultant now. He is an advocate of open source development and its utilization in solving critical business problems. His interests include Microservices architecture, Enterprise solutions, Machine Learning, Integrations and Databases. He is an admirer of quality code and test-driven development (TDD). His technical skills include translating business requirements into scalable architecture and designing sustainable solutions. He is a co-author of Hands-On High Performance with Spring 5, Hands-On AI for Banking and MySQL 8 Administrator's Guide. He has also been a technical reviewer for other books.

See other products by Subhash Shah