Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [mysql-8.0]

MySQL version 8.0 - please also tag with mysql for search purposes.

Filter by
Sorted by
Tagged with
0 votes
0 answers
23 views

Upon PC restart, MySQL service on local computer "started and then stopped"

I'm working in MySQL on a local (Windows) computer. I have a somewhat recurring issue I have with managing the server. I cannot replicate this error because I do not know what causes it. Sometimes, I'...
ZZ Top's user avatar
  • 1
1 vote
0 answers
6 views

How to stop losing control of a user I just created due to SYSTEM_USER privilege in MySQL

We have recently been plagued by users getting created with the SYSTEM_USER privilege by users who don't have that privilege. What do we need to do from a systematic perspective to stop this from ...
juacala's user avatar
  • 125
0 votes
0 answers
37 views

MySQL Exec_Master_Log_Pos is slow to update in replica compared to actual data

I'm trying to use Exec_Master_Log_Pos from SHOW REPLICA STATUS to check whether the replica is caught up to the master. However, Exec_Master_Log_Pos appears to take a while to update. When I add a row ...
Victor L's user avatar
  • 101
0 votes
0 answers
18 views

Random MySql client error "got an error writing communication packets"

I have several different Linux servers running MySQL 8.0.x instances (ranging from 8.0.23 to 8.0.33). I occasionally get "error writing communication packets" from clients when connecting to ...
Alberto Pastore's user avatar
-3 votes
0 answers
14 views

My Table has the same values for primary Key and foreign key in MYSQL and it is giving me an error of 1062. How do I solve it?

CREATE TABLE DISTRIBUTION_COMPANIES ( ID INT PRIMARY KEY, COMPANY_NAME VARCHAR(30) ); INSERT INTO DISTRIBUTION_COMPANIES(ID, COMPANY_NAME) VALUES('1', 'COLUMBIA PICTURES'); INSERT INTO ...
ms08's user avatar
  • 1
0 votes
0 answers
32 views

MySQL 8 window functions optimization with multiple greatest-n-per-group

I'm struggling to make efficient this sort of query: with a as ( select -- the battery cycle cycles_bat_1, -- interested on a single result row per cycle, so using ...
Michele Mariotti's user avatar
0 votes
0 answers
25 views

MySQL Table Locks Immediate Metric

This Datadog graph is related to the Table Locks Immediate defined as the "number of times that a request for a table lock could be granted immediately" based on this. For over a year, this ...
Brian Estrada's user avatar
0 votes
0 answers
22 views

Can't get hostname for your address flooded in error log even if skip-name-resolve is enabled and many unauth users in processlist in percona 8.0.25

Information about the currently configured percona servers : We are using percona 8.0.25 server. Mysql service is running with skip-name-resolve enabled. host_cache_size=753 but the ...
Sana Ansari's user avatar
3 votes
1 answer
397 views

"#1292 - Incorrect datetime value" when time is within one hour

I'm running into a bizarre error with a timestamp column in a MySQL DB. When inserting the date/time value, it fails with a #1292 error if the time is between 02:00:00 and 02:59:59. Here is a sample ...
lcdservices's user avatar
0 votes
1 answer
25 views

Is there a way to send DDL query asynchronously, disconnect client & poll for completion?

AFAICT when you send a query to MySQL from any client it always blocks and waits for the server to respond with success or failure. When performing a slow operation like adding a new index on large ...
Anentropic's user avatar
0 votes
1 answer
47 views

Why does my IOPS keep increasing during bulk batch inserts?

The database in question: AWS RDS, MySQL 8, InnoDB. GP3 storage. I am attempting to do a bulk insert of rows to multiple tables in the db. I have omitted all secondary indexes from the target table, ...
Anentropic's user avatar
-1 votes
2 answers
39 views

How important is the "clustered" property of MySQL PK index?

I am importing ~50M rows into MySQL 8, InnoDB. It's on AWS RDS with GP3 storage. The unique key of the rows is a uuid-like string. When querying we will never care about this unique key, except when ...
Anentropic's user avatar
1 vote
1 answer
22 views

Will a replicated event cause issues?

