mysql> SHOW PROCESSLIST;
+----+-------------+-----------+------+---------+------+----------------------------------+------------------+
| Id | User        | Host      | db   | Command | Time | State                            | Info             |
+----+-------------+-----------+------+---------+------+----------------------------------+------------------+
|  1 | root        | localhost | NULL | Query   | 0    | NULL                             | SHOW PROCESSLIST |
| 35 | system user |           | NULL | Connect | 2    | Waiting for master to send event | NULL             |
| 36 | system user |           | NULL | Connect | 2547 | freeing items                    | NULL             |
+----+-------------+-----------+------+---------+------+----------------------------------+------------------+
3 rows in set (0.00 sec)

mysql> STOP SLAVE IO_THREAD;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW PROCESSLIST;
+----+-------------+-----------+------+---------+------+-------+--------------------------------------------------------------------------------+
| Id | User        | Host      | db   | Command | Time | State | Info                                                                           |
+----+-------------+-----------+------+---------+------+-------+--------------------------------------------------------------------------------+
|  1 | root        | localhost | NULL | Query   | 0    | NULL  | SHOW PROCESSLIST                                                               |
| 36 | system user |           | test | Connect | 2557 | end   | update player_reservation_test set amount=amount+1 where reservation_id=551193 |
+----+-------------+-----------+------+---------+------+-------+--------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> START SLAVE IO_THREAD;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
          Master_Host: 10.0.26.222
          Master_User: repl
          Master_Port: 3306
        Connect_retry: 60
      Master_Log_File: master-bin.008
  Read_Master_Log_Pos: 2654191
       Relay_Log_File: slave-relay-bin.001
        Relay_Log_Pos: 86638870
Relay_Master_Log_File: master-bin.007
     Slave_IO_Running: Yes
    Slave_SQL_Running: No
      Replicate_do_db:
  Replicate_ignore_db:
           Last_errno: 0
           Last_error: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
         Skip_counter: 0
  Exec_master_log_pos: 86638829
      Relay_log_space: 494811927
1 row in set (0.00 sec)

mysql> STOP SLAVE SQL_THREAD;
ERROR 1199: This operation requires a running slave, configure slave and do SLAVE START
mysql> STOP SLAVE;
Query OK, 0 rows affected (0.00 sec)

mysql> START SLAVE;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
          Master_Host: 10.0.26.222
          Master_User: repl
          Master_Port: 3306
        Connect_retry: 60
      Master_Log_File: master-bin.008
  Read_Master_Log_Pos: 70147375
       Relay_Log_File: slave-relay-bin.001
        Relay_Log_Pos: 86856597
Relay_Master_Log_File: master-bin.007
     Slave_IO_Running: Yes
    Slave_SQL_Running: Yes
      Replicate_do_db:
  Replicate_ignore_db:
           Last_errno: 0
           Last_error:
         Skip_counter: 0
  Exec_master_log_pos: 86856556
      Relay_log_space: 562305152
1 row in set (0.00 sec)

mysql>