Help Optimizing MySQL SQL Queries by Executing the MySQL Metadata Query: Lately, in PHP 93 Part 5
Get the best SQL query optimizations from the EverSQL tool using your MySQL database metadata.
1:27 Get the MySQL database metadata to help the EverSQL tool to optimize your SQL queries
2:08 Get a SQL query that will make MySQL output the database metadata
2:46 Save the MySQL database metadata SQL query to a local file
3:04 Execute the MySQL metadata SQL query
3:22 Upload the MySQL database metadata
The link to the podcast article is in this video's comments.
The EverSQL tool is excellent for suggesting optimizations for SQL queries for your applications that use MySQL.
That tool must first obtain the structure of your database tables to suggest good optimizations. You can get that structure by executing a SQL query that extracts the database metadata.
Watch this video of part 4 of episode 93 of the Lately in PHP podcast to learn how to extract your MySQL database metadata to help the EverSQL tool to optimize your application SQL queries for free.
Listen on Spotify: https://open.spotify.com/show/7nJyDle...
Music obtained with permission from: http://spoti.fi/NCS
Sound effects obtained with permission from: https://www.zapsplat.com/