API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 11th, 2024
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.35 KB | None | 0 0
raw download clone embed print report
  1. MariaDB [mywebsitedb]> SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), 'MB') DATA_Space,
  2. -> CONCAT(ROUND(data_free / ( 1024 * 1024 ), 2), 'MB') FREE_Space, create_time, table_rows, engine, create_options
  3. -> from information_schema.TABLES
  4. -> where TABLE_SCHEMA NOT IN ('information_schema','mysql') and Data_free > ( DATA_length * .1)
  5. -> ORDER BY FLOOR ( FREE_Space ) DESC, FLOOR ( DATA_Space ) DESC, TABLE_SCHEMA, TABLE_NAME
  6. -> LIMIT 0,512
  7. -> ;
  8.  
  9. +--------------+------------------------------------+------------+------------+---------------------+------------+--------+----------------+
  10. | TABLE_SCHEMA | TABLE_NAME | DATA_Space | FREE_Space | create_time | table_rows | engine | create_options |
  11. +--------------+------------------------------------+------------+------------+---------------------+------------+--------+----------------+
  12. | mywebsitedb | wp_options | 670.52MB | 5009.00MB | 2023-10-08 16:27:49 | 1531248 | InnoDB | |
  13. | mywebsitedb | wp_woocommerce_sessions | 13323.02MB | 3470.00MB | 2023-03-14 20:00:23 | 6503687 | InnoDB | |
  14. | mywebsitedb | wp_term_relationships | 902.00MB | 786.00MB | 2024-02-03 10:43:24 | 24106141 | InnoDB | |
  15. | anotherdb | wp_woocommerce_sessions | 8.02MB | 597.00MB | 2023-03-14 17:22:44 | 1428 | InnoDB | |
  16. | mywebsitedb | wp_actionscheduler_actions | 217.27MB | 188.00MB | 2023-05-22 01:01:32 | 538879 | InnoDB | |
  17. | anotherdb | wp_options | 44.55MB | 136.00MB | 2022-07-08 05:28:46 | 59733 | InnoDB | |
  18. | mywebsitedb | wp_wfconfig | 1.28MB | 59.00MB | 2022-04-19 17:29:58 | 270 | InnoDB | |
  19. | anotherdb | wp_wfconfig | 2.27MB | 30.00MB | 2022-07-08 05:28:47 | 275 | InnoDB | |
  20. | anotherdb | wp_actionscheduler_actions | 12.22MB | 24.00MB | 2023-05-23 18:22:35 | 26271 | InnoDB | |
  21. | mywebsitedb | wp_actionscheduler_logs | 182.22MB | 21.00MB | 2021-12-14 11:22:05 | 1738678 | InnoDB | |
  22. | mywebsitedb | wp_woocommerce_order_itemmeta | 35.58MB | 19.00MB | 2023-03-14 20:00:23 | 613763 | InnoDB | |
  23. | anotherdb | wp_ilab_mc_logging | 1.02MB | 16.00MB | 2022-07-08 05:29:01 | 980 | InnoDB | |
  24. | anotherdb | wp_actionscheduler_logs | 12.03MB | 13.00MB | 2022-07-08 05:29:01 | 107003 | InnoDB | |
  25. | mywebsitedb | wp_nextend2_section_storage | 0.02MB | 9.00MB | 2024-01-02 23:14:25 | 1 | InnoDB | |
  26. | mywebsitedb | wp_wc_order_product_lookup | 11.52MB | 7.00MB | 2023-03-14 20:00:24 | 72404 | InnoDB | |
  27. | mywebsitedb | wp_zorem_email_sms_log | 7.52MB | 7.00MB | 2024-01-02 23:15:10 | 57046 | InnoDB | |
  28. | mywebsitedbTest | wp_woocommerce_order_items | 27.56MB | 6.00MB | 2021-12-14 08:33:03 | 185695 | InnoDB | |
  29. | mywebsitedb | wp_wc_order_stats | 16.53MB | 6.00MB | 2023-03-14 20:00:24 | 70511 | InnoDB | |
  30. | anotherdb | wp_woocommerce_order_itemmeta | 8.52MB | 6.00MB | 2023-03-14 17:22:44 | 123004 | InnoDB | |
  31. | anotherdb | wp_wfhits | 1.02MB | 6.00MB | 2022-07-08 05:29:04 | 434 | InnoDB | |
  32. | mywebsitedbTest | wp_comments | 41.56MB | 5.00MB | 2021-12-14 06:07:47 | 169494 | InnoDB | |
  33. | anotherdb | cerber_traffic | 40.58MB | 5.00MB | 2022-07-08 05:29:05 | 79360 | InnoDB | |
  34. | anotherdb | wp_wc_product_meta_lookup | 39.61MB | 5.00MB | 2022-07-08 05:29:05 | 310995 | InnoDB | |
  35. | anotherdb | wp_commentmeta | 7.52MB | 5.00MB | 2022-07-08 05:28:46 | 134419 | InnoDB | |
  36. | mywebsitedb | wp_commentmeta | 3.52MB | 5.00MB | 2021-12-14 11:22:35 | 17910 | InnoDB | |
  37. | mywebsitedb | wp_wffilemods | 16.55MB | 4.00MB | 2022-05-18 15:00:11 | 29978 | InnoDB | |
  38. | mywebsitedb | wp_wpmelon_advbedit_temp | 15.55MB | 4.00MB | 2024-01-02 20:28:22 | 348075 | InnoDB | |
  39. | anotherdb | wp_wffilemods | 14.55MB | 4.00MB | 2022-07-08 05:29:04 | 25721 | InnoDB | |
  40. | mywebsitedb | cerber_traffic | 13.52MB | 4.00MB | 2023-06-17 16:03:06 | 19142 | InnoDB | |
  41. | anotherdb | wp_yoast_indexable_hierarchy | 13.52MB | 4.00MB | 2022-07-08 05:29:00 | 289278 | InnoDB | |
  42. | mywebsitedb | wp_woocommerce_order_items | 11.52MB | 4.00MB | 2023-03-14 20:00:23 | 83067 | InnoDB | |
  43. | mywebsitedb | wp_wpmailsmtp_debug_events | 9.52MB | 4.00MB | 2022-09-27 16:54:34 | 42273 | InnoDB | |
  44. | mywebsitedb | wp_mcloud_task | 8.52MB | 4.00MB | 2021-12-14 11:22:42 | 59701 | InnoDB | |
  45. | mywebsitedb | wp_wc_customer_lookup | 8.52MB | 4.00MB | 2023-03-14 20:00:24 | 74673 | InnoDB | |
  46. | mywebsitedb | wp_wfknownfilelist | 8.52MB | 4.00MB | 2022-05-18 15:00:11 | 29329 | InnoDB | |
  47. | mywebsitedbTest | wp_mcloud_task | 8.52MB | 4.00MB | 2021-12-14 06:07:53 | 59701 | InnoDB | |
  48. | anotherdb | wp_yoast_seo_meta | 8.52MB | 4.00MB | 2022-07-08 05:29:02 | 211494 | InnoDB | |
  49. | mywebsitedb | wp_usermeta | 7.50MB | 4.00MB | 2021-12-14 22:08:51 | 72612 | InnoDB | |
  50. | anotherdb | cerber_log | 7.52MB | 4.00MB | 2022-07-08 05:28:48 | 45645 | InnoDB | |
  51. | anotherdb | wp_wfknownfilelist | 7.52MB | 4.00MB | 2022-07-08 05:29:07 | 27411 | InnoDB | |
  52. | mywebsitedb | wp_wfhits | 5.52MB | 4.00MB | 2022-04-19 17:29:58 | 5572 | InnoDB | |
  53. | anotherdb | wp_cerber_files | 5.52MB | 4.00MB | 2022-07-08 05:28:59 | 10825 | InnoDB | |
  54. | mywebsitedb | wp_wc_reserved_stock | 4.52MB | 4.00MB | 2021-12-14 22:16:15 | 66211 | InnoDB | |
  55. | mywebsitedbTest | wp_wc_reserved_stock | 4.52MB | 4.00MB | 2021-12-14 08:32:29 | 67915 | InnoDB | |
  56. | mywebsitedb | wp_trackship_shipment | 3.45MB | 4.00MB | 2024-02-06 09:09:33 | 17904 | InnoDB | |
  57. | mywebsitedbTest | wp_commentmeta | 3.52MB | 4.00MB | 2021-12-14 06:07:46 | 21266 | InnoDB | |
  58. | mywebsitedbTest | wp_wc_order_product_lookup | 3.52MB | 4.00MB | 2021-12-14 08:26:26 | 22132 | InnoDB | |
  59. | mywebsitedbTest | wp_wc_order_stats | 3.52MB | 4.00MB | 2021-12-14 08:26:27 | 23985 | InnoDB | |
  60. | mywebsitedb | wp_aioseo_cache | 2.11MB | 4.00MB | 2022-08-18 08:56:03 | 10 | InnoDB | |
  61. | mywebsitedb | wp_termmeta | 2.52MB | 4.00MB | 2021-12-14 22:08:47 | 24115 | InnoDB | |
  62. | mywebsitedb | wp_terms | 2.52MB | 4.00MB | 2021-12-14 22:08:49 | 25146 | InnoDB | |
  63. | mywebsitedb | wp_term_taxonomy | 2.52MB | 4.00MB | 2021-12-14 22:08:43 | 25988 | InnoDB | |
  64. | mywebsitedbTest | wp_termmeta | 2.52MB | 4.00MB | 2021-12-14 08:26:16 | 24325 | InnoDB | |
  65. | mywebsitedbTest | wp_usermeta | 2.52MB | 4.00MB | 2021-12-14 08:26:21 | 19676 | InnoDB | |
  66. | mywebsitedbTest | wp_wc_customer_lookup | 2.52MB | 4.00MB | 2021-12-14 08:26:24 | 20097 | InnoDB | |
  67. | anotherdb | wp_usermeta | 2.52MB | 4.00MB | 2022-07-08 05:29:01 | 23716 | InnoDB | |
  68. | anotherdb | wp_woocommerce_order_items | 2.52MB | 4.00MB | 2023-03-14 17:22:44 | 18904 | InnoDB | |
  69. | mywebsitedb | wp_woocommerce_gpf_google_taxonomy | 1.52MB | 4.00MB | 2021-12-14 22:16:18 | 5450 | InnoDB | |
  70. | mywebsitedb | wp_wt_iew_action_history | 1.52MB | 4.00MB | 2021-12-14 22:17:13 | 14 | InnoDB | |
  71. | mywebsitedb | wp_yith_wcwl | 1.52MB | 4.00MB | 2021-12-14 22:17:14 | 7882 | InnoDB | |
  72. | mywebsitedb | wp_yith_wcwl_lists | 1.52MB | 4.00MB | 2021-12-14 22:17:15 | 7764 | InnoDB | |
  73. | mywebsitedbTest | cerber_log | 1.52MB | 4.00MB | 2021-12-14 06:05:31 | 4650 | InnoDB | |
  74. | mywebsitedbTest | wp_actionscheduler_claims | 1.52MB | 4.00MB | 2021-12-14 06:07:26 | 27724 | InnoDB | |
  75. | mywebsitedbTest | wp_terms | 1.52MB | 4.00MB | 2021-12-14 08:26:19 | 16029 | InnoDB | |
  76. | mywebsitedbTest | wp_term_taxonomy | 1.52MB | 4.00MB | 2021-12-14 08:26:14 | 16184 | InnoDB | |
  77. | mywebsitedbTest | wp_woocommerce_gpf_google_taxonomy | 1.52MB | 4.00MB | 2021-12-14 08:32:33 | 5400 | InnoDB | |
  78. | mywebsitedbTest | wp_yith_wcwl | 1.52MB | 4.00MB | 2021-12-14 08:33:23 | 7882 | InnoDB | |
  79. | mywebsitedbTest | wp_yith_wcwl_lists | 1.52MB | 4.00MB | 2021-12-14 08:33:24 | 7764 | InnoDB | |
  80. | anotherdb | wp_cerber_sets | 1.52MB | 4.00MB | 2022-07-08 05:29:01 | 88 | InnoDB | |
  81. | anotherdb | wp_termmeta | 1.52MB | 4.00MB | 2022-07-08 05:29:06 | 10300 | InnoDB | |
  82. | anotherdb | wp_wc_customer_lookup | 1.52MB | 4.00MB | 2023-03-14 17:22:45 | 8886 | InnoDB | |
  83. | anotherdb | wp_wc_order_product_lookup | 1.52MB | 4.00MB | 2023-03-14 17:22:45 | 9809 | InnoDB | |
  84. | anotherdb | wp_wc_order_stats | 1.52MB | 4.00MB | 2023-03-14 17:22:45 | 10182 | InnoDB | |
  85. | anotherdb | wp_woocommerce_gpf_google_taxonomy | 1.52MB | 4.00MB | 2022-07-08 05:29:06 | 4154 | InnoDB | |
  86. | mywebsitedb | wp_users | 0.50MB | 4.00MB | 2021-12-14 22:08:54 | 3034 | InnoDB | |
  87. | mywebsitedb | wp_wfstatus | 0.13MB | 4.00MB | 2022-04-19 17:29:59 | 943 | InnoDB | |
  88. | anotherdb | wp_terms | 0.42MB | 4.00MB | 2022-07-08 05:28:48 | 5697 | InnoDB | |
  89. | anotherdb | wp_wfstatus | 0.20MB | 4.00MB | 2022-07-08 05:29:03 | 957 | InnoDB | |
  90. | mywebsitedb | wp_cerber_files | 8.55MB | 2.00MB | 2023-06-17 16:03:07 | 17028 | InnoDB | |
  91. +--------------+------------------------------------+------------+------------+---------------------+------------+--------+----------------+
  92. 79 rows in set, 158 warnings (0.210 sec)
  93.  
  94. MariaDB [mywebsitedb]>
  95. MariaDB [mywebsitedb]>
  96.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!