Remove c
article thumbnail

Dealing With “Too Many Connections” Error in MySQL 8

Percona

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 94
article thumbnail

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Percona

Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. Type 'c' to clear the current input statement. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Type 'c' to clear the current input statement. copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

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

How Many Warehouses for the HammerDB TPC-C Test?

HammerDB

The official TPC-C test has a fixed number of users per warehouse and uses keying and thinking time so that the workload generated by each user is not intensive. Also depending on your chosen database some database software will not scale to fully utilise all cores, see the best practice guides for guidance on your chosen database.

C++ 40
article thumbnail

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

Percona

The need to audit who is using a database and their activities is crucial in many environments. 22 Percona Server (GPL), Release '22', Revision '7e301439b65' Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Type 'c' to clear the current input statement.

article thumbnail

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Percona

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. Type 'c' to clear the current input statement. deb (Reading database. bullseye_amd64.deb.

Servers 84
article thumbnail

Back-to-Basics Weekend Reading - Epidemics - All Things Distributed

All Things Distributed

Werner Vogels weblog on building scalable and robust distributed systems. My paper to read this weekend was the Alan Demers seminal paper on epidemic techniques for database replication. reliable and scalable distributed systems. scalable distributed systems. Epidemic algorithms for replicated database maintenance.

article thumbnail

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

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? KB boundary   12 Larger transaction logs   13 Restore and attach   14 Format for 4 ?KB

Servers 40