Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P11251
(An Untitled Masterwork)
Archived
Public
Actions
Authored by
Kormat
on May 20 2020, 10:39 AM.
Edit Paste
Activate Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F31833816: raw.txt
May 20 2020, 10:39 AM
2020-05-20 10:39:16 (UTC+0)
Subscribers
None
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.
May 20 2020, 10:39 AM
2020-05-20 10:39:16 (UTC+0)
Kormat
archived this paste.
Sep 23 2020, 12:48 PM
2020-09-23 12:48:38 (UTC+0)
Log In to Comment