Find large MySQL tables

Last update: November 6, 2024

To identify the large tables, connect to the database as described in the Connect to the database article, and run the following command, where project_id is your Cloud project ID:

SELECT TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = "<project_id>"
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;

This would display the complete list of tables and their size. You can go through the list and identify which tables require attention because of the big size.

Best practices for modifying database tables in the Commerce Implementation Playbook

Previous pageUpdate Shared Catalog prices using REST API
Next pageSync data and files Production to Staging or Staging to Integration

Commerce