SQL Performance

MARCH 17, 2020

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. I will be using the 50GB Stack Overflow 2013 database , but any large table with a low number of distinct values would do. The Stack Overflow 2013 database comes without nonclustered indexes to minimize download time. Test Environment.

Servers 86

Servers Tuning Database Efficiency 86

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Instead of relational (SQL) databases defined primarily through a hierarchy of related sets via tables and columns, their non-relational structure used a system of collections and documents. Is MongoDB an open source NoSQL database? ” Nothing nefarious there.

Open Source 83

Open Source Programming Database Servers 83

All Things Distributed

APRIL 12, 2013

Back-to-Basics Weekend Reading - Join Processing in Relational Databases. By Werner Vogels on 12 April 2013 04:00 AM. Joins are one of the fundamental relational database query operations. Join Processing in Relational Databases , Priti Mishra and Margaret H. Comments (). blog comments powered by Disqus. Contact Info.

Processing 89

Processing Database Efficiency Scalability 89

All Things Distributed

JULY 7, 2013

By Werner Vogels on 07 July 2013 06:30 PM. As customers move increasing amounts of compute and database workloads over to AWS, they have expressed an increased desire for finer grain control over their underlying resources. For example, you can mandate that only Senior Database Administrators in your company can modify â??productionâ??

Cloud 107

Cloud AWS Database Scalability 107

Smashing Magazine

JANUARY 15, 2019

How Improving Website Performance Can Help Save The Planet. How Improving Website Performance Can Help Save The Planet. The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. Jack Lenox. Sustainable Web Design.

Website Performance 74

Website Performance Website Energy Performance 74

Percona

AUGUST 27, 2018

5000 named Percona to their list in 2013, 2014, 2015 and 2016. Peter was an early employee at MySQL AB, eventually leading the company’s High-Performance Group. Peter is a co-author of High-Performance MySQL: Optimization, Backups, and Replication , one of the most popular books on MySQL performance.

Open Source 43

Open Source Internet Internet Strategy 43

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 127

Performance Hardware Tuning Storage 127

All Things Distributed

APRIL 17, 2013

By Werner Vogels on 17 April 2013 10:30 AM. While DynamoDB already allows you to perform low-latency queries based on your tableâ??s s primary key, even at tremendous scale, LSI will now give you the ability to perform fast queries against other attributes (or columns) in your table. Comments (). Today, Iâ??m

Cloud 107

Cloud Latency Games Scalability 107

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. Most Popular Cloud Providers for PostgreSQL Hosting.

Strategy 182

Strategy Cloud Java Open Source 182

Scalegrid

APRIL 2, 2019

PostgreSQL is an open source relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 185

Database Cloud Open Source Azure 185

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. DigitalOcean Droplets. DigitalOcean Disk Types.

Azure 187

Azure AWS Latency Database 187

Percona

DECEMBER 28, 2022

Connection id: 22 Current database: db + --+ | connection_id() | + --+ | 22 | + --+ 1 row in set (3.19 To understand this better let’s see what happens when we perform any DDL operation in a binary log-based replication environment and in the Aurora replication environment. Trying to reconnect. What are the issues?

Storage 93

Storage Servers AWS Database 93

Percona

JULY 30, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). 5000 named Percona to their list in 2013, 2014, 2015 and 2016. Register Now.

Architecture 41

Architecture Database Open Source Internet 41

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Poor performance has a compound effect on user expectations at an ecosystem level. Live by the link, die by the link.

Performance 127

Performance Network Metrics Cache 127

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 111

Virtualization AWS Hardware Storage 111

All Things Distributed

DECEMBER 12, 2013

We launched DynamoDB last year to address the need for a cloud database that provides seamless scalability, irrespective of whether you are doing ten transactions or ten million transactions, while providing rock solid durability and availability. You saw the first iteration in April 2013 with the launch of Local Secondary Indexes (LSI).

Games 125

