Tag: database performance

Feed: Planet PostgreSQL. For many developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.Disclaimer: it is okay to break the rules. Sometimes, you may choose to have slow database interactions, because you know they are rare events. Assuming a well-designed database infrastructure (which is what we launch at Crunchy Data), database performance is reactionary to the queries, reads, and writes sent ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Art Danielov. By Art Danielov, CEO and CTO – FlashGrid Oracle Database is at the heart of many mission-critical enterprise applications. Moving such applications to Amazon Web Services (AWS) offers multiple benefits, including agility, elasticity, and reliability. Teams responsible for moving Oracle Databases often have a legitimate concern, however—will they be able to achieve the same level of database performance they’re getting in their current on-premises environments? A poorly performing backend database makes the applications slow, no matter how much power or horizontal scaling the servers provide. Also, given the central role backed ... Read More

Feed: R-bloggers. Author: Posts on R-hub blog. [This article was first published on Posts on R-hub blog, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. SQLite is a great, full featured SQL database engine. Most likely it is used more than all other database engines combined. The RSQLite R package embeds SQLite, and lets you query and manipulate SQLite databases from R. It is used in Bioconductor data packages, many deployed Shiny apps, ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Point-In-Time Recovery (PITR) for MySQL databases is an important feature that is essential and covers common use cases, like a recovery to the latest possible transaction or roll-back the database to a specific date before some bad query was executed. Percona Kubernetes Operator for Percona XtraDB Cluster (PXC) added support for PITR in version 1.7, and in this blog post we are going to look into the technical details and decisions we made to implement this feature. Architecture Decisions Store Binary Logs on Object Storage MySQL uses binary logs to perform point-in-time recovery ... Read More

Feed: Planet PostgreSQL. Last week I was on a call with someone giving an overview of Crunchy Bridge, our multi-cloud fully managed database as a service. During the call they asked about what was the best way to get a sense of how their database was doing, a health check if you will. I mentioned a few monitoring tools such as pganalyze and pgMonitor that were good options, but that we could also dig in live and see how things were. The person I was talking to was very similar to many of the customers we run databases for - an ... Read More

Feed: Planet MySQL; Author: Tiago L. Alves; MySQL NDB Cluster is an open-source in-memory distributed database developed for high-availability (99.999% or more) and predictable query times. It can be found at the core of gaming, banking, telecommunication, and online services. Benchmarks [, ] have shown latencies in the order of 5–10 ms per transaction and throughput of 1.4M New Order TPM using a common 2-node configuration (each transaction consisting of 30 SQL statements — DBT2 benchmark).While the specific performance requirements of each customer might vary, from the product side it’s critical to ensure that performance is stable from version to ... Read More

Feed: Matillion. Author: Julie Polito;   Data is behind every decision we make. But if we’re going to make decisions about our businesses based on our data, we have to be able to trust that this data is accurate, reliable and trustworthy. How do we do this? By making sure we maintain proper data integrity practices. However, as data volumes continue to increase exponentially, maintaining data integrity becomes more difficult.   Data integrity involves making sure that your people, processes, and technology are all working together to ensure that your data is complete, reliable, searchable, and traceable. When proper data ... Read More

Feed: Redis Labs. Author: Ajeet Raina. With more than 46,000 GitHub stars, 18,000 forks, and 430 contributors, Redis is an incredibly popular open source project supported by a vibrant community.  But developers don’t just use Redis, they love it. Stack Overflow’s annual Developer Survey has ranked Redis as the Most Loved Database platform for four years running! Designed for the cloud-native world and created by the makers of open source Redis, Redis Enterprise maintains the simplicity and high performance of Redis while adding enterprise-grade performance, availability, scalability, and security capabilities across hybrid, multi-cloud, and global deployments. Given all that love ... Read More

Feed: Recent Announcements. Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time. RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights supports segmenting the performance data by database name. You can determine if a specific database is generating unusual high load, or is executing ... Read More

Feed: Recent Announcements. Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time.   RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights supports segmenting the performance data by additional dimensions, such as database name, application, and session type. You can determine if a specific ... Read More