Scalegrid

MARCH 22, 2024

Choosing the Right Cloud Services Choosing the right cloud services is crucial in developing an efficient multi cloud strategy. Ready to take your database management to the next level with ScaleGrid’s cutting-edge solutions? Elevate your cloud strategy today with ScaleGrid!

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

The Morning Paper

JUNE 16, 2019

Towards multiverse databases Marzoev et al., The central idea behind multiverse databases is to push the data access and privacy rules into the database itself. Such a design rules out an entire class of application errors, protecting private data from accidentally leaking. HotOS’19. Managing universes.

Database 90

Database Cache Benchmarking Efficiency 90

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

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

AUGUST 31, 2018

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters. shared_buffer.

Tuning 55

Tuning Database Performance Benchmarking 55

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

Particular Software

SEPTEMBER 20, 2021

Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. If you did such a benchmark, here’s an incomplete picture you might end up with: Graph of microbenchmark showing RPC is faster than messaging.

Benchmarking 97

Benchmarking Latency Servers Systems 97

Dynatrace

SEPTEMBER 23, 2021

Many good security tools provide that function, and benchmarks from the Center for Internet Security (CIS) are clear and prescriptive. Use scripts to configure hosts properly based on the CIS benchmarks. Secrets, such as database credentials, API keys, SSL keys or encryption keys, need to be managed to protect them from discovery.

Open Source 239

Open Source Benchmarking Best Practices Network 239

Percona

JULY 25, 2023

Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. Old design (until Percona XtraBackup 8.0.33-27): New design (from Percona XtraBackup 8.0.33-28) ibd2sdi data/test/t1.ibd

Cache 85

Cache Benchmarking Servers Design 85

The Morning Paper

SEPTEMBER 15, 2019

Fine-grained, secure and efficient data provenance on blockchain systems Ruan et al., In designing a blockchain-friendly provenance mechanism, three aspects unique to the blockchain environment differentiate the problem from that of traditional database provenance: There are no higher-order data operators (e.g. VLDB’19.

Blockchain 55

Blockchain Efficiency Systems Storage 55

Percona

SEPTEMBER 1, 2023

MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. A Trigger in MySQL is a database object that plays a pivotal role in database management.

Cache 60

Cache Database Games Healthcare 60

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL.

Open Source 85

Open Source Storage Database Big Data 85

Percona

JANUARY 24, 2023

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. Lz4 compression can be the choice if the database workload is CPU bound because it is light on the CPU. Modern compression algorithms and libraries are excellent.

Database 115

Database Benchmarking Open Source Latency 115

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes. Additionally, MySQL 8.0

Strategy 40

Strategy Storage Database Best Practices 40

The Morning Paper

JULY 2, 2019

One SQL to rule them all: an efficient and syntactically idiomatic approach to management of streams and tables Begoli et al., Note that a mutable database table, as perceived by a consumer across multiple queries, is already a time-varying relation (TVR). SIGMOD’19. Hop example. Emit Stream example.

Efficiency 65

Efficiency Processing Benchmarking Open Source 65

The Netflix TechBlog

OCTOBER 19, 2020

Now let’s look at how we designed the tracing infrastructure that powers Edgar. We earned the trust of our engineers by developing empathy for their operational burden and by focusing on providing efficient tracer library integrations in runtime environments. Storage: don’t break the bank!

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Percona

MARCH 20, 2023

When designing an architecture, many components need to be considered before deciding on the best solution. In this scenario, it is also crucial to be efficient in resource utilization and scaling with frugality. In short, each cluster is, in reality, a single database with high availability and other functionalities built in.

Games 119

Games Latency Traffic Cache 119

Smashing Magazine

SEPTEMBER 28, 2022

On your first try, you can use it as a benchmark for optimizations later. On design systems, UX, web performance and CSS/JS. Server caches help lower the latency between a Frontend and Backend; since key-value databases are faster than traditional relational SQL databases, it will significantly increase an API’s response time.

Performance 127

Performance Cache Servers Social Media 127

The Netflix TechBlog

MAY 21, 2019

The device ecosystem is rich with partners ranging from Silicon-on-Chip (SoC) manufacturers, Original Design Manufacturer (ODM) and Original Equipment Manufacturer (OEM) vendors. Solving the above problems could help Netflix and our Partners save time and money during the entire lifecycle of device design, build, test, and certification.

Testing 163

Testing AWS Lambda Network 163

Alex Russell

APRIL 29, 2021

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. With each team, benchmarks lost are understood as bugs. All modern browsers are fast, Chromium and Safari/WebKit included. CSS Custom Paint.

Media 145

Media Games Education Engineering 145

KeyCDN

OCTOBER 2, 2018

Codrops Codrops features blogs with topics ranging from UI design and page animations to image formatting and general JavaScript practices. A List Apart A List Apart focuses on UX and branding from business and design-oriented perspectives. Topics include web design, security, web-based tools and workflows and more.

Development 75

Development Website Design Code 75

Abhishek Tiwari

DECEMBER 13, 2017

This is a question recently asked and explored by a team of Google researchers led by Jeff Dean with a major focus on database indexes. This has far-reaching implications how future data systems and algorithms will be designed. Can machine learning-based data structures i.e. learned data structures replace traditional data structures?

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

The Morning Paper

MAY 14, 2019

Last time around we looked at the DeathStarBench suite of microservices-based benchmark applications and learned that microservices systems can be especially latency sensitive, and that hotspots can propagate through a microservices architecture in interesting ways. ASPLOS’19. accuracy) and avoided 495 (84%) of them.

Big Data 45

Big Data Cloud Performance Hardware 45

High Scalability

NOVEMBER 25, 2019

To help our customers manage ongoing data explosion, we have designed many of the core components over the last few years. Chokepoint : Even sharded Berkeley DB was choking under the stress and there was a database crash with recovery taking hours, it had to be replaced. How much upfront design should you do? Cloud Platform.

Architecture 52

Architecture Cache Azure Storage 52

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? This is different from ​​ the reference count design ​​ that was ​​ used in SQL Server 7.0

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. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Highly Scalable

MARCH 10, 2015

Although these problems are very different, we are trying to establish a common framework that helps to design optimization and data mining tasks required for solutions. The design of the model heavily depends on the problem. This model helps to design targeted usage expansion campaigns. Propensity to category expansion.

Retail 152

Retail C++ Analytics Metrics 152

Smashing Magazine

JANUARY 6, 2020

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Map design decisions against performance budget and the priorities defined early on.

Performance 145

Performance Cache Network Metrics 145