The Releem Blog

In this guide, we’ll walk through the various types of MariaDB logs, where to find them, and how to make the most of the insights they hold. With the right strategies, you can turn your logs into a powerful tool for maintaining and optimizing your database.

Let’s explore the core elements of MySQL memory usage with best practices for trimming excess in demanding environments.

These checks can help you stay on top of any new or lingering problems before they snowball into bigger issues. You can dive deeper into these schema checks below and find out exactly how to fix any issues if your database doesn't pass.

In this article, we’ll explore why optimizing high-frequency queries that consume significant system resources (referred to as “top queries”) can often provide more substantial benefits than focusing solely on slow queries.

This writing will detail it out on how to safeguard your MySQL database as you go through the procedures as per the MySQL Workbench.

See what's new in Releem in June 2024. ✨ September’s was anything but ordinary for us at Reelem! We’ve been hard at work rolling out some awesome new features, we also took things to new heights – literally.

We’re excited to announce that Automatic SQL Query Optimization and Index Recommendations are now live for Releem Premium users running MySQL. MariaDB support is just around the corner.

Frequent MySQL database restarts can degrade system performance. Each restart resets MySQL’s caches and buffers, causing a temporary slowdown as data is reloaded. To troubleshoot this problem, try this steps.

Choosing the right MySQL monitoring tool can make a world of difference toward improving your database’s condition and efficiency. You want a tool that offers features to help you keep your database fast, secure, and reliable. In this article, we present 10 of the best MySQL monitoring tools for you to consider.

For anyone working with MySQL – from seasoned DBAs to developers just dipping their toes into MySQL for the first time – knowing which port your server is running on is a must. The port number is key for establishing database connections, configuring firewalls, and enabling communication between applications and the database.

In this guide, we'll cover practical tips to optimize MariaDB, like adjusting configuration settings, using effective indexing strategies, and monitoring performance metrics.

See what's new in Releem in June 2024. ✨ June was a monumental month for Releem, thanks to your incredible support and engagement.We launched on ProductHunt 🎉, securing: 4th place for the day, 5th place among developer tools for the week, 240 Upvotes.

This guide will show you simple ways to check the status of your MySQL server, whether it's running or stopped, and how to fix common problems.

When managing a MySQL database, understanding and troubleshooting issues often necessitate a detailed look at the queries running through the system. This is where the MySQL General Query Log comes into play. It provides an extensive record of all client connections and the queries they execute, making it a crucial tool for database administrators. In this article, we'll delve into what the MySQL General Query Log is, how to enable it, and how to effectively check its contents.

Dealing with MySQL memory allocation can be tricky, and that's where memory calculators come in handy. These tools help you figure out the best memory settings for your MySQL setup by taking into account your system's resources and how you use your database.

See what's new in Releem in May 2024. ✨ We've been hard at work here at Releem, cooking up some awesome improvements to make your MySQL experience smarter and more robust than ever.

MySQL Security checks can be leveraged to verify that your database adheres to top security standards. They offer a systematic approach to identifying potential vulnerabilities within your database settings, helping to fine-tune your database configuration to block unauthorized access and safeguard data integrity.

Whether it’s spotting them early, stopping them in their tracks, or setting up a way to handle them automatically, this guide has you covered.

See what's new in Releem in April 2024. ✨ Releem has grown into an intuitive, user-friendly tool that automatically spots performance hiccups in your database, suggests fixes, and even applies them for you.

Whether you’re running busy web applications, large data warehouses, or agile enterprise applications, the insights and guidelines shared here will help you optimize your database to run smoothly and efficiently!

In this article, we'll walk you through a series of SQL commands that allow you to check the size of databases, tables, and indexes directly using the MySQL command line interface. This guide is especially useful if you prefer working with SQL commands over graphical tools like MySQL Workbench or phpMyAdmin.

We are proud to announce the launch of the Query Analytics! This new feature helps you quickly identify slow queries and those that demand significant system resources.

Discover how to diagnose and reduce MySQL CPU usage with practical tips and tools. This guide covers the essentials for monitoring CPU performance, identifying common causes of high usage, and implementing effective strategies to optimize MySQL efficiency.

See what's new in Releem in February 2024. ✨ We're thrilled to share that, based on our recent survey, a majority of our customers have expressed immense satisfaction with Releem's capability for automatic detection of performance issues and offering actionable recommendations for improvement.

