Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

Percona

AUGUST 8, 2023

Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance. Hardware considerations The first thing we have to consider here is the resources that the underlying host provides to the database.

Traffic 90

Traffic Cache Monitoring Database 90

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

J. Paul Reed

AUGUST 7, 2023

The “root cause” [sic] was eventually identified and it was related subtle differences in server provisioning. Even though that remediation task was pretty minor — tweaking some low-level hardware settings on each physical server and rebooting — and could have been done quickly enough, there was intense debate on whether it should be done.

Engineering 52

Engineering Hardware Games Infrastructure 52

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. Instead, focus on understanding what the workloads exercise to help us determine how to best use them to aid our performance assessment. TB)) for storage of database tablespaces and logging. Database: MySQL 8.0.31

Performance 54

Performance Benchmarking Cache Storage 54

SQL Performance

DECEMBER 27, 2019

This is a copy of the data, on an idle server (8 cores, 64GB RAM), with plenty of disk space (well over 6TB). ALTER DATABASE OCopy ADD FILE ( name = N'CCI_8' , size = 250000 , filename = 'K:Datao_cci_8.mdf' ALTER DATABASE OCopy ADD FILE ( name = N'CCI_P_8' , size = 250000 , filename = 'K:Datao_p_8.mdf' I just took the 3.75

Database 70

Database Storage Hardware Efficiency 70

All Things Distributed

NOVEMBER 15, 2010

The early GPU systems were very vendor specific and mostly consisted of graphic operators implemented in hardware being able to operate on data streams in parallel. Programming the GPU evolved in a similar fashion; it started with the early APIs being mainly pass-through to the operations programmed in hardware.

AWS 136

AWS Latency Programming Architecture 136