I've got the replication configuration shown in the image. Everything replicates to everywhere. One of the tables maintains session data which has rows that must be deleted due to expiration. I ...
user22044385's user avatar
1 vote
1 answer
21 views

MySQL tempfolder Full

I have a mysql server hosted in an Azure VM. This is a slave where the data is being replicated from an on premise Master. Configurations are mentioned below. users are frequently getting an error ...
Vinodh Ashok's user avatar
1 vote
1 answer
35 views

How to choose hardware for MYSQL Server in Azure - Flexible Server

I have a MYSQL Flexible Server in Azure with the following hardware configuration: MYSQL 8.0 Compute Tier: Business Critical - 16 vCores Size: E16ds_v4 Storage: 269 GB AutoScale IOPS RAM: 128 GB I ...
SakZepelin's user avatar
0 votes
0 answers
17 views

Issue with group by on left join attempting to calculate totals

I have the following table (dummy data): project keyword_id listing_id clicks ctr impressions pos date 1 1 2 3 4 5 6 2024-04-14 1 1 3 3 4 5 6 2024-04-14 1 2 4 5 6 7 8 2024-04-14 1 2 5 5 6 7 8 ...
CSystems's user avatar
1 vote
0 answers
29 views

During starting InnoDB, error log shows 'Could not open log file.'

