· 10 years ago · Sep 05, 2016, 01:30 PM
1DROP TABLE IF EXISTS `gtid_slave_pos`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `gtid_slave_pos` (
5 `domain_id` int(10) unsigned NOT NULL,
6 `sub_id` bigint(20) unsigned NOT NULL,
7 `server_id` int(10) unsigned NOT NULL,
8 `seq_no` bigint(20) unsigned NOT NULL,
9 PRIMARY KEY (`domain_id`,`sub_id`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Replication slave GTID position';
11/*!40101 SET character_set_client = @saved_cs_client */;
12
13
14
15DROP TABLE IF EXISTS `innodb_table_stats`;
16/*!40101 SET @saved_cs_client = @@character_set_client */;
17/*!40101 SET character_set_client = utf8 */;
18CREATE TABLE `innodb_table_stats` (
19 `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
20 `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
21 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
22 `n_rows` bigint(20) unsigned NOT NULL,
23 `clustered_index_size` bigint(20) unsigned NOT NULL,
24 `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
25 PRIMARY KEY (`database_name`,`table_name`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
27/*!40101 SET character_set_client = @saved_cs_client */;
28
29
30DROP TABLE IF EXISTS `innodb_index_stats`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `innodb_index_stats` (
34 `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
35 `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
36 `index_name` varchar(64) COLLATE utf8_bin NOT NULL,
37 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
38 `stat_name` varchar(64) COLLATE utf8_bin NOT NULL,
39 `stat_value` bigint(20) unsigned NOT NULL,
40 `sample_size` bigint(20) unsigned DEFAULT NULL,
41 `stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,
42 PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
43) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
44/*!40101 SET character_set_client = @saved_cs_client */;