A RetroSearch Logo

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Search Query:

Showing content from https://phabricator.wikimedia.org/T362566 below:

⚓ T362566 Stop growth of text table by storing ES addresses in content table

First step in addressing the parent ticket. And at least reducing the growth rate of s1 and s8

Event Timeline Comment Actions

https://en.wikipedia.beta.wmflabs.org/w/index.php?title=BeforeEach-name-0.8802907327901288-I%C3%B1t%C3%ABrn%C3%A2ti%C3%B4n%C3%A0liz%C3%A6ti%C3%B8n&oldid=620186

MariaDB [enwiki]> select * from content where content_id = 547295;
+------------+--------------+---------------------------------+---------------+------------------------------------------+
| content_id | content_size | content_sha1                    | content_model | content_address                          |
+------------+--------------+---------------------------------+---------------+------------------------------------------+
|     547295 |           66 | lp53apdzyatqddqr5uvcrzn8cecx7m0 |             1 | es:DB://cluster1/692465?flags=utf-8,gzip |
+------------+--------------+---------------------------------+---------------+------------------------------------------+
1 row in set (0.001 sec)
root@deployment-db14:/srv/sqldata/enwiki# ls -l | grep -i text
-rw-r----- 1 mysql mysql       973 Feb 26 21:36 aft_article_answer_text.frm
-rw-r----- 1 mysql mysql     65536 Feb 26 21:32 aft_article_answer_text.ibd
-rw-r----- 1 mysql mysql      1001 Feb 26 21:36 text.frm
-rw-r----- 1 mysql mysql 432013312 May  4 19:21 text.ibd
-rw-r----- 1 mysql mysql      1001 Feb 26 21:36 unittest_external_text.frm
-rw-r----- 1 mysql mysql     65536 Feb 26 21:32 unittest_external_text.ibd

Everything works as expected.

Comment Actions

Everything is fine. That's fishy. I close this ticket for now.


RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4