2024-04-11T05:07:26.565563Z 0 [System] [MY-015015] [Server] MySQL Server - start. 2024-04-11T05:07:26.742860Z 0 [System] [MY-010116] [Server] /opt/homebrew/Cellar/mysql/8.3.0_1/bin/mysqld (mysqld 8.3....
wang ted's user avatar
0 votes
1 answer
18 views

Convert character encoding in big database

We have big database (~1TB) and we need to update character encoding for all tables. I am running following SQL: SET FOREIGN_KEY_CHECKS = 0; ALTER DATABASE wallmob_etail CHARACTER SET utf8mb4 COLLATE ...
Justinas's user avatar
  • 101
0 votes
1 answer
114 views

How to set up component_keyring_file in MySql 8.3

I am trying to set up tablespace encryption in MySQL 8.3 and I can activate the keyring-file plugin. The plugin, however, throws a deprecation notice suggesting migration to component_keyring_file. I ...
Simas Joneliunas's user avatar
2 votes
0 answers
47 views

'Deadlock found when trying to get lock; try restarting transaction' in AWS RDS MySQL 8.0.36 after upgrading from MySQL 5.7.42. Django v4.1.6

Following an upgrade of our AWS RDS instance from MySQL version 5.7.42 to version 8.0.36, we are encountering persistent deadlock issues across concurrent transactions, affecting even basic read ...
Karan Raj's user avatar
1 vote
1 answer
32 views

Many items in `IN` clause causing full table scan earlier than expected

We have a search index table, provided by a CMS, that is of the form: CREATE TABLE `craft_searchindex` ( `elementId` int NOT NULL, `attribute` varchar(25) CHARACTER SET utf8mb3 COLLATE ...
msbit's user avatar
  • 121
-1 votes
2 answers
62 views

MySQL 8 - very slow query when ORDER BY is used with hash join

I encountered an issue today and I'm not sure if this is a bug in MySQL 8 or if I'm doing something wrong. Preface At the bottom of the post I attached a query to reproduce the issue locally. I have ...
samu's user avatar
  • 101
0 votes
1 answer
78 views

drop database hangs with "Waiting for table metadata lock" in MySQL8 RDS on AWS

We have a large table in a database that a user tried to run DELETE * FROM table on. It was still running the next day so we killed the process. I tried renaming, dropping and truncating the affected ...
George's user avatar
  • 126
0 votes
0 answers
9 views

KILL QUERY Flooding in General Query log for MySQL 8.0.25

Problem : We have two MySQL servers in master master replication. We can see many KILL QUERY statements in MySQL general log specific to stored procedures as below : 2024-03-20T21:54:45.056981+05:30 ...
Sana Ansari's user avatar
1 vote
0 answers
26 views

How to find IP subnet that is decomposed into multiple sub-one?

I have a table which like like that: Id IpRange Mask 1 127.0.0.0 24 2 127.0.1.0 24 3 127.0.2.0 24 I'm checking if an IP is in the range thanks to this : (inet_aton('here is the IP') & ((POWER(...
Elikill58's user avatar
  • 221
0 votes
0 answers
36 views

Reduce varchar column size in a production database

We have a database running on AWS Aurora Mysql with version 8.0.mysql_aurora.3.04.1 as a regional database. There is a table in it with a column with varchar size 200. We want to reduce it to varchar(...
Tanmay Sule's user avatar
0 votes
1 answer
55 views

What could cause replication to break on MySQL when replicating from 5.7.40 to 8.0 replica

We have a MySQL primary running on 5.7.40. We are in process of testing the upgrade to 8.0.36 (this is on AWS RDS). We had 2 MySQL-8 replicas and 2 MySQL-5.7 replicas replicating from the primary. At ...
Rahul's user avatar
  • 119
0 votes
0 answers
31 views

Performance Differences in JOIN query Between MySQL 5.7 and MySQL 8.0

Hello MySQL Community, I wanted to share some observations regarding the performance differences between MySQL 5.7 and MySQL 8.0, specifically related to join algorithms. In a recent project, I ...
Amarjit Singh's user avatar
0 votes
0 answers
27 views

Using Clone for addInstance on MySQL Innodb Cluster uses 100% Memory

When trying to add a new node to a MySQL Innodb cluster using Cluster.addInstance() and selecting the Clone option, within 2 or 3 minutes the donor nodes memory usages hits 100% on a server with 36Gb ...
mwarble's user avatar
0 votes
0 answers
61 views

Getting MySql Error 'aio read' returned OS error 0

MySql server goes down after running for couple of months. I can see below error in the MySQL error logs. 2024-02-12T14:15:58.414920Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' ...
thab's user avatar
  • 1
1 vote
2 answers
37 views

MySQL exclusive lock not appearing to work for new child rows

I have some logic in my application which I think results in the following MySQL calls, however when I get two of these run within a couple of milliseconds, I get two incompatible child rows. Start ...
mjaggard's user avatar
  • 125
0 votes
0 answers
29 views

INNODB FULLTEXT Index Performance and Optimization Strategy without Down Time

We have an INNODB table specifically for text searching which has a text column and a FULLTEXT index. This table mostly get inserts and updates and almost no deletes in our model. A typical table ...
Jason Riffel's user avatar
1 vote
1 answer
94 views

high disk Wrrite IO on mysqld

I'm facing a rather weird issue with mysqld v8.0.36 there's constantly very high disk write operations(~300MB/s) coming from mysqld. Although there's a single database hosted on this server(wordpress) ...
Menelaos pc's user avatar
1 vote
0 answers
39 views

Create table statement gives 'ERROR 1030 (HY000): Got error 168' for MySQL 8

More specifically: mysql> create table test(`test` varchar(8) NOT NULL); ERROR 1030 (HY000): Got error 168 - 'Unknown (generic) error from engine' from storage engine Error log isn't showing much, ...
Chris's user avatar
  • 191
0 votes
0 answers
24 views

Getting OOM when trying to change id from int to bigint in MySQL w/ percona

We have 2.5tb table with id column as int in Aurora 3 (MySQL 8.0.26). We need to change it to bigint as ids will run out soon. We tested it with pt-online-schema-change and the server crashed because ...
Nir's user avatar
  • 533
0 votes
2 answers
27 views

List of characters managed by a collation

I'm migrating to MySQL 8.0.33. We are changing character set to utf8mb4. For collation, I'm wondering among different options. I'm looking for documentation to review the list of characters that are &...
yaki_nuka's user avatar
  • 141
0 votes
0 answers
22 views

Error mysqlimport loading to symlink table

Getting ERROR 1030 (HY000): Got error 168 - 'Unknown (generic) error from engine' when trying to import a .sql file produced via mysqldump. Running MySQL 8 on a Ubuntu 22.04 system. chris@chris-X1C6:/...
Chris's user avatar
  • 191
0 votes
0 answers
116 views

Probably missing something simple, source of ERROR 1146 (42S02): Table doesn't exist error

Looking to import a mysqldump .sql file into a new db. Have tried both via command line and directly within a mysql session. The following call gives the assocaited error: chris@chris-X1C6:/media/...
Chris's user avatar
  • 191
0 votes
0 answers
26 views

sql_skip_slave not working in mysql 8.0.30

The Error: Worker 1 failed executing transaction '3c852db0-0a3e-11eb-9a41-005056b2f2da:589631974' at master log log_bin_BD6_LDPY.014848, end_log_pos 130823035; Could not execute Delete_rows event on ...
Ruan Oliveira's user avatar
0 votes
1 answer
141 views

MySQL master-slave stopped replication no Error on relay log

MySQL Master stopped sending updates 1 day ago to Slave there is no obvious error. Everything was working fine I tried to create DB, and Users, no updates on Slave also SO far I tried to remove the ...
awd's user avatar
  • 1
0 votes
0 answers
34 views

Loading .sql file to MySQL via symbolic link

I have an existing MySQL 8 installation on a Ubuntu 22.04 system that relies on the standard /var/lib/mysql datadir. I'm trying to load a dumped .sql file to a new database, but it's too big to be ...
Chris's user avatar
  • 191
1 vote
0 answers
80 views

Force index not working in Aurora MySQL 8

I have recently upgraded to Aurora MySQL engine version 8.0.mysql_aurora.3.05.2 from Aurora MySQL 5.7. I see huge performance issue after upgrading. Recently I found that I have queries whose indexes ...
Ali Mehdi's user avatar
2 votes
2 answers
217 views

Unexplained MySQL memory usage

I am experiencing an issue with MySQL memory usage increasing over time to a point where OOM Killer kills the MySQL process. I have 3 servers configured with Group Replication (1 Primary and 2 ...
O Genthe's user avatar
0 votes
0 answers
32 views

Rename table taking too long on MySql 8

We recently upgraded from MySql 5.7 to 8 and have run into this issue. We have a rename table operation that runs every minute. It used to take a fraction of a second, but now it takes over 6.0 ...
Faheem's user avatar
  • 101
0 votes
0 answers
6 views

Aurora RDS MySQL historical database recovery from historical snapshot and master snapshot?

I was able to simulate a transactional cluster replicating to a historical cluster and it does all the changes, inserts, updates, deletes. I was able to do an archiving delete so those deletes did ...
Dean Hiller's user avatar
1 vote
1 answer
16 views

Aurora RDS async replication to historical MySQL cluster

I was trying to do https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html until the command to pause all writes gets access denied on my test db FLUSH TABLES WITH READ LOCK; Error ...
Dean Hiller's user avatar
0 votes
0 answers
118 views

cant connect with secure connection to latest mysql server 8.0.36, error | MY-010914 | Server | Bad handshake

I upgraded from MySQL server 7 to latest 8.0.36 and now when I try to connect securely using the following command: mysql -u my_user -pxxxxxxxxx -h db-server.domain.com -P 3306 --verbose --protocol ...
Jon Simson's user avatar
1 vote
1 answer
86 views

How should I troubleshoot a very slow MySQL server droplet?

I'm new to the DBA forum, but not SO, and I've searched for answers on this, and tried what I've found. We have a Rails app that lives on a Digital Ocean droplet, and a bigger and more powerful ...
nimmolo's user avatar
  • 111
0 votes
1 answer
9 views

MySQL replication status not reporting mysqld.cnf parameters

I am running a multi master replication from 3 master servers to 1 slave. Each of the masters has 2 DBs but I am replicating just 1 of the DBs. Server version: 8.0.35-0ubuntu0.20.04.1 (Ubuntu) ...
Andrei Hristov's user avatar
0 votes
0 answers
16 views

Dockerized MySQL suddenly shutdown

There are 15 microservices, each has MySQL 8.0.35. The services used to be implemented on the host system, however, we recently switched to Docker. Four of the microservices that were under more read ...
M a m a D's user avatar
  • 101

1
2 3 4 5
14