database-assessment
database-assessment copied to clipboard
Database Migration Assessment
* Modify Statspack collection to be able to extract historical data vs only recent. * Filter out restarts between snaps. * Modify status messages for Statspack collections * Ability to...
fix: remove non-postgres code from script #425
fix: remove non-mysql functions from script #424
https://github.com/GoogleCloudPlatform/database-assessment/blob/c50fa80ddb9c6a5e2a61aea6b390c42ef28308dd/scripts/collector/postgres/collect-data.sh#L206-L249
https://github.com/GoogleCloudPlatform/database-assessment/blob/bc4a6c462b5f0175e755d5ea523382df7052c6b1/Makefile#L100-L176
https://github.com/GoogleCloudPlatform/database-assessment/blob/bc4a6c462b5f0175e755d5ea523382df7052c6b1/scripts/collector/mysql/sql/table_details.sql#L19
https://github.com/GoogleCloudPlatform/database-assessment/blob/bc4a6c462b5f0175e755d5ea523382df7052c6b1/scripts/collector/postgres/sql/calculated_metrics.sql#L183 ```sql select count(1) from ..extensions.. where extension_owner='rdsadmin' and is_super_user ```
https://github.com/GoogleCloudPlatform/database-assessment/blob/c50fa80ddb9c6a5e2a61aea6b390c42ef28308dd/scripts/collector/mysql/collect-data.sh#L102-L135
https://github.com/GoogleCloudPlatform/database-assessment/blob/c50fa80ddb9c6a5e2a61aea6b390c42ef28308dd/src/dma/cli/main.py#L114