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

CSS Wizardry

JULY 21, 2018

le|c|sa|sc)ss$/{print}' | nl. For a slightly more robust, but still imperfect method of identifying dead code, try this technique that I wrote up earlier in 2018. Basically, ctags will create a kind of of database of all of the function, variable, mixin, ID, and class definitions for your project. Learn the Codebase Organically.

Programming 150

Programming C++ Code Database 150

Brendan Gregg

APRIL 30, 2018

The CFP for LISA18 is open now, and we’d love for you to submit talks and tutorials ideas by May 24th, 2018. In 2018, for the first time, LISA will be in Nashville, Tennessee, October 29-31, and will be hosted at the Omni Nashville Hotel , next to the Country Music Hall of Fame and Museum.

DevOps 41

DevOps Network Best Practices Programming 41

Brendan Gregg

APRIL 29, 2018

The CFP for LISA18 is open now, and we’d love for you to submit talks and tutorials ideas by May 24th, 2018. In 2018, for the first time, LISA will be in Nashville, Tennessee, October 29-31, and will be hosted at the Omni Nashville Hotel , next to the Country Music Hall of Fame and Museum.

DevOps 40

DevOps Network Best Practices Programming 40

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. 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. What is PostgreSQL performance tuning?

Tuning 52

Tuning Database Efficiency Performance 52

Percona

SEPTEMBER 13, 2018

2018-09-03.09 > mysql-slowquery.log.2018-09-03.09 2018-09-03.09 2018-09-03.09 system time, 43.80M rss, 141.48M vsz # Current date: Tue Sep 4 15:54:21 2018 # Hostname: aahmed-GL503VD # Files: mysql-slowquery.log.2018-09-03.09 2018-09-03.09 Run pt-query-digest on the log file. . $ user time, 2.5s user time, 2.5s

C++ 62

C++ AWS Open Source Testing 62

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

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

Percona

DECEMBER 5, 2022

Proxysql has a stats database which we can see with an admin login. This database contains metrics gathered by ProxySQL concerning its internal functioning. Your MySQL connection id is 1 Server version: 5.5.30 (ProxySQL Admin Module) Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Explanation.

Servers 60

Servers Cache C++ Metrics 60

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 72

Cache C++ AWS Airlines 72

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

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 49

Testing Tuning Storage Latency 49

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

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 72

Performance Benchmarking Cache Tuning 72

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

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 88

Cache Website Speed Testing 88

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 111

Performance Cache Network Metrics 111

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 112

Performance Cache Servers Network 112

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 48

Database Analytics Blockchain Healthcare 48