rich1.0phorkiehttps://p.cweiske.de/mysql: show largest tables (with most rows) on mysql shellChristian Weiske86400900900<!-- embedding all files of https://p.cweiske.de/848 -->
<link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/>
<div class="phork" id="848">
<div class="phork-file">
<div class="phork-content">
<style type="text/css">/**
* GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2014 Benny Baumann
* (http://qbnz.com/highlighter/ and http://geshi.org/)
*/
.sql .de1, .sql .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;}
.sql {font-family:monospace;}
.sql .imp {font-weight: bold; color: red;}
.sql li, .sql .li1 {color: #DDD;}
.sql .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;}
.sql .kw1 {color: #993333; font-weight: bold;}
.sql .co1 {color: #808080; font-style: italic;}
.sql .coMULTI {color: #808080; font-style: italic;}
.sql .es0 {color: #000099; font-weight: bold;}
.sql .br0 {color: #66cc66;}
.sql .sy0 {color: #66cc66;}
.sql .st0 {color: #ff0000;}
.sql .nu0 {color: #cc66cc;}
.sql span.xtra { display:block; }
</style><div class="code"><table class="sql"><tbody><tr class="li1"><td class="ln"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
</pre></td><td class="de1"><pre class="de1">mysql<span class="sy0">></span> <span class="kw1">SELECT</span> <span class="kw1">TABLE_NAME</span><span class="sy0">,</span> TABLE_ROWS<span class="sy0">,</span> TABLE_COMMENT  <span class="kw1">FROM</span> INFORMATION_SCHEMA<span class="sy0">.</span>TABLES <span class="kw1">WHERE</span> TABLE_SCHEMA <span class="sy0">=</span>  <span class="st0">'drupal-mfl'</span> <span class="kw1">ORDER</span> <span class="kw1">BY</span> table_rows <span class="kw1">DESC</span>;
<span class="sy0">+</span><span class="co1">--------------------------------------------------+------------+--------------------------------------------------------------+</span>
<span class="sy0">|</span> <span class="kw1">TABLE_NAME</span>                                       <span class="sy0">|</span> TABLE_ROWS <span class="sy0">|</span> TABLE_COMMENT                                                <span class="sy0">|</span>
<span class="sy0">+</span><span class="co1">--------------------------------------------------+------------+--------------------------------------------------------------+</span>
<span class="sy0">|</span> watchdog                                         <span class="sy0">|</span>     <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>               <span class="sy0">|</span>
<span class="sy0">|</span> oauth2_token__scopes                             <span class="sy0">|</span>      <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>                  <span class="sy0">|</span>
<span class="sy0">|</span> locales_source                                   <span class="sy0">|</span>      <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>                              <span class="sy0">|</span>
<span class="sy0">|</span> locales_target                                   <span class="sy0">|</span>      <span class="nu0">22766</span> <span class="sy0">|</span> Stores translated versions <span class="kw1">OF</span> strings<span class="sy0">.</span>                       <span class="sy0">|</span>
<span class="sy0">|</span> oauth2_token                                     <span class="sy0">|</span>      <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>                    <span class="sy0">|</span>
<span class="sy0">|</span> cache_config                                     <span class="sy0">|</span>       <span class="nu0">3420</span> <span class="sy0">|</span> Storage <span class="kw1">FOR</span> the cache API<span class="sy0">.</span>                                   <span class="sy0">|</span>
<span class="sy0">|</span> locales_location                                 <span class="sy0">|</span>       <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>                     <span class="sy0">|</span>
<span class="sy0">|</span> key_value                                        <span class="sy0">|</span>       <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>�   <span class="sy0">|</span>
<span class="sy0">|</span> config_import                                    <span class="sy0">|</span>       <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>                       <span class="sy0">|</span>
<span class="sy0">|</span> config                                           <span class="sy0">|</span>       <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>                       <span class="sy0">|</span>
<span class="sy0">|</span> config_snapshot                                  <span class="sy0">|</span>       <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>                       <span class="sy0">|</span>
<span class="sy0">|</span> router                                           <span class="sy0">|</span>       <span class="nu0">1187</span> <span class="sy0">|</span> Maps paths <span class="kw1">TO</span> various callbacks <span class="br0">(</span>access<span class="sy0">,</span> page <span class="kw1">AND</span> title<span class="br0">)</span>     <span class="sy0">|</span>
 </pre></td></tr></tbody></table></div>
</div>
<div class="phork-meta">
<a href="https://p.cweiske.de/848/rev-raw/66786e6add66e884b169982b8feb9b773d4da778/show-most-rows.sql" style="float: right">view raw source</a>
<a href="https://p.cweiske.de/848#show-most-rows.sql">show-most-rows.sql</a>
</div>
</div>
</div>