The Morning Paper

JUNE 20, 2019

In total, there were 112 such incidents over the period March – September 2018 (not all of them affecting external customers). Most Azure code is written in.Net managed languages such as C#, reducing memory leak bugs. In 40% of cases different parties assume different formats for shared files or database tables.

Cloud 81

Cloud Azure Cache C++ 81

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. Once the schema was built I shutdown and restarted the database and configured a test script as follows: HammerDB-3.1$

Testing 48

Testing Tuning Latency Storage 48

O'Reilly

FEBRUARY 18, 2020

Growth is still strong for such a large topic, but usage slowed in 2018 (+13%) and cooled significantly in 2019, growing by just 7%. But sustained interest in cloud migrations—usage was up almost 10% in 2019, on top of 30% in 2018—gets at another important emerging trend. ML + AI are up, but passions have cooled. Security is surging.

Software Architecture 134

Software Architecture DevOps Data Engineering Architecture 134

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Here’s the attempted solution using a CTE: WITH C AS. ( Using our trick with the TOP filter in the inner query, you prevent the unnesting of the table expression, like so: WITH C AS. ( ( SELECT *. FROM Sales. OrderDetails. FROM Sales.

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

OCTOBER 13, 2021

In my examples I’ll use a sample database called TSQLV5. Like views, iTVFs are created as a permanent object in the database, and therefore are reusable by users who have permissions to interact with them. iTVFs vs. Combining the APPLY operator with an iTVF call, you can achieve the task nicely and cleanly, like so: SELECT C.

Cache 144

Cache Strategy C++ Code 144

High Scalability

JULY 26, 2018

Lance Gutteridge : The reason why almost no one encrypts their databases is one of the dirty secrets of IT. AndreaPessino : It's finally happening - after >30 years of pro use, 20 of which quite reluctantly, I am officially DONE with C/C++. Only maintenance from now on, everything new will be in @rustlang.

Internet 124

Internet Internet Scalability Serverless 124

SQL Performance

OCTOBER 14, 2020

In my examples I’ll continue using the sample databases TSQLV5 and PerformanceV5. Here’s the attempted solution using a CTE: WITH C AS. ( Using our trick with the TOP filter in the inner query, you prevent the unnesting of the table expression, like so: WITH C AS. ( ( SELECT *. FROM Sales. OrderDetails. FROM Sales.

C++ 52

C++ Servers Code Efficiency 52

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. SELECT DISTINCT c from sbtest where id between ? order by c.

Best Practices 40

Best Practices Scalability Performance C++ 40

HammerDB

NOVEMBER 30, 2018

However if you have downloaded the source code and are looking to add features or make modifications such as adding new databases you may be wondering once you have the source code where to start. However HammerDB will not be able to connect to a database yet and the librarycheck command included with the CLI gives an indication why.

Architecture 40

Architecture Virtualization Open Source C++ 40

HammerDB

OCTOBER 8, 2018

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. D isabling all C-states or Idle states is likely to reduce overall performance by reducing the available turbo frequency. Initially it is best leave all of these states enabled. cat /proc/meminfo.

Best Practices 40

Best Practices Scalability Performance Hardware 40

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. Logging Waits.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

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. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story. Description.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

OCTOBER 26, 2018

2018-10-26T13:45:46+02:00. When it comes down to how WordPress is programmed, one thing is certain: it doesn’t follow the M odel- V iew- C ontroller (MVC) design pattern that many developers are familiar with. This will be run on the save_post hook and will overwrite the transient in the database with the JSON data of our post.

Cache 78

Cache Website Speed Database 78

High Scalability

SEPTEMBER 28, 2018

MrTonyD : I was writing production code over 30 years ago (C, OS, database). . $2 billion : Pokémon GO revenue since launch; 10 : say happy birthday to StackOverflow; $148 million : Uber data breach fine; 75% : streaming music industry revenue in the US; 5.2 I acknowledge that. It is much worse to be a software developer now.

Internet 35

Internet Internet Scalability Blockchain 35

Scalegrid

AUGUST 15, 2019

In this article, we are going to compare 6 of the top MongoDB Graphical User Interfaces that help developers increase their productivity and manage their database. Whether you're exploring your local #MongoDB database or working with shards and replica sets, @Studio3T allows you to do all of it. Comparing MongoDB GUIs. Click To Tweet.

Database 40

Database Servers Monitoring Availability 40

Percona

JANUARY 17, 2019

I’m using the “Airlines On-Time Performance” database from [link] (You can find the scripts I used here: [link] ). MySQL on ec2. mysql> show global variables like '%version%'; + -+ + | Variable_name | Value | + -+ + | innodb_version | 5.6.41-84.1 sec) The table is very wide, 84 columns.

Cache 46

Cache C++ AWS Airlines 46

Brendan Gregg

FEBRUARY 9, 2018

Plotting the percent performance loss vs syscall rate per CPU, for my microbenchmark: Applications that have high syscall rates include proxies, databases, and others that do lots of tiny I/O. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Hit Ctrl-C to end. Linux 4.14.12-virtual

Performance 75

Performance Benchmarking Cache Tuning 75

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. Not available.

Open Source 244

Open Source Tuning C++ Database 244

Brendan Gregg

FEBRUARY 8, 2018

Plotting the percent performance loss vs syscall rate per CPU, for my microbenchmark: Applications that have high syscall rates include proxies, databases, and others that do lots of tiny I/O. virtual (bgregg-c5.9xl-i-xxx) 02/09/2018 _x86_64_ (36 CPU) 05:24:51 PM proc/s cswch/s. Hit Ctrl-C to end. Linux 4.14.12-virtual

Performance 40

Performance Benchmarking Cache Tuning 40

Smashing Magazine

JANUARY 7, 2019

Depending on how much dynamic data you have, you might be able to "outsource" some part of the content to a static site generator , pushing it to a CDN and serving a static version from it, thus avoiding database requests. In 2018, the Alliance of Open Media has released a new promising video format called AV1. Same with Etag.

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

JANUARY 6, 2020

Globally in 2018–2019, according to the IDC, 87% of all shipped mobile phones are Android devices. Depending on how much dynamic data you have, you might be able to "outsource" some part of the content to a static site generator , pushing it to a CDN and serving a static version from it, thus avoiding database requests.

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. 2018-05-31

Database 40

Database Analytics Blockchain Healthcare 40