Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: x$memory_by_thread_by_current_bytes
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0262 seconds.)
SELECT * FROM `x$memory_by_thread_by_current_bytes`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
thread_idusercurrent_count_usedcurrent_allocatedcurrent_avg_alloccurrent_max_alloctotal_allocated
38 innodb/clone_gtid_thread 96 269783 2810.2396 119120 351301
67549 root@localhost 14 104540 7467.1429 87576 151993
67548 pma@localhost 7 17040 2434.2857 16736 126524
47 sql/event_scheduler 20 16789 839.4500 16391 27319
31 mysqlx/acceptor_network 168 15126 90.0357 15118 93072
30 innodb/fts_optimize_thread 30 3714 123.8000 1113 5178
39 innodb/srv_purge_thread 30 3346 111.5333 1113 4810
14 innodb/page_flush_coordinator_thread 42 3217 76.5952 1113 10233
28 innodb/srv_master_thread 29 3066 105.7241 1113 4530
41 innodb/srv_worker_thread 29 3066 105.7241 1113 29928
43 innodb/srv_worker_thread 29 3066 105.7241 1113 6613
44 innodb/srv_worker_thread 29 3066 105.7241 1113 19221
29 innodb/dict_stats_thread 27 2402 88.9630 1113 392210
37 innodb/buf_dump_thread 12 153 12.7500 153 239209
16 innodb/page_flush_thread 0 0 0.0000 0 0
17 innodb/page_flush_thread 0 0 0.0000 0 0
18 innodb/log_checkpointer_thread 0 0 0.0000 0 0
19 innodb/log_closer_thread 0 0 0.0000 0 0
20 innodb/log_flush_notifier_thread 0 0 0.0000 0 0
21 innodb/log_flusher_thread 0 0 0.0000 0 0
22 innodb/log_write_notifier_thread 0 0 0.0000 0 0
23 innodb/log_writer_thread 0 0 0.0000 0 0
24 innodb/srv_lock_timeout_thread 0 0 0.0000 0 0
25 innodb/srv_error_monitor_thread 0 0 0.0000 0 0
8 innodb/io_read_thread 0 0 0.0000 0 0

|
|
|
Number of rows:
Filter rows:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query