The financial services industry is facing a new regulation: the Digital Operational Resilience Act (DORA). One of the key requirements of DORA is that financial institutions must have a robust riskmanagement framework in place. This framework must identify, assess, and mitigate ICT risks. MySQL Enterprise Edition can help organizations achieve DORA compliance byproviding a number of features that can help to identify, assess, and mitigate ICT risks.
This blog shows how HeatWave MySQL delivers substantially more value than the MySQL cloud services offered by AWS, Google Cloud, and Azure. Furthermore, not only can you power your OLTP applications using HeatWave MySQL but you also get built-in lakehouse-scale analytics, generative AI, and machine learning at no additional cost
The 2024 JetBrains Developer Ecosystem Report reaffirms what millions of developers already know—MySQL is the #1 database. According to the report, "MySQL continues to be the most widely used database, favored by developers across various domains for its reliability and ease of use.
Advent Calendar Recap 2024
PCI DSS 4.0 Compliance and MySQL
The preFOSDEM MySQL Belgian Days 2025 will occur at the usual place (ICAB Incubator, Belgium, 1040 Bruxelles) on Thursday, January 30th, and Friday, January 31st, just before FOSDEM. Again this year, we will have the chance to have incredible sessions from our Community and the opportunity to meet some MySQL Engineers from Oracle. DimK will […]
This is the agenda of the preFOSDEM MySQL Belgian Days 2025, an Oracle MySQL technical event managed by the MySQL Community Team for customers, partners & community users.
This article will be helpful if you use the Percona Monitoring and Management (PMM) instance and alert notifications, as it is nice to capture the image of the graph when you receive the alert. We will see how to capture and attach the image of the graph when receiving the alert notification (email, telegram, Slack, […]
Here is part two of my MySQL with Diagrams series (Here’s part one – MySQL with Diagrams Part One: Replication Architecture). We are going to explore how MySQL handles thread termination using the KILL command, as visualized in the provided diagram, and provide sample demonstrations to help you better understand. Many people think they know […]
Did you ever need to determine the performance of a query over time? One of the problems with database query optimizations is that the underlying data is always churning. Add in an increase in the number of users, expanding server demand use, and other items that impact your query. What was optimized is no longer performing as expected.
MySQL added a JSON format option to the output of the EXPLAIN command quite a while ago. More recently, Oracle added the feature of saving the output into a variable (see https://dev.mysql.com/doc/refman/9.0/en/mysql-nutshell.html and https://dev.mysql.com/blog-archive/explain-into-and-explain-for-schema-in-mysql-81-and-82). This provides a way to access the data in that variable and plop it into a database. The saved result can be compared to current or other past responses for analysis.
mysql> explain format=json into @var
SELECT * from …