Games Scalability Database Retail 125

Alex Russell

APRIL 29, 2021

Classics of the genre include: Apple's just focused on performance! The Performance Argument. 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. Steve & Tim's Close-up Magic.

Media 145

Media Games Education Engineering 145

All Things Distributed

MARCH 7, 2013

By Werner Vogels on 07 March 2013 08:00 PM. Many of our customers have, with the click of a button, created DynamoDB deployments in a matter of minutes that are able to serve trillions of database requests per year. I am often asked: When is it appropriate to use DynamoDB instead of a relational database? All Things Distributed.

Ecommerce 135

Ecommerce Storage Scalability Hardware 135

Official Blog - World Web Technology

NOVEMBER 27, 2023

You can create a high-performing website with little effort and time learning the ropes. Shopify introduced its feature – Shopify Payments in 2013. It is written in PHP and uses a MySQL database for operations. The business plan on WordPress.com has updates, security, performance monitoring, and the freedom to use plugins.

Website 59

Website Development Mobile Storage 59

All Things Distributed

FEBRUARY 18, 2013

By Werner Vogels on 18 February 2013 11:30 PM. When a new app server instance starts, OpsWorks will use built-in recipes to configure the app server software and deploy your apps, and can also apply your specified recipes to make changes to your database and monitoring infrastructure. Comments (). Operational Control â??

AWS 153

AWS Cloud Architecture Infrastructure 153

Brendan Gregg

NOVEMBER 28, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

MARCH 30, 2021

It includes initializing each operator, and adding hidden profilers to collect runtime performance data like actual row count and elapsed time. I used the public Stack Overflow 2013 database ( download details ). To provide a concrete basis for the analysis, we will follow how a particular parallel query starts execution.

Cache 98

Cache Servers Operating System Processing 98

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. This is the first time any server vendor has even bothered to submit a TPC-E result for an AMD-based system since 2013. Single-threaded CPU performance is the one relative weak point of the AMD EPYC 7742 processor. This system has two, Intel Xeon Platinum 8280 28-core processors and 1.5TB of RAM.

Servers 52

Servers Benchmarking Virtualization Architecture 52

High Scalability

SEPTEMBER 28, 2018

MrTonyD : I was writing production code over 30 years ago (C, OS, database). They sent me long email listing reasons why I shouldn't get a second monitor, including (numbers are approximate, employee count from 2013 or so) "If every googler gets an extra monitor, in a year it would be equivalent to driving Toyota Camry for 18000 miles.".

Internet 35

Internet Internet Scalability Blockchain 35

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. The following examples use the public Stack Overflow 2013 database ( download details ), with a single index added: CREATE INDEX PP ON dbo. Both calculations are performed over the per-thread truncated millisecond values. A final example.

Servers 95

Servers Tuning Architecture Performance 95

Highly Scalable

MARCH 10, 2015

The goal is to find a set of the most promising candidates who should receive the resource in order to maximize the overall performance of the targeted group of customers. Moreover, gross margin is not the only performance metric that is important for retailers. The resource can be homogenous (i.e. Applications. Applications.

Retail 152

Retail C++ Analytics Metrics 152

O'Reilly Software

MARCH 7, 2018

In addition to that, software is increasingly dependent on other software to provide its functionality, be it WebServices, HTTP APIs, databases, or even external devices such as sensors. blocking), discarding data, or none—which can lead to resilience problems, poor performance, or worse: rapid unscheduled disassembly in production.

Transportation 72

Transportation Java Programming Architecture 72

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 6, 2020

Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Front-End Performance Checklist 2020 [PDF, Apple Pages, MS Word]. Web performance is a tricky beast, isn’t it? How do we actually know where we stand in terms of performance, and what our performance bottlenecks exactly are? Vitaly Friedman.

Performance 145

Performance Cache Network Metrics 145

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Text search.

Database 40

Database Analytics Blockchain Healthcare 40