Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options not deleted
user 7697
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
0
votes
1
answer
115
views
How do I debug max_allowed_packet going to -1?
I am using Amazon's MySQL Aurora and using JDBI on the client side. … Since I have multiple servers and only one of them randomly sees this, I am guessing this has something do with client-side mysql. The error is too fleeting to be able to debug. …
- 119
1
vote
0
answers
108
views
How to find queries that use a given index for mysql?
I am looking to change indices on my MySQL table. My hunch was that one of the indices, that I am looking to remove, shouldn't be used. … Is there a place where MySQL stores query plans? Or any other way of finding the queries that use a given index? …
- 119
0
votes
1
answer
689
views
Unable to understand this mysql deadlock log
there is a deadlock
------------------------
LATEST DETECTED DEADLOCK
------------------------
2020-02-05 03:52:47 0x2b38b7b91700
*** (1) TRANSACTION:
TRANSACTION 257063481717, ACTIVE 0 sec inserting
mysql … tables in use 1, locked 1
LOCK WAIT 3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 4990288, OS thread handle 47474114635520, query id 359069256602 172.26.107.139 update …
- 119
0
votes
1
answer
128
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. … Or some mysql variable mismatch?
How can I debug this further? What could have possibly caused this blip? …
- 119
0
votes
Accepted
What could cause replication to break on MySQL when replicating from 5.7.40 to 8.0 replica
We enabled binary logs and were able to figure this out when it happened again. The replica had read_only=0 and an application level bug was doing writes in extremely rare scenarios.
- 119