Page MenuHomePhabricator
Paste P10729

how to check if a table is being read
ActivePublic

Authored by jcrespo on Thu, Mar 19, 1:28 PM.
root@db1109.eqiad.wmnet[sys]> SELECT rows_fetched FROM schema_table_statistics WHERE table_name='wb_terms';
+--------------+
| rows_fetched |
+--------------+
| 43745407489 |
+--------------+
1 row in set (0.13 sec)
root@db1109.eqiad.wmnet[sys]> select * FROM wikidatawiki.wb_terms limit 1;
<1 row shown>
1 row in set (0.00 sec)
root@db1109.eqiad.wmnet[sys]> SELECT rows_fetched FROM schema_table_statistics WHERE table_name='wb_terms';
+--------------+
| rows_fetched |
+--------------+
| 43745407490 |
+--------------+
1 row in set (0.13 sec)

Event Timeline

jcrespo created this paste.Thu, Mar 19, 1:28 PM