Percona

JANUARY 17, 2019

select SQL_CALC_FOUND_ROWS FlightDate, UniqueCarrier, TailNum, FlightNum, Origin, OriginCityName, Dest, DestCityName, DepDelay, ArrDelay FROM ontime_ind o JOIN carriers c on o.carrier = c.carrier_code WHERE (carrier_name like 'United%' or carrier_name like 'Delta%') and ArrDelay > 30 ORDER by DepDelay DESC LIMIT 10G.

Cache 72

Cache C++ AWS Airlines 72

SQL Performance

MARCH 20, 2020

In SQL Server 2016, STRING_SPLIT solved a long-missing gap in a language that, admittedly, was not intended for complicated string processing. For years before SQL Server 2016 (and for years since), we've written our own versions, improved them over time, and even argued about whose was fastest.

Database 109

Database Servers C++ AWS 109

All Things Distributed

DECEMBER 8, 2016

Lululemon Athletica is a Canadian athletic apparel company that is using AWS Lambda, AWS CodePipeline, and AWS CodeDeploy to rapidly build and deploy their digital marketing and e-commerce solutions for the upcoming 2016 holiday season. Par Werner Vogels, le 8 décembre 2016.

AWS 128

AWS Cloud Lambda Innovation 128

Percona

SEPTEMBER 19, 2023

Copyright (c) 2016, 2023, Oracle and/or its affiliates. Press ^C to stop. Press ^C to stop. -R /var/lib/mysql-redo-archive [root@ip-xxx-xx-xx-xx ~]# chmod -R 700 /var/lib/mysql-redo-archive/ Login into mysqlsh by root user and check the variable innodb_redo_log_archive_dirs. for help; 'quit' to exit.

C++ 124

C++ Servers Storage Speed 124

SQL Performance

APRIL 10, 2019

