Timeline for MySQL slave taking too long on "Queueing master event to the relay log"
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Sep 8, 2014 at 22:18 | history | bounty ended | mezi | ||
| S Sep 8, 2014 at 22:18 | history | notice removed | mezi | ||
| Sep 6, 2014 at 18:52 | comment | added | RolandoMySQLDBA |
Please run SHOW GLOBAL VARIABLES LIKE 'binlog_format'; and post the output.
|
|
| S Sep 6, 2014 at 17:21 | history | bounty started | mezi | ||
| S Sep 6, 2014 at 17:21 | history | notice added | mezi | Authoritative reference needed | |
| Sep 5, 2014 at 9:52 | history | edited | mezi | CC BY-SA 3.0 |
added 23 characters in body
|
| Sep 5, 2014 at 9:39 | history | edited | mezi | CC BY-SA 3.0 |
added 1849 characters in body
|
| Sep 5, 2014 at 9:37 | comment | added | mezi | Hi @rolandomysqldba, 2) it was created using "insert into ... select". I have now posted the query with this question. | |
| Sep 4, 2014 at 23:15 | comment | added | eroomydna | I suspect that pt-osc was used and the backfill of the shadow table is being replicated. | |
| Sep 4, 2014 at 17:37 | answer | added | RolandoMySQLDBA | timeline score: 3 | |
| Sep 4, 2014 at 17:35 | comment | added | mezi | 1) yes, it is growing steadily.2) I will get back to you on that. | |
| Sep 4, 2014 at 17:31 | comment | added | RolandoMySQLDBA |
Two questions: 1) When you run SHOW SLAVE STATUS\G is Relay_Log_Space steadily growing ? 2) Was the big table on the Master rebuilt using LOAD DATA INFILE ?
|
|
| Sep 4, 2014 at 17:19 | history | asked | mezi | CC BY-SA 3.0 |