| 02:32.35 | *** join/#uphpu josephscott (~josephsco@192.0.80.201) |
| 02:40.43 | *** join/#uphpu josephscott (~josephsco@192.0.80.201) |
| 03:07.05 | *** join/#uphpu ninnypants (~textual@unaffiliated/ninnypants) |
| 03:07.05 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 11:37.23 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 11:37.23 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 14:21.47 | *** join/#uphpu ninnypants (~textual@unaffiliated/ninnypants) |
| 14:21.47 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 14:37.06 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 14:37.06 | *** mode/#UPHPU [+v eggyknap] by sendak.freenode.net |
| 14:38.50 | *** join/#uphpu josephscott (~josephsco@192.0.80.201) |
| 15:43.32 | *** join/#uphpu UtahDave (~boucha@208.186.233.100) |
| 15:43.32 | *** mode/#UPHPU [+o UtahDave] by ChanServ |
| 16:57.40 | *** join/#uphpu ninnypants (~textual@unaffiliated/ninnypants) |
| 16:57.40 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 18:20.55 | *** join/#uphpu herlo (~herlo@fedora/herlo) |
| 18:20.55 | *** mode/#UPHPU [+v herlo] by ChanServ |
| 18:46.46 | utahcon | any DBA-ish homies here? |
| 18:46.52 | utahcon | got a question about mysql replication |
| 18:48.40 | fungus | not a DBA, but i have some experience w/ MySQL replication. |
| 19:06.14 | utahcon | Hey fungus! |
| 19:06.25 | fungus | good morning |
| 19:06.37 | utahcon | I have a server that 10 hours behind on replication, and NO clue what to do about it... do you have any crash courses I can peruse? |
| 19:07.13 | fungus | Is it moving forware and just can't keep up, or is it stuck? |
| 19:07.18 | fungus | SHOW SLAVE STATUS\G |
| 19:08.16 | utahcon | ok |
| 19:08.23 | utahcon | what am I looking for there? |
| 19:08.30 | fungus | Slave_IO_Running |
| 19:08.34 | fungus | Slave_SQL_Running |
| 19:08.42 | fungus | Seconds_Behind_Master |
| 19:08.53 | utahcon | Yes, Yes, 39817 |
| 19:09.13 | utahcon | the time keeps increasing |
| 19:09.21 | utahcon | and position keeps moving forward |
| 19:09.33 | fungus | k, good. so it just can't keep up. |
| 19:09.38 | fungus | show processlist |
| 19:09.49 | utahcon | on slave? |
| 19:09.49 | fungus | that will tell you what query it is currently executing. |
| 19:09.52 | fungus | Yes |
| 19:10.21 | utahcon | | 1688081 | system user | | NULL | Connect | 23337592 | Waiting for master to send event | NULL | |
| 19:10.36 | utahcon | bunch of "Waiting for table" |
| 19:11.11 | fungus | There should be 2 threads for the slave. The one you mentioned is what transfers the logs from the master. |
| 19:11.19 | fungus | And another executes the logs. |
| 19:11.43 | fungus | Both show "system user" as the user |
| 19:11.48 | utahcon | | 1688082 | system user | | NULL | Connect | 39874 | Waiting for table | NULL | |
| 19:12.04 | utahcon | that is the only other one for "system user" |
| 19:12.25 | fungus | That is the one. It seems it's waiting for a table, but it doesn't show which table... |
| 19:12.56 | fungus | Look through all the other processes and see if anything is holding any locks. |
| 19:13.26 | utahcon | lots of selects, but there is a FLUSH TABLES... that seems... IDK scary? |
| 19:13.50 | fungus | what is the Time on that query? |
| 19:14.24 | utahcon | 39534 |
| 19:14.33 | fungus | hah, that's your problem it seems. |
| 19:14.47 | utahcon | do I just kill that process? |
| 19:14.47 | fungus | It seems to have locked all the tables and isn't finishing. |
| 19:15.25 | fungus | You can try that, but my guess is that you have some other more serious problem if a "FLUSH TABLES" gets stuck. |
| 19:15.41 | fungus | maybe a mysql restart, or a full reboot. |
| 19:15.55 | utahcon | fair enough |
| 19:16.01 | utahcon | I will go with that knowledge |
| 19:16.03 | utahcon | Thanks a ton! |
| 19:16.06 | fungus | np |
| 20:06.31 | *** join/#uphpu ninnypants (~textual@unaffiliated/ninnypants) |
| 20:06.31 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 20:10.06 | *** join/#uphpu ninnypants (~textual@unaffiliated/ninnypants) |
| 20:10.07 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 23:08.35 | *** part/#uphpu UtahDave (~boucha@208.186.233.100) |