Questions tagged [mysql-5.7]
MySQL version 5.7 - please also tag with mysql for search purposes.
1,073 questions
0
votes
0
answers
37
views
Copying millions of rows to a new table
I have a mysql table that has 100+ million rows and we need to add a new column to this table. ALTER TABLE will lock the table and I can't have that, so my next idea was to make a new table that has ...
- 1
0
votes
1
answer
79
views
Replication Mysql 5.7.44 + myIsam storage engine - cluster setup issue
I have a mysql 5.7.44 database with myIsam storage engine for few tables and I need to setup a cluster with 3 nodes that should be available for write process at same time, active/active for all 3 ...
0
votes
2
answers
65
views
What's wrong with this proc (works in MySQL 8 but not in 5.7)?
Procedure text (yes, I have a database named boxscore and a table named boxscore; don't sue me):
use `boxscore`;
delimiter //
create procedure `archive_boxscore_proc`(IN pkmin bigint, IN pkmax bigint, ...
- 183
0
votes
0
answers
125
views
Drastically slower query after migrating from MySQL 5.7 to MySQL 8.4 — complex SELECT DISTINCT with multiple LEFT JOINs
I’m facing a performance issue after migrating from MySQL 5.7 to MySQL 8.4.
I have a query using multiple LEFT JOINs and a SELECT DISTINCT that used to run in ~300ms on MySQL 5.7. After migrating to ...
0
votes
1
answer
136
views
Mysql "ERROR 1045 (28000): Access denied" only when host is specified
I'm scratching my head with this issue.
I have an Azure flexible for MySQL server with MySQL 5.7.
I've created and give grants for a new user with the "%" wildcard, following the syntax (don'...
- 668
0
votes
1
answer
140
views
MySQL 5.7 multi-master Galera Cluster - Index Creation
I have a production Galera (v3) Cluster with 3 MySQL (v5.7) nodes running in multi-master mode.
I need to create a new index (~16GB) and drop an old index on a large table (112 million rows, ~20GB ...
- 3
0
votes
0
answers
54
views
When does xtrabackup take lock exactly and why there's slave lag after backup starts?
MySQL Version -- MySQL Community Server 5.7.44
Percona xtrabackup Version 2.4.29 (x86_64)
I want to understand when does xtrabackup exactly take the FLUSH TABLES WITH READ LOCK.
Following is the ...
- 216
0
votes
0
answers
65
views
MySQL switching primary — why did writes happen on read-only replica?
I have a primary-replica setup in MySQL 5.7 (call them A and B), and I sometimes need to switch the primary to the replica and vice-versa. I'm trying to make a reliable script to do this.
When I tried ...
- 101
1
vote
1
answer
279
views
MySQL won't start after upgrade from 5.7.30 to 8.4.3
I just attempted an upgrade of a MySQL instance running MySQL 5.7.30 (in Docker) to MySQL 8.4.3 (in Docker) and now the instance won't start, complaining about a missing mysql.ibd file.
I have checked ...
- 131
3
votes
2
answers
178
views
Extra metadata in mysql slow query log - meaning of Id?
I'm running MySql5.7 with slow query logging enabled, and the log includes more metadata than is mentioned by the docs; these three lines are printed before each query:
# Time: 2025-02-18T14:25:16....
- 439
0
votes
2
answers
131
views
Performance Impact of PURGE BINARY LOGS on MySQL 5.7.32
I am currently facing disk space issues with a MySQL 5.7.32 server that has >500 binary logs of 1.1GB each.
I have spent several days reading up on this, and found that PURGE BINARY LOGS is the ...
0
votes
0
answers
75
views
xtrabackup fails with error xb_stream_write_data() failed
I am facing a weird issue while using xtrabackup with xbstream. The weird part is that it was working fine just few days ago and apart from a reboot there were no changes on the machine. I have at ...
- 216
0
votes
1
answer
130
views
Unable to create root@localhost mysql 5.7 or 8.0.31
I have received a mysql environment to work on and currently Audits are being performed.
What I see in mysql.user is 'root'@'%' created everywhere and it is required that access to root is to be ...
- 216
0
votes
2
answers
103
views
Disable MySQL ONLY_FULL_GROUP_BY while logging violations
We have attempted to upgrade a legacy database from MySQL 5.6 to 5.7 in the hopes of bringing it up to current, but quickly experienced queries that failed with this is incompatible with sql_mode=...
- 195
0
votes
1
answer
285
views
Switch to master auto position from master_log_file and master_log_pos MySQL 5.7.44
MySQL Server - 5.7.44
I have a master and three slaves running on MySQL 5.7.44.
The GTID is enabled and I am using gtid_enforce_consistency.
I took a backup from a slave and built a fourth slave using ...
- 216