greg-1-anderson / terminus_debugging_tools

A collection of terminus plugins to facilitate managing sites on Pantheon.

terminus debugging tools

A collection of terminus plugins to facilitate managing sites on Pantheon.

Installation

For installing this plugin, please follow the instrctions from here - https://pantheon.io/docs/terminus/plugins/

Blob Blotter commands

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

Analyze Table commands

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