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
17 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
  • 181
0 votes
0 answers
17 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
37 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
31 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
  • 181
1 vote
0 answers
42 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
1 vote
2 answers
97 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
13 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
5 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
13 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
19 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
51 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
8 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
-1 votes
0 answers
39 views

ERROR 1064 (42000) while importing mysqldump from MariaDB to MySQL

I'm trying to migrate DB from MariaDB to MySQL 8 I created dump via phpMyAdmin panel and when I'm importing db.sql via MySQL Workbench I'm getting below error ERROR 1064 (42000) at line 4244422: You ...
Breaking News's user avatar
0 votes
0 answers
13 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
0 votes
0 answers
18 views

AWS Mysql unknown variable Warning Log

I upgraded AWS Aurora Mysql 5.7 to 8, but aws aurora log outputs like this. 2024-01-19T00:24:16.179185Z 0 [Warning] [MY-000067] [Server] unknown variable '...
B_B_Tod's user avatar
0 votes
0 answers
69 views

MASTER-MASTER replication failed on Production: Coordinator stopped because there were error(s) in the worker(s)

This error occured after I was importing a database dump to master1. In production our MASTER-MASTER replication failed UPDATE SELECT CHANNEL_NAME, WORKER_ID, THREAD_ID, SERVICE_STATE, ...
Breaking News's user avatar
0 votes
0 answers
26 views

Upgrading from MySQL 5.7 to 8

I am looking at upgrading MySQL 5.7 to MySQL 8.0 (all in AWS). I have the added benefit of a QA environment to work with, which is the obvious starting point. I ran through their article here: ...
Travis's user avatar
  • 145
0 votes
0 answers
24 views

Mysql data at rest encryption component file keyring

Hi I have a mysql server version 8.0.34-0ubuntu0.22.04.1 for Linux on x86_64 and I want to enable data at rest encryption component keyring file. according to this page https://dev.mysql.com/doc/...
Amir Almian's user avatar
0 votes
1 answer
27 views

Force MySQL to use specific index on ORDER BY clause with LIMIT to satisfy join

MySQL 8.0.30 I have three tables defined: C CT T CT is a linking table (many-to-many between C & T) The query I'm trying to optimize is of the following kind: SELECT C.*, T.* FROM C JOIN CT ON C....
ktn's user avatar
  • 1
1 vote
1 answer
48 views

SQL query classifying types of nodes in a binary tree

I am using MySQL in trying to solve a problem relating to a SQL query classifying types of nodes in a binary tree. Specifically, the question states as follows: You are given a table, BST, containing ...
Squirrel-Power's user avatar
1 vote
1 answer
92 views

MySQL Multi-Valued Indexes

In the following SQL, Multi-Valued Indexes are generated for the json array. ALTER TABLE table_name ADD INDEX index_name((CAST(json->'$.field' AS json_type ARRAY))). ALTER TABLE table_name ADD ...
feilong gao's user avatar
0 votes
1 answer
27 views

Existing tables adding composite foreign key constraints

I've got the above set of tables shown in the ER Diagram above. members have many users. members have many approval_groups. approval_groups have many approval_group_users. approval_group_users....
Matthew Lenz's user avatar
3 votes
1 answer
36 views

Row Locks in Partitioned Aurora MySQL Table

I'm experiencing many row locks in a AWS Aurora AWS MySQL MySQL version=8.0 Aurora Version=3.04.0 The table is pretty big close to 1 Billion rows. The table is partitioned in 24 partitions based on ...
sonus21's user avatar
  • 131
2 votes
0 answers
16 views

Cloning failing in Mysql Group replication

We have a 3-node MySQL group replication set up in K8s. After all the respective setups, during the cloning process from the primary node to rebuild or add a secondary node to the cluster, the process ...
Pravat Dash's user avatar
1 vote
0 answers
34 views

Error 1216, not 1451, despite reference privilege on MySQL 8

MySQL 8.0.34 Limited-privilege users see less verbose errors (1216/1217) per the design intent. I've granted reference privileges, as suggested here, in an attempt to show more verbose errors (1451/...
Chris Broz's user avatar
0 votes
0 answers
28 views

