Percona

AUGUST 4, 2023

in 2017; after that, major releases came every one to two years, with MariaDB 10.6 The MariaDB 11 series did not yet have any long-term supported (LTS) releases, which are the releases most would consider for running mission-critical databases in production. (It is worth noting that MariaDB 5.2 and MariaDB 5.3 MariaDB 10.1

Database 98

Database Servers Innovation Open Source 98

O'Reilly

FEBRUARY 18, 2020

Up until 2017, the ML+AI topic had been amongst the fastest growing topics on the platform. After several years of steady climbing—and after outstripping Java in 2017—Python-related interactions now comprise almost 10% of all usage. Not necessarily: Java-related searches increased by 5% between 2017 and 2018. Coincidence?

Software Architecture 145

Software Architecture DevOps Data Engineering Architecture 145

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Use the following code to create the Employees table in the tempdb database, populate it with sample data, and create a supporting index: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo. Employees ; GO. CREATE TABLE dbo. Employees. (

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

AUGUST 14, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. 2017-07-04 10248 440.00 2017-07-05 10249 1863.40 2017-07-08 10250 1552.60 2017-07-08 10251 654.06 2017-07-09 10252 3597.90 2017-07-05 10249 1863.40

Best Practices 108

Best Practices Servers Database Azure 108

Dynatrace

MAY 6, 2021

Linux: Amazon Linux AMI 2017.x. Fixed an issue in which database conditions in tagging and management zone configurations were evaluated incorrectly. Operating systems support. Future Dynatrace Managed operating systems support changes. The following operating systems will no longer be supported starting 01 September 2021.

Operating System 246

Operating System AWS Metrics Storage 246

SQL Performance

SEPTEMBER 12, 2019

In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Suppose for example that you want to query the Sales.Orders table in the TSQLV5 sample database. Implicit grouping with PIVOT. 830 rows affected).

Best Practices 103

Best Practices C++ Code Design 103

SQL Server According to Bob

OCTOBER 26, 2017

Please check out these new resources for SQL Server 2017 and SQL Server on Linux and Docker: Brk2045 upgrade sql server 2017 (on prem, iaa-s and paas) from Bob Ward. To find out what’s different and new about SQL Server 2017, go to this documentation page: What’s new in SQL Server 2017. SQL Server on Docker.

Servers 40

Servers Azure Open Source Database 40

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here.

Best Practices 117

Best Practices C++ Database Code 117

High Scalability

NOVEMBER 30, 2018

during the 2017-18 academic year, on top of a 3.3% The scalability of a native graph database. They'll love it and you'll be their hero forever. 8 : successful Mars landings; $250,000 : proposed price for Facebook Graph API; 33 : countries where mobile internet is faster than WiFi; 1000s : Facebook cache poisoning; 8.2

Internet 28

Internet Internet Scalability Blockchain 28

SQL Server According to Bob

SEPTEMBER 25, 2017

Scott Guthrie and Rohan Kumar officially made the announcement today at Ignite that SQL Server 2017 will be generally available on October 2nd, 2017. Andrew Brust also wrote a very nice article detailing out all the great new features that come with SQL Server 2017. Principal Architect, Microsoft Database Systems Group.

Servers 40

Servers Availability Tuning Database 40

All Things Distributed

OCTOBER 17, 2016

In the remainder of 2016 and inq 2017, we will launch another four AWS regions in Canada, China, the United Kingdom, and France, adding another nine AZs to our global infrastructure footprint. It brings the worldwide total of AWS Availability Zones (AZs) to 38, and the number of regions globally to 14. The Ohio Region is no different.

AWS 107

AWS Cloud Infrastructure Storage 107

SQL Server According to Bob

SEPTEMBER 27, 2017

Please check out a new blog post I created detailing how SQL Server 2017 is Fast, Built-In. And we are the fastest database everywhere you need it: On the planet or in the cloud. Look for more details on my blog post and the SQL Server Blog about some of these concepts and new features for performance for SQL Server 2017.

Servers 40

Servers Tuning Database Cloud 40

SQL Performance

OCTOBER 9, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. Many people are not aware that SQL Server 2017 introduced a new function called TRANSLATE that simplifies such replacements a great deal. EOMONTH has a second parameter.

C++ 111

C++ Database Servers Code 111

SQL Performance

AUGUST 11, 2021

Another is using a custom calculation that emulates the DATE_BUCKET function, which you can use in any version, edition, and flavor of SQL Server and Azure SQL Database. In my examples, I’ll use the sample database TSQLV5. An event that took place on July 14 th , 2018 belongs to fiscal year 2017. 2017 343 495118.14

Azure 139

Azure Code Database Servers 139

SQL Performance

FEBRUARY 12, 2020

I'll continue using the sample database TSQLV5 like last month in some of my examples. You can find the script that creates and populates this database here , and its ER diagram here. 10249 2017-07-10 10252 2017-07-11 10250 2017-07-12. DISTINCT predicate. 11063 2019-05-06 11067 2019-05-06 11069 2019-05-06.

C++ 120

C++ Code Servers Database 120

The Netflix TechBlog

OCTOBER 19, 2020

By 2017, open source projects like Open-Tracing and Open-Zipkin were mature enough for use in polyglot runtime environments at Netflix. In 2019 our stunning colleagues in the Cloud Database Engineering (CDE) team benchmarked EBS performance for our use case and migrated existing clusters to use EBS Elastic volumes.

Infrastructure 238

Infrastructure Transportation Storage Open Source 238

Brendan Gregg

NOVEMBER 28, 2017

But not all workloads: some are network bound (proxies) and storage bound (databases). ## 5. Xen AWS 2017 In 2015, AWS launched c4, which used hardware virtualization for EBS volumes. This finally came to storage-optimized instance types in 2017 with the [i3 instance type], which used SR-IOV and the nvme storage driver.

Virtualization 40

Virtualization AWS Hardware Storage 40

SQL Performance

JULY 9, 2019

For example, suppose that you want to query the Sales.OrderValues view in the TSQLV5 sample database, and return for each customer and order date, the daily total of the order values, and the running total until the current day. 2 2017-09-18 88.80 10248 85 2017-07-04 440.00 180.000000 10249 79 2017-07-05 1863.40

Servers 83

Servers Availability Database Code 83

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet 110

Internet Internet AWS Performance 110

SQL Performance

JANUARY 23, 2020

Recently, a SentryOne customer contacted me about performance concerns with their SentryOne database. There is a single SQL Server database at the heart of every SentryOne monitoring environment, and this customer was monitoring around 600 servers with our software. Query Store 2017 to the Rescue. The Top Queries That Weren't.

Tuning 115

Tuning Servers Monitoring Hardware 115

The Symphonia

DECEMBER 6, 2017

Serverless Aurora promises to be the SQL Database to partner with Lambda that we’ve been hoping for. It’s still in early access, so no concrete news to report here, but a lot of people will be happy to be able to use a SQL database that has the operational properties of DynamoDB. We’re the experts!

Serverless 40

Serverless Lambda AWS Traffic 40

Alex Russell

MARCH 6, 2021

TL;DR: A lot has changed since 2017 when we last estimated a global baseline resource per-page resource budget of 130-170KiB. To update our global baseline from 2017, we want to update our priors on a few dimensions: The evolved device landscape. The Moto G4 , for example. Here begins our 2021 adventure. Hard Reset.

Performance 127

Performance Network Mobile Metrics 127

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. StackOverflow statistics show that 26% of developers preferred it in 2017, 34% in 2019, and 40% in 2021. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ).

