article thumbnail

Auto-Increment Counter Persistence in MySQL 8: Comparing the Evolution From MySQL 5.7

Percona

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

Servers 113
article thumbnail

Upcoming Webinar Tuesday, 7/31: Using MySQL for Distributed Database Architectures

Percona

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Such architectures bring many benefits (such as scalability and resiliency), but can also bring a lot of pain if incorrectly designed and executed.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Why Waits Alone Are Not Enough

SQL Performance

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
article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

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

article thumbnail

Front-End Testing is For Everyone

CSS - Tricks

Cem Kaner, “Exploratory Testing” (November 17, 2006). However, it won’t necessarily check if the item was actually removed from the database?—?that Web accessibility means that websites, tools, and technologies are designed and developed so that people with disabilities can use them.

Testing 95
article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

© ​​ 2006 ​​ Microsoft Corporation. KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? ​​ All rights reserved.

Servers 40
article thumbnail

Improving The Performance Of Wix Websites (Case Study)

Smashing Magazine

It was founded in 2006 and has since grown to have over 210 million users in 190 countries, and hosts over five million domains. There are more challenges for us in addition to scale and diversity: Retaining existing design and behavior. As a result, we cannot optimize for a specific layout or set of features that are known in advance.

Website 126