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.

Related Content you might be interested in

Current Title:

Small book image
Mastering The Faster Web with PHP, MySQL, and JavaScript
Andrew Caya
Jun, 2018 | 278 pages
No titles found
Table of Contents (19 chapters)
Title Page
Title Page
Copyright and Credits
Copyright and Credits
Dedication
Dedication
Packt Upsell
Packt Upsell
Foreword
Foreword
Contributors
Contributors
Preface
Preface
Free Chapter
1
Faster Web – Getting Started
Faster Web – Getting Started
What is the Faster Web?
Summary
References
2
Continuous Profiling and Monitoring
Continuous Profiling and Monitoring
What is Blackfire.io?
Performance testing with Blackfire.io
Monitoring performance with the TICK Stack
Summary
References
3
Harnessing the Power of PHP 7 Data Structures and Functions
Harnessing the Power of PHP 7 Data Structures and Functions
PHP 7 optimizations
Identifying more possible optimizations
Functional programming and memoization
Summary
Reference
4
Envisioning the Future with Asynchronous PHP
Envisioning the Future with Asynchronous PHP
Asynchronous non-blocking I/O calls
Multithreading with pthreads
Using the ReactPHP library
Summary
5
Measuring and Optimizing Database Performance
Measuring and Optimizing Database Performance
SQL query performance
Advanced benchmarking tools
Summary
6
Querying a Modern SQL Database Efficiently
Querying a Modern SQL Database Efficiently
Modern SQL
Summary
7
JavaScript and Danger-Driven Development
JavaScript and Danger-Driven Development
The global object and local variables
Avoiding bad idioms and keeping an eye on the very bad parts
Using the DOM efficiently
Structuring and loading a JavaScript application
Summary
8
Functional JavaScript
Functional JavaScript
Simplifying functions
Functional programming techniques
More upcoming JavaScript features
Summary
9
Boosting a Web Server's Performance
Boosting a Web Server's Performance
MOD_SPDY and HTTP/2
PHP-FPM and OPCache
ESI and Varnish Cache
Client-side caching
Other Faster Web tools
Summary
References
10
Going Beyond Performance
Going Beyond Performance
Clocked and perceived time
Speed perception
Reasonable delay and response times
UI design principles and patterns
"Beyond Performance" tools
Summary
References
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think
Index
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
Previous Section
End of Section 1
Next Section