This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

show slave status;

By: a guest on Jan 11th, 2013  |  syntax: None  |  size: 1.87 KB  |  views: 28  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. *************************** 1. row ***************************
  2.                Slave_IO_State: Waiting for master to send event
  3.                   Master_Host: master.example.com
  4.                   Master_User: replication
  5.                   Master_Port: 3306
  6.                 Connect_Retry: 60
  7.               Master_Log_File: mysql-bin.000003
  8.           Read_Master_Log_Pos: 6562925
  9.                Relay_Log_File: mysqld-relay-bin.000005
  10.                 Relay_Log_Pos: 5365856
  11.         Relay_Master_Log_File: mysql-bin.000002
  12.              Slave_IO_Running: Yes
  13.             Slave_SQL_Running: No
  14.               Replicate_Do_DB:
  15.           Replicate_Ignore_DB:
  16.            Replicate_Do_Table:
  17.        Replicate_Ignore_Table:
  18.       Replicate_Wild_Do_Table:
  19.   Replicate_Wild_Ignore_Table:
  20.                    Last_Errno: 1062
  21.                    Last_Error: Error 'Duplicate entry 'fetch_task::views' for key 'PRIMARY'' on query. Default database: 'ngcserver_com'. Query: 'INSERT INTO cache_update (cid, created) VALUES ('fetch_task::views', '1357856101')'
  22.  Skip_Counter: 0
  23.           Exec_Master_Log_Pos: 5365710
  24.               Relay_Log_Space: 24736932
  25.               Until_Condition: None
  26.                Until_Log_File:
  27.                 Until_Log_Pos: 0
  28.            Master_SSL_Allowed: No
  29.            Master_SSL_CA_File:
  30.            Master_SSL_CA_Path:
  31.               Master_SSL_Cert:
  32.             Master_SSL_Cipher:
  33.                Master_SSL_Key:
  34.         Seconds_Behind_Master: NULL
  35. Master_SSL_Verify_Server_Cert: No
  36.                 Last_IO_Errno: 0
  37.                 Last_IO_Error:
  38.                Last_SQL_Errno: 1062
  39. Last_SQL_Error: Error 'Duplicate entry 'fetch_task::views' for key 'PRIMARY'' on query. Default database: 'ngcserver_com'. Query: 'INSERT INTO cache_update (cid, created) VALUES ('fetch_task::views', '1357856101')'
  40.   Replicate_Ignore_Server_Ids:
  41.              Master_Server_Id: 172868
clone this paste RAW Paste Data