Open Source 98

Open Source Healthcare Social Media Database 98

VoltDB

JANUARY 12, 2018

So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB. Create Better, Real-Time Customer Experiences.

Database 40

Database Blockchain Healthcare Transportation 40

VoltDB

JANUARY 12, 2018

So, in the spirit of things, we’ve laid out a few New Year’s resolutions that all database professionals can take into account as they look to turn over a new leaf in 2018 and build on their successes. The post Database Resolutions for 2018 appeared first on VoltDB. Create Better, Real-Time Customer Experiences.

Database 40

Database Blockchain Healthcare Transportation 40

SQL Performance

JULY 8, 2020

In my examples I’ll use sample databases called TSQLV5 and PerformanceV5. The outer query then filters from those three orders only those that were placed on or after July 8 th , 2017. This query generates the following output: orderid orderdate -- - 10250 2017-07-08 (1 row affected). Example for performance reasons.

Servers 110

Servers Code Performance Processing 110

The Morning Paper

NOVEMBER 8, 2020

Back in 2017 the engineering team at Facebook had a problem. A related example is when Delos is running in converged mode and e.g. two of the five converged database replicas crash. Once the database was restored to five replicas, we reconfigured back. Every little helps!

Virtualization 126

Virtualization Latency Storage Systems 126

All Things Distributed

JUNE 30, 2017

So much so, that in March 2017, we announced Amazon Connect, which is the result of nearly ten years of work to build cloud-based contact centers at scale to power customer service for more than 50 Amazon teams and subsidiaries, including Amazon.com, Zappos, and Audible.

Artificial Intelligence 114

Artificial Intelligence Lambda AWS Virtualization 114

Percona

JANUARY 17, 2019

I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). Here is a summary of the queries: Simple queries: select count(*) from ontime where flightdate > '2017-01-01'. sec) mysql> explain select count(*) from ontime where flightdate > '2017-01-01'G 1.

Cache 72

Cache C++ AWS Airlines 72

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. 2017: MongoDB goes public, trading as MDB.

Open Source 98

Open Source Programming Database Servers 98

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. I've shared many posts about superpower observability tools, but often humble hacking is just as effective. These can be invisible to top(8).

Speed 103

Speed Java AWS Virtualization 103

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. The reduction effort started when we shipped SQL Server 2017 ( [link].) Remove the background task and aggressively reclaim database space during query execution.

IoT 61

IoT Servers Development Cache 61

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Database architects working with MongoDB encounter specific challenges related to database systems and system growth.

Best Practices 98

Best Practices Traffic Database Servers 98

Percona

DECEMBER 21, 2023

The efficiency of database queries in MySQL can make all the difference in the performance and responsiveness of applications. A Query Execution Plan is the way a database chooses to run a specific query. Before looking at the problematic query, I will walk you through a little detail about the optimizer.

Efficiency 126

Efficiency Database Open Source Performance 126

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 98

Availability Open Source Architecture Database 98

MachMetrics

DECEMBER 14, 2019

In 2017, mobile internet usage passed desktop as the majority. It is typically reduced via server-side optimizations, such as enabling caching and database indexes. What is the number of resources I should stay under? How fast is the average time to first byte (server delay)? What impact does the increased use of mobile devices have?

Best Practices 105

Best Practices Speed Mobile Google 105

SQL Server According to Bob

DECEMBER 11, 2017

Current limitation: Engaging in a distributed transaction with SQL Server 2017 on Linux. SQL Server 2017 on Linux does not have distributed transaction support. However, SQL Server 2017 on Windows provides distributed transaction support allowing interactions with SQL Server 2019 on Linux. Try out this example.

Servers 40

Servers Database Software Engineering Engineering 40