The pt-query-digest is my go-to tool in order to perform slow query analysis, improve query performance and thus overall MySQL performance. In this blog post, I’m going to highlight the…
The post How to filter MySQL slow queries using pt-query-digest first appeared on Change Is Inevitable.
We’re happy to introduce Audit Log Filter — our newly upgraded audit plugin. Its functionality has been significantly improved in comparison to Audit Log and currently mirrors the functionality of the MySQL Enterprise Audit plugin. Starting with Percona Server for MySQL 8.0.34-26, the Audit Log Filter is available in a technical preview mode. You’re welcome […]
Long-time Drupal developer Ryan Szrama shares a fantastic developer interview with the OpenLampTech newsletter readers
Code, content, and community for developers.
The LAMP stack and the PHP technologies and frameworks it runs.
Ryan Szrama is very active in Drupal development, developing plugins and specific commerce-first software using Drupal.
Consider subscribing to OpenLampTech to receive this content and more each week directly to your inbox.
Thank you for reading this post. Please share it with someone else who would enjoy it as well.
Disclaimer: The majority of examples in this post, are performed in a personal development/learning workstation environment and …
[Read more]Last post from the MySQL Content Advent Calendar 2023 - Season's Greetings from the MySQL Community Team.
In this article we will see how we can deploy WordPress and MySQL on OKE in OCI using the MySQL Operator for Kubernetes.
I could have set MySQL between parenthesis in the title as this article is more about how to use OpenTofu to deploy on OCI.
I will explain how to install OpenTofu and how to use it to deploy on OCI. I will also mention what are the required changes be able to use my previous Terraform deployment files.
As an example, let’s use the modules to deploy WordPress with MySQL HeatWave Database Service: oci-wordpress-mds.
Installing OpenTofu
If like me you are using a RPM based Linux distro, you can find the necessary information to create the yum repository on OpenTofu’s website:
$ sudo su -
# cat >/etc/yum.repos.d/opentofu.repo <<EOF
[opentofu]
name=opentofu …The concept of Agile software development is characterized by simplicity, collaboration, continuous delivery of working software, and sustainable development. With its new features, MySQL 8 makes using it as a database in the Agile software development process more suitable. In this post we will discuss how the relational MySQL database server is more Agile.
The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. In this blog post, I’ll dig into MySQL query optimization and show how MySQL uses indexes in cases of queries using sorting and limiting. While sorting may seem simple, it’s important to understand how to do it efficiently and effectively to ensure your queries are optimized and use better indexing.
Since sorting your rows is not free, it can take a significant amount of resources and time to sort large data sets; thus, it’s important to do it cautiously. If you don’t need your rows in a certain order, don’t order them.
However, if you need to order your rows, doing it efficiently and effectively is essential to optimize your queries. You must understand how to use indexes to make sorting cheaper.
Looking at this, can you say which is faster: LIMIT 1 or LIMIT 10? Presumably, fetching …
[Read more]Discover the Oracle ACE Program for MySQL and meet Matthias Jung.
The InnoDB buffer pool acts as a powerhouse for MySQL, caching frequently accessed data and index pages in memory to accelerate query performance. In this blog post, we will go through the process of InnoDB buffer pool resizing online, covering why it is important to monitor its progress and how to monitor it.Importance of monitoring […]