Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 76

Open Source Database Storage Scalability 76

Scalegrid

OCTOBER 7, 2019

As this open source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. PostgreSQL popularity is skyrocketing in the enterprise space.

Strategy 182

Strategy Cloud Java Open Source 182

Percona

SEPTEMBER 1, 2023

This blog was originally published in February 2019 and was updated in September 2023. Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. It specifies how characters are converted into binary code and vice-versa.

Performance 52

Performance Storage Social Media Database 52

SQL Server According to Bob

DECEMBER 18, 2018

Durability: “In database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. Microsoft SQL Server Database Engine Input/Output Requirements. Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system.

Servers 90

Servers Media Cache Storage 90

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. Need help managing complex database environments? This structure makes for faster data access.

Virtualization 77

Virtualization Speed Database Efficiency 77

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 85

Availability Open Source Architecture Database 85

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. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

The Morning Paper

NOVEMBER 8, 2020

replacing Paxos with Raft), or they could be shims over external storage systems. A minimal Loglet needs to provide totally ordered, durable storage via the shared log API. Clients trying to write to the old active segment after step 1 will receive a ‘sealed’ error code, and can retry after fetching the latest chain from the MetaStore.

Virtualization 126

Virtualization Latency Storage Systems 126

SQL Performance

SEPTEMBER 6, 2022

Let’s look at some examples using a fresh database. I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. USE master ; -- Create a new test database. -- COLLATE clause only to remind people it exists. Well, almost.

Database 98

Database Storage Testing Servers 98

O'Reilly

JULY 25, 2023

If you’re reading this, chances are you’ve played around with using AI tools like ChatGPT or GitHub Copilot to write code for you. So far I’ve read a gazillion blog posts about people’s experiences with these AI coding assistance tools. For instance, if I’m reading a paper from 2019, a popular song from that year could start playing.

Programming 98

Programming Code Design Benchmarking 98

SQL Performance

NOVEMBER 30, 2021

Whether the page is dirty or not (a dirty page has changes on it that haven’t yet been written back to durable storage). Code would have to scan the entire list of buffers for the database, looking for buffers that map pages for the allocation unit in question. Why Using Buffer Pool Contents Would Be Dangerous. ) ; GO.

Efficiency 54

Efficiency Servers Database Cache 54

The Morning Paper

JANUARY 26, 2020

This week we’ll be looking at a selection of papers from the 2019 edition of the ACM Symposium of Cloud Computing ( SoCC ). Reverb also take a snapshot of the client’s local storage (e.g. The new code may make fewer, the same, or more calls to such functions depending on the branches explored.

Programming 86

Programming Servers Network Latency 86

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. Engineering Rigor. Ghost Record Cleanup.

IoT 61

IoT Servers Development Cache 61

SQL Performance

OCTOBER 7, 2020

If you’re interested in table-valued function rewinds, please see my Q & A on Database Administrators Stack Exchange. Sorts use storage (memory and perhaps disk if they spill) so they do have a facility capable of storing rows between loop iterations. Sort Rewinds. History and my explanation. ( c1 ) VALUES. (

Servers 106

Servers Cache Azure Performance 106

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. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. .

Best Practices 40

Best Practices Scalability Performance C++ 40

Smashing Magazine

SEPTEMBER 26, 2019

2019-09-26T12:30:59+02:00. 2019-09-26T11:02:12+00:00. An input field for adding new items to a database could be an example of a service: it’s dedicated to one particular job (adding new items) and does the job without dependency on any other service. Frankenstein Migration: Framework-Agnostic Approach (Part 1). Denys Mishunov.

Architecture 73

Architecture Virtualization Servers Technology 73

SQL Performance

NOVEMBER 13, 2019

Use the following code to create this table and populate it with sample data: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. When there is a supporting index in place, you're limiting the storage engine to an index order scan strategy (following the index linked list). When order matters. CREATE TABLE dbo.

Servers 104

Servers C++ Storage Performance 104

Testsigma

NOVEMBER 16, 2021

In the summer of 2019, British Airways faced a technical issue on its website. Notice how March 2020 has shown an extremely positive change in website users with respect to March 2019. This includes the design principles, server communications or data transfers and storage. What does enterprise mean from a tester’s POV?

Testing 52

Testing Website Small Business Internet 52

Enprowess

JANUARY 12, 2022

Easy Deployment: PWAs can be deployed easily using a single code base that runs on accelerated mobile pages and web browsers. Other benefits: It has other benefits like a Quicker launch to the market, Easier distribution, saving device power and storage, seamless maintenance, and updating. Famous PWA Use Examples.

Blockchain 59

Blockchain IoT Development Serverless 59

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. Single-Socket Database Servers. Because of this, I think they will be a great choice for virtualization hosts and for Storage Spaces Direct nodes.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013.

Open Source 244

Open Source Tuning C++ Database 244

Smashing Magazine

JANUARY 7, 2019

Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2019 [PDF, Apple Pages, MS Word]. 2019-01-07T12:00:13+00:00. 2019-04-29T18:34:58+00:00. Ad Weight Impact If your site depends on the revenue generated by advertising, it’s useful to track the weight of ad related code.

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? It’s much easier to reach performance goals when the code base is fresh or is just being refactored.

Performance 145

Performance Cache Network Metrics 145