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.
Dec
22
2023
Dec
21
2023
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]
Dec
21
2023
MySQL NDB Cluster is a distributed database that makes it possible to have more than two hundred MySQL servers operating on the same data, forming a scalable and high-performing cluster where data can be read and written by a large number of clients at the same time. Using the standard MySQL replication mechanism, data can […]
Dec
21
2023
Discover the Oracle ACE Program for MySQL and meet Matthias Jung.
Dec
20
2023
Key Takeaways 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 […]
Dec
20
2023
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 […]
Dec
20
2023
In MySQL, you cannot do this: create table t (i int primary key, j int); insert into t values (1, 1); update t set j = (select max(j) from t) + 1; The UPDATE statement will raise an error as follows: SQL Error [1093] [HY000]: You can't specify target table 't' for update in FROM … Continue reading Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error →
Dec
20
2023
Web developer Joni Halabi shares a fantastic developer interview with the OpenLampTech newsletter readers and community.
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.
Welcome to this OpenLampTech text-based developer interview.
Web and WordPress developer Joni Halabi has been working with the web’s most used and popular CMS for several years.
Joni is also very knowledgeable about Gutenberg, focusing much of her development on writing custom blocks for the post editor.
Needless to say, I am very excited Joni participated in this …
[Read more]
Dec
20
2023
Dear MySQL Community, As the year comes to a close, we wanted to take a moment to extend our warmest season’s greetings and best wishes to all of you. It has been a remarkable journey working together with such a vibrant and diverse community, and we are grateful for your continuous support and inspiration. As […]
Dec
20
2023
We are approaching the conclusion of our MySQL Content Advent Calendar 2023. Today, we bring you an immensely popular article that was published earlier this autumn. The article delves into a highly trending subject: the utilization of Kubernetes for running MySQL. Let’s see how to deploy WordPress and MySQL on a Kubernetes Cluster. The Kubernets […]