This post is the eight one of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
Recently we published the first part (m5, m5a, m6g) and
the second part (C5, C5a, C6g) of research
regarding comparing Graviton ARM with AMD and Intel CPU on AWS.
We selected general-purpose EC2 instances with the same
configurations (amount of vCPU in the first part). In the second
part, we compared compute-optimized EC2 instances with the same
conditions. The main goal was to see the trend and make a general
comparison of CPU types on the AWS platform only for MySQL. We
didn’t set the goal to compare the performance of different CPU
types. Our expertise is in MySQL performance tuning. We share
research “as is” with all scripts, and anyone interested could
rerun and reproduce it.
All scripts, …
Guess what? OpenLampTech, the newsletter for PHP/MySQL developers, has a new issue full of great curated content for your reading experience this week. Come on by and read the publication!
Get tailored articles with Refind delivered each day in your inbox. Refind is part of my daily reading habit. Make it part of yours by using my referral link. At no additional cost to you, I will be eligible for a premium subscription with more sign-ups from my link. “The essence of the web, every morning in your inbox. Subscribe for free“
The Newsletter for PHP and MySQL Developers
This latest newsletter issue has a wide range of PHP/MySQL articles covering:
This post is the seventh post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
For my presentation for the next FOSDEM MySQL Devroom, I needed to create some load.
As usual, for this task, what better than sysbench ?
The “problem” was that my system was already setup and I used OL7 on the always free Ampere compute instance on OCI.
As you may know, this is an ARM architecture
(aarch64) and there was not sysbench
rpm package available for this OS and architecture.
I also wanted to have sysbench compiled and linked
with MySQL 8.0 libraries [1], [ …
Hello,
Due to a complete misunderstanding about the available slots, FOSDEM’s organization had to remove 2 talks from the previous planned agenda.
However, we didn’t want to announce to previously accepted speakers that their talks were cancelled ! Therefore, we decided, with FOSDEM’s approval, to extend the FOSDEM 2022 MySQL Devroom, opening our room on Saturday afternoon.
Two talks were then moved to Saturday and the two backup talks were immediately added to the schedule !
More work for us and our speakers but more pleasure for all the MySQL fans !
Don’t miss FOSDEM MySQL Devroom’s 2022 edition, free online conference.
Here is the new updated schedule (the official one …
[Read more]This post is the sixth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
I’m resharing a post I first published over on my Medium account for interested readers here. As you know, SQL is my passion and sweet spot. But, I also have an affinity for PHP and CodeIgniter. Continue reading and learn how I prototype Query Builder patterns in CodeIgniter 4…
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!
The Newsletter for PHP and MySQL Developers
CodeIgniter 4 Query Helper methods
I use the CodeIgniter 4 Query Helper, $db->getLastQuery() method a great deal to learn just how Query Builder methods are mapping to the actual SQL …
[Read more]This post is the fifth post of a series of articles on extending MySQL with the Component Infrastructure, the list above will be updated as new articles are published:
In April 2021, I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented.
Anyhow, in that article I have shown how an online DDL was de facto locking the whole cluster for a very long time even when using the consistency level set to EVENTUAL.
This article is to give justice to the work done by the MySQL/Oracle engineers to correct that annoying inconvenience.
Before going ahead, let us remember how an Online DDL was propagated in a group replication cluster, and identify the differences with what happens now, all with the consistency level set to EVENTUAL ( …
[Read more]