1114. How to Use Simple MySQL Monitoring Tools for Free to Find the Slowest Queries that You Should Optimize First - 2 minutes - Lately in PHP Podcast Episode 93 Part 3
Updated on: 2022-10-25
Posted on: 2022-10-25
When you want to optimize the performance of a MySQL-based application, you should try to optimize first the slowest queries that affect the application's performance.
The MySQL slow query log file provides a list of slow queries as they happen. So you need to monitor that file to determine the most critical slow SQL queries you need to optimize first.
Read this article, watch a 2-minute video, or listen to part 3 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to monitor the MySQL slow query log and find the slowest SQL queries.
More ... Post a comment See comments (0) Trackbacks (0)
The MySQL slow query log file provides a list of slow queries as they happen. So you need to monitor that file to determine the most critical slow SQL queries you need to optimize first.
Read this article, watch a 2-minute video, or listen to part 3 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to monitor the MySQL slow query log and find the slowest SQL queries.
More ... Post a comment See comments (0) Trackbacks (0)
1112. How to Find MySQL Slow Queries in a Production Server by Activating the Slow Query Log - 2 minutes - Lately in PHP Podcast Episode 93 Part 2
Updated on: 2022-10-19
Posted on: 2022-10-19
When you want to optimize a MySQL database application in production, you should figure out the slowest queries in that environment.
Enabling the MySQL slow query log can help you figure out the slowest SQL queries to optimize first. You can do that in a production environment, but you need to take extra care with how you enable the slow query log to avoid causing harm to the application.
Read this article, watch a 2-minute video, or listen to part 2 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log in a production environment in a safe way.
More ... Post a comment See comments (0) Trackbacks (0)
Enabling the MySQL slow query log can help you figure out the slowest SQL queries to optimize first. You can do that in a production environment, but you need to take extra care with how you enable the slow query log to avoid causing harm to the application.
Read this article, watch a 2-minute video, or listen to part 2 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log in a production environment in a safe way.
More ... Post a comment See comments (0) Trackbacks (0)
1111. Find MySQL Slow Queries by Activating the Slow Query Log - 7 minutes - Lately in PHP Podcast Episode 93 Part 1
Updated on: 2022-10-13
Posted on: 2022-10-13
One of the factors that may make a Web application slow is the speed of execution of database queries executed by the application back-end code.
If you optimize the database queries that are the slowest, it may make a lot of impact on the speed of an application.
The first step in optimizing the slowest database queries is to find which are the slowest queries. Using MySQL as the database server, you can find the slowest queries by activating the slow query log.
Read this article, watch a 7-minute video, or listen to part 1 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log.
More ... Post a comment See comments (4) Trackbacks (0)
If you optimize the database queries that are the slowest, it may make a lot of impact on the speed of an application.
The first step in optimizing the slowest database queries is to find which are the slowest queries. Using MySQL as the database server, you can find the slowest queries by activating the slow query log.
Read this article, watch a 7-minute video, or listen to part 1 of episode 93 of the Lately in PHP podcast to learn how to enable the MySQL slow query log.
More ... Post a comment See comments (4) Trackbacks (0)
1107. How to Discover What PHP Code You Should Optimize First to Improve the Performance of a Real Web Application Using a Monitoring Tool
Updated on: 2022-08-19
Posted on: 2022-08-16
A profiling tool can be handy to find the parts of your application code that are slow and that you need to optimize.
If there are many parts of your application that you need to optimize, the next decision is which parts you should work to optimize first.
Fortunately, some profiling tools can help you figure out which parts of your application you need to optimize first.
Please read this short article to learn how to use the Scout Application Performance Monitoring tool to determine which parts of a Laravel or Symfony application you should optimize to achieve the most significant performance improvements sooner.
More ... Post a comment See comments (2) Trackbacks (0)
If there are many parts of your application that you need to optimize, the next decision is which parts you should work to optimize first.
Fortunately, some profiling tools can help you figure out which parts of your application you need to optimize first.
Please read this short article to learn how to use the Scout Application Performance Monitoring tool to determine which parts of a Laravel or Symfony application you should optimize to achieve the most significant performance improvements sooner.
More ... Post a comment See comments (2) Trackbacks (0)
1104. How to Update PHP Version Using Methods and Tools the PHP Community Uses - 3 minutes - Lately in PHP Podcast Episode 92 Part 10
Updated on: 2022-10-12
Posted on: 2022-07-28
Every time you need to solve a problem, you may realize there may be several approaches to solve that problem. Each way has its advantages and disadvantages.
This fact shows why it is helpful to learn from other developers what approach they use to solve a problem that you also want to solve.
Read this article, watch a 3-minute video, or listen to part 10 of episode 92 of the Lately in PHP podcast to learn about other methods and tools different developers use to upgrade PHP versions.
More ... Post a comment See comments (0) Trackbacks (0)
This fact shows why it is helpful to learn from other developers what approach they use to solve a problem that you also want to solve.
Read this article, watch a 3-minute video, or listen to part 10 of episode 92 of the Lately in PHP podcast to learn about other methods and tools different developers use to upgrade PHP versions.
More ... Post a comment See comments (0) Trackbacks (0)
1102. How to Use a PHP Monitoring System with Email Notification to Verify a Version Upgrade - 3 minutes - Lately in PHP Podcast Episode 92 Part 9
Updated on: 2022-07-28
Posted on: 2022-07-12
When you make changes to a site or another aspect of your site production environment, there is always a chance that some parts may not work well after you complete the changes due to unexpected consequences.
Often these consequences cause your site's PHP code to trigger errors. These errors may start appearing after you do a PHP version upgrade.
One way to determine if there were errors after you made production environment changes is to monitor PHP errors and send emails for the new PHP errors that started to appear.
Read this article, watch a 3-minute video, or listen to part 9 of episode 92 of the Lately in PHP podcast to learn how to monitor your PHP errors quickly and be notified by email, so you can fix the environment that causes the errors.
More ... Post a comment See comments (0) Trackbacks (0)
Often these consequences cause your site's PHP code to trigger errors. These errors may start appearing after you do a PHP version upgrade.
One way to determine if there were errors after you made production environment changes is to monitor PHP errors and send emails for the new PHP errors that started to appear.
Read this article, watch a 3-minute video, or listen to part 9 of episode 92 of the Lately in PHP podcast to learn how to monitor your PHP errors quickly and be notified by email, so you can fix the environment that causes the errors.
More ... Post a comment See comments (0) Trackbacks (0)
1100. How to Verify If a PHP Version Upgrade Really Succeeded - 2 minutes - Lately in PHP Podcast Episode 92 Part 8
Updated on: 2022-07-05
Posted on: 2022-06-30
Having tests to verify if a PHP version upgrade succeeded is excellent, but unfortunately, that is not enough because there are always aspects of the consequences of the version upgrade that we are not fully aware of initially.
So it is expected that some fixes may be necessary after a PHP version upgrade. Still, you may not even be aware of all the fixes you may need to do after the upgrade.
This situation is where other human beings can help you complete the quality control of the PHP version upgrade process.
Read this article, watch a 2-minute video, or listen to part 8 of episode 92 of the Lately in PHP podcast to learn how you can use the help of other human beings to assure the control of the quality of your applications after a PHP version upgrade.
More ... Post a comment See comments (0) Trackbacks (0)
So it is expected that some fixes may be necessary after a PHP version upgrade. Still, you may not even be aware of all the fixes you may need to do after the upgrade.
This situation is where other human beings can help you complete the quality control of the PHP version upgrade process.
Read this article, watch a 2-minute video, or listen to part 8 of episode 92 of the Lately in PHP podcast to learn how you can use the help of other human beings to assure the control of the quality of your applications after a PHP version upgrade.
More ... Post a comment See comments (0) Trackbacks (0)
1099. The Right Order to Execute the Steps to Upgrade to a New PHP Version - 2 minutes - Lately in PHP Podcast Episode 92 Part 7
Updated on: 2022-06-24
Posted on: 2022-06-24
One of the reasons why certain version upgrades went wrong is that you do the version upgrade process steps in the incorrect order.
You can determine the correct order by the more critical steps you need to do first because you can only do the following steps when you complete the crucial steps.
Read this article, watch a 2-minute video, or listen to part 7 of episode 92 of the Lately in PHP podcast to learn the correct order of the steps to perform a PHP version upgrade.
More ... Post a comment See comments (0) Trackbacks (0)
You can determine the correct order by the more critical steps you need to do first because you can only do the following steps when you complete the crucial steps.
Read this article, watch a 2-minute video, or listen to part 7 of episode 92 of the Lately in PHP podcast to learn the correct order of the steps to perform a PHP version upgrade.
More ... Post a comment See comments (0) Trackbacks (0)
1095. How to Test Your Application Features in Practice During a PHP Version Upgrade - 4 minutes - Lately in PHP Podcast Episode 92 Part 6
Updated on: 2022-06-07
Posted on: 2022-05-30
After you have planned all the steps of a PHP version upgrade process, it is time to execute the planned steps.
Read this article, watch a 4-minute video, or listen to part 6 of episode 92 of the Lately in PHP podcast to learn how to test your application features in practice during a PHP version upgrade using reliable testing tools.
More ... Post a comment See comments (0) Trackbacks (0)
Read this article, watch a 4-minute video, or listen to part 6 of episode 92 of the Lately in PHP podcast to learn how to test your application features in practice during a PHP version upgrade using reliable testing tools.
More ... Post a comment See comments (0) Trackbacks (0)
1094. What Are Your App Features to Test First Before a PHP Version Upgrade - 3 minutes - Lately in PHP Podcast Episode 92 Part 5
Updated on: 2022-05-20
Posted on: 2022-05-20
Testing a PHP application may require that you test a lot of features. Therefore you need to define the order of the features that you will test.
First, you need to define the most critical features of your PHP application to verify if they are working as expected early on in the testing process.
Read this article, watch a 3-minute video, or listen to part 5 of episode 92 of the Lately in PHP podcast to learn how to determine which are the most critical features you should test first during a PHP version upgrade testing process.
More ... Post a comment See comments (0) Trackbacks (0)
First, you need to define the most critical features of your PHP application to verify if they are working as expected early on in the testing process.
Read this article, watch a 3-minute video, or listen to part 5 of episode 92 of the Lately in PHP podcast to learn how to determine which are the most critical features you should test first during a PHP version upgrade testing process.
More ... Post a comment See comments (0) Trackbacks (0)