Johnson-You-j
Johnson-You-j
/ qa_tables_vs_prod_diff.txt
Created
October 9, 2025 09:47
Schema Drift: qa vs prod - ANALYSIS (2025-10-09)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2025-10-09 09:47:26 [INFO] Generating diff of 127.0.0.1:3306 ANALYSIS vs /skeema/gke_btc-dev-323305_asia-southeast1_btc-devqa/ANALYSIS/tables/*.sql | |
| 2025-10-09 09:47:37 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devqa/ANALYSIS/tables/AGGREGATE_STATUS_DAILY_USER_TAG.sql:10: Index AGGREGATE_STATUS_DAILY_USER_TAG_DAY_ID_index of table `AGGREGATE_STATUS_DAILY_USER_TAG` is redundant to larger index PRIMARY. In most cases it is safe to drop index AGGREGATE_STATUS_DAILY_USER_TAG_DAY_ID_index, but consider making it INVISIBLE first. Redundant indexes waste disk space, and harm write performance. | |
| 2025-10-09 09:47:37 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devqa/ANALYSIS/tables/GAME_SUMMARY_INFO.sql:1:1: Table `GAME_SUMMARY_INFO` does not define a PRIMARY KEY. | |
| 2025-10-09 09:47:37 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devqa/ANALYSIS/tables/GAME_SUMMARY_SETTING.sql:1:1: Table `GAME_SUMMARY_SETTING` does not define a PRIMARY KEY. | |
| 2025-10-09 09:47:37 [WARN] /skeema/gke_btc-dev-3 |
Johnson-You-j
/ dev_tables_vs_prod_diff.txt
Created
October 9, 2025 09:47
Schema Drift: dev vs prod - ANALYSIS (2025-10-09)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2025-10-09 09:47:06 [INFO] Generating diff of 127.0.0.1:3306 ANALYSIS vs /skeema/gke_btc-dev-323305_asia-southeast1_btc-devuse/ANALYSIS/tables/*.sql | |
| 2025-10-09 09:47:15 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devuse/ANALYSIS/tables/AGGREGATE_STATUS_DAILY_USER_TAG.sql:10: Index AGGREGATE_STATUS_DAILY_USER_TAG_DAY_ID_index of table `AGGREGATE_STATUS_DAILY_USER_TAG` is redundant to larger index PRIMARY. In most cases it is safe to drop index AGGREGATE_STATUS_DAILY_USER_TAG_DAY_ID_index, but consider making it INVISIBLE first. Redundant indexes waste disk space, and harm write performance. | |
| 2025-10-09 09:47:15 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devuse/ANALYSIS/tables/GAME_SUMMARY_INFO.sql:1:1: Table `GAME_SUMMARY_INFO` does not define a PRIMARY KEY. | |
| 2025-10-09 09:47:15 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devuse/ANALYSIS/tables/GAME_SUMMARY_SETTING.sql:1:1: Table `GAME_SUMMARY_SETTING` does not define a PRIMARY KEY. | |
| 2025-10-09 09:47:15 [WARN] /skeema/gke_btc-d |
Johnson-You-j
/ qa_tables_vs_prod_diff.txt
Created
October 9, 2025 09:46
Schema Drift: qa vs prod - ACTIVITY (2025-10-09)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2025-10-09 09:45:48 [INFO] Generating diff of 127.0.0.1:3306 ACTIVITY vs /skeema/gke_btc-dev-323305_asia-southeast1_btc-devqa/ACTIVITY/tables/*.sql | |
| 2025-10-09 09:46:18 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devqa/ACTIVITY/tables/ACTIVITY_REWARD_TIME_BLOCK.sql:10: Index ACTIVITY_REWARD_TIME_BLOCK_ACTIVITY_NO_index of table `ACTIVITY_REWARD_TIME_BLOCK` is redundant to larger index ACTIVITY_REWARD_TIME_BLOCK_index. In most cases it is safe to drop index ACTIVITY_REWARD_TIME_BLOCK_ACTIVITY_NO_index, but consider making it INVISIBLE first. Redundant indexes waste disk space, and harm write performance. | |
| 2025-10-09 09:46:18 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devqa/ACTIVITY/tables/ACTIVITY_TEMPLATE.sql:1:1: Table `ACTIVITY_TEMPLATE` does not define a PRIMARY KEY. Lack of a PRIMARY KEY hurts performance, and prevents use of third-party tools such as pt-online-schema-change. | |
| 2025-10-09 09:46:18 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devqa/ACTIVITY/tables/BATCH_REWARD |
Johnson-You-j
/ dev_tables_vs_prod_diff.txt
Created
October 9, 2025 09:45
Schema Drift: dev vs prod - ACTIVITY (2025-10-09)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2025-10-09 09:44:45 [INFO] Generating diff of 127.0.0.1:3306 ACTIVITY vs /skeema/gke_btc-dev-323305_asia-southeast1_btc-devuse/ACTIVITY/tables/*.sql | |
| 2025-10-09 09:45:16 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devuse/ACTIVITY/tables/ACTIVITY_REWARD_TIME_BLOCK.sql:10: Index ACTIVITY_REWARD_TIME_BLOCK_ACTIVITY_NO_index of table `ACTIVITY_REWARD_TIME_BLOCK` is redundant to larger index ACTIVITY_REWARD_TIME_BLOCK_index. In most cases it is safe to drop index ACTIVITY_REWARD_TIME_BLOCK_ACTIVITY_NO_index, but consider making it INVISIBLE first. Redundant indexes waste disk space, and harm write performance. | |
| 2025-10-09 09:45:16 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devuse/ACTIVITY/tables/ACTIVITY_TEMPLATE.sql:1:1: Table `ACTIVITY_TEMPLATE` does not define a PRIMARY KEY. Lack of a PRIMARY KEY hurts performance, and prevents use of third-party tools such as pt-online-schema-change. | |
| 2025-10-09 09:45:16 [WARN] /skeema/gke_btc-dev-323305_asia-southeast1_btc-devuse/ACTIVITY/tables/BATCH_RE |