| | 26 | * TdB: John, Roger and myself went through the logfiles to figure out what went wrong yesterday with ipp113. We looked through the reports for ipp113 on Ganglia, noticing the spiking load after 18:00 until 20:00. We went into the serial console using: |
| | 27 | {{{ |
| | 28 | console --user xxxx -v ipp113 |
| | 29 | }}} |
| | 30 | |
| | 31 | and check the rolling log information. We check the status (option 8) under power management (CTRL + P) and noticed it was back to normal now. |
| | 32 | Mark showed us how to powercycle the machine and check the boot messages in /var/log/messages (as sudo user) |
| | 33 | |
| | 34 | When a machine has been power cycled, MYSQL is probably down. Check that by doing: |
| | 35 | {{{ |
| | 36 | ps -ef | grep mysql |
| | 37 | }}} |
| | 38 | Check the config file under /etc/mysql/my.cnf for the location of the error log and see if MYSQL is what caused the issue. In this case, it did not. |
| | 39 | |
| | 40 | To restart MYSQL do: |
| | 41 | {{{ |
| | 42 | /etc/init.d/mysql start |
| | 43 | }}} |
| | 44 | |