Advertisement
ababababababab

Untitled

Sep 10th, 2021
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.19 KB | None | 0 0
  1. mysql> show engine performance_schema status;
  2. +--------------------+-------------------------------------------------------------+-----------+
  3. | Type | Name | Status |
  4. +--------------------+-------------------------------------------------------------+-----------+
  5. | performance_schema | events_waits_current.size | 176 |
  6. | performance_schema | events_waits_current.count | 1536 |
  7. | performance_schema | events_waits_history.size | 176 |
  8. | performance_schema | events_waits_history.count | 2560 |
  9. | performance_schema | events_waits_history.memory | 450560 |
  10. | performance_schema | events_waits_history_long.size | 176 |
  11. | performance_schema | events_waits_history_long.count | 10000 |
  12. | performance_schema | events_waits_history_long.memory | 1760000 |
  13. | performance_schema | (pfs_mutex_class).size | 256 |
  14. | performance_schema | (pfs_mutex_class).count | 300 |
  15. | performance_schema | (pfs_mutex_class).memory | 76800 |
  16. | performance_schema | (pfs_rwlock_class).size | 256 |
  17. | performance_schema | (pfs_rwlock_class).count | 60 |
  18. | performance_schema | (pfs_rwlock_class).memory | 15360 |
  19. | performance_schema | (pfs_cond_class).size | 256 |
  20. | performance_schema | (pfs_cond_class).count | 100 |
  21. | performance_schema | (pfs_cond_class).memory | 25600 |
  22. | performance_schema | (pfs_thread_class).size | 256 |
  23. | performance_schema | (pfs_thread_class).count | 100 |
  24. | performance_schema | (pfs_thread_class).memory | 25600 |
  25. | performance_schema | (pfs_file_class).size | 320 |
  26. | performance_schema | (pfs_file_class).count | 80 |
  27. | performance_schema | (pfs_file_class).memory | 25600 |
  28. | performance_schema | mutex_instances.size | 80 |
  29. | performance_schema | mutex_instances.count | 4096 |
  30. | performance_schema | mutex_instances.memory | 327680 |
  31. | performance_schema | rwlock_instances.size | 88 |
  32. | performance_schema | rwlock_instances.count | 2048 |
  33. | performance_schema | rwlock_instances.memory | 180224 |
  34. | performance_schema | cond_instances.size | 72 |
  35. | performance_schema | cond_instances.count | 256 |
  36. | performance_schema | cond_instances.memory | 18432 |
  37. | performance_schema | threads.size | 4288 |
  38. | performance_schema | threads.count | 256 |
  39. | performance_schema | threads.memory | 1097728 |
  40. | performance_schema | file_instances.size | 704 |
  41. | performance_schema | file_instances.count | 4096 |
  42. | performance_schema | file_instances.memory | 2883584 |
  43. | performance_schema | (pfs_file_handle).size | 8 |
  44. | performance_schema | (pfs_file_handle).count | 32768 |
  45. | performance_schema | (pfs_file_handle).memory | 262144 |
  46. | performance_schema | events_waits_summary_by_thread_by_event_name.size | 32 |
  47. | performance_schema | events_waits_summary_by_thread_by_event_name.count | 141824 |
  48. | performance_schema | events_waits_summary_by_thread_by_event_name.memory | 4538368 |
  49. | performance_schema | (pfs_table_share).size | 1024 |
  50. | performance_schema | (pfs_table_share).count | 4096 |
  51. | performance_schema | (pfs_table_share).memory | 4194304 |
  52. | performance_schema | (pfs_table).size | 9280 |
  53. | performance_schema | (pfs_table).count | 1024 |
  54. | performance_schema | (pfs_table).memory | 9502720 |
  55. | performance_schema | setup_actors.size | 512 |
  56. | performance_schema | setup_actors.count | 128 |
  57. | performance_schema | setup_actors.memory | 65536 |
  58. | performance_schema | setup_objects.size | 448 |
  59. | performance_schema | setup_objects.count | 128 |
  60. | performance_schema | setup_objects.memory | 57344 |
  61. | performance_schema | (pfs_account).size | 896 |
  62. | performance_schema | (pfs_account).count | 128 |
  63. | performance_schema | (pfs_account).memory | 114688 |
  64. | performance_schema | events_waits_summary_by_account_by_event_name.size | 32 |
  65. | performance_schema | events_waits_summary_by_account_by_event_name.count | 70912 |
  66. | performance_schema | events_waits_summary_by_account_by_event_name.memory | 2269184 |
  67. | performance_schema | events_waits_summary_by_user_by_event_name.size | 32 |
  68. | performance_schema | events_waits_summary_by_user_by_event_name.count | 70912 |
  69. | performance_schema | events_waits_summary_by_user_by_event_name.memory | 2269184 |
  70. | performance_schema | events_waits_summary_by_host_by_event_name.size | 32 |
  71. | performance_schema | events_waits_summary_by_host_by_event_name.count | 70912 |
  72. | performance_schema | events_waits_summary_by_host_by_event_name.memory | 2269184 |
  73. | performance_schema | (pfs_user).size | 640 |
  74. | performance_schema | (pfs_user).count | 128 |
  75. | performance_schema | (pfs_user).memory | 81920 |
  76. | performance_schema | (pfs_host).size | 768 |
  77. | performance_schema | (pfs_host).count | 128 |
  78. | performance_schema | (pfs_host).memory | 98304 |
  79. | performance_schema | (pfs_stage_class).size | 256 |
  80. | performance_schema | (pfs_stage_class).count | 175 |
  81. | performance_schema | (pfs_stage_class).memory | 44800 |
  82. | performance_schema | events_stages_history.size | 104 |
  83. | performance_schema | events_stages_history.count | 2560 |
  84. | performance_schema | events_stages_history.memory | 266240 |
  85. | performance_schema | events_stages_history_long.size | 104 |
  86. | performance_schema | events_stages_history_long.count | 10000 |
  87. | performance_schema | events_stages_history_long.memory | 1040000 |
  88. | performance_schema | events_stages_summary_by_thread_by_event_name.size | 32 |
  89. | performance_schema | events_stages_summary_by_thread_by_event_name.count | 44800 |
  90. | performance_schema | events_stages_summary_by_thread_by_event_name.memory | 1433600 |
  91. | performance_schema | events_stages_summary_global_by_event_name.size | 32 |
  92. | performance_schema | events_stages_summary_global_by_event_name.count | 175 |
  93. | performance_schema | events_stages_summary_global_by_event_name.memory | 5600 |
  94. | performance_schema | events_stages_summary_by_account_by_event_name.size | 32 |
  95. | performance_schema | events_stages_summary_by_account_by_event_name.count | 22400 |
  96. | performance_schema | events_stages_summary_by_account_by_event_name.memory | 716800 |
  97. | performance_schema | events_stages_summary_by_user_by_event_name.size | 32 |
  98. | performance_schema | events_stages_summary_by_user_by_event_name.count | 22400 |
  99. | performance_schema | events_stages_summary_by_user_by_event_name.memory | 716800 |
  100. | performance_schema | events_stages_summary_by_host_by_event_name.size | 32 |
  101. | performance_schema | events_stages_summary_by_host_by_event_name.count | 22400 |
  102. | performance_schema | events_stages_summary_by_host_by_event_name.memory | 716800 |
  103. | performance_schema | (pfs_statement_class).size | 192 |
  104. | performance_schema | (pfs_statement_class).count | 218 |
  105. | performance_schema | (pfs_statement_class).memory | 41856 |
  106. | performance_schema | events_statements_history.size | 1456 |
  107. | performance_schema | events_statements_history.count | 2560 |
  108. | performance_schema | events_statements_history.memory | 3727360 |
  109. | performance_schema | events_statements_history_long.size | 1456 |
  110. | performance_schema | events_statements_history_long.count | 10000 |
  111. | performance_schema | events_statements_history_long.memory | 14560000 |
  112. | performance_schema | events_statements_summary_by_thread_by_event_name.size | 184 |
  113. | performance_schema | events_statements_summary_by_thread_by_event_name.count | 55808 |
  114. | performance_schema | events_statements_summary_by_thread_by_event_name.memory | 10268672 |
  115. | performance_schema | events_statements_summary_global_by_event_name.size | 184 |
  116. | performance_schema | events_statements_summary_global_by_event_name.count | 218 |
  117. | performance_schema | events_statements_summary_global_by_event_name.memory | 40112 |
  118. | performance_schema | events_statements_summary_by_account_by_event_name.size | 184 |
  119. | performance_schema | events_statements_summary_by_account_by_event_name.count | 27904 |
  120. | performance_schema | events_statements_summary_by_account_by_event_name.memory | 5134336 |
  121. | performance_schema | events_statements_summary_by_user_by_event_name.size | 184 |
  122. | performance_schema | events_statements_summary_by_user_by_event_name.count | 27904 |
  123. | performance_schema | events_statements_summary_by_user_by_event_name.memory | 5134336 |
  124. | performance_schema | events_statements_summary_by_host_by_event_name.size | 184 |
  125. | performance_schema | events_statements_summary_by_host_by_event_name.count | 27904 |
  126. | performance_schema | events_statements_summary_by_host_by_event_name.memory | 5134336 |
  127. | performance_schema | events_statements_current.size | 1456 |
  128. | performance_schema | events_statements_current.count | 2560 |
  129. | performance_schema | events_statements_current.memory | 3727360 |
  130. | performance_schema | (pfs_socket_class).size | 320 |
  131. | performance_schema | (pfs_socket_class).count | 10 |
  132. | performance_schema | (pfs_socket_class).memory | 3200 |
  133. | performance_schema | socket_instances.size | 312 |
  134. | performance_schema | socket_instances.count | 256 |
  135. | performance_schema | socket_instances.memory | 79872 |
  136. | performance_schema | events_statements_summary_by_digest.size | 4160 |
  137. | performance_schema | events_statements_summary_by_digest.count | 10000 |
  138. | performance_schema | events_statements_summary_by_digest.memory | 41600000 |
  139. | performance_schema | events_statements_summary_by_program.size | 448 |
  140. | performance_schema | events_statements_summary_by_program.count | 0 |
  141. | performance_schema | events_statements_summary_by_program.memory | 0 |
  142. | performance_schema | session_connect_attrs.size | 256 |
  143. | performance_schema | session_connect_attrs.count | 512 |
  144. | performance_schema | session_connect_attrs.memory | 131072 |
  145. | performance_schema | prepared_statements_instances.size | 1664 |
  146. | performance_schema | prepared_statements_instances.count | 0 |
  147. | performance_schema | prepared_statements_instances.memory | 0 |
  148. | performance_schema | (account_hash).count | 4 |
  149. | performance_schema | (account_hash).size | 4 |
  150. | performance_schema | (digest_hash).count | 5 |
  151. | performance_schema | (digest_hash).size | 8 |
  152. | performance_schema | (filename_hash).count | 207 |
  153. | performance_schema | (filename_hash).size | 256 |
  154. | performance_schema | (host_hash).count | 2 |
  155. | performance_schema | (host_hash).size | 2 |
  156. | performance_schema | (setup_actor_hash).count | 1 |
  157. | performance_schema | (setup_actor_hash).size | 1 |
  158. | performance_schema | (setup_object_hash).count | 20 |
  159. | performance_schema | (setup_object_hash).size | 32 |
  160. | performance_schema | (table_share_hash).count | 50 |
  161. | performance_schema | (table_share_hash).size | 64 |
  162. | performance_schema | (user_hash).count | 4 |
  163. | performance_schema | (user_hash).size | 4 |
  164. | performance_schema | (program_hash).count | 0 |
  165. | performance_schema | (program_hash).size | 1 |
  166. | performance_schema | host_cache.size | 512 |
  167. | performance_schema | (pfs_memory_class).row_size | 192 |
  168. | performance_schema | (pfs_memory_class).row_count | 450 |
  169. | performance_schema | (pfs_memory_class).memory | 86400 |
  170. | performance_schema | memory_summary_by_thread_by_event_name.row_size | 72 |
  171. | performance_schema | memory_summary_by_thread_by_event_name.row_count | 115200 |
  172. | performance_schema | memory_summary_by_thread_by_event_name.memory | 8294400 |
  173. | performance_schema | memory_summary_global_by_event_name.row_size | 72 |
  174. | performance_schema | memory_summary_global_by_event_name.row_count | 450 |
  175. | performance_schema | memory_summary_global_by_event_name.memory | 32400 |
  176. | performance_schema | memory_summary_by_account_by_event_name.row_size | 72 |
  177. | performance_schema | memory_summary_by_account_by_event_name.row_count | 57600 |
  178. | performance_schema | memory_summary_by_account_by_event_name.memory | 4147200 |
  179. | performance_schema | memory_summary_by_user_by_event_name.row_size | 72 |
  180. | performance_schema | memory_summary_by_user_by_event_name.row_count | 57600 |
  181. | performance_schema | memory_summary_by_user_by_event_name.memory | 4147200 |
  182. | performance_schema | memory_summary_by_host_by_event_name.row_size | 72 |
  183. | performance_schema | memory_summary_by_host_by_event_name.row_count | 57600 |
  184. | performance_schema | memory_summary_by_host_by_event_name.memory | 4147200 |
  185. | performance_schema | metadata_locks.row_size | 512 |
  186. | performance_schema | metadata_locks.row_count | 1024 |
  187. | performance_schema | metadata_locks.memory | 524288 |
  188. | performance_schema | events_transactions_history.size | 344 |
  189. | performance_schema | events_transactions_history.count | 2560 |
  190. | performance_schema | events_transactions_history.memory | 880640 |
  191. | performance_schema | events_transactions_history_long.size | 344 |
  192. | performance_schema | events_transactions_history_long.count | 10000 |
  193. | performance_schema | events_transactions_history_long.memory | 3440000 |
  194. | performance_schema | events_transactions_summary_by_thread_by_event_name.size | 88 |
  195. | performance_schema | events_transactions_summary_by_thread_by_event_name.count | 256 |
  196. | performance_schema | events_transactions_summary_by_thread_by_event_name.memory | 22528 |
  197. | performance_schema | events_transactions_summary_by_account_by_event_name.size | 88 |
  198. | performance_schema | events_transactions_summary_by_account_by_event_name.count | 128 |
  199. | performance_schema | events_transactions_summary_by_account_by_event_name.memory | 11264 |
  200. | performance_schema | events_transactions_summary_by_user_by_event_name.size | 88 |
  201. | performance_schema | events_transactions_summary_by_user_by_event_name.count | 128 |
  202. | performance_schema | events_transactions_summary_by_user_by_event_name.memory | 11264 |
  203. | performance_schema | events_transactions_summary_by_host_by_event_name.size | 88 |
  204. | performance_schema | events_transactions_summary_by_host_by_event_name.count | 128 |
  205. | performance_schema | events_transactions_summary_by_host_by_event_name.memory | 11264 |
  206. | performance_schema | table_lock_waits_summary_by_table.size | 344 |
  207. | performance_schema | table_lock_waits_summary_by_table.count | 0 |
  208. | performance_schema | table_lock_waits_summary_by_table.memory | 0 |
  209. | performance_schema | table_io_waits_summary_by_index_usage.size | 352 |
  210. | performance_schema | table_io_waits_summary_by_index_usage.count | 8192 |
  211. | performance_schema | table_io_waits_summary_by_index_usage.memory | 2883584 |
  212. | performance_schema | (history_long_statements_digest_token_array).count | 10000 |
  213. | performance_schema | (history_long_statements_digest_token_array).size | 1024 |
  214. | performance_schema | (history_long_statements_digest_token_array).memory | 10240000 |
  215. | performance_schema | (history_statements_digest_token_array).count | 2560 |
  216. | performance_schema | (history_statements_digest_token_array).size | 1024 |
  217. | performance_schema | (history_statements_digest_token_array).memory | 2621440 |
  218. | performance_schema | (current_statements_digest_token_array).count | 2560 |
  219. | performance_schema | (current_statements_digest_token_array).size | 1024 |
  220. | performance_schema | (current_statements_digest_token_array).memory | 2621440 |
  221. | performance_schema | (history_long_statements_text_array).count | 10000 |
  222. | performance_schema | (history_long_statements_text_array).size | 1024 |
  223. | performance_schema | (history_long_statements_text_array).memory | 10240000 |
  224. | performance_schema | (history_statements_text_array).count | 2560 |
  225. | performance_schema | (history_statements_text_array).size | 1024 |
  226. | performance_schema | (history_statements_text_array).memory | 2621440 |
  227. | performance_schema | (current_statements_text_array).count | 2560 |
  228. | performance_schema | (current_statements_text_array).size | 1024 |
  229. | performance_schema | (current_statements_text_array).memory | 2621440 |
  230. | performance_schema | (statements_digest_token_array).count | 10000 |
  231. | performance_schema | (statements_digest_token_array).size | 1024 |
  232. | performance_schema | (statements_digest_token_array).memory | 10240000 |
  233. | performance_schema | events_errors_summary_by_thread_by_error.size | 48848 |
  234. | performance_schema | events_errors_summary_by_thread_by_error.count | 256 |
  235. | performance_schema | events_errors_summary_by_thread_by_error.memory | 12505088 |
  236. | performance_schema | events_errors_summary_by_account_by_error.size | 48848 |
  237. | performance_schema | events_errors_summary_by_account_by_error.count | 128 |
  238. | performance_schema | events_errors_summary_by_account_by_error.memory | 6252544 |
  239. | performance_schema | events_errors_summary_by_user_by_error.size | 48848 |
  240. | performance_schema | events_errors_summary_by_user_by_error.count | 128 |
  241. | performance_schema | events_errors_summary_by_user_by_error.memory | 6252544 |
  242. | performance_schema | events_errors_summary_by_host_by_error.size | 48848 |
  243. | performance_schema | events_errors_summary_by_host_by_error.count | 128 |
  244. | performance_schema | events_errors_summary_by_host_by_error.memory | 6252544 |
  245. | performance_schema | events_errors_summary_global_by_error.size | 158272 |
  246. | performance_schema | events_errors_summary_global_by_error.count | 1 |
  247. | performance_schema | events_errors_summary_global_by_error.memory | 158272 |
  248. | performance_schema | (pfs_buffer_scalable_container).count | 19 |
  249. | performance_schema | (pfs_buffer_scalable_container).memory | 2096 |
  250. | performance_schema | (max_global_server_errors).count | 4946 |
  251. | performance_schema | (max_session_server_errors).count | 1526 |
  252. | performance_schema | performance_schema.memory | 228401680 |
  253. +--------------------+-------------------------------------------------------------+-----------+
  254. 248 rows in set (0.29 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement