Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency

© Y V Ravi Kumar, Arun Kumar Samayam, Naresh Kumar Miryala 2024

Y. V. Ravi Kumar et al.Mastering MySQL Administrationhttps://doi.org/10.1007/979-8-8688-0252-2_11

11. MySQL Performance Tuning

Y V Ravi Kumar¹  , Arun Kumar Samayam² and Naresh Kumar Miryala³

(1)

Irving, TX, USA

(2)

Dallas, TX, USA

(3)

Tracy, CA, USA

 

Introduction

Performance is one of the key areas where organizations focus as this directly impacts end users of the systems.

Performance tuning starts with good system architecture design and data based on the application type and user expectations. Performance is directly associated with organizations’ revenue in highly transactional OLTP systems like shopping carts. System timeouts or bad user experience during checkout will lead to customers ...