Percona

JULY 19, 2023

Well, “easy” if you know just a tiny bit of C++. Our function will implement a ULID generator using a C++ library from ChrisBove/ulid. Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $ cd ~/percona-server-8.0.32-24/plugin/ulid/

C++ 77

C++ Servers Benchmarking Best Practices 77

Dynatrace

AUGUST 7, 2023

Developers use generative AI to find errors in code and automatically document their code. They can also use generative AI for cybersecurity, write prototype code, and implement complex software systems. Visit our booth, number #2608, at Black Hat and c heck out our guide below. Here’s what you need to know.

DevOps 184

DevOps Analytics Best Practices Java 184

SQL Performance

APRIL 13, 2022

I’ll start by presenting a generalized form of the challenge. I’ll present a generalized form of Erland’s original islands challenge. I’ll present a generalized form of Erland’s original islands challenge. Use the following code to create the helper function GetNums: CREATE FUNCTION dbo. L0 AS ( SELECT 1 AS c.

C++ 136

C++ Strategy Testing Servers 136

SQL Performance

JULY 13, 2022

This could also happen if you need to migrate code written for another database platform with a different dialect of SQL to T-SQL. Use the following code to create the Orders table and populate it with a small set of sample data to help you verify the validity of the solutions: SET NOCOUNT ON ; USE tempdb ; DROP TABLE IF EXISTS dbo.

C++ 112

C++ Code Azure Database 112

Percona

APRIL 21, 2023

The major problem it causes during a planned change in a MySQL replication topology is that the transaction is not present in the binlog and hence cannot be sent over to the replica, which causes a replication error. root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306

C++ 80

C++ Monitoring Database Open Source 80

Sutter's Mill

SEPTEMBER 25, 2022

[Edited to add pre-publication link to next draft of P2392, revision 2, and correct iterator comparison] Brief background As I presented at CppCon 2021 starting at 11:15 , I’m proposing is (a general type or value query) and as (a general cast, for only the safe casts) for C++ evolution. in requires clauses, in general code).

C++ 96

C++ Testing Code Systems 96

SQL Performance

MAY 11, 2022

Similarly, what if other elements in the query besides window functions also require arranging input data as ordered in the plan, such as a presentation ORDER BY clause? You can download the source code to create and populate this database here. But what about queries involving multiple window functions with different ordering needs?

C++ 133

C++ Database Servers Code 133

Percona

JUNE 20, 2023

In order to understand “segmentation fault,” it is a must to know the basic idea of segmentation and its implementation in C programming. Here, memory is divided into equal sizes of partitions where the code of a program resides. ” Below is a line of code that results in a segmentation fault on PostgreSQL 13.4

Programming 80

Programming C++ Database Virtualization 80

SQL Performance

FEBRUARY 12, 2020

According to the standard, you would use the following code with the DISTINCT predicate to handle this need: SELECT orderid , shippeddate FROM Sales. According to the standard, you would use the following code to handle such a join: SELECT T1. INNER JOIN dbo. k1 IS NOT DISTINCT FROM T2. k2 IS NOT DISTINCT FROM T2. CREATE TABLE dbo.

C++ 120

C++ Code Servers Database 120

SQL Performance

MAY 13, 2020

I just wanted to mention some use cases here to illustrate how important table expressions are in our T-SQL code, and why it's worthwhile to invest in understanding their fundamentals well. However, from relational theory's standpoint, there's a deeper meaning to what C represents. C is what's known as a range variable.

C++ 143

C++ Code Design Servers 143

SQL Performance

DECEMBER 9, 2020

I’ll present the performance tests that I’ve done with my solution. Use the following code to run a test with base CTE cardinality of 2 (requires 5 additional levels of CTEs): DECLARE @low AS BIGINT = 1 , @high AS BIGINT = 100000000 ; WITH. Testing different base table cardinalities is just one dimension to try.

C++ 114

C++ Servers Testing Processing 114

SQL Performance

JANUARY 13, 2021