Speedup wordcloud select with group by in mysql

I am currently working on a project for my studies where a wordcloud is created for the NYT. Therefore I am scraping all the articles from the NYT from their API, and then store dates of the article, ...
Ynfiniti's user avatar
0 votes
1 answer
40 views

Out of my depth with post mysql 8 update (Warning: #1287 Setting user variables within expressions is deprecated)

Now I can get my way around PHP, and I can get around basic MySQL queries, but I'm not really comfy with MySQL, and have inherited an issue that occurred today after our hosting company updated their ...
Adrian M 's user avatar
0 votes
1 answer
26 views

Best practice to implement count based subscription model?

Currently I have implemented a system where user subscribes to a plan for specific number of events. Whenever a new event is being created I am checking count against that user, say SELECT COUNT(*|id) ...
Rameez Raja's user avatar
0 votes
0 answers
70 views

RDS MySQL Cluster: Cannot Grant SET_USER_ID

On an RDS MySQL 8.0.33 cluster, I'm trying to grant the SET_USER_ID privilege to a migrations@% User so that that account can change the DEFINER on some views. I'm using the Master account, root, ...
benbotto's user avatar
  • 101
0 votes
0 answers
43 views

MySQL 8: show deprecated error only as warning

I'm migrating MySQL from 5.7 to 8.0.32. I know character set utf8mb3 and its collations are deprecated. But we have lots of functionality and data with utf8mb3, and we don't have more time to change ...
yaki_nuka's user avatar
  • 141
0 votes
0 answers
22 views

MySQL Crash dump on AlmaLinux 8

I have sent SIGABRT to MySQL process but I am not getting the crash dump file. Server is AlmaLinux 8.8 (4.18.0-477.21.1.el8_8.x86_64 x86_64 x86_64) and MySQL version is 8.0.32. Set the configuration ...
supmethods's user avatar
1 vote
0 answers
37 views

How to correctly set the database, table, and column collation in MySQL?

Background I am experiencing problems setting the collation in my local MySQL database I am using for a Drupal site I am developing. I attempted to create a local database with charset utf8mb4 and ...
GeorgeCiesinski's user avatar
0 votes
0 answers
31 views

MySQL 8 host_cache returning wrong HOST for IP address

We're trying to troubleshoot a number of issues with the host_cache on a MySQL 8 server The issues are all tied to a recent update where we tightened our user "From Host" definitions from @&...
Dan Kelly's user avatar
  • 181
2 votes
1 answer
59 views

how percona hot backup works / innodb crash recovery works?

I am trying to understand the process of how percona does hot backup. from what in understand is, they use innodb crash recovery mechanism and execute the following steps. store/remember start LSN ...
Rajat Aggarwal's user avatar
1 vote
1 answer
55 views

MySQL - Slow Performing Subquery when DISTINCT Is Used

I have this query that runs very slowly when DISTINCT is used; SELECT COUNT(*) FROM (SELECT DISTINCT query_text FROM search_query WHERE (store_id IN (1)) AND (num_results > 0) ORDER BY popularity ...
Marisa's user avatar
  • 23
1 vote
0 answers
25 views

Performance degradation after upgrading to MySQL 8

We have upgraded MySQL in our application from version 5.7.43 to version 8.0.35. We are getting below exception while trying the fetch the records from the database. 231104 04:04:03 : com.mysql.jdbc....
Kishore's user avatar
  • 11
0 votes
1 answer
26 views

MySQL Data not flushing to disk

Lets start with what I did... I copied a table via PHPmyadmin operations/ copy table/(temp1) structure and data. nothing should make any changes to this copy.phpmyadmin shows 1185199 entries I copy ...
tek-dragon's user avatar
0 votes
0 answers
15 views

How to migrate from a MySQL master-master setup to a master-master setup with as little as possible downtime

I have to conduct a migration of a few databases from two MySQL VMs with master-master replication to another 2 VMS that would be also master-master replication. How would you do it with minimal ...
Zexxxx's user avatar
  • 1
0 votes
0 answers
29 views

Slow execution even with proper indexes defined

I am using AWS Aurora Serverless V2 with MySql. I have a table with 10M rows as shown below. CREATE TABLE 'VCont' ( 'id' varchar(64) NOT NULL, 'version' int NOT NULL, 'colId' bigint unsigned ...
Ravindra's user avatar
4 votes
2 answers
423 views

max_binlog_files on MySQL Server?

I read recently about a setting in Percona Server called max_binlog_files which restricts the total number of binlog files. This is exactly what I need. My binlog_expire_logs_seconds is currently ...
But those new buttons though..'s user avatar
0 votes
1 answer
49 views

Spatial query instantaneous when using GUI client; slow through CLI or PDO application

I'm having a very peculiar instance wherein we recently had to upgrade our database from MySQL 5.7 to 8.0, and I had to rewrite some queries. If my query is complicated enough, I usually prepare ...
Offlein's user avatar
  • 101
1 vote
1 answer
69 views

Wrong execution plan in MySQL 8.0 when using JOIN in WHERE NOT IN clause

After a migration from MySQL 5.7 to MySQL 8.0.34, we have a very strange behavior with a query when semijoin is on in the optimizer_switch. 1. The problematic query: SELECT COUNT(s0_.id) FROM ...
Arie S.'s user avatar
  • 13
1 vote
2 answers
114 views

How to Identify Tables with Index Size Issues during MySQL 5.7 to 8.0 Migration?

I'm trying to migrate from MySQL 5.7 to MySQL 8.0 for my application's database. However, the precheck failed with an incompatibility error "25," stating that tables with redundant row ...
Abhijith Ea's user avatar
0 votes
0 answers
32 views

MySql keep loosing tablespace id for random tables

In one of our databases we are seeing more and more frequent errors where the table space id of an innodb file is lost. We are running mysql 8.0.31. The error message in the log file is: [ERROR] [MY-...
Ingar Pedersen's user avatar
1 vote
0 answers
55 views

MySQL slow running query - Need help with tuning

I am using the Aurora MySQL Serverless V2 database and facing an issue with the below query taking longer. In the end, I have listed different approaches that I tried to fix this. The table has around ...
Ravindra's user avatar
0 votes
0 answers
82 views

Illegal mix of collations when collation_connection does not match actual type

After upgrading from 8.0.26 to 8.0.30, I found a character set problem when calling the stored procedure. When I call the stored procedure, the procedure returns a utf8mb4_unicode_520_ci string, which ...
Spirytus Rektyfikowany's user avatar
1 vote
0 answers
56 views

Adjust SQL query to select only one record

I have three tables: An adjacency-list table, territories with fields id, alignment_id, three_left, tree_right, depth and deleted_at (omitted from table for brevity, all values null). id alignent_id ...
ioni's user avatar
  • 61
0 votes
0 answers
30 views

Why can I establish SSL Session to MYSQL from Mysql Client, but not DbEaver 8.0

[mysqld] ssl=ON ssl_ca=ca.pem ssl_cert=server-cert.pem ssl_key=server-key.pem require_secure_transport=ON tls_version=TLSv1.2,TLSv1.3 Results: mysql client remote = Tls Session connects. ...
DBA_OnDemand's user avatar
0 votes
2 answers
37 views

MySQL is not utilizing the index when the IN operator is used

I have a mysql 8 query like below. the ch_site_user table is indexed on user_id, site_id, status. Explain plan shows the correct index is used. But usersite.site_id IN (2315, 2316, 2324, 2323, 2320, ...
Sreenivas Kolanthayappan's user avatar
3 votes
0 answers
2k views

Upgrade from MySQL 5.7 to MySQL 8 massive drop in performance occasionally

I have recently upgraded from MySQL 5.7 to 8 on several databases innodb engine with the same schema but different data hosted on RDS, performance was fine on all of them until the last one which was ...
Colm Canavan's user avatar

1
2 3 4 5
13