A little bit ago, I released a blog post comparing the backup performance of different MySQL tools such as mysqldump, the MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. You can find the first analysis here:
[Read more]
Feb
28
2022
Feb
28
2022
Sit back, grab your beverage of choice, and get ready for a deep-dive issue of OpenLampTech, the newsletter for PHP/MySQL developers. This month’s featured piece covers select-like methods in the CodeIgniter 4 Query Builder class. Thanks for being here to read the publication
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
Take your time with this week’s issue of the OpenLampTech featured piece.
There is original and curated content …
[Read more]
Feb
27
2022
As of MySQL 8.0.18, EXPLAIN ANALYZE is an
indispensable tool for understanding query execution because it
breaks down the query execution stage of response time by
measuring each step of the query execution plan. The information
is illuminating, but the output is not intuitive: it requires
practice and some understanding of how MySQL executes queries
beyond the table join order shown by traditional
EXPLAIN output. This blog post closely examines
three different examples of EXPLAIN ANALYZE output.
Feb
27
2022
As of MySQL 8.0.18, EXPLAIN ANALYZE is an
indispensable tool for understanding query execution because it
breaks down the query execution stage of response time by
measuring each step of the query execution plan. The information
is illuminating, but the output is not intuitive: it requires
practice and some understanding of how MySQL executes queries
beyond the table join order shown by traditional
EXPLAIN output. This blog post closely examines
three different examples of EXPLAIN ANALYZE output.
Feb
27
2022
As of MySQL 8.0.18, EXPLAIN ANALYZE is an
indispensable tool for understanding query execution because it
breaks down the query execution stage of response time by
measuring each step of the query execution plan. The information
is illuminating, but the output is not intuitive: it requires
practice and some understanding of how MySQL executes queries
beyond the table join order shown by traditional
EXPLAIN output. This blog post closely examines
three different examples of EXPLAIN ANALYZE output.
Feb
23
2022
In this blog post, we will learn how to group sets of values into a comma-separated list, for each group, using the MySQL GROUP_CONCAT() function. Continue reading for more information…
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
…
[Read more]
Feb
23
2022
MySQL is a traditional open source relational database that goes well with many well-established applications. Find out more about its features and use cases.
Feb
22
2022
The Vitess maintainers are pleased to announce the general availability of Vitess 13. Major Themes # In this release, Vitess maintainers have made significant progress in several areas, including query serving and cluster management. Compatibility # This release comes with major compatibility improvements. We added support for a large number of character sets and improved our evaluation engine to perform more evaluations at the VTGate level. Gen4 planner is no longer experimental and we have used it to add support for a number of previously unsupported complex queries.
Feb
22
2022
The Vitess maintainers are pleased to announce the general availability of Vitess 13. Major Themes # In this release, Vitess maintainers have made significant progress in several areas, including query serving and cluster management. Compatibility # This release comes with major compatibility improvements. We added support for a large number of character sets and improved our evaluation engine to perform more evaluations at the VTGate level. Gen4 planner is no longer experimental and we have used it to add support for a number of previously unsupported complex queries.
Feb
21
2022
Rolling right along this week with another loaded issue of OpenLampTech, the newsletter for PHP/MySQL developers. Glad to have you here reading this week’s issue.
Do you need to learn MySQL? Just starting and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don’t know where to start. Learn more about the premium blog posts as I develop and release them.
[Read more]