Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. sec) service mysql restart mysql> select * from users; ERROR 2006 (HY000): MySQL server has gone away No connection. Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00 Trying to reconnect.

Servers 108

Servers Storage Database Open Source 108

SQL Performance

JANUARY 23, 2020

Waits and Queues has been used as a SQL Server performance tuning methodology since Tom Davidson published the above article as well as the well-known SQL Server 2005 Waits and Queues whitepaper in 2006. Recently, a SentryOne customer contacted me about performance concerns with their SentryOne database. The Top Queries That Weren't.

Tuning 115

Tuning Servers Monitoring Hardware 115

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. 2006-01-01

Database 40

Database Analytics Blockchain Healthcare 40

Brendan Gregg

NOVEMBER 29, 2017

At Netflix, we've been using these technologies as they've been made available for instance types in the AWS EC2 cloud. It's amazing to recall that it was even possible to virtualize x86 before processors had hardware-assisted virtualization (Intel VT-x and AMD-V), which were added in 2005 and 2006. The first was c3.

Virtualization 111

Virtualization AWS Hardware Storage 111

All Things Distributed

MAY 18, 2010

Amazon Simple Storage Service (S3) was launched in 2006 as "Storage for the Internet" with the promise to make web-scale computing easier for developers. For example to ensure availability of data, the data is replicated over multiple locations such that failure modes are independent of each other. Amazon DynamoDB â??

Storage 72

Storage Cloud AWS Scalability 72

CSS - Tricks

JUNE 1, 2021

Cem Kaner, “Exploratory Testing” (November 17, 2006). However, it won’t necessarily check if the item was actually removed from the database?—?that We have all kinds of accessibility tooling , and it’s worth having a plan for what to test and the tooling that’s available to hit those points. Visual regression testing.

Testing 95

Testing Performance Testing Website Code 95

SQL Performance

SEPTEMBER 25, 2020

Back in 2006, I complained via multiple Connect items about the lack of visibility of the default values for parameters in the catalog views. Add-Type -Path "Microsoft.SqlServer.TransactSql.ScriptDom.dll" ; # set up a parser object using the most recent version available. However, the problem still exists in SQL Server 2019.

Code 42

Code C++ Database Servers 42