Mysqldump extra Analyze Table DDL

Hi,
I’ve used mysqldump to dump schema from Singlestore Cloud and it keeps adding (analyzing table for each column). Is there a way to avoid that?

mysqldump -h ${targethost} -u admin -P 3306 -p --lock-tables=false --default-auth=mysql_native_password -d db_name >


CREATE TABLE `cloud_sync_table_list` (
  `id` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
  `table_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `sql_string` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  SHARD KEY `idx_SHARDKEY` (`id`),
  KEY `idx_cluster_key` (`id`) USING CLUSTERED COLUMNSTORE
) AUTOSTATS_CARDINALITY_MODE=INCREMENTAL AUTOSTATS_HISTOGRAM_MODE=CREATE AUTOSTATS_SAMPLING=ON SQL_MODE='STRICT_ALL_TABLES';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!80002 ANALYZE TABLE `cloud_sync_table_list` UPDATE HISTOGRAM ON `id` WITH (null) BUCKETS */;
/*!80002 ANALYZE TABLE `cloud_sync_table_list` UPDATE HISTOGRAM ON `updated_at` WITH (null) BUCKETS */;
/*!80002 ANALYZE TABLE `cloud_sync_table_list` UPDATE HISTOGRAM ON `created_at` WITH (null) BUCKETS */;
/*!80002 ANALYZE TABLE `cloud_sync_table_list` UPDATE HISTOGRAM ON `sql_string` WITH (null) BUCKETS */;
/*!80002 ANALYZE TABLE `cloud_sync_table_list` UPDATE HISTOGRAM ON `is_active` WITH (null) BUCKETS */;

I don’t know if it will solve the problem, but consider using sdb-admin dump instead.

https://docs.singlestore.com/db/v7.8/en/reference/singlestore-tools-reference/sdb-admin-commands/dump.html

1 Like