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 112
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.

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

Impact of DDL Operations on Aurora MySQL Readers

Percona

Connection id: 22 Current database: db + --+ | connection_id() | + --+ | 22 | + --+ 1 row in set (3.19 To understand this better let’s see what happens when we perform any DDL operation in a binary log-based replication environment and in the Aurora replication environment. Trying to reconnect. What are the issues?

Storage 94
article thumbnail

Why Waits Alone Are Not Enough

SQL Performance

"Waitstats helps us identify performance-related counters. But waits information by itself isn't enough to accurately diagnose performance problems. The queues component of our methodology comes from Performance Monitor counters, which provide a view of system performance from a resource standpoint.".

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

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 was an early employee at MySQL AB, eventually leading the company’s High-Performance Group. Peter is a co-author of High-Performance MySQL: Optimization, Backups, and Replication , one of the most popular books on MySQL performance.

article thumbnail

AWS EC2 Virtualization 2017: Introducing Nitro

Brendan Gregg

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. The latest AWS hypervisor, Nitro, uses everything to provide a new hardware-assisted hypervisor that is easy to use and has near bare-metal performance.