ProxySQL is a high-performance MySQL proxy with a small footprint that can be installed in multiple environments such as VM, K8s, bare-metal, and Docker containers. In this guide, you will install and set up load balancing of MySQL Cluster via ProxySQL on a Debian 11 server.

There are some scenarios where application do require to show datetime with regional time zone(let’s say application user wanted to show data in India IST time zone). By default MySQL database service(MDS) has UTC time zone and in order to change the system variable of time_zone you can’t do at this moment by SQL commands […]

This blog walk through an easy way to change global system variable time_zone using OCI dashboard

Learn how the parallel index rebuild feature in MySQL 8.0.31 improves performance by optimizing index and column additions. Explore the multithreaded insert phase, sort index build process, and system configurations for enhanced efficiency.

1. Understanding Sorted Index Build
   1. When does InnoDB use a sort index build approach?
2. Phases of Sort …

Node and MySQL are a go-to combination for a quick prototype build and in various cases for production build as well. In this tutorial, we will learn how to connect Node with MySQL and how to pool the connections for better performance and optimization of resources. You need Node and MySQL installed in your system before proceeding towards the tutorial. Click here to read a comprehensive guide on the installation and setup of Node.js. And if you want to know how to run and connect to a MySQL server, check out: NodeJS Create MySQL Connection. Node MySQL Connection To begin…

Updated June 1, 2023.

Suboptimal MySQL ORDER BY implementation, especially together with MySQL LIMIT is often the cause of MySQL performance problems. Here is what you need to know about MySQL ORDER BY LIMIT optimization to avoid these problems.

Try Now: Free your applications with Percona Distribution for MySQL

MySQL LIMIT clause

The MySQL LIMIT clause is a valuable tool for controlling the number of rows returned by a SELECT statement. By specifying the maximum number of rows to retrieve from the result set, it enables you to work with subsets of data, especially in situations involving large tables. This feature enhances query performance and optimizes resource usage by fetching only …

Our pleasure to inform you about the events and conferences where you can find MySQL Community or MySQL during June to August 2023. Please join us at any of them below! We are looking forward to meeting and talking to you at any of the conferences above!

List of shows 6-8/2023

This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS. The post includes instructions for installation using…

The post Install exact version of Percona Server for MySQL on CentOS first appeared on Change Is Inevitable.

A friend needed to analyze slow queries and for that he decides to use pt-query-digest tool. Though he got stuck at exporting slow queries from slow logs in RDS for…

The post MySQL Slow query log export and download in RDS first appeared on Change Is Inevitable.