Scalegrid

MARCH 28, 2024

In this comparison of Redis vs Memcached, we strip away the complexity, focusing on each in-memory data store’s performance, scalability, and unique features. Redis is better suited for complex data models, and Memcached is better suited for high-throughput, string-based caching scenarios.

Cache 130

Cache Storage Scalability Architecture 130

Percona

DECEMBER 11, 2023

Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables.

AWS 103

AWS Benchmarking Performance Traffic 103

Scalegrid

OCTOBER 24, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. As organizations continue to migrate to the cloud, it’s important to get in front of performance issues, such as high latency, low throughput, and replication lag with higher distances between your users and cloud infrastructure.

AWS 183

AWS Latency Performance Benchmarking 183

Scalegrid

JULY 29, 2020

PgBouncer defines one pool per user+database combination. A client benefits from a pooled connection only if it connects to a child which has previously served a connection for this database+user combination. PgBouncer allows limiting connections per-pool, per-database, per-user or per-client. Throughput Benchmark.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

The Morning Paper

SEPTEMBER 3, 2019

SLOG: serializable, low-latency, geo-replicated transactions Ren et al., That’s where SLOG (Serializable LOw-latency, Geo-replicated transactions) comes in. If every read of a data item is served from the location of the most recent write to that data item, then there is no need to synchronously replicate writes across regions.

Latency 70

Latency Processing Benchmarking Systems 70

Scalegrid

NOVEMBER 26, 2020

In fact, it is the number one key value store and eighth most popular database in the world. It has high throughput and runs from memory, but also has the ability to persist data on disk. Redis is an advanced key-value store. Redis is a great caching solution for highly demanding applications, and there are […].

Cache 130

Cache Azure Benchmarking Performance 130

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So what jumps out immediately here is the comment “The single-threaded PostgreSQL 12 performance was most surprising.” hardware limits: 1000 MHz - 4.00

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Smashing Magazine

SEPTEMBER 28, 2022

Five Data-Loading Patterns To Improve Frontend Performance. Five Data-Loading Patterns To Improve Frontend Performance. Data loading patterns are an essential part of your application as they will determine which parts of your application are directly usable by visitors. But isn’t waiting for the data the point?

Performance 125

Performance Cache Servers Social Media 125

The Morning Paper

MARCH 10, 2020

Characterizing, modeling, and benchmarking RocksDB key-value workloads at Facebook , Cao et al., Or in the case of key-value stores, what you benchmark. So if you want to design a system that will offer good real-world performance, it’s really useful to have benchmarks that accurately represent real-world workloads.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

Scalegrid

MARCH 22, 2024

They can also bolster uptime and limit latency issues or potential downtimes. This covers everything from tech specs and what you expect from the service to security, how you’ll handle data, and how services will be managed. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions?

Strategy 130

Strategy Cloud Government Innovation 130

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Percona

JULY 1, 2023

Now that Database-as-a-service (DBaaS) is in high demand, there are multiple questions regarding AWS services that cannot always be answered easily: When should I use Aurora and when should I use RDS MySQL ? What we should really compare is the MySQL and Aurora database engines provided by Amazon RDS. How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Speed Curve

FEBRUARY 5, 2024

Looking at the industry benchmarks for US retailers , four well-known sites have backend times that are approaching – or well beyond – that threshold. Pagespeed Benchmarks - US Retail - LCP When you examine a waterfall, it's pretty obvious that TTFB is the long pole in the tent, pushing out render times for the page.

Servers 57

Servers Cache Retail Benchmarking 57

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. These include popular technologies such as web servers and web applications, along with advanced solutions like distributed data stores and containerized microservices.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Percona

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 That’s a heritage of the LAMP model when the same server would host both the database and the web server. MySQL (B) 2517529 2610323 389048 5516900 194140 11523.48

Tuning 138

Tuning Cache Servers Benchmarking 138

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 108

Performance Monitoring Traffic Database 108

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide.

Performance 129

Performance Hardware Tuning Storage 129

The Netflix TechBlog

OCTOBER 19, 2020

If we had an ID for each streaming session then distributed tracing could easily reconstruct session failure by providing service topology, retry and error tags, and latency measurements for all service calls. Traces collected from various microservices are ingested in a stream processing manner into the data store.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Percona

JANUARY 24, 2023

Reduced WAL segment size has further gains in replication and backup because less data need to be transmitted. Such “torn pages” are corruptions from the database point of view. This is not a problem for PostgreSQL alone; every database software needs to deal with this problem. What is Full Page Writes?

Database 120

Database Benchmarking Open Source Latency 120

The Morning Paper

NOVEMBER 8, 2020

If you think of this a bit like mapping memory addresses to data in memory, then another parallel comes to mind: the virtual address space. This separation of concerns moves reconfiguration into the VirtualLog control plane, leaving Loglets responsible for the data plane. Delos in production.

