API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2014
190
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.17 KB | None | 0 0
raw download clone embed print report
  1. slave> show slave status G
  2. *************************** 1. row ***************************
  3. Slave_IO_State: Waiting for master to send event
  4. Master_Host: 10.192.1.100
  5. Master_User: repl
  6. Master_Port: 3306
  7. Connect_Retry: 60
  8. Master_Log_File: mysql-bin.000417
  9. Read_Master_Log_Pos: 103252997
  10. Relay_Log_File: mysqld-relay-bin.000027
  11. Relay_Log_Pos: 1035475
  12. Relay_Master_Log_File: mysql-bin.000417
  13. Slave_IO_Running: Yes
  14. Slave_SQL_Running: Yes
  15. Replicate_Do_DB:
  16. Replicate_Ignore_DB:
  17. Replicate_Do_Table:
  18. Replicate_Ignore_Table:
  19. Replicate_Wild_Do_Table:
  20. Replicate_Wild_Ignore_Table:
  21. Last_Errno: 0
  22. Last_Error:
  23. Skip_Counter: 0
  24. Exec_Master_Log_Pos: 103252997
  25. Relay_Log_Space: 1035632
  26. Until_Condition: None
  27. Until_Log_File:
  28. Until_Log_Pos: 0
  29. Master_SSL_Allowed: No
  30. Master_SSL_CA_File:
  31. Master_SSL_CA_Path:
  32. Master_SSL_Cert:
  33. Master_SSL_Cipher:
  34. Master_SSL_Key:
  35. Seconds_Behind_Master: 0
  36. Master_SSL_Verify_Server_Cert: No
  37. Last_IO_Errno: 0
  38. Last_IO_Error:
  39. Last_SQL_Errno: 0
  40. Last_SQL_Error:
  41. Replicate_Ignore_Server_Ids:
  42. Master_Server_Id: 3
  43. 1 row in set (0.00 sec)
  44.  
  45. root@slave:/vol/log/mysql# ll -h
  46. total 9.9G
  47. drwxr-xr-x 2 mysql mysql 4.0K Sep 23 02:23 ./
  48. drwxr-xr-x 3 mysql mysql 18 Sep 4 20:51 ../
  49. -rw-rw---- 1 mysql mysql 101M Sep 18 03:56 mysql-bin.000417
  50. -rw-rw---- 1 mysql mysql 102M Sep 18 03:57 mysql-bin.000418
  51. -rw-rw---- 1 mysql mysql 102M Sep 18 03:58 mysql-bin.000419
  52. -rw-rw---- 1 mysql mysql 103M Sep 18 03:59 mysql-bin.000420
  53. -rw-rw---- 1 mysql mysql 101M Sep 18 04:00 mysql-bin.000421
  54. -rw-rw---- 1 mysql mysql 102M Sep 18 04:01 mysql-bin.000422
  55. -rw-rw---- 1 mysql mysql 101M Sep 18 04:03 mysql-bin.000423
  56. -rw-rw---- 1 mysql mysql 101M Sep 18 04:04 mysql-bin.000424
  57. -rw-rw---- 1 mysql mysql 102M Sep 18 04:05 mysql-bin.000425
  58. -rw-rw---- 1 mysql mysql 102M Sep 18 04:07 mysql-bin.000426
  59. -rw-rw---- 1 mysql mysql 102M Sep 18 04:08 mysql-bin.000427
  60. -rw-rw---- 1 mysql mysql 102M Sep 18 04:10 mysql-bin.000428
  61. -rw-rw---- 1 mysql mysql 101M Sep 18 04:12 mysql-bin.000429
  62. -rw-rw---- 1 mysql mysql 102M Sep 18 04:13 mysql-bin.000430
  63. -rw-rw---- 1 mysql mysql 102M Sep 18 04:15 mysql-bin.000431
  64. -rw-rw---- 1 mysql mysql 101M Sep 18 04:17 mysql-bin.000432
  65. -rw-rw---- 1 mysql mysql 101M Sep 18 04:19 mysql-bin.000433
  66. -rw-rw---- 1 mysql mysql 101M Sep 18 04:21 mysql-bin.000434
  67. -rw-rw---- 1 mysql mysql 103M Sep 18 04:23 mysql-bin.000435
  68. -rw-rw---- 1 mysql mysql 101M Sep 18 04:25 mysql-bin.000436
  69. -rw-rw---- 1 mysql mysql 104M Sep 18 04:27 mysql-bin.000437
  70. -rw-rw---- 1 mysql mysql 101M Sep 18 04:30 mysql-bin.000438
  71. -rw-rw---- 1 mysql mysql 101M Sep 18 04:32 mysql-bin.000439
  72. -rw-rw---- 1 mysql mysql 102M Sep 18 04:35 mysql-bin.000440
  73. -rw-rw---- 1 mysql mysql 101M Sep 18 04:37 mysql-bin.000441
  74. -rw-rw---- 1 mysql mysql 103M Sep 18 04:40 mysql-bin.000442
  75. -rw-rw---- 1 mysql mysql 103M Sep 18 04:42 mysql-bin.000443
  76. -rw-rw---- 1 mysql mysql 101M Sep 18 04:45 mysql-bin.000444
  77. -rw-rw---- 1 mysql mysql 101M Sep 18 04:48 mysql-bin.000445
  78. -rw-rw---- 1 mysql mysql 103M Sep 18 04:51 mysql-bin.000446
  79. -rw-rw---- 1 mysql mysql 101M Sep 18 04:54 mysql-bin.000447
  80. -rw-rw---- 1 mysql mysql 101M Sep 18 04:57 mysql-bin.000448
  81. -rw-rw---- 1 mysql mysql 101M Sep 18 04:59 mysql-bin.000449
  82. -rw-rw---- 1 mysql mysql 101M Sep 18 05:02 mysql-bin.000450
  83. -rw-rw---- 1 mysql mysql 101M Sep 18 05:06 mysql-bin.000451
  84. -rw-rw---- 1 mysql mysql 101M Sep 18 05:09 mysql-bin.000452
  85. -rw-rw---- 1 mysql mysql 101M Sep 18 05:12 mysql-bin.000453
  86. -rw-rw---- 1 mysql mysql 102M Sep 18 05:15 mysql-bin.000454
  87. -rw-rw---- 1 mysql mysql 101M Sep 18 05:19 mysql-bin.000455
  88. -rw-rw---- 1 mysql mysql 102M Sep 18 05:22 mysql-bin.000456
  89. -rw-rw---- 1 mysql mysql 101M Sep 18 05:26 mysql-bin.000457
  90. -rw-rw---- 1 mysql mysql 103M Sep 18 05:29 mysql-bin.000458
  91. -rw-rw---- 1 mysql mysql 104M Sep 18 05:33 mysql-bin.000459
  92. -rw-rw---- 1 mysql mysql 102M Sep 18 05:37 mysql-bin.000460
  93. -rw-rw---- 1 mysql mysql 102M Sep 18 05:41 mysql-bin.000461
  94. -rw-rw---- 1 mysql mysql 102M Sep 18 05:45 mysql-bin.000462
  95. -rw-rw---- 1 mysql mysql 102M Sep 18 05:49 mysql-bin.000463
  96. -rw-rw---- 1 mysql mysql 101M Sep 18 05:53 mysql-bin.000464
  97. -rw-rw---- 1 mysql mysql 103M Sep 19 07:43 mysql-bin.000465
  98. -rw-rw---- 1 mysql mysql 101M Sep 19 07:44 mysql-bin.000466
  99. -rw-rw---- 1 mysql mysql 101M Sep 19 07:45 mysql-bin.000467
  100. -rw-rw---- 1 mysql mysql 102M Sep 19 07:46 mysql-bin.000468
  101. -rw-rw---- 1 mysql mysql 102M Sep 19 07:47 mysql-bin.000469
  102. -rw-rw---- 1 mysql mysql 103M Sep 19 07:48 mysql-bin.000470
  103. -rw-rw---- 1 mysql mysql 102M Sep 19 07:49 mysql-bin.000471
  104. -rw-rw---- 1 mysql mysql 103M Sep 19 07:50 mysql-bin.000472
  105. -rw-rw---- 1 mysql mysql 101M Sep 19 07:51 mysql-bin.000473
  106. -rw-rw---- 1 mysql mysql 102M Sep 19 07:53 mysql-bin.000474
  107. -rw-rw---- 1 mysql mysql 101M Sep 19 07:54 mysql-bin.000475
  108. -rw-rw---- 1 mysql mysql 103M Sep 19 07:55 mysql-bin.000476
  109. -rw-rw---- 1 mysql mysql 103M Sep 19 07:57 mysql-bin.000477
  110. -rw-rw---- 1 mysql mysql 103M Sep 19 07:58 mysql-bin.000478
  111. -rw-rw---- 1 mysql mysql 102M Sep 19 08:00 mysql-bin.000479
  112. -rw-rw---- 1 mysql mysql 103M Sep 19 08:01 mysql-bin.000480
  113. -rw-rw---- 1 mysql mysql 103M Sep 19 08:03 mysql-bin.000481
  114. -rw-rw---- 1 mysql mysql 101M Sep 19 08:05 mysql-bin.000482
  115. -rw-rw---- 1 mysql mysql 101M Sep 19 08:07 mysql-bin.000483
  116. -rw-rw---- 1 mysql mysql 102M Sep 19 08:09 mysql-bin.000484
  117. -rw-rw---- 1 mysql mysql 102M Sep 19 08:11 mysql-bin.000485
  118. -rw-rw---- 1 mysql mysql 101M Sep 19 08:13 mysql-bin.000486
  119. -rw-rw---- 1 mysql mysql 101M Sep 19 08:15 mysql-bin.000487
  120. -rw-rw---- 1 mysql mysql 101M Sep 19 08:17 mysql-bin.000488
  121. -rw-rw---- 1 mysql mysql 101M Sep 19 08:19 mysql-bin.000489
  122. -rw-rw---- 1 mysql mysql 101M Sep 19 08:21 mysql-bin.000490
  123. -rw-rw---- 1 mysql mysql 102M Sep 19 08:24 mysql-bin.000491
  124. -rw-rw---- 1 mysql mysql 104M Sep 19 08:26 mysql-bin.000492
  125. -rw-rw---- 1 mysql mysql 101M Sep 19 08:29 mysql-bin.000493
  126. -rw-rw---- 1 mysql mysql 102M Sep 19 08:32 mysql-bin.000494
  127. -rw-rw---- 1 mysql mysql 103M Sep 19 08:34 mysql-bin.000495
  128. -rw-rw---- 1 mysql mysql 102M Sep 19 08:37 mysql-bin.000496
  129. -rw-rw---- 1 mysql mysql 101M Sep 19 08:40 mysql-bin.000497
  130. -rw-rw---- 1 mysql mysql 101M Sep 19 08:43 mysql-bin.000498
  131. -rw-rw---- 1 mysql mysql 102M Sep 19 08:46 mysql-bin.000499
  132. -rw-rw---- 1 mysql mysql 101M Sep 19 08:49 mysql-bin.000500
  133. -rw-rw---- 1 mysql mysql 101M Sep 19 08:52 mysql-bin.000501
  134. -rw-rw---- 1 mysql mysql 103M Sep 19 08:55 mysql-bin.000502
  135. -rw-rw---- 1 mysql mysql 102M Sep 19 08:58 mysql-bin.000503
  136. -rw-rw---- 1 mysql mysql 101M Sep 19 09:01 mysql-bin.000504
  137. -rw-rw---- 1 mysql mysql 102M Sep 19 09:05 mysql-bin.000505
  138. -rw-rw---- 1 mysql mysql 104M Sep 19 09:08 mysql-bin.000506
  139. -rw-rw---- 1 mysql mysql 103M Sep 19 09:12 mysql-bin.000507
  140. -rw-rw---- 1 mysql mysql 101M Sep 19 09:15 mysql-bin.000508
  141. -rw-rw---- 1 mysql mysql 103M Sep 19 09:19 mysql-bin.000509
  142. -rw-rw---- 1 mysql mysql 103M Sep 19 09:22 mysql-bin.000510
  143. -rw-rw---- 1 mysql mysql 104M Sep 19 09:26 mysql-bin.000511
  144. -rw-rw---- 1 mysql mysql 102M Sep 19 09:30 mysql-bin.000512
  145. -rw-rw---- 1 mysql mysql 102M Sep 19 09:34 mysql-bin.000513
  146. -rw-rw---- 1 mysql mysql 102M Sep 19 09:38 mysql-bin.000514
  147. -rw-rw---- 1 mysql mysql 102M Sep 19 09:42 mysql-bin.000515
  148. -rw-rw---- 1 mysql mysql 48M Sep 23 01:50 mysql-bin.000516
  149. -rw-rw---- 1 mysql mysql 1.2M Sep 23 02:44 mysql-bin.000517
  150. -rw-rw---- 1 mysql adm 3.2K Sep 23 02:23 mysql-bin.index
  151.  
  152. root@prod-dbm:/vol/log/mysql# ll -h
  153. total 394M
  154. drwxr-s--- 2 mysql adm 134 2014-09-18 21:40 ./
  155. drwxr-xr-x 3 root root 18 2012-12-29 18:52 ../
  156. -rw-rw---- 1 mysql adm 197K 2014-07-21 18:41 error.log
  157. -rw-rw---- 1 mysql adm 101M 2014-09-14 01:50 mysql-bin.000415
  158. -rw-rw---- 1 mysql adm 101M 2014-09-18 21:40 mysql-bin.000416
  159. -rw-rw---- 1 mysql adm 99M 2014-09-23 02:46 mysql-bin.000417
  160. -rw-rw---- 1 mysql adm 96 2014-09-18 21:40 mysql-bin.index
  161. -rw-rw---- 1 mysql adm 31M 2014-09-23 01:53 slow_query.log
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!