Page MenuHomePhabricator
Paste P11251

(An Untitled Masterwork)
ActivePublic

Authored by Kormat on Wed, May 20, 10:39 AM.
root@db1141:/srv/sqldata# time mysql wikidatawiki -e 'optimize table wb_terms;'
+-----------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+----------+----------+-------------------------------------------------------------------+
| wikidatawiki.wb_terms | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| wikidatawiki.wb_terms | optimize | status | OK |
+-----------------------+----------+----------+-------------------------------------------------------------------+
real 0m0.225s
user 0m0.011s
sys 0m0.000s
root@db1141:/srv/sqldata# du -hs ./wikidatawiki/T248086_wb_terms.ibd
537G ./wikidatawiki/T248086_wb_terms.ibd
mysql:root@localhost [wikidatawiki]> select * FROM T248086_wb_terms limit 1;
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
| term_row_id | term_entity_id | term_full_entity_id | term_entity_type | term_language | term_type | term_text | term_search_key | term_weight |
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
| 363474 | 50445 | Q50445 | item | en-gb | label | Jungwon-gu | | 0 |
+-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+
1 row in set (0.000 sec)
mysql:root@localhost [wikidatawiki]> select count(*) from wb_terms;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.001 sec)

Event Timeline

Kormat created this paste.Wed, May 20, 10:39 AM