云数据库 RDS-DDL工具测试对比:测试步骤

时间：2024-09-06 14:25:01

云数据库 RDS MySQL Online DDL工具使用

测试步骤

创建4张表，表结构如下：

CREATE TABLE if not exists users
	(
	 `rid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	  `nid` bigint(20) DEFAULT NULL,
	  `level` int(11) DEFAULT NULL,
	  `vip` int(11) DEFAULT NULL,
	  `vip_exp` int(11) DEFAULT NULL,
	  `reg_channel` int(11) DEFAULT NULL,
	  `guild_id` bigint(20) unsigned DEFAULT '0',
	  `guild_open` tinyint(1) DEFAULT '0',
	  `forbid_login_time` bigint(20) DEFAULT NULL,
	  `forbid_talk_time` bigint(20) DEFAULT NULL,
	  `ctime` bigint(20) DEFAULT NULL,
	  `mtime` datetime(3) DEFAULT NULL,
	  `last_offline_time` bigint(20) DEFAULT NULL,
	  `friend_open` tinyint(1) DEFAULT '0',
	  `user_data_str` mediumblob,
	  `name` varchar(64) DEFAULT NULL,
	  `db_fix_version` int(10) DEFAULT '0',
	  PRIMARY KEY (`rid`),
	  KEY `idx_users_99_nid` (`nid`),
	  KEY `idx_users_99_level` (`level`),
	  KEY `idx_users_99_ctime` (`ctime`),
	  KEY `idx_users_99_mtime` (`mtime`),
	  KEY `idx_users_99_last_offline_time` (`last_offline_time`),
	  KEY `idx_users_99_name` (`name`)
	) ENGINE=InnoDB AUTO_INCREMENT=4393751571200 DEFAULT CHARSET=utf8mb4;