SQL Performance

OCTOBER 18, 2022

In my examples, I’ll use the sample database TSQLV6. You can download the script file to create and populate this database here and find its ER diagram here. Feature availability and optimization could change in future builds of the product. I’ll also describe cases where you might still need to use the older workaround.

Servers 144

Servers Code Best Practices Database 144

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges.

Availability 87

Availability Open Source Architecture Database 87

Dynatrace

SEPTEMBER 23, 2021

Best practices for container security. Here is a checklist of best practices for how to approach container security. Secrets, such as database credentials, API keys, SSL keys or encryption keys, need to be managed to protect them from discovery. Pretty neat, isn’t it? Manage secrets. Run source code tests.

Open Source 249

Open Source Benchmarking Best Practices Network 249

The Netflix TechBlog

DECEMBER 11, 2020

For storing schema changes, we use an internal library that implements the event sourcing pattern on top of the Cassandra database. The DGS framework is planned to be open-sourced in early 2021. We engaged with them to determine graph schema best practices to best suit the needs of Studio Engineering.

Architecture 249

Architecture Best Practices Engineering Open Source 249

Smashing Magazine

JUNE 28, 2021

2021-06-29T05:30:00+00:00. 2021-07-13T02:07:04+00:00. There’s accessibility, best practices, performance and one fourth one. You just plug the theme provider in there and Chakra does the rest of the work and it just becomes available everywhere. Some of these are actually available. Drew McLellan.

Website 62

Website Design Open Source Software 62

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Checking those available: $ cat /sys/devices/system/clocksource/clocksource0/available_clocksource. These can be invisible to top(8).

Speed 126

Speed Java AWS Virtualization 126

Smashing Magazine

JULY 2, 2021

2021-07-02T10:30:00+00:00. 2021-07-13T02:07:04+00:00. It is recommended to follow rules and best practices of building and sending emails. August 5–19, 2021. Make sure that the right database is selected (or the right list of contacts in your email marketing service). Email Testing Flow As It Should Be.

Testing 110

Testing Servers Social Media Automotive 110

Smashing Magazine

DECEMBER 22, 2021

2021-12-22T10:00:00+00:00. 2021-12-22T16:34:55+00:00. Their design tools database features tools for everything from UI design and prototyping, to user flow and handoff, design systems and versioning. The Ultimate Guide to UX Research shares tips and best practices from leading industry experts. Cosima Mielke.

Airlines 129

Airlines Mobile Design Strategy 129

Smashing Magazine

MAY 5, 2021

2021-05-05T10:30:00+00:00. 2021-05-05T16:06:35+00:00. However, in our pages, the case was different as our database stores lots of data, and we need to serve thousands of landing pages at scale. This data collection is being made available by inserting the JSON inside a script tag with id __NEXT_DATA__. Liran Cohen.

Google 111

Google Architecture Servers Speed 111

Smashing Magazine

SEPTEMBER 27, 2021

2021-09-27T11:30:00+00:00. 2021-09-27T14:10:09+00:00. Cypress provides some prewritten sample tests to showcase its features and give you some starting points — this is the reason for the tests that are available. However, due to run times, it is not advisable to cover every single available workflow.

Testing 135

Testing Website Code Efficiency 135

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. What is a Trigger in MySQL?

Cache 63

Cache Database Games Healthcare 63

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 40

Speed Java AWS Virtualization 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official recommendation (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 52

Speed Java AWS Virtualization 52

Smashing Magazine

JULY 20, 2021

2021-07-20T10:30:00+00:00. 2021-07-20T12:06:49+00:00. In this decoupled way, models and controllers are bundled on the WordPress side , handling data manipulation and database interaction. The goal is to provide high availability and performance by distributing the service spatially relative to end-users. “. Monolithic.

Website 142

Website Architecture Technology Technology 142

Smashing Magazine

AUGUST 12, 2021

2021-08-12T13:30:00+00:00. 2021-08-12T14:41:21+00:00. Thousands of avatars available straight from Figma: UI Faces. The plugin has a large library of (literally) millions of logos available at your fingertips. There is also a searchable database for you to find what you are looking for. Janet John. Large preview ).

Google 145

Google Design Code Mobile 145

O'Reilly

JULY 25, 2023

I guessed that maybe ChatGPT only knew about v2 since it was trained on open-source code from before September 2021 (its knowledge cutoff date) and v2 was the dominant format before that date. For a few years now Google has been transitioning developers to v3 , which I didn’t know about since I had no prior experience with Chrome extensions.

Programming 98

Programming Code Design Benchmarking 98

Smashing Magazine

NOVEMBER 12, 2021

2021-11-12T10:00:00+00:00. 2021-11-12T14:04:20+00:00. The plugin provides useful warnings and hints on the best practices. The API has been available in React, as an experimental feature, for a while but it became safe to use in React 16.3.0. The complete code is available on here. Ifeanyi Dike.

Code 118

Code Availability Efficiency Performance 118