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 Trying to reconnect.

Servers 110
article thumbnail

Webinar Tuesday, 8/28: Forking or Branching – Lessons from the MySQL Community

Percona

Peter Zaitsev co-founded Percona and assumed the role of CEO in 2006. Peter frequently speaks as an expert lecturer at MySQL and related conferences, and regularly posts on the Percona Database Performance Blog. Register for the webinar. Peter Zaitsev, CEO and Co-Founder.

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

A survival strategy for the digital transformation

All Things Distributed

Since 2006, Amazon Web Services has introduced far more than 2,500 new services and features, and around 90% of them were the result of wishes articulated directly by customers. We found out that by organizing our innovation efforts around customers' needs, we could innovate very fast.

Strategy 112
article thumbnail

Self-Insuring Software Assets

The Agile Manager

If regulation changes and we need to capture additional data, if a nightly data import process chokes on a value we hadn't anticipated, if our stored procedures mysteriously fail after a database upgrade, if the latest release of FireFox doesn't like the Javascript generated by one of our helper classes, it's our problem to sort out.

article thumbnail

Impact of DDL Operations on Aurora MySQL Readers

Percona

Connection id: 22 Current database: db + --+ | connection_id() | + --+ | 22 | + --+ 1 row in set (3.19 If you are performing frequent DDL operations in your database, it is not recommended to take logical backups from Aurora Reader. Trying to reconnect. What are the issues? What is the solution?

Storage 94
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). Peter Zaitsev co-founded Percona and assumed the role of CEO in 2006. Register Now. Register for the webinar. Peter Zaitsev, CEO and Co-Founder.

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