A collection of terminus plugins to facilitate managing sites on Pantheon.
For installing this plugin, please follow the instrctions from here - https://pantheon.io/docs/terminus/plugins/
Finds the biggest text/blob columns from your MariaDB database ordered by size.
$ terminus blob:columns SITE.ENV
------------------------------------ -------------------- --------------------
Table Column Biggest entry (KB)
------------------------------------ -------------------- --------------------
cache data 61.2412
field_data_body body_value 46.4551
field_revision_body body_value 46.4551
cache_update data 38.4697
search_dataset data 19.4033
Finds the biggest rows from the specified table and column.
$ terminus blob:cells SITE.ENV TABLE COLUMN --format=table
Example output:
$ terminus blob:cells SITE.ENV field_data_body body_value --format=table
------------- --------- --------- ----------- ------------- ---------- ------- -------------- ------------- -----------
Entity_type Bundle Deleted Entity_id Revision_id Language Delta Body_summary Body_format Column_KB
------------- --------- --------- ----------- ------------- ---------- ------- -------------- ------------- -----------
node article 0 238 238 und 0 full_html 46.4551
node article 0 183 183 und 0 full_html 21.3848
node article 0 179 179 und 0 full_html 18.3184
node article 0 186 186 und 0 full_html 15.7764
node article 0 222 222 und 0 full_html 15.4717
node article 0 158 158 und 0 full_html 14.0332
Runs ANALIZE TABLE query on either a specific group of tables or all of them.
$ terminus analyze-table:run SITE.ENV TABLE
$ terminus analyze-table:run SITE.ENV TABLE_1,TABLE_2,TABLE_3
$ terminus analyze-table:run SITE.ENV all