{"type":"rich","version":"1.0","provider_name":"phorkie","provider_url":"https:\/\/p.cweiske.de\/","title":"mysql: show largest tables (with most rows) on mysql shell","author_name":"Christian Weiske","cache_age":86400,"width":900,"height":900,"html":"<!-- embedding all files of https:\/\/p.cweiske.de\/848 -->\n<link rel=\"stylesheet\" href=\"https:\/\/p.cweiske.de\/css\/embed.css\"\/>\n<div class=\"phork\" id=\"848\">\n    <div class=\"phork-file\">\n <div class=\"phork-content\">\n  <style type=\"text\/css\">\/**\n * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2014 Benny Baumann\n * (http:\/\/qbnz.com\/highlighter\/ and http:\/\/geshi.org\/)\n *\/\n.sql .de1, .sql .de2 {font: normal normal 1em\/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}\n.sql  {font-family:monospace;}\n.sql .imp {font-weight: bold; color: red;}\n.sql li, .sql .li1 {color: #DDD;}\n.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}\n.sql .kw1 {color: #993333; font-weight: bold;}\n.sql .co1 {color: #808080; font-style: italic;}\n.sql .coMULTI {color: #808080; font-style: italic;}\n.sql .es0 {color: #000099; font-weight: bold;}\n.sql .br0 {color: #66cc66;}\n.sql .sy0 {color: #66cc66;}\n.sql .st0 {color: #ff0000;}\n.sql .nu0 {color: #cc66cc;}\n.sql span.xtra { display:block; }\n<\/style><div class=\"code\"><table class=\"sql\"><tbody><tr class=\"li1\"><td class=\"ln\"><pre class=\"de1\">1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12\n13\n14\n15\n16\n17\n<\/pre><\/td><td class=\"de1\"><pre class=\"de1\">mysql<span class=\"sy0\">&gt;<\/span> <span class=\"kw1\">SELECT<\/span> <span class=\"kw1\">TABLE_NAME<\/span><span class=\"sy0\">,<\/span> TABLE_ROWS<span class=\"sy0\">,<\/span> TABLE_COMMENT &#160;<span class=\"kw1\">FROM<\/span> INFORMATION_SCHEMA<span class=\"sy0\">.<\/span>TABLES <span class=\"kw1\">WHERE<\/span> TABLE_SCHEMA <span class=\"sy0\">=<\/span> &#160;<span class=\"st0\">'drupal-mfl'<\/span> <span class=\"kw1\">ORDER<\/span> <span class=\"kw1\">BY<\/span> table_rows <span class=\"kw1\">DESC<\/span>;\n<span class=\"sy0\">+<\/span><span class=\"co1\">--------------------------------------------------+------------+--------------------------------------------------------------+<\/span>\n<span class=\"sy0\">|<\/span> <span class=\"kw1\">TABLE_NAME<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> TABLE_ROWS <span class=\"sy0\">|<\/span> TABLE_COMMENT &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<span class=\"sy0\">|<\/span>\n<span class=\"sy0\">+<\/span><span class=\"co1\">--------------------------------------------------+------------+--------------------------------------------------------------+<\/span>\n<span class=\"sy0\">|<\/span> watchdog &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; <span class=\"nu0\">154087<\/span> <span class=\"sy0\">|<\/span> <span class=\"kw1\">TABLE<\/span> that contains logs <span class=\"kw1\">OF<\/span> <span class=\"kw1\">ALL<\/span> system events<span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> oauth2_token__scopes &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; &#160;<span class=\"nu0\">44176<\/span> <span class=\"sy0\">|<\/span> <span class=\"kw1\">DATA<\/span> storage <span class=\"kw1\">FOR<\/span> oauth2_token <span class=\"kw1\">FIELD<\/span> scopes<span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> locales_source &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; &#160;<span class=\"nu0\">23513<\/span> <span class=\"sy0\">|<\/span> List <span class=\"kw1\">OF<\/span> English <span class=\"kw1\">SOURCE<\/span> strings<span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> locales_target &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; &#160;<span class=\"nu0\">22766<\/span> <span class=\"sy0\">|<\/span> Stores translated versions <span class=\"kw1\">OF<\/span> strings<span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> oauth2_token &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; &#160;<span class=\"nu0\">21973<\/span> <span class=\"sy0\">|<\/span> The base <span class=\"kw1\">TABLE<\/span> <span class=\"kw1\">FOR<\/span> oauth2_token entities<span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> cache_config &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; &#160; <span class=\"nu0\">3420<\/span> <span class=\"sy0\">|<\/span> Storage <span class=\"kw1\">FOR<\/span> the cache API<span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> locales_location &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; &#160; <span class=\"nu0\">2613<\/span> <span class=\"sy0\">|<\/span> Location information <span class=\"kw1\">FOR<\/span> <span class=\"kw1\">SOURCE<\/span> strings<span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> key_value &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<span class=\"sy0\">|<\/span> &#160; &#160; &#160; <span class=\"nu0\">1960<\/span> <span class=\"sy0\">|<\/span> Generic key<span class=\"sy0\">-<\/span><span class=\"kw1\">VALUE<\/span> storage <span class=\"kw1\">TABLE<\/span><span class=\"sy0\">.<\/span> See the state system <span class=\"kw1\">FOR<\/span>\ufffd &#160; <span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> config_import &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<span class=\"sy0\">|<\/span> &#160; &#160; &#160; <span class=\"nu0\">1782<\/span> <span class=\"sy0\">|<\/span> The base <span class=\"kw1\">TABLE<\/span> <span class=\"kw1\">FOR<\/span> configuration <span class=\"kw1\">DATA<\/span><span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> config &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; &#160; <span class=\"nu0\">1362<\/span> <span class=\"sy0\">|<\/span> The base <span class=\"kw1\">TABLE<\/span> <span class=\"kw1\">FOR<\/span> configuration <span class=\"kw1\">DATA<\/span><span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> config_snapshot &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160;<span class=\"sy0\">|<\/span> &#160; &#160; &#160; <span class=\"nu0\">1334<\/span> <span class=\"sy0\">|<\/span> The base <span class=\"kw1\">TABLE<\/span> <span class=\"kw1\">FOR<\/span> configuration <span class=\"kw1\">DATA<\/span><span class=\"sy0\">.<\/span> &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span>\n<span class=\"sy0\">|<\/span> router &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; &#160; <span class=\"sy0\">|<\/span> &#160; &#160; &#160; <span class=\"nu0\">1187<\/span> <span class=\"sy0\">|<\/span> Maps paths <span class=\"kw1\">TO<\/span> various callbacks <span class=\"br0\">&#40;<\/span>access<span class=\"sy0\">,<\/span> page <span class=\"kw1\">AND<\/span> title<span class=\"br0\">&#41;<\/span> &#160; &#160; <span class=\"sy0\">|<\/span>\n&#160;<\/pre><\/td><\/tr><\/tbody><\/table><\/div>\n <\/div>\n <div class=\"phork-meta\">\n  <a href=\"https:\/\/p.cweiske.de\/848\/rev-raw\/66786e6add66e884b169982b8feb9b773d4da778\/show-most-rows.sql\" style=\"float: right\">view raw source<\/a>\n  <a href=\"https:\/\/p.cweiske.de\/848#show-most-rows.sql\">show-most-rows.sql<\/a>\n <\/div>\n<\/div>\n<\/div>\n"}