Virtualization 126

Virtualization Latency Storage Systems 126

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Percona

MARCH 20, 2023

In this case, we have a quite well-defined scenario that can resemble the image below: In this scenario, the proxies must sit inside Pods, balancing the incoming traffic from the Service LoadBalancer connecting with the active data nodes. Let us take a look also the latency: Here the situation starts to be a little bit more complicated.

Games 125

Games Latency Traffic Cache 125

n0derunner

SEPTEMBER 17, 2018

Creating a HCI benchmark to simulate multi-tennent workloads. It is very common to have large resource-hungry databases separated across nodes using anti-affinity rules. It is the shared storage that often causes performance issues for data bases which are otherwise separated across nodes. Time based benchmark actions.

Performance Testing 40

Performance Testing Benchmarking Testing Performance 40

HammerDB

DECEMBER 5, 2020

A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. This was both expensive and time consuming to configure. I.e. if system A generated 1.5X

C++ 40

C++ Benchmarking Virtualization Open Source 40

The Morning Paper

MAY 14, 2019

Seer: leveraging big data to navigate the complexity of performance debugging in cloud microservices Gan et al., Seer uses a lightweight RPC-level tracing system to collect request traces and aggregate them in a Cassandra database. on end-to-end latency) and less than 0.15% on throughput. ASPLOS’19. Seer in action.

Big Data 45

Big Data Cloud Performance Hardware 45

The Morning Paper

AUGUST 29, 2019

There’s a broad set of choices including where you store the data, whether you run your own DBMS nodes or use a service, the kinds of instance types to go for if you do run your own, and so forth. We focused on OLAP-oriented parallel data warehouse products available for AWS and restricted our attention to commercially available systems.

Architecture 76

Architecture Cloud Storage Serverless 76

Alex Russell

MAY 9, 2022

This is a complex topic, but to borrow from a recent post , web performance expands access to information and services by reducing latency and variance across interactions in a session, with a particular focus on the tail of the distribution (P75+). Consistent performance matters just as much as low average latency. Photo by von Vix.

Performance 86

Performance Latency Metrics Engineering 86

SQL Performance

APRIL 8, 2019

Both of these Intel processors are special bespoke models that are not in the Intel ARK database. I wrote about using CPU-Z to benchmark the Intel Xeon E5-2673 v3 processor in an Azure VM in this article. Figure 1: CPU-Z Benchmark Results for LS16v2. GHz Intel Xeon E5-2673 v4 (Broadwell) and the 2.4 Memory (GiB).

Azure 42

Azure Virtualization Storage Benchmarking 42

Alex Russell

MARCH 6, 2021

Before Jio's disruptive pricing and aggressive rollout, data services in India were among the most expensive in the world relative to income and heavily reliant on 3G outside wealthier "tier 1" cities. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 124

Performance Network Cache Metrics 124

IO River

NOVEMBER 15, 2023

The OSI Model is like a layer cake of how data moves through networks. This means it specifically looks at the content of the data (like the writing inside our letters from the analogy) rather than just the envelope.So, what is the difference between a Firewall at the application level and network level? You've put new rules in place.

Traffic 52

Traffic Network Logistics Architecture 52

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. Converging Views.

Media 145

Media Games Education Engineering 145

IO River

NOVEMBER 2, 2023

The OSI Model is like a layer cake of how data moves through networks. This means it specifically looks at the content of the data (like the writing inside our letters from the analogy) rather than just the envelope.So, what is the difference between a Firewall at the application level and network level? You've put new rules in place.

Traffic 40

Traffic Network Logistics Architecture 40

SQL Server According to Bob

SEPTEMBER 26, 2016

Our customers who deployed Availability Groups were now using servers for primary and secondary replicas with 12+ core sockets and flash storage SSD arrays providing microsecond to low millisecond latencies. This chart shows our scaled results using a OLTP workload derived from TPC benchmarks. Direct seeding of new database replicas.

Availability 40

Availability Servers Hardware Benchmarking 40

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

All Things Distributed

NOVEMBER 19, 2010

There was an excellent first benchmarking report of the Cluster GPU Instances by the folks at Cycle Computing - " A Couple More Nails in the Coffin of the Private Compute Cluster " The Top500 supercomputer list. a Fast and Scalable NoSQL Database Service Designed for Internet Scale Applications. Expanding the Cloud â??

AWS 67

AWS Cloud Benchmarking Storage 67

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? ​​ The same formula can later be used to ​​ examine ​​ the ​​ data for damage.

Servers 40

Servers Cache Database Media 40

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. Consistency When completed, a transaction must leave all data in a consistent state.

Servers 40

Servers Cache Media Hardware 40