Elasticsearch performance optimization
Performance optimization, or "performance tuning," is an ongoing process, not a one-time task. After making changes and testing them, continuous monitoring is essential to determine if further adjustments are necessary. This applies to Elasticsearch and...
How to Measure Database Performance
Running production environments, you may be wondering how your database is performing? Does it deliver a proper level of performance? How can we measure it? Database performance is a very vast topic, but we would...
Connection Management in PostgreSQL: A Guide
Performance is always important in any system. You will need to make good use of the available resources to ensure the best response time possible and there are different ways to do this. Every connection...
Live Webinar: Tips to Drive MariaDB Galera Cluster Performance for Nextcloud
Join us for this webinar on Tips to Drive MariaDB Galera Cluster Performance for Nextcloud. The webinar features Björn Schiessle, Co-Founder and Pre-sales lead at Nextcloud, and Ashraf Sharif, senior support engineer at Severalnines. They...
How to manage large databases effectively
One of the biggest concerns when managing a database is the size and complexity of its data. As the size of the database increases, you need to have a plan in place for how to...
Challenges of Scaling the Moodle MySQL Database
Moodle, an open source Learning Management System, became more and more popular in last year as the pandemic forced hard lockdowns and majority of the education activities have moved from schools, colleges and universities to...
Performance Testing Using MySQLdump and the MySQL Shell Utility
In my previous post I explained how to take a logical backup using the mysql shell utilities. In this post, we shall compare the speed of the backup and restoration process. MySQL Shell Speed Test ...
pgDash Diagnostics Alternatives – PostgreSQL Query Management with ClusterControl
Databases are all about queries. You store your data in them and then you have to be able to retrieve it in some way. Here come queries - you write them in some language, structured...
Dealing with Slow Queries in MongoDB
When in production, an application should provide a timely response to the user for the purpose of improving user interaction with your application. At times, however, database queries may start to lag hence taking a...
How Performant is Your ProxySQL Node?
ProxySQL has gained a lot of interest right now in the MySQL and MariaDB database world, not to mention ClickHouse which helps make the case for ProxySQL. It’s safe to say that ProxySQL has become...
How High CPU Utilization Effects Database Performance
One of the indicators to see if our database is experiencing performance issues is by looking at the CPU utilization. High CPU usage is directly proportional to disk I/O (where data is either read or...
What to Look for if Your PostgreSQL Replication is Lagging
PostgreSQL is designed to handle multiple threads, such as query parallelism, or deploying worker threads to handle specific tasks based on the assigned values in the configuration. But, sometimes replication lag and other issues can...