See what's new in Releem in January 2024. ✨ At Releem, our mission revolves around simplicity and efficacy. We're dedicated to offering you a tool that not only achieves outstanding results but does so with minimal complexity.

Releem utilized MySQL for storing all metrics. However, as our service grew, the sheer volume of metrics we needed to analyze and store presented a formidable challenge that led us to migrate from MySQL to ClickHouse. This article delves into the details of that migration.

See Releem results and Improvements in 2023 ✨ This year has been a testament to our dedication and expertise in enhancing database performance.

The article for engineers on how to Keep an Eye on MySQL with Health Checks

See what's new in Releem in November 2023. ✨ This month we’ve just rolled out a feature where Releem can zap configuration tasks straight to the Releem Agent. What this means for you: new configurations are just a click away, no more messing around with server connections or manual scripts.

See what's new in Releem in October 2023. ✨ Our dedication is paying off – in the past two months, we've witnessed a significant uptick in the popularity our services. Several hosting companies have integrated Releem on a large scale, adding hundreds of servers.

Navigating the intricacies of database performance can be challenging, but understanding key metrics like latency is crucial. As businesses increasingly rely on data-driven insights, ensuring that databases respond swiftly and efficiently becomes paramount.

See what's new in Releem in September 2023. ✨ Crafted with simplicity and efficiency in mind – Releem is built to enhance your database performance, regardless of its location – be it on a server or in the cloud.

See what's new in Releem in August 2023. ✨ In August, we ironed out bugs for a smoother experience, optimized our backend for greater stability, and updated our documentation for easier navigation.

See what's new in Releem in July 2023. ✨ We made a number of improvements and fixes in July that were suggested by our dedicated users.

This comprehensive guide walks through eight critical steps for effective MySQL tuning that can help improve MySQL performance.

See what's new in Releem in June 2023. ✨ We're thrilled to introduce new enhancements to the Releem platform for June.

See what's new in Releem in May 2023. ✨ We're excited to unveil this month's Releem product updates, packed with enhancements and features designed to make your experience even more seamless and enjoyable.

See what's new in Releem in March 2023. ✨ We're excited to unveil this month's Releem product updates, packed with enhancements and features designed to make your experience even more seamless and enjoyable.

Our latest product update for February is packed with exciting new features to make managing your MySQL database easier than ever.

We are thrilled to announce the January 2023 product updates for Releem. Our team has been hard at work to bring you the latest and greatest features to help optimize your servers.

Research on how MySQL tuning positively affects the performance of popular open-source web applications: Drupal, Laravel, WordPress

2022 Recap! The year 2022 has been a significant turning point for Releem. We developed a user-friendly tool for monitoring and optimizing MySQL performance, starting with a basic bash script and evolving into the advanced tool that it is today.

This month we’ve made significant changes to Releem Customer Portal and received a lot of positive feedback from customers.

This month we redesigned key parts of Releem. We started with the Releem Customer Portal landing page and ‘Add server’ page before moving on to completely rebuild Releem Agent in the Go programming language.

For the month of September, we focused on adding support for the queries per second or QPS metric. We needed to make various changes to Releem Agent, Cloud Platform, and Customer Portal to make this a reality.

See what's new in Releem in August 2022. ✨ For the month of August, we’re most excited to announce our new one-step command for applying configuration recommendations.

See what's new in Releem in July 2022. ✨ We added support for FreeBSD and have already moved to support the newest MySQL 8.0.30 update released on July 26th, 2022. 

See what's new in Releem and what we're gradually rolling out and how we improved the Performance of Releem in June 2022. ✨

See what's new in Releem and what we're gradually rolling out in May 2022. ✨

See what's new in Releem and what we're gradually rolling out in April 2022. ✨

See what's new in Releem and what we're gradually rolling out in March 2022. ✨

See what's new in Releem and what we're gradually rolling out in February 2022. ✨

See what's new in Releem and what we're gradually rolling out in January 2022. ✨

See what's new in Releem and what we're gradually rolling out in October. ✨

See what's new in Releem and what we're gradually rolling out. ✨

We conducted a survey of several hundreds software engineers who have experience in manage servers with installed MySQL / MariaDB / Percona

Research on how MySQL tuning positively affects the performance of popular open-source web applications

What do Database Administrators do and are they necessary?

In this article, we benchmark the performance of MySQL 5.7 default configuration against the configuration recommended by Releem.