19:52:26 (dbausr@localhost) [(none)]> show engine performance_schema status\G *************************** 1. row *************************** Type: performance_schema Name: events_waits_current.row_size Status: 184 *************************** 2. row *************************** Type: performance_schema Name: events_waits_current.row_count Status: 360600 *************************** 3. row *************************** Type: performance_schema Name: events_waits_history.row_size Status: 184 *************************** 4. row *************************** Type: performance_schema Name: events_waits_history.row_count Status: 601000 *************************** 5. row *************************** Type: performance_schema Name: events_waits_history.memory Status: 110584000 *************************** 6. row *************************** Type: performance_schema Name: events_waits_history_long.row_size Status: 184 *************************** 7. row *************************** Type: performance_schema Name: events_waits_history_long.row_count Status: 10000 *************************** 8. row *************************** Type: performance_schema Name: events_waits_history_long.memory Status: 1840000 *************************** 9. row *************************** Type: performance_schema Name: (pfs_mutex_class).row_size Status: 256 *************************** 10. row *************************** Type: performance_schema Name: (pfs_mutex_class).row_count Status: 200 *************************** 11. row *************************** Type: performance_schema Name: (pfs_mutex_class).memory Status: 51200 *************************** 12. row *************************** Type: performance_schema Name: (pfs_rwlock_class).row_size Status: 320 *************************** 13. row *************************** Type: performance_schema Name: (pfs_rwlock_class).row_count Status: 40 *************************** 14. row *************************** Type: performance_schema Name: (pfs_rwlock_class).memory Status: 12800 *************************** 15. row *************************** Type: performance_schema Name: (pfs_cond_class).row_size Status: 256 *************************** 16. row *************************** Type: performance_schema Name: (pfs_cond_class).row_count Status: 80 *************************** 17. row *************************** Type: performance_schema Name: (pfs_cond_class).memory Status: 20480 *************************** 18. row *************************** Type: performance_schema Name: (pfs_thread_class).row_size Status: 192 *************************** 19. row *************************** Type: performance_schema Name: (pfs_thread_class).row_count Status: 50 *************************** 20. row *************************** Type: performance_schema Name: (pfs_thread_class).memory Status: 9600 *************************** 21. row *************************** Type: performance_schema Name: (pfs_file_class).row_size Status: 320 *************************** 22. row *************************** Type: performance_schema Name: (pfs_file_class).row_count Status: 50 *************************** 23. row *************************** Type: performance_schema Name: (pfs_file_class).memory Status: 16000 *************************** 24. row *************************** Type: performance_schema Name: mutex_instances.row_size Status: 128 *************************** 25. row *************************** Type: performance_schema Name: mutex_instances.row_count Status: 187000 *************************** 26. row *************************** Type: performance_schema Name: mutex_instances.memory Status: 23936000 *************************** 27. row *************************** Type: performance_schema Name: rwlock_instances.row_size Status: 192 *************************** 28. row *************************** Type: performance_schema Name: rwlock_instances.row_count Status: 64000 *************************** 29. row *************************** Type: performance_schema Name: rwlock_instances.memory Status: 12288000 *************************** 30. row *************************** Type: performance_schema Name: cond_instances.row_size Status: 128 *************************** 31. row *************************** Type: performance_schema Name: cond_instances.row_count Status: 121300 *************************** 32. row *************************** Type: performance_schema Name: cond_instances.memory Status: 15526400 *************************** 33. row *************************** Type: performance_schema Name: threads.row_size Status: 3200 *************************** 34. row *************************** Type: performance_schema Name: threads.row_count Status: 60100 *************************** 35. row *************************** Type: performance_schema Name: threads.memory Status: 192320000 *************************** 36. row *************************** Type: performance_schema Name: file_instances.row_size Status: 704 *************************** 37. row *************************** Type: performance_schema Name: file_instances.row_count Status: 3077 *************************** 38. row *************************** Type: performance_schema Name: file_instances.memory Status: 2166208 *************************** 39. row *************************** Type: performance_schema Name: (pfs_file_handle).row_size Status: 8 *************************** 40. row *************************** Type: performance_schema Name: (pfs_file_handle).row_count Status: 32768 *************************** 41. row *************************** Type: performance_schema Name: (pfs_file_handle).memory Status: 262144 *************************** 42. row *************************** Type: performance_schema Name: events_waits_summary_by_thread_by_event_name.row_size Status: 32 *************************** 43. row *************************** Type: performance_schema Name: events_waits_summary_by_thread_by_event_name.row_count Status: 23018300 *************************** 44. row *************************** Type: performance_schema Name: events_waits_summary_by_thread_by_event_name.memory Status: 736585600 *************************** 45. row *************************** Type: performance_schema Name: (pfs_table_share).row_size Status: 22208 *************************** 46. row *************************** Type: performance_schema Name: (pfs_table_share).row_count Status: 12500 *************************** 47. row *************************** Type: performance_schema Name: (pfs_table_share).memory Status: 277600000 *************************** 48. row *************************** Type: performance_schema Name: (pfs_table).row_size Status: 9280 *************************** 49. row *************************** Type: performance_schema Name: (pfs_table).row_count Status: 4000 *************************** 50. row *************************** Type: performance_schema Name: (pfs_table).memory Status: 37120000 *************************** 51. row *************************** Type: performance_schema Name: setup_actors.row_size Status: 576 *************************** 52. row *************************** Type: performance_schema Name: setup_actors.row_count Status: 100 *************************** 53. row *************************** Type: performance_schema Name: setup_actors.memory Status: 57600 *************************** 54. row *************************** Type: performance_schema Name: setup_objects.row_size Status: 448 *************************** 55. row *************************** Type: performance_schema Name: setup_objects.row_count Status: 100 *************************** 56. row *************************** Type: performance_schema Name: setup_objects.memory Status: 44800 *************************** 57. row *************************** Type: performance_schema Name: (pfs_account).row_size Status: 576 *************************** 58. row *************************** Type: performance_schema Name: (pfs_account).row_count Status: 100 *************************** 59. row *************************** Type: performance_schema Name: (pfs_account).memory Status: 57600 *************************** 60. row *************************** Type: performance_schema Name: events_waits_summary_by_account_by_event_name.row_size Status: 32 *************************** 61. row *************************** Type: performance_schema Name: events_waits_summary_by_account_by_event_name.row_count Status: 38300 *************************** 62. row *************************** Type: performance_schema Name: events_waits_summary_by_account_by_event_name.memory Status: 1225600 *************************** 63. row *************************** Type: performance_schema Name: events_waits_summary_by_user_by_event_name.row_size Status: 32 *************************** 64. row *************************** Type: performance_schema Name: events_waits_summary_by_user_by_event_name.row_count Status: 38300 *************************** 65. row *************************** Type: performance_schema Name: events_waits_summary_by_user_by_event_name.memory Status: 1225600 *************************** 66. row *************************** Type: performance_schema Name: events_waits_summary_by_host_by_event_name.row_size Status: 32 *************************** 67. row *************************** Type: performance_schema Name: events_waits_summary_by_host_by_event_name.row_count Status: 38300 *************************** 68. row *************************** Type: performance_schema Name: events_waits_summary_by_host_by_event_name.memory Status: 1225600 *************************** 69. row *************************** Type: performance_schema Name: (pfs_user).row_size Status: 512 *************************** 70. row *************************** Type: performance_schema Name: (pfs_user).row_count Status: 100 *************************** 71. row *************************** Type: performance_schema Name: (pfs_user).memory Status: 51200 *************************** 72. row *************************** Type: performance_schema Name: (pfs_host).row_size Status: 128 *************************** 73. row *************************** Type: performance_schema Name: (pfs_host).row_count Status: 100 *************************** 74. row *************************** Type: performance_schema Name: (pfs_host).memory Status: 12800 *************************** 75. row *************************** Type: performance_schema Name: (pfs_stage_class).row_size Status: 256 *************************** 76. row *************************** Type: performance_schema Name: (pfs_stage_class).row_count Status: 150 *************************** 77. row *************************** Type: performance_schema Name: (pfs_stage_class).memory Status: 38400 *************************** 78. row *************************** Type: performance_schema Name: events_stages_history.row_size Status: 88 *************************** 79. row *************************** Type: performance_schema Name: events_stages_history.row_count Status: 601000 *************************** 80. row *************************** Type: performance_schema Name: events_stages_history.memory Status: 52888000 *************************** 81. row *************************** Type: performance_schema Name: events_stages_history_long.row_size Status: 88 *************************** 82. row *************************** Type: performance_schema Name: events_stages_history_long.row_count Status: 10000 *************************** 83. row *************************** Type: performance_schema Name: events_stages_history_long.memory Status: 880000 *************************** 84. row *************************** Type: performance_schema Name: events_stages_summary_by_thread_by_event_name.row_size Status: 32 *************************** 85. row *************************** Type: performance_schema Name: events_stages_summary_by_thread_by_event_name.row_count Status: 9015000 *************************** 86. row *************************** Type: performance_schema Name: events_stages_summary_by_thread_by_event_name.memory Status: 288480000 *************************** 87. row *************************** Type: performance_schema Name: events_stages_summary_global_by_event_name.row_size Status: 32 *************************** 88. row *************************** Type: performance_schema Name: events_stages_summary_global_by_event_name.row_count Status: 150 *************************** 89. row *************************** Type: performance_schema Name: events_stages_summary_global_by_event_name.memory Status: 4800 *************************** 90. row *************************** Type: performance_schema Name: events_stages_summary_by_account_by_event_name.row_size Status: 32 *************************** 91. row *************************** Type: performance_schema Name: events_stages_summary_by_account_by_event_name.row_count Status: 15000 *************************** 92. row *************************** Type: performance_schema Name: events_stages_summary_by_account_by_event_name.memory Status: 480000 *************************** 93. row *************************** Type: performance_schema Name: events_stages_summary_by_user_by_event_name.row_size Status: 32 *************************** 94. row *************************** Type: performance_schema Name: events_stages_summary_by_user_by_event_name.row_count Status: 15000 *************************** 95. row *************************** Type: performance_schema Name: events_stages_summary_by_user_by_event_name.memory Status: 480000 *************************** 96. row *************************** Type: performance_schema Name: events_stages_summary_by_host_by_event_name.row_size Status: 32 *************************** 97. row *************************** Type: performance_schema Name: events_stages_summary_by_host_by_event_name.row_count Status: 15000 *************************** 98. row *************************** Type: performance_schema Name: events_stages_summary_by_host_by_event_name.memory Status: 480000 *************************** 99. row *************************** Type: performance_schema Name: (pfs_statement_class).row_size Status: 192 *************************** 100. row *************************** Type: performance_schema Name: (pfs_statement_class).row_count Status: 188 *************************** 101. row *************************** Type: performance_schema Name: (pfs_statement_class).memory Status: 36096 *************************** 102. row *************************** Type: performance_schema Name: events_statements_history.row_size Status: 2040 *************************** 103. row *************************** Type: performance_schema Name: events_statements_history.row_count Status: 601000 *************************** 104. row *************************** Type: performance_schema Name: events_statements_history.memory Status: 1226040000 *************************** 105. row *************************** Type: performance_schema Name: events_statements_history_long.row_size Status: 2040 *************************** 106. row *************************** Type: performance_schema Name: events_statements_history_long.row_count Status: 100000 *************************** 107. row *************************** Type: performance_schema Name: events_statements_history_long.memory Status: 204000000 *************************** 108. row *************************** Type: performance_schema Name: events_statements_summary_by_thread_by_event_name.row_size Status: 184 *************************** 109. row *************************** Type: performance_schema Name: events_statements_summary_by_thread_by_event_name.row_count Status: 11298800 *************************** 110. row *************************** Type: performance_schema Name: events_statements_summary_by_thread_by_event_name.memory Status: 2078979200 *************************** 111. row *************************** Type: performance_schema Name: events_statements_summary_global_by_event_name.row_size Status: 184 *************************** 112. row *************************** Type: performance_schema Name: events_statements_summary_global_by_event_name.row_count Status: 188 *************************** 113. row *************************** Type: performance_schema Name: events_statements_summary_global_by_event_name.memory Status: 34592 *************************** 114. row *************************** Type: performance_schema Name: events_statements_summary_by_account_by_event_name.row_size Status: 184 *************************** 115. row *************************** Type: performance_schema Name: events_statements_summary_by_account_by_event_name.row_count Status: 18800 *************************** 116. row *************************** Type: performance_schema Name: events_statements_summary_by_account_by_event_name.memory Status: 3459200 *************************** 117. row *************************** Type: performance_schema Name: events_statements_summary_by_user_by_event_name.row_size Status: 184 *************************** 118. row *************************** Type: performance_schema Name: events_statements_summary_by_user_by_event_name.row_count Status: 18800 *************************** 119. row *************************** Type: performance_schema Name: events_statements_summary_by_user_by_event_name.memory Status: 3459200 *************************** 120. row *************************** Type: performance_schema Name: events_statements_summary_by_host_by_event_name.row_size Status: 184 *************************** 121. row *************************** Type: performance_schema Name: events_statements_summary_by_host_by_event_name.row_count Status: 18800 *************************** 122. row *************************** Type: performance_schema Name: events_statements_summary_by_host_by_event_name.memory Status: 3459200 *************************** 123. row *************************** Type: performance_schema Name: events_statements_current.row_size Status: 2040 *************************** 124. row *************************** Type: performance_schema Name: events_statements_current.row_count Status: 60100 *************************** 125. row *************************** Type: performance_schema Name: events_statements_current.memory Status: 122604000 *************************** 126. row *************************** Type: performance_schema Name: (pfs_socket_class).row_size Status: 320 *************************** 127. row *************************** Type: performance_schema Name: (pfs_socket_class).row_count Status: 10 *************************** 128. row *************************** Type: performance_schema Name: (pfs_socket_class).memory Status: 3200 *************************** 129. row *************************** Type: performance_schema Name: socket_instances.row_size Status: 320 *************************** 130. row *************************** Type: performance_schema Name: socket_instances.row_count Status: 60020 *************************** 131. row *************************** Type: performance_schema Name: socket_instances.memory Status: 19206400 *************************** 132. row *************************** Type: performance_schema Name: events_statements_summary_by_digest.row_size Status: 512 *************************** 133. row *************************** Type: performance_schema Name: events_statements_summary_by_digest.row_count Status: 10000 *************************** 134. row *************************** Type: performance_schema Name: events_statements_summary_by_digest.memory Status: 5120000 *************************** 135. row *************************** Type: performance_schema Name: session_connect_attrs.row_size Status: 60100 *************************** 136. row *************************** Type: performance_schema Name: session_connect_attrs.row_count Status: 512 *************************** 137. row *************************** Type: performance_schema Name: session_connect_attrs.memory Status: 30771200 *************************** 138. row *************************** Type: performance_schema Name: (account_hash).count Status: 6 *************************** 139. row *************************** Type: performance_schema Name: (account_hash).size Status: 8 *************************** 140. row *************************** Type: performance_schema Name: (digest_hash).count Status: 43 *************************** 141. row *************************** Type: performance_schema Name: (digest_hash).size Status: 64 *************************** 142. row *************************** Type: performance_schema Name: (filename_hash).count Status: 864 *************************** 143. row *************************** Type: performance_schema Name: (filename_hash).size Status: 1024 *************************** 144. row *************************** Type: performance_schema Name: (host_hash).count Status: 5 *************************** 145. row *************************** Type: performance_schema Name: (host_hash).size Status: 8 *************************** 146. row *************************** Type: performance_schema Name: (setup_actor_hash).count Status: 1 *************************** 147. row *************************** Type: performance_schema Name: (setup_actor_hash).size Status: 1 *************************** 148. row *************************** Type: performance_schema Name: (setup_object_hash).count Status: 4 *************************** 149. row *************************** Type: performance_schema Name: (setup_object_hash).size Status: 4 *************************** 150. row *************************** Type: performance_schema Name: (table_share_hash).count Status: 24 *************************** 151. row *************************** Type: performance_schema Name: (table_share_hash).size Status: 32 *************************** 152. row *************************** Type: performance_schema Name: (user_hash).count Status: 6 *************************** 153. row *************************** Type: performance_schema Name: (user_hash).size Status: 8 *************************** 154. row *************************** Type: performance_schema Name: host_cache.size Status: 336 *************************** 155. row *************************** Type: performance_schema Name: (history_long_statements_digest_token_array).row_count Status: 100000 *************************** 156. row *************************** Type: performance_schema Name: (history_long_statements_digest_token_array).row_size Status: 1024 *************************** 157. row *************************** Type: performance_schema Name: (history_long_statements_digest_token_array).memory Status: 102400000 *************************** 158. row *************************** Type: performance_schema Name: (history_statements_digest_token_array).row_count Status: 601000 *************************** 159. row *************************** Type: performance_schema Name: (history_statements_digest_token_array).row_size Status: 1024 *************************** 160. row *************************** Type: performance_schema Name: (history_statements_digest_token_array).memory Status: 615424000 *************************** 161. row *************************** Type: performance_schema Name: (current_statements_digest_token_array).row_count Status: 60100 *************************** 162. row *************************** Type: performance_schema Name: (current_statements_digest_token_array).row_size Status: 1024 *************************** 163. row *************************** Type: performance_schema Name: (current_statements_digest_token_array).memory Status: 61542400 *************************** 164. row *************************** Type: performance_schema Name: (statements_digest_token_array).row_count Status: 10000 *************************** 165. row *************************** Type: performance_schema Name: (statements_digest_token_array).row_size Status: 1024 *************************** 166. row *************************** Type: performance_schema Name: (statements_digest_token_array).memory Status: 10240000 *************************** 167. row *************************** Type: performance_schema Name: performance_schema.memory Status: 6244749120 167 rows in set (0.00 sec)