· 9 years ago · Oct 28, 2016, 05:36 PM
1-- MySQL dump 10.13 Distrib 5.7.16, for Linux (x86_64)
2--
3-- Host: localhost Database: mysql
4-- ------------------------------------------------------
5-- Server version 5.7.16
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `innodb_index_stats`
20--
21
22DROP TABLE IF EXISTS `innodb_index_stats`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `innodb_index_stats` (
26 `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
27 `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
28 `index_name` varchar(64) COLLATE utf8_bin NOT NULL,
29 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
30 `stat_name` varchar(64) COLLATE utf8_bin NOT NULL,
31 `stat_value` bigint(20) unsigned NOT NULL,
32 `sample_size` bigint(20) unsigned DEFAULT NULL,
33 `stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,
34 PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `innodb_index_stats`
40--
41
42LOCK TABLES `innodb_index_stats` WRITE;
43/*!40000 ALTER TABLE `innodb_index_stats` DISABLE KEYS */;
44INSERT INTO `innodb_index_stats` VALUES ('mysql','gtid_executed','PRIMARY','2016-10-28 15:33:11','n_diff_pfx01',0,1,'source_uuid'),('mysql','gtid_executed','PRIMARY','2016-10-28 15:33:11','n_diff_pfx02',0,1,'source_uuid,interval_start'),('mysql','gtid_executed','PRIMARY','2016-10-28 15:33:11','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('mysql','gtid_executed','PRIMARY','2016-10-28 15:33:11','size',1,NULL,'Number of pages in the index'),('sys','sys_config','PRIMARY','2016-10-28 15:33:15','n_diff_pfx01',6,1,'variable'),('sys','sys_config','PRIMARY','2016-10-28 15:33:15','n_leaf_pages',1,NULL,'Number of leaf pages in the index'),('sys','sys_config','PRIMARY','2016-10-28 15:33:15','size',1,NULL,'Number of pages in the index');
45/*!40000 ALTER TABLE `innodb_index_stats` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `innodb_table_stats`
50--
51
52DROP TABLE IF EXISTS `innodb_table_stats`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `innodb_table_stats` (
56 `database_name` varchar(64) COLLATE utf8_bin NOT NULL,
57 `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
58 `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
59 `n_rows` bigint(20) unsigned NOT NULL,
60 `clustered_index_size` bigint(20) unsigned NOT NULL,
61 `sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
62 PRIMARY KEY (`database_name`,`table_name`)
63) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `innodb_table_stats`
68--
69
70LOCK TABLES `innodb_table_stats` WRITE;
71/*!40000 ALTER TABLE `innodb_table_stats` DISABLE KEYS */;
72INSERT INTO `innodb_table_stats` VALUES ('mysql','gtid_executed','2016-10-28 15:33:11',0,1,0),('sys','sys_config','2016-10-28 15:33:15',6,1,0);
73/*!40000 ALTER TABLE `innodb_table_stats` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `slave_master_info`
78--
79
80DROP TABLE IF EXISTS `slave_master_info`;
81/*!40101 SET @saved_cs_client = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `slave_master_info` (
84 `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',
85 `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
86 `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',
87 `Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'The host name of the master.',
88 `User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',
89 `User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',
90 `Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
91 `Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
92 `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
93 `Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
94 `Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
95 `Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',
96 `Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',
97 `Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',
98 `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
99 `Heartbeat` float NOT NULL,
100 `Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
101 `Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
102 `Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',
103 `Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
104 `Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
105 `Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
106 `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
107 `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
108 `Tls_version` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Tls version',
109 PRIMARY KEY (`Channel_name`)
110) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `slave_master_info`
115--
116
117LOCK TABLES `slave_master_info` WRITE;
118/*!40000 ALTER TABLE `slave_master_info` DISABLE KEYS */;
119/*!40000 ALTER TABLE `slave_master_info` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `slave_relay_log_info`
124--
125
126DROP TABLE IF EXISTS `slave_relay_log_info`;
127/*!40101 SET @saved_cs_client = @@character_set_client */;
128/*!40101 SET character_set_client = utf8 */;
129CREATE TABLE `slave_relay_log_info` (
130 `Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
131 `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',
132 `Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.',
133 `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
134 `Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.',
135 `Sql_delay` int(11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
136 `Number_of_workers` int(10) unsigned NOT NULL,
137 `Id` int(10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.',
138 `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
139 PRIMARY KEY (`Channel_name`)
140) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';
141/*!40101 SET character_set_client = @saved_cs_client */;
142
143--
144-- Dumping data for table `slave_relay_log_info`
145--
146
147LOCK TABLES `slave_relay_log_info` WRITE;
148/*!40000 ALTER TABLE `slave_relay_log_info` DISABLE KEYS */;
149/*!40000 ALTER TABLE `slave_relay_log_info` ENABLE KEYS */;
150UNLOCK TABLES;
151
152--
153-- Table structure for table `slave_worker_info`
154--
155
156DROP TABLE IF EXISTS `slave_worker_info`;
157/*!40101 SET @saved_cs_client = @@character_set_client */;
158/*!40101 SET character_set_client = utf8 */;
159CREATE TABLE `slave_worker_info` (
160 `Id` int(10) unsigned NOT NULL,
161 `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
162 `Relay_log_pos` bigint(20) unsigned NOT NULL,
163 `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
164 `Master_log_pos` bigint(20) unsigned NOT NULL,
165 `Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
166 `Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,
167 `Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
168 `Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,
169 `Checkpoint_seqno` int(10) unsigned NOT NULL,
170 `Checkpoint_group_size` int(10) unsigned NOT NULL,
171 `Checkpoint_group_bitmap` blob NOT NULL,
172 `Channel_name` char(64) NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
173 PRIMARY KEY (`Channel_name`,`Id`)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';
175/*!40101 SET character_set_client = @saved_cs_client */;
176
177--
178-- Dumping data for table `slave_worker_info`
179--
180
181LOCK TABLES `slave_worker_info` WRITE;
182/*!40000 ALTER TABLE `slave_worker_info` DISABLE KEYS */;
183/*!40000 ALTER TABLE `slave_worker_info` ENABLE KEYS */;
184UNLOCK TABLES;
185/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
186
187/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
188/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
189/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
190/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
191/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
192/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
193/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
194
195-- Dump completed on 2016-10-28 15:34:27