Tag: Database Monitoring

Feed: Planet PostgreSQL. PostgreSQL-14 was released in September 2021, and it contained many performance improvements and feature enhancements, including some features from a monitoring perspective. As we know, monitoring is the key element of any database management system, and PostgreSQL keeps updating and enhancing the monitoring capabilities. Here are some key ones in PostgreSQL-14. Query Identifier Query identifier is used to identify the query, which can be cross-referenced between extensions. Prior to PostgreSQL-14, extensions used an algorithm to calculate the query_id. Usually, the same algorithm is used to calculate the query_id, but any extension can use its own algorithm. Now, ... Read More

Feed: Planet PostgreSQL. Every few months we get an alert from our database monitoring to warn us that we are about to run out of space. Usually we just provision more storage and forget about it, but this time we were under quarantine, and the system in question was under less load than usual. We thought this is a good opportunity to do some cleanups that would otherwise be much more challenging. To start from the end, we ended up freeing more than 70GB of un-optimized and un-utilized space without dropping a single index or deleting any data! Using conventional ... Read More

Feed: Recent Announcements. Now enterprises with Oracle databases can easily setup monitoring, alerting and dashboards for their EC2 and RDS Oracle instances on AWS with CloudWatch Application Insights. CloudWatch Application Insights is a capability that helps customers simply setup monitoring and enhanced observability for their enterprise applications running on AWS resources. The new feature automatically setups the metrics, telemetry and logs for monitoring the health and wellness of Oracle databases running in AWS.  With just a few clicks Application Insights provides customers with the peace of mind of knowing that their enterprise databases on SQL Server, MySQL, PostgreSQL and now ... Read More

Feed: Planet MySQL; Author: Severalnines; Database monitoring is a critical part of any application’s maintenance. Finding database issues on time can help the application remain healthy and accessible. Without monitoring in place, database outages can be prolonged, resulting in increased downtime for users. In this blog we are going to explain what you need to monitor in a Moodle Database, and how you can do it using ClusterControl. ClusterControl Monitoring  Using ClusterControl you can monitor the databases efficiently, it can do so by deploying agents on the database hosts or in an agentless fashion, by simply connecting to the databases ... Read More

Feed: Planet MySQL; Author: EverSQL; So you thought your database is in good shape, but suddenly your CPU usage spiked and reached 100% at 2AM. How would you go about tracking the root cause and fix it? 1. Locate the root cause If you are using CloudWatch or any infrastructure monitoring solution, you can start your investigation there.To understand what happened in your database, you should enable the slow query log feature on your database. This will capture all the slow log queries into a log, based on a threshold that you define.If you are not sure how to enable ... Read More

Feed: Planet PostgreSQL. Database monitoring is important in production. Effective database monitoring helps you to visualize database activities and detect errors. Pgpool-II Exporter can expose Pgpool-II and PostgreSQL cluster's metrics which can be collected by Prometheus. In this post, I will describe how to use Pgpool-II Exporter to monitor Pgpool-II and PostgreSQL cluster's statistics and visualize them with Prometheus and Grafana. What is Prometheus? Prometheus is a leading cloud-native monitoring solution. Prometheus collects application metrics from monitored targets which expose Prometheus-formatted metrics. Prometheus metrics exporter provides the endpoint to scrape. The most popular one is node_exporter which collects system metrics ... Read More

Feed: AWS Big Data Blog. Amazon Redshift is a fast, scalable, secure, and fully managed cloud data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL, and your existing ETL, Business Intelligence (BI), and reporting tools. Tens of thousands of customers use Amazon Redshift to process exabytes of data per day and power analytics workloads such as BI, predictive analytics, and real-time streaming analytics. As a data engineer or application developer, for some use cases, you want to interact with Amazon Redshift to load or query data with a simple API endpoint without having ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Oftentimes, we need to replicate between Amazon Aurora and an external MySQL server. The idea is to start by taking a point-in-time copy of the dataset. Next, we can configure MySQL replication to roll it forward and keep the data up-to-date.This process is documented by Amazon, however, it relies on the mysqldump method to create the initial copy of the data. If the dataset is in the high GB/TB range, this single-threaded method could take a very long time. Similarly, there are ways to improve the import phase (which can easily take 2x ... Read More

Feed: Clustrix Blog. Author: Shane Johnson. Database monitoring is an invaluable tool when you need to react to a problem. And root cause analysis helped by monitoring can avoid repeat issues. That’s great, but we’d all rather prevent problems than react to them. Monitoring doesn’t provide the depth and level of information you need to predict and prepare for the future. MariaDB SkySQL Workload Analysis does.MariaDB SkySQL Workload Analysis, currently in technical preview on SkySQL, inhales hundreds of metrics on your database, uses machine learning to build a model that characterizes your workloads, and let’s you clearly see patterns over ... Read More

Feed: Planet PostgreSQL. One of my colleagues at EDB spent some time working on a new extension for PostgreSQL and EDB Postgres Advanced Server as part of a proof of concept that I asked him to look into. I'm pleased to say that we've decided to make that work Open Source, releasing it under the PostgreSQL licence.The system_stats extension offers a number of stored procedures that are useful when monitoring Postgres. They expose various system metrics to the database server, allowing you to extend your database monitoring to include information about CPU, memory, disk and network usage without having to add a ... Read More