New answers tagged mysql-5.7
0
votes
AWS RDS MySQL upgrade from 5.7 to 8 failing due to ROW_FORMAT
I would use pt-online-schema-change to alter the large tables without downtime.
You can probably do many of the smaller tables in the conventional way with ALTER TABLE, because they will each finish ...
- 12.6k
0
votes
MySQL 5.7.42, Gradual memory growth over time, memory leak?
Analysis of GLOBAL STATUS and VARIABLES:
Observations:
Version: 5.7.42-log
8 GB of RAM
Uptime = 23:29:29; some GLOBAL STATUS values may not be meaningful yet.
813 QPS
The More Important Issues:
...
- 74.9k
0
votes
MySQL 5.7.42, Gradual memory growth over time, memory leak?
(Analysis of chart)
The steep decline at 23:40 is probably a restart or some kind of flush. Neither should (normally) be necessary.*
The line between those 23:40 and 00:05 smells like "normal&...
- 74.9k
2
votes
MySQL 5.7.42, Gradual memory growth over time, memory leak?
See if any of these apply:
----- 2022-04-26 5.7.38 General Availability -- -- -----
A memory leak occurred if mysqldump was used on more than one table with the --order-by-primary option. The memory ...
- 74.9k
0
votes
Accepted
Deadlock while concurrently updating multiple rows on the same table
Assumptions (for this Answer):
Lots of one-row UPDATEs are done throughout the day. They use a 5-column unique key and change only a JSON and updated_at.
Data with updated_at before 15 days ago ...
- 74.9k
0
votes
Deadlock while concurrently updating multiple rows on the same table
Which partition do you drop every day? How does it compute what do drop? Please do EXPLAIN SELECT * FROM ... WHERE .... You may find that all the partitions are being used! If all are used, then ...
- 74.9k
0
votes
Execution plan changed for existing query - high CPU usage
(Not an answer, but need formatting to present a problem.)
CASE WHEN `alias_50656806`.`status` = 'CAPTURED'
THEN `alias_50656806`.`amount`
ELSE `alias_50656806`.`due_by`
END
"...
- 74.9k
1
vote
MySQL 8.0.x: Discard temporary table left behind during a pre-migration (5.7.x) crash when the parent schema is already dropped
I had to create an empty directory with the name of the database in the data directory, only then was MySQL happy to drop it.
- 133
Top 50 recent answers are included