Book Image

Mastering The Faster Web with PHP, MySQL, and JavaScript

By : Andrew Caya
Book Image

Mastering The Faster Web with PHP, MySQL, and JavaScript

By: Andrew Caya

Overview of this book

This book will get you started with the latest benchmarking, profiling and monitoring tools for PHP, MySQL and JavaScript using Docker-based technologies. From optimizing PHP 7 code to learning asynchronous programming, from implementing Modern SQL solutions to discovering Functional JavaScript techniques, this book covers all the latest developments in Faster Web technologies. You will not only learn to determine the best optimization strategies, but also how to implement them. Along the way, you will learn how to profile your PHP scripts with Blackfire.io, monitor your Web applications, measure database performance, optimize SQL queries, explore Functional JavaScript, boost Web server performance in general and optimize applications when there is nothing left to optimize by going beyond performance. After reading this book, you will know how to boost the performance of any Web application and make it part of what has come to be known as the Faster Web.
Table of Contents (19 chapters)
Title Page
Copyright and Credits
Dedication
Packt Upsell
Foreword
Contributors
Preface
Free Chapter
1
Faster Web – Getting Started
6
Querying a Modern SQL Database Efficiently
Index

Chapter 5. Measuring and Optimizing Database Performance

In the first chapter of this book, we used the mysqlslap tool to learn how to do basic MySQL benchmarking. In this chapter, we will use this tool and others to do more advanced benchmarking with our MariaDB (MySQL) server. But, first, we will learn query optimization techniques that will use some of MySQL's built-in features in order to better analyze our SQL queries.

Thus, we will learn how to measure and optimize database performance through the use of simple measurement techniques such as query optimization. Also, we will see how to use advanced database benchmarking tools, such as DBT2 and SysBench.

Therefore, we will cover the following points:

  • Measuring and optimizing SQL query performance
  • Installing, configuring and using advanced database benchmarking tools