Page MenuHomePhabricator
Paste P8027

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Jan 23 2019, 1:50 PM.
root@dbstore1002.eqiad.wmnet[information_schema]> select TABLE_SCHEMA,TABLE_NAME,UPDATE_TIME,TABLE_ROWS from information_schema.tables where ENGINE='aria' and TABLE_SCHEMA='staging' order by table_rows asc;
+--------------+-----------------------------+---------------------+------------+
| TABLE_SCHEMA | TABLE_NAME | UPDATE_TIME | TABLE_ROWS |
+--------------+-----------------------------+---------------------+------------+
| staging | referer_data | 2019-01-14 13:39:59 | 31056556 |
| staging | pageviews04 | 2019-01-14 13:33:05 | 43488232 |
| staging | pageviews | 2019-01-14 13:37:20 | 43568621 |
| staging | pageviews05 | 2019-01-14 13:35:19 | 51109873 |
| staging | revert_20150304_enwiki | 2019-01-14 13:47:49 | 87573047 |
| staging | th_subst_template_additions | 2019-01-14 14:07:32 | 94939126 |
| staging | page_name_views_dupes | 2019-01-14 13:31:12 | 127987744 |
| staging | sessions_enwiki_20150801 | 2019-01-14 13:56:47 | 154379416 |
| staging | organic_link | 2019-01-14 13:12:06 | 209134095 |
| staging | mep_word_persistence | 2019-01-14 12:34:42 | 435986042 |
+--------------+-----------------------------+---------------------+------------+
10 rows in set (0.01 sec)