Here’s the code to create the dummy table: CREATE TABLE dbo. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; And here’s the code defining the dbo.GetNumsItzikBatch function: CREATE OR ALTER FUNCTION dbo. L0 AS ( SELECT 1 AS c. L0 AS ( SELECT 1 AS c. BatchMe ON 1 = 0.

C++ 113

C++ Code Testing Processing 113

Sutter's Mill

SEPTEMBER 24, 2019

Yesterday, I received this question from a distinguished C++ expert who served on the ISO C++ committee for many years. The email poses a decades-old question that still has the classic roll-your-own answer in C++ Core Guidelines #C.130 macros ), C++11/14/17 features (e.g., decltype ), draft C++20 features (e.g.,

C++ 73

C++ Code 73

SQL Performance

MARCH 10, 2021

Here’s the code to create the dummy table: DROP TABLE IF EXISTS dbo. BatchMe ( col1 INT NOT NULL , INDEX idx_cs CLUSTERED COLUMNSTORE ) ; And here’s the code with the definition of the dbo.GetNumsAlanCharlieItzikBatch function: CREATE OR ALTER FUNCTION dbo. BatchMe ; GO. CREATE TABLE dbo. BatchMe ON 1 = 0. and dbo.T3

C++ 134

C++ Testing Code Servers 134

Adrian Cockcroft

JANUARY 29, 2023

I presented this analysis of response time distributions talk in 2016 — at Microxchg in Berlin ( video ). The code is written using the R statistics language and I downloaded a free copy of RStudio to run the examples below. > > system.time(wait1 <- normalmixEM(waiting, mu=c(50,80), lambda=.5,

Lambda 98

Lambda Latency Cache C++ 98

Percona

JUNE 4, 2023

Disadvantages: While MariaDB is a popular and widely-used RDBMS, it can present some disadvantages to users that may not be present in others. now a release candidate) SQL – Window Functions Present in MariaDB Server 10.2 now a release candidate) SQL – Window Functions Present in MariaDB Server 10.2

Open Source 52

Open Source Servers Storage Scalability 52

Adrian Cockcroft

FEBRUARY 9, 2023

We wanted AWS to grow its platform functionality, and to continually eat away at the bottom of the thin layer of rapidly evolving Netflix specific platform code that we had built. I was thinking about drawing a layer cake diagram to show this but decided to put it on a Wardley Map instead (created using mapkeep.com).

Engineering 137

Engineering Serverless Lambda AWS 137

Sutter's Mill

FEBRUARY 23, 2020

This post is an attempt to shed light on this situation, and perhaps reduce some of the time spent on unresolved ongoing design debates in the C++ community. References What references are and how to use them In C++, a C& or C&& reference is an indirect way to refer to an existing object. That’s it.

C++ 75

C++ Lambda Games Design 75

SQL Performance

JULY 1, 2021

When you're automating an index maintenance solution or deploying new compression settings across your environment, it is a bit more of a pain in the behind to make your solution handle present or future state. name , [ Column ] = c. name , [ Data Type ] = TYPE_NAME ( c. name , [ Column ] = c.

C++ 58

C++ Database Servers Performance 58

Sutter's Mill

FEBRUARY 25, 2021

Explain your answer using the following example, which uses a variation of a proposed post-C++20 syntax for preconditions. [1] GUIDELINE: Use a precondition to write “this is what a bug is” as code the caller can check. A precondition states in code the circumstances under which this function’s behavior is not documented.

C++ 49

C++ Code Testing Systems 49

Sutter's Mill

AUGUST 13, 2023

Thanks again to C++ Now for inviting me to speak this year in glorious Aspen, Colorado, USA! The talk I gave there was just posted on YouTube, you can find it here: At CppCon 2022, I argued for why we should try to make C++ 10x simpler and safer , and I presented my own incomplete experimental compiler, cppfront.

C++ 89

C++ Efficiency Design Virtualization 89

SQL Performance

DECEMBER 9, 2020

I’ll present the performance tests that I’ve done with my solution. Use the following code to run a test with base CTE cardinality of 2 (requires 5 additional levels of CTEs): DECLARE @low AS BIGINT = 1 , @high AS BIGINT = 100000000 ; WITH. Testing different base table cardinalities is just one dimension to try.

C++ 61

C++ Servers Testing Processing 61

Sutter's Mill

MAY 28, 2012

It’s time for, not one, but two brand-new, up-to-date talks on the state of the art of concurrency and parallelism in C++. I’m going to put them together especially and only for C++ and Beyond 2012 , and I’ll be giving them nowhere else this year: C++ Concurrency – 2012 State of the Art (and Standard). And there’s a lot to tell.

C++ 40

C++ Hardware Best Practices Tuning 40

SQL Performance

SEPTEMBER 12, 2019

The main benefit of the PIVOT operator is that it tends to result in shorter code. However, this operator has a few shortcomings, among them an inherent design trap that can result in bugs in your code. You can find a clue that will help you figure out the bug in the code by looking at the query plan shown in Figure 1.

Best Practices 103

Best Practices C++ Code Design 103

HammerDB

JULY 14, 2021

However, as the two databases diverged from a shared common codebase, this presented a challenge in that it was not possible to modify the workload for MySQL or MariaDB without also changing the other. dbset db maria dbset bm TPC-C diset connection maria_socket /tmp/mariadb10234.sock Prior to HammerDB v4.2 HammerDB v4.2 linux-x86_64.tar.gz

Testing 57

Testing C++ Virtualization Tuning 57

SQL Performance

DECEMBER 11, 2019

Like them or not, as a database practitioner you often have to deal with them, and given that NULLs do add complexity to your SQL code writing, it's a good idea to make it a priority to understand them well. An order that was shipped will always have a present and relevant shipped date. But what about rows with a NULL shipped date?

Best Practices 117

Best Practices C++ Database Code 117

SQL Performance

OCTOBER 1, 2020

And with the Visitor code I provided, the output to the console was: ==. a AS /* comment here because -- chaos */ int = 5 , @b AS varchar ( 64 ) = 'AS = /* BEGIN @a, int = 7 */ ' 'blat' '' , @c AS int = -- 12. Param name: @c. Previously, I used a simple example like this: CREATE PROCEDURE dbo. procedure1. Default: -64.

C++ 57

C++ Code Database Systems 57

Percona

AUGUST 16, 2023

In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free databases. PostgreSQL developers and database administrators often deal with complex SQL queries, making code readability a critical factor for productivity. What is pgFormatter?

Code 74

Code Best Practices Open Source C++ 74

Rigor

JANUARY 13, 2020

This book presents 14 specific rules that will cut 25% to 50% off response time when users request a page. Steve Souders, plus Dion Almaer, Doug Crockford, Ben Galbraith, Tony Gentilcore, Dylan Schiemann, Stoyan Stefanov, Nicole Sullivan, Nicholas C. Want your web site to display more quickly? Even Faster Websites. Using Webpagetest.

Performance 75

Performance Social Media Website Website Performance 75

Brendan Gregg

JULY 2, 2021

Here are the top ten tools you can run and present as a generic BPF observability dashboard, along with suggested visualizations: Tool Shows Visualization. This is thinking like a sysadmin who installs and maintains software, and not like a programmer who codes everything. as a traced function was renamed or a new code path added.

Latency 145

Latency Cache Energy Systems 145

SQL Performance

MAY 1, 2020

There's a lot to unpack from this graphic, but this is the raw data I used to present my argument ( click to enlarge ): My evidence. availability_databases_cluster AS c ON s. group_id = c. AND is_read_only = 0. AND NOT EXISTS. ( ( SELECT 1 FROM sys. dm_hadr_availability_replica_states AS s INNER JOIN sys.

C++ 58

C++ Database Servers Storage 58

Software Architecture

APRIL 8, 2018

Kotlin’s official documentation is great and there are many introductory articles to Kotlin language on medium, so I won’t be explaining the basics and syntax but wanted to present some unique features that Java doesn’t have and makes Kotlin stand out. Kotlin’s type system eliminates the danger of null references from code.

Java 100

Java Lambda Software Architecture Programming 100

Adrian Cockcroft

JUNE 21, 2022

I also learned how marketing worked, and began to build my presentation and training skills as I was sent around the world by Sun to teach workshops and speak at events. I still code in R… One role I had for many years was to lead technical training events for the global specialist systems engineers, which we called the Ambassador Program.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Brendan Gregg

AUGUST 29, 2021

100.00 ^C I'm looking at the r_await column in particular: the average wait time for reads in milliseconds. Hit Ctrl-C to end. ^C Hit Ctrl-C to end. ^C The developers can also rework the code with the memory constraint in mind to improve performance (e.g., avg-cpu: %user %nice %system %iowait %steal %idle 14.81

Cache 40

Cache C++ AWS Systems 40

CSS Wizardry

OCTOBER 16, 2023

Concatenate Concatenation is probably the trickiest bit to get right because, even though the three C s happen in order, decisions we make later will influence decisions we make back here. This is because, at present, algorithms like Gzip and Brotli become more effective the more historical data they have to play with. The Client.

Cache 291

Cache Latency Strategy Speed 291

ScaleOut Software

MAY 6, 2020

Developers need to write code that extracts patterns out of an incoming telemetry stream and take appropriate action. This model uses standard object-oriented techniques to let developers easily specify both the state information to be maintained for each data source and the code required to process incoming messages from that data source.

Development 52

Development Analytics Database Programming 52

ScaleOut Software

MAY 6, 2020

Developers need to write code that extracts patterns out of an incoming telemetry stream and take appropriate action. This model uses standard object-oriented techniques to let developers easily specify both the state information to be maintained for each data source and the code required to process incoming messages from that data source.

Development 52

Development Analytics Database Programming 52