The ISO/IEC 9075:2016 standard, or SQL:2016 in short, introduces support for a profound concept called Row Pattern Recognition (RPR) in SQL. The SQL:2016 standard provides two main RPR-related features: Feature R010, “Row pattern recognition: FROM clause”. price ) AS bottomprice , LAST ( C. LAST ( C.

C++ 73

C++ Servers Virtualization Code 73

SQL Performance

APRIL 20, 2021

A reminder of the plan ( click to enlarge ): This is the first point in the process so far that an in-flight execution plan is available (SQL Server 2016 SP1 onward) in sys.dm_exec_query_statistics_xml. Additional parallel workers will be started to run the additional parallel tasks contained in branches B, C, and D. Starting Sequence.

C++ 98

C++ Processing Servers Cache 98

SQL Performance

MAY 1, 2020

In a recent tip , I described a scenario where a SQL Server 2016 instance seemed to be struggling with checkpoint times. Kendra Little – Target Recovery Interval and Indirect Checkpoint – New Default of 60 Seconds in SQL Server 2016. SQL 2016 – It Just Runs Faster: Indirect Checkpoint Default. group_id = c.

C++ 58

C++ Database Servers Storage 58

SQL Performance

OCTOBER 14, 2020

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. ( The following code returns only shippers with a maximum order date that is on or after January 1 st , 2018: USE PerformanceV5 ; WITH C AS. (

C++ 52

C++ Servers Code Efficiency 52

SQL Performance

JULY 27, 2021

Continuing my series of articles on latches, this time I’m going to discuss the DBCC_OBJECT_METADATA latch and show how it can be a major bottleneck for consistency checks prior to SQL Server 2016 under certain circumstances. But remember, this bottleneck only happens for versions of SQL Server earlier than SQL Server 2016.

C++ 54

C++ Servers Database Code 54

Alex Podelko

OCTOBER 28, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Tools, using standard languages such as C (e.g. I decided to publish a few parts here to see if anything triggers a discussion. – Cloud.

Performance Testing 100

Performance Testing Technology Technology Testing 100

Nick Desaulniers

DECEMBER 31, 0001

2020 Apr 6 Off by Two 2019 May 12 f() vs f(void) in C vs C++ 2019 Jan 18 Finding Compiler Bugs With C-Reduce 2018 Oct 24 Booting a Custom Linux Kernel in QEMU and Debugging It With GDB 2018 Jun 2 Speeding Up Linux Kernel Builds With ccache 2017 Sep 5 GCC vs LLVM Q3 2017 Commit Rates and Active Developer Counts 2017 May 31 Running Clang-Tidy (..)

C++ 40

C++ Speed Development 40

Brendan Gregg

DECEMBER 21, 2019

Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this. This is the culmination of five years of work: the BPF kernel runtime, C support, LLVM and Clang support, the BCC front-end, and finally the bpftrace language. This is not my best code, since I hacked it in a hurry, but here it is: #!/usr/bin/python

C++ 52

C++ Education Java AWS 52

Brendan Gregg

DECEMBER 21, 2019

Embedded C. # # Tone generation from: [link] # # 29-Apr-2019 Brendan Gregg Created this. This is the culmination of five years of work: the BPF kernel runtime, C support, LLVM and Clang support, the BCC front-end, and finally the bpftrace language. This is not my best code, since I hacked it in a hurry, but here it is: #!/usr/bin/python

C++ 52

C++ Education Java AWS 52

SQL Performance

DECEMBER 9, 2020

L0 AS ( SELECT 1 AS c. Figure 1: Plan for base CTE cardinality of 2.

C++ 61

C++ Servers Testing Code 61

SQL Performance

JULY 1, 2019

On SQL Server 2014 and earlier, the plan is: For SQL Server 2016 or later, you will see: Both plans are safe, but for different reasons. The more complex SQL Server 2016+ plan does not use the ANY aggregate at all. Reproducing the bug in SQL Server 2016+. This plan shape is always safe, since no ANY aggregates are used.

C++ 58

C++ Servers Database Performance 58

SQL Performance

OCTOBER 29, 2019

CustomerID , c. Customers c JOIN Sales. CustomerTransactions ct ON c. GROUP BY c. CustomerID , c. ORDER BY ExecutionCount DESC ; Note: The sys.dm_exec_function_stats DMV was added in SQL Server 2016. AccountOpenedDate , COUNT ( ct. CustomerTransactionID ) FROM Sales. CustomerID = ct. CustomerID.

C++ 74

C++ Database Servers Tuning 74

Randon ASCII

JANUARY 22, 2017

In August of 2016 Chrome switched meta-build systems, from gyp to gn. It’s also peculiar because log2f is a C Run-Time (CRT) function, which shouldn’t be supplied by Blink anyway. The symbol search order is unspecified by C++ and due to the One Definition Rule (ODR) the search order should not matter.

C++ 56

C++ Code Processing Systems 56

O'Reilly

FEBRUARY 4, 2025

Then, development of even higher-level compiled languages like Fortran, COBOL, and their successors C, C++, and Java meant that most programmers no longer wrote assembly code. It lets a programmer use a human-like language to tell the computer to move data to locations in memory and perform calculations on it.

Programming 145

Programming Google Infrastructure Internet 145

Percona

AUGUST 18, 2023

In the SYSTEMD configuration file, %I will be replaced with the naming convention that you use. root@ip-172-31-128-38 share]# cat /usr/lib/systemd/system/mysqld@.service

Programming 98

Programming Servers Database Open Source 98

SQL Performance

SEPTEMBER 5, 2019

You will need SQL Server 2016 (or later) and Developer Edition (or equivalent) to reproduce the results shown here. CREATE CLUSTERED COLUMNSTORE INDEX c ON #T WITH ( MAXDOP = 1 ) ; Run the following test queries against the new columnstore table: SELECT. c1 = @Start + N. FROM #Numbers AS N ; GO. m = MAX ( T.

Performance 81

Performance C++ Storage Servers 81

Adrian Cockcroft

JANUARY 29, 2023

I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ). > system.time(wait1 <- normalmixEM(waiting, mu=c(50,80), lambda=.5, I’ve been thinking about this for a long time.

Lambda 98

Lambda Latency Cache C++ 98

Scalegrid

JANUARY 19, 2024

The files look something like this: <dbname> <collectionname> 2016-02-08T19-34-44.0.bson bson Load the data from the rollback into a separate database or server The general preference is to copy the rollback files to a new server and use mongorestore to load them into the server.

Database 130

Database Network Servers Monitoring 130

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). I wrote about it in a previous post, [DTrace for Linux 2016]. Hit Ctrl-C to end. ^C C operation = 'read' usecs : count distribution 0 -> 1 : 0 | | 2 -> 3 : 0 | | 4 -> 7 : 4479 | *| 8 -> 15 : 1028 | | 16 -> 31 : 14 | | 32 -> 63 : 1 | | [.]. The hardest part on Linux is now done: kernel support.

Virtualization 75

Virtualization AWS Engineering Hardware 75

SQL Performance

SEPTEMBER 25, 2019

This value is hard-coded into SQL Server and has not been changed following the increase to 1700 bytes for nonclustered index keys from SQL Server 2016 onward. c1 UNION SELECT NULL ) AS U ) AS CA ( c ) ; Notice the Stream Aggregate below the Lazy Index Spool. Optimizer Rules. FROM #T1 AS T1 CROSS APPLY. (

Performance 104

Performance Cache Servers Education 104

Rigor

JANUARY 13, 2020

These are the bestsellers in the web performance field, including the good old Speed Up Your Site (2003) by Andy King; Steve Souders’ Even Faster Web Sites (2009) ; Ilya Grigorik’s High Performance Browser Networking (2013) ; Tammy Everts’ Time is Money (2016) ; and a handful of more recent publications.

Performance 75

Performance Social Media Website Website Performance 75

Smashing Magazine

JULY 6, 2021

With Luminary’s 21 years of experience in the digital space, my experience of 17 years in the CMS space as well as our focus on Headless since 2016, here are my two cents on what you should look out for. Things To Consider When Choosing A Headless CMS. Microservices architecture. Omnichannel. For content authors.

Cache 145

Cache Website Mobile Google 145

Brendan Gregg

OCTOBER 7, 2018

C @ns: [256, 512) 10900 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ | [512, 1k) 18291 |@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@| [1k, 2k) 4998 |@@@@@@@@@@@@@@ | [2k, 4k) 57 | | [4k, 8k) 117 | | [8k, 16k) 48 | | [16k, 32k) 109 | | [32k, 64k) 3 | |. ply is also C, whereas bpftrace is C++. # Attaching 2 probes. ^C

C++ 40

C++ Virtualization Programming Latency 40

Alex Russell

SEPTEMBER 12, 2016

Instead, this article focuses on the strictest common criteria to ensure broad installability as of late 2016. In US educational terms, doing well in these criteria will be the difference between a C- and an A-: Mobile-friendly design. Similarly, per-browser criteria are not cataloged. Proprietary and legacy technologies (e.g.,

Mobile 54

Mobile Network Education Design 54

Tech News Gather

NOVEMBER 22, 2022

Programmers are shifting to the more result-oriented and user-friendly Kotlin programming language due to its high compatibility with Java and Objective C and its excellent tooling support. in 2016 after five years of existence. Java is now widely regarded as an antiquated programming language that does not support modernization.

Development 52

Development Java Programming Google 52

Smashing Magazine

FEBRUARY 8, 2022

In 2016, I released the first version of the tool, then called not Statoscope, but Webpack Runtime Analyzer. These two packages both use the same Package C — but different versions. It turns out that suddenly a double of Package C appears in your bundle. Statoscope: A Course Of Intensive Therapy For Your Bundle.

Storage 89

Storage Code Metrics C++ 89

Randon ASCII

FEBRUARY 25, 2018

In September of 2016 we started noticing random failures when building Chrome – 3 out of 200 builds of Chrome failed when protoc.exe, one of the executables that is part of the build, crashed with an access violation. The next step was a custom C++ program that opened the just-linked exe and called FlushFileBuffers on it.

Programming 79

Programming Hardware Cache Code 79

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. STRING_SPLIT() in SQL Server 2016 : Follow-Up #1. STRING_SPLIT() in SQL Server 2016 : Follow-Up #2. all_columns AS c WHERE EXISTS. ( WHERE Item = c. ) ORDER BY c. [

C++ 46

C++ Servers Testing Performance 46

SQL Server According to Bob

JANUARY 5, 2017

By March of 2016 Slava had convinced me to join the team. int c = a + b; 0134167C 8B 45 F8 mov eax,dword ptr [a]. 01341682 89 45 E0 mov dword ptr [c],eax. He started me off with an easy project. Upgrade the complier and get SOS to boot below Win32. Let’s look at a more concrete example of adding two numbers.

Servers 40

Servers Operating System C++ Software Engineering 40

John McCalpin

NOVEMBER 5, 2016

In the latest (October 2016) revision of Intel’s Instruction Extensions Programming Reference , Intel has disclosed a fairly dramatic departure from these “traditional” approaches. Notes on notation: C[i][j] is invariant in the innermost loop, so I refer to the values in the accumulator as elements of the C array.

Cache 40

Cache C++ Latency Hardware 40

Nick Desaulniers

NOVEMBER 20, 2016

clang -c x.c If you run otool -L on libSystem itself, you’ll see it depends on a bunch of other libraries including a C runtime, malloc implementation, pthreads implementation, and more. is part of libc, which is probably the most shared dynamic library on most computing devices since most every program makes use of the C runtime. (I

C++ 48

C++ Programming Code Virtualization 48

J. Paul Reed

JANUARY 24, 2017

In the vein of my 2016 prediction that DevOps will continue dis-integrating , I believe that we’ll see a process of “ othering ” with definitions of DevOps that are not highly aligned with the The Handbook’s definition, along with pressure to rename those ideas to soemthing other than “DevOps.” And we now have that.

DevOps 40

DevOps Engineering IoT C++ 40

Tech News Gather

JUNE 9, 2022

nd of 2016. r a luxury – th?y ntial part of our liv?s. In fact, according to P?w ricans now own a smartphon?. And this numb?r r is only going to grow in th? ars to com?. an for busin?ss?s? ans that you can see no long?r signing your mark? r of mobil? apps is growing at an incr?dibl? than 700,000 apps. r of mobil? than 2 billion by th? ?nd

Mobile 52

Mobile Virtualization C++ Google 52