API tools faq
paste
Advertisement
SkyCGM

:D

SkyCGM
Feb 11th, 2016
432
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.31 KB | None | 0 0
raw download clone embed print report
  1. +-----------------------------------+----------------+
  2. | VARIABLE_NAME | VARIABLE_VALUE |
  3. +-----------------------------------+----------------+
  4. [17:45:45] [WARNING] console output will be trimmed to last 256 rows due to large table size
  5. | COM_CREATE_USER | 0 |
  6. | COM_CREATE_VIEW | 0 |
  7. | COM_DEALLOC_SQL | 0 |
  8. | COM_DELETE | 0 |
  9. | COM_DELETE_MULTI | 0 |
  10. | COM_DO | 0 |
  11. | COM_DROP_DB | 0 |
  12. | COM_DROP_EVENT | 0 |
  13. | COM_DROP_FUNCTION | 0 |
  14. | COM_DROP_INDEX | 0 |
  15. | COM_DROP_PROCEDURE | 0 |
  16. | COM_DROP_SERVER | 0 |
  17. | COM_DROP_TABLE | 0 |
  18. | COM_DROP_TRIGGER | 0 |
  19. | COM_DROP_USER | 0 |
  20. | COM_DROP_VIEW | 0 |
  21. | COM_EMPTY_QUERY | 0 |
  22. | COM_EXECUTE_SQL | 0 |
  23. | COM_FLUSH | 0 |
  24. | COM_GRANT | 0 |
  25. | COM_HA_CLOSE | 0 |
  26. | COM_HA_OPEN | 0 |
  27. | COM_HA_READ | 0 |
  28. | COM_HELP | 0 |
  29. | COM_INSERT | 0 |
  30. | COM_INSERT_SELECT | 0 |
  31. | COM_INSTALL_PLUGIN | 0 |
  32. | COM_KILL | 0 |
  33. | COM_LOAD | 0 |
  34. | COM_LOAD_MASTER_DATA | 0 |
  35. | COM_LOAD_MASTER_TABLE | 0 |
  36. | COM_LOCK_TABLES | 0 |
  37. | COM_OPTIMIZE | 0 |
  38. | COM_PRELOAD_KEYS | 0 |
  39. | COM_PREPARE_SQL | 0 |
  40. | COM_PURGE | 0 |
  41. | COM_PURGE_BEFORE_DATE | 0 |
  42. | COM_RELEASE_SAVEPOINT | 0 |
  43. | COM_RENAME_TABLE | 0 |
  44. | COM_RENAME_USER | 0 |
  45. | COM_REPAIR | 0 |
  46. | COM_REPLACE | 0 |
  47. | COM_REPLACE_SELECT | 0 |
  48. | COM_RESET | 0 |
  49. | COM_RESTORE_TABLE | 0 |
  50. | COM_REVOKE | 0 |
  51. | COM_REVOKE_ALL | 0 |
  52. | COM_ROLLBACK | 0 |
  53. | COM_ROLLBACK_TO_SAVEPOINT | 0 |
  54. | COM_SAVEPOINT | 0 |
  55. | COM_SELECT | 1 |
  56. | COM_SET_OPTION | 1 |
  57. | COM_SHOW_AUTHORS | 0 |
  58. | COM_SHOW_BINLOG_EVENTS | 0 |
  59. | COM_SHOW_BINLOGS | 0 |
  60. | COM_SHOW_CHARSETS | 0 |
  61. | COM_SHOW_COLLATIONS | 0 |
  62. | COM_SHOW_COLUMN_TYPES | 0 |
  63. | COM_SHOW_CONTRIBUTORS | 0 |
  64. | COM_SHOW_CREATE_DB | 0 |
  65. | COM_SHOW_CREATE_EVENT | 0 |
  66. | COM_SHOW_CREATE_FUNC | 0 |
  67. | COM_SHOW_CREATE_PROC | 0 |
  68. | COM_SHOW_CREATE_TABLE | 0 |
  69. | COM_SHOW_CREATE_TRIGGER | 0 |
  70. | COM_SHOW_DATABASES | 0 |
  71. | COM_SHOW_ENGINE_LOGS | 0 |
  72. | COM_SHOW_ENGINE_MUTEX | 0 |
  73. | COM_SHOW_ENGINE_STATUS | 0 |
  74. | COM_SHOW_EVENTS | 0 |
  75. | COM_SHOW_ERRORS | 0 |
  76. | COM_SHOW_FIELDS | 0 |
  77. | COM_SHOW_FUNCTION_STATUS | 0 |
  78. | COM_SHOW_GRANTS | 0 |
  79. | COM_SHOW_KEYS | 0 |
  80. | COM_SHOW_MASTER_STATUS | 0 |
  81. | COM_SHOW_NEW_MASTER | 0 |
  82. | COM_SHOW_OPEN_TABLES | 0 |
  83. | COM_SHOW_PLUGINS | 0 |
  84. | COM_SHOW_PRIVILEGES | 0 |
  85. | COM_SHOW_PROCEDURE_STATUS | 0 |
  86. | COM_SHOW_PROCESSLIST | 0 |
  87. | COM_SHOW_PROFILE | 0 |
  88. | COM_SHOW_PROFILES | 0 |
  89. | COM_SHOW_SLAVE_HOSTS | 0 |
  90. | COM_SHOW_SLAVE_STATUS | 0 |
  91. | COM_SHOW_STATUS | 0 |
  92. | COM_SHOW_STORAGE_ENGINES | 0 |
  93. | COM_SHOW_TABLE_STATUS | 0 |
  94. | COM_SHOW_TABLES | 0 |
  95. | COM_SHOW_TRIGGERS | 0 |
  96. | COM_SHOW_VARIABLES | 0 |
  97. | COM_SHOW_WARNINGS | 0 |
  98. | COM_SLAVE_START | 0 |
  99. | COM_SLAVE_STOP | 0 |
  100. | COM_STMT_CLOSE | 0 |
  101. | COM_STMT_EXECUTE | 0 |
  102. | COM_STMT_FETCH | 0 |
  103. | COM_STMT_PREPARE | 0 |
  104. | COM_STMT_REPREPARE | 0 |
  105. | COM_STMT_RESET | 0 |
  106. | COM_STMT_SEND_LONG_DATA | 0 |
  107. | COM_TRUNCATE | 0 |
  108. | COM_UNINSTALL_PLUGIN | 0 |
  109. | COM_UNLOCK_TABLES | 0 |
  110. | COM_UPDATE | 0 |
  111. | COM_UPDATE_MULTI | 0 |
  112. | COM_XA_COMMIT | 0 |
  113. | COM_XA_END | 0 |
  114. | COM_XA_PREPARE | 0 |
  115. | COM_XA_RECOVER | 0 |
  116. | COM_XA_ROLLBACK | 0 |
  117. | COM_XA_START | 0 |
  118. | COMPRESSION | OFF |
  119. | CONNECTIONS | 19841 |
  120. | CREATED_TMP_DISK_TABLES | 1 |
  121. | CREATED_TMP_FILES | 151 |
  122. | CREATED_TMP_TABLES | 2 |
  123. | DELAYED_ERRORS | 0 |
  124. | DELAYED_INSERT_THREADS | 0 |
  125. | DELAYED_WRITES | 0 |
  126. | FLUSH_COMMANDS | 1 |
  127. | HANDLER_COMMIT | 0 |
  128. | HANDLER_DELETE | 0 |
  129. | HANDLER_DISCOVER | 0 |
  130. | HANDLER_PREPARE | 0 |
  131. | HANDLER_READ_FIRST | 0 |
  132. | HANDLER_READ_KEY | 1 |
  133. | HANDLER_READ_NEXT | 1 |
  134. | HANDLER_READ_PREV | 0 |
  135. | HANDLER_READ_RND | 0 |
  136. | HANDLER_READ_RND_NEXT | 0 |
  137. | HANDLER_ROLLBACK | 0 |
  138. | HANDLER_SAVEPOINT | 0 |
  139. | HANDLER_SAVEPOINT_ROLLBACK | 0 |
  140. | HANDLER_UPDATE | 0 |
  141. | HANDLER_WRITE | 172 |
  142. | INNODB_BUFFER_POOL_PAGES_DATA | 511 |
  143. | INNODB_BUFFER_POOL_PAGES_DIRTY | 0 |
  144. | INNODB_BUFFER_POOL_PAGES_FLUSHED | 2 |
  145. | INNODB_BUFFER_POOL_PAGES_FREE | 0 |
  146. | INNODB_BUFFER_POOL_PAGES_MISC | 1 |
  147. | INNODB_BUFFER_POOL_PAGES_TOTAL | 512 |
  148. | INNODB_BUFFER_POOL_READ_AHEAD_RND | 259 |
  149. | INNODB_BUFFER_POOL_READ_AHEAD_SEQ | 425 |
  150. | INNODB_BUFFER_POOL_READ_REQUESTS | 759723 |
  151. | INNODB_BUFFER_POOL_READS | 5472 |
  152. | INNODB_BUFFER_POOL_WAIT_FREE | 0 |
  153. | INNODB_BUFFER_POOL_WRITE_REQUESTS | 2 |
  154. | INNODB_DATA_FSYNCS | 11 |
  155. | INNODB_DATA_PENDING_FSYNCS | 0 |
  156. | INNODB_DATA_PENDING_READS | 0 |
  157. | INNODB_DATA_PENDING_WRITES | 0 |
  158. | INNODB_DATA_READ | 230772736 |
  159. | INNODB_DATA_READS | 6835 |
  160. | INNODB_DATA_WRITES | 11 |
  161. | INNODB_DATA_WRITTEN | 69120 |
  162. | INNODB_DBLWR_PAGES_WRITTEN | 2 |
  163. | INNODB_DBLWR_WRITES | 2 |
  164. | INNODB_LOG_WAITS | 0 |
  165. | INNODB_LOG_WRITE_REQUESTS | 0 |
  166. | INNODB_LOG_WRITES | 3 |
  167. | INNODB_OS_LOG_FSYNCS | 7 |
  168. | INNODB_OS_LOG_PENDING_FSYNCS | 0 |
  169. | INNODB_OS_LOG_PENDING_WRITES | 0 |
  170. | INNODB_OS_LOG_WRITTEN | 1536 |
  171. | INNODB_PAGE_SIZE | 16384 |
  172. | INNODB_PAGES_CREATED | 0 |
  173. | INNODB_PAGES_READ | 13952 |
  174. | INNODB_PAGES_WRITTEN | 2 |
  175. | INNODB_ROW_LOCK_CURRENT_WAITS | 0 |
  176. | INNODB_ROW_LOCK_TIME | 0 |
  177. | INNODB_ROW_LOCK_TIME_AVG | 0 |
  178. | INNODB_ROW_LOCK_TIME_MAX | 0 |
  179. | INNODB_ROW_LOCK_WAITS | 0 |
  180. | INNODB_ROWS_DELETED | 0 |
  181. | INNODB_ROWS_INSERTED | 0 |
  182. | INNODB_ROWS_READ | 726946 |
  183. | INNODB_ROWS_UPDATED | 0 |
  184. | KEY_BLOCKS_NOT_FLUSHED | 0 |
  185. | KEY_BLOCKS_UNUSED | 8134 |
  186. | KEY_BLOCKS_USED | 5853 |
  187. | KEY_READ_REQUESTS | 24038712 |
  188. | KEY_READS | 39729 |
  189. | KEY_WRITE_REQUESTS | 85246 |
  190. | KEY_WRITES | 69051 |
  191. | LAST_QUERY_COST | 0.000000 |
  192. | MAX_USED_CONNECTIONS | 8 |
  193. | NOT_FLUSHED_DELAYED_ROWS | 0 |
  194. | OPEN_FILES | 124 |
  195. | OPEN_STREAMS | 0 |
  196. | OPEN_TABLE_DEFINITIONS | 256 |
  197. | OPEN_TABLES | 64 |
  198. | OPENED_FILES | 88212 |
  199. | OPENED_TABLE_DEFINITIONS | 0 |
  200. | OPENED_TABLES | 0 |
  201. | PREPARED_STMT_COUNT | 0 |
  202. | QCACHE_FREE_BLOCKS | 1316 |
  203. | QCACHE_FREE_MEMORY | 4430872 |
  204. | QCACHE_HITS | 1293005 |
  205. | QCACHE_INSERTS | 944293 |
  206. | QCACHE_LOWMEM_PRUNES | 879284 |
  207. | QCACHE_NOT_CACHED | 4675 |
  208. | QCACHE_QUERIES_IN_CACHE | 6819 |
  209. | QCACHE_TOTAL_BLOCKS | 15707 |
  210. | QUERIES | 2374393 |
  211. | QUESTIONS | 3 |
  212. | RPL_STATUS | NULL |
  213. | SELECT_FULL_JOIN | 0 |
  214. | SELECT_FULL_RANGE_JOIN | 0 |
  215. | SELECT_RANGE | 0 |
  216. | SELECT_RANGE_CHECK | 0 |
  217. | SELECT_SCAN | 1 |
  218. | SLAVE_OPEN_TEMP_TABLES | 0 |
  219. | SLAVE_RETRIED_TRANSACTIONS | 0 |
  220. | SLAVE_RUNNING | OFF |
  221. | SLOW_LAUNCH_THREADS | 0 |
  222. | SLOW_QUERIES | 0 |
  223. | SORT_MERGE_PASSES | 0 |
  224. | SORT_RANGE | 0 |
  225. | SORT_ROWS | 0 |
  226. | SORT_SCAN | 0 |
  227. | SSL_ACCEPT_RENEGOTIATES | 0 |
  228. | SSL_ACCEPTS | 0 |
  229. | SSL_CALLBACK_CACHE_HITS | 0 |
  230. | SSL_CIPHER | <blank> |
  231. | SSL_CIPHER_LIST | <blank> |
  232. | SSL_CLIENT_CONNECTS | 0 |
  233. | SSL_CONNECT_RENEGOTIATES | 0 |
  234. | SSL_CTX_VERIFY_DEPTH | 0 |
  235. | SSL_CTX_VERIFY_MODE | 0 |
  236. | SSL_DEFAULT_TIMEOUT | 0 |
  237. | SSL_FINISHED_ACCEPTS | 0 |
  238. | SSL_FINISHED_CONNECTS | 0 |
  239. | SSL_SESSION_CACHE_HITS | 0 |
  240. | SSL_SESSION_CACHE_MISSES | 0 |
  241. | SSL_SESSION_CACHE_MODE | NONE |
  242. | SSL_SESSION_CACHE_OVERFLOWS | 0 |
  243. | SSL_SESSION_CACHE_SIZE | 0 |
  244. | SSL_SESSION_CACHE_TIMEOUTS | 0 |
  245. | SSL_SESSIONS_REUSED | 0 |
  246. | SSL_USED_SESSION_CACHE_ENTRIES | 0 |
  247. | SSL_VERIFY_DEPTH | 0 |
  248. | SSL_VERIFY_MODE | 0 |
  249. | SSL_VERSION | <blank> |
  250. | TABLE_LOCKS_IMMEDIATE | 1044746 |
  251. | TABLE_LOCKS_WAITED | 39 |
  252. | TC_LOG_MAX_PAGES_USED | 0 |
  253. | TC_LOG_PAGE_SIZE | 0 |
  254. | TC_LOG_PAGE_WAITS | 0 |
  255. | THREADS_CACHED | 6 |
  256. | THREADS_CONNECTED | 1 |
  257. | THREADS_CREATED | 8 |
  258. | THREADS_RUNNING | 1 |
  259. | UPTIME | 46979 |
  260. | UPTIME_SINCE_FLUSH_STATUS | 46980 |
  261. +-----------------------------------+----------------+
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!