Percona

JUNE 4, 2023

Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. Efficient data processing and indexing, making it optimal for executing queries and handling large datasets.

Open Source 52

Open Source Servers Storage Scalability 52

Randon ASCII

JANUARY 22, 2017

The savings this time are less important as they are mostly in the.BSS segment, but there are also some modest code-size savings, and some interesting lessons. In August of 2016 Chrome switched meta-build systems, from gyp to gn. This was a painful process. The process continues until all symbols are resolved.

C++ 56

C++ Code Systems Processing 56

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. To do this, the tool should have the ability to add code to (or invoke code from) your script. Tools, using standard languages such as C (e.g.

Performance Testing 100

Performance Testing Technology Technology Testing 100

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

SQL Performance

OCTOBER 14, 2020

In Part 4 of the series, which focused on optimization of derived tables, I described a process of unnesting/substitution of table expressions. The TL;DR version of substitution/unnesting of CTEs is that the process is the same as it is with derived tables. Here’s the attempted solution using a CTE: WITH C AS. ( FROM Sales.

C++ 140

C++ Servers Code Efficiency 140

SQL Performance

APRIL 20, 2021

We are now ready to start the query scan, perform some early phase processing, and start the first additional parallel tasks. The query processor begins execution by starting the query scan process via a call to CQueryScan::StartupQuery. The same goes for branch C and branch D, giving a total of six additional tasks.

C++ 98

C++ Processing Servers Cache 98

SQL Server According to Bob

FEBRUARY 10, 2019

– -c the control file. We then found a few code paths in find login that did not switch to preemptive before making a call to SSSD or LDAP for Linux, AD activities. If the login was in the middle of processing pre-login the ring buffer entry may show time spent in SSL, reads, etc and the disconnect. ·

Servers 40

Servers Network Database Systems 40

SQL Performance

OCTOBER 14, 2020

In Part 4 of the series, which focused on optimization of derived tables, I described a process of unnesting/substitution of table expressions. The TL;DR version of substitution/unnesting of CTEs is that the process is the same as it is with derived tables. Here’s the attempted solution using a CTE: WITH C AS. ( FROM Sales.

C++ 52

C++ Servers Code Efficiency 52

SQL Server According to Bob

JANUARY 28, 2018

The import process establishes communication between MSTDC (B) and MSDTC (A), creating the proper superior to subordinate relationship, adding DTC voting endpoints and returning an ITransaction to SQL Server. SQL Server also supports XA based transactions but has no code in the SQL Server engine to engage in XA transactions.

Servers 40

Servers Azure Engineering Java 40

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

Smashing Magazine

FEBRUARY 8, 2022

In 2016, I released the first version of the tool, then called not Statoscope, but Webpack Runtime Analyzer. We don’t need the second export, so we can painlessly remove it without harming the bundled code. This is all part of Webpack’s optimization process, in order to reduce the size of output assets. Sergey Melukov.

Storage 79

Storage Code Metrics C++ 79

Brendan Gregg

SEPTEMBER 5, 2017

LTS (April 2016). It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process).

Virtualization 76

Virtualization AWS Engineering Hardware 76

Nick Desaulniers

NOVEMBER 20, 2016

Let’s say we wanted to reuse some of the code from our previous project in our next one. clang -c x.c While static libraries allowed us to reuse source code, static linkage does not allow us to reuse memory for executable code between different processes. This is the second post in a series on memory segmentation.

C++ 48

C++ Programming Code Virtualization 48

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. Explanation.

Performance 81

Performance C++ Storage Servers 81

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. Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes?

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. SQL Server Split String Replacement Code with STRING_SPLIT. WHERE Item = c.

C++ 59

C++ Servers Testing Database 59

Smashing Magazine

JULY 6, 2021

Moving to a headless CMS is not an easy decision and the selection process should not be taken lightly. 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. Microservices architecture.

Cache 143

Cache Website Mobile Google 143

SQL Performance

SEPTEMBER 25, 2019

You can read more details about the process in my Query Optimizer Deep Dive series. 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. As part of that process, an estimated cost is calculated. Optimizer Rules.

Performance 104

Performance Cache Servers Education 104

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. Code that had duplication all over the place? Chances are you were dealing with legacy code that was written years ago. In my 15+ years of coding, every single time I've dealt with legacy code, fear, anger, hate, and suffering were pretty common.

Architecture 49

Architecture Database Code Systems 49

Alex Russell

MAY 9, 2022

Effective managers understand that products require processes to manage, yet front-end discourse assumes that switching frameworks will introduce a golden age. Who owns this code? When sibling teams are brought in to integrate late in the process, attention to the cumulative experience may suffer. Why is it there?

Performance 86

Performance Latency Metrics Engineering 86

SQL Server According to Bob

DECEMBER 18, 2018

Before all was said and done, all of these people and more helped with various activities: · Eugene, Mike, Slava, Scott, Peter, Steve and others doing code reviews on my SQL Server and Host Extension changes. · Red Hat, SUSE, HPE, Intel helping and confirming Linux behaviors and making file system code changes. When SQL Server 7.0

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

OCTOBER 26, 2018

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. Recommended reading : WordPress Security As A Process. Before we delve deeper in the code, a couple more things about WordPress REST API.

Cache 78

Cache Website Speed Database 78