CREATE TABLE `ts_date_by_server` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`id_mysql_server` int(11) NOT NULL,
|
`id_ts_file` int(11) NOT NULL,
|
`date` datetime NOT NULL,
|
PRIMARY KEY (`id`,`date`),
|
UNIQUE KEY `id_mysql_server` (`id_mysql_server`,`id_ts_file`,`date`)
|
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT
|
PARTITION BY RANGE (to_days(`date`))
|
(PARTITION `p737840` VALUES LESS THAN (737840) ENGINE = ROCKSDB,
|
PARTITION `p737841` VALUES LESS THAN (737841) ENGINE = ROCKSDB);
|
|
|
while(true)
|
{
|
INSERT INTO `ts_date_by_server` (`id_mysql_server`,`id_ts_file`, `date`) VALUES (1, 3, '2020-02-19 16:06:05'),
|
(9, 3, '2020-02-19 16:06:05'),
|
(115, 3, '2020-02-19 16:06:05'),
|
(183, 3, '2020-02-19 16:06:05'),
|
(176, 3, '2020-02-19 16:06:05'),
|
(174, 3, '2020-02-19 16:06:05'),
|
(172, 3, '2020-02-19 16:06:05'),
|
(179, 3, '2020-02-19 16:06:05'),
|
(173, 3, '2020-02-19 16:06:05'),
|
(181, 3, '2020-02-19 16:06:05'),
|
(178, 3, '2020-02-19 16:06:05'),
|
(187, 3, '2020-02-19 16:06:05'),
|
(114, 3, '2020-02-19 16:06:05'),
|
(184, 3, '2020-02-19 16:06:05'),
|
(186, 3, '2020-02-19 16:06:05'),
|
(180, 3, '2020-02-19 16:06:05'),
|
(185, 3, '2020-02-19 16:06:05'),
|
(177, 3, '2020-02-19 16:06:05'),
|
(175, 3, '2020-02-19 16:06:05'),
|
(171, 3, '2020-02-19 16:06:05'),
|
(182, 3, '2020-02-19 16:06:05');
|
}
|
|
|
[2020-02-19 16:08:18] [SHOW WARNINGS]
|
SELECT
|
*
|
FROM
|
`sys`.`schema_auto_increment_columns`
|
LIMIT
|
200
|
|
/data/www/pmacontrol/vendor/glial/glial/Glial/Sgbd/Sql/Mysql/Mysql.php:419
|
+-----------+--------+-------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+-----------+--------+-------------------------------------------------------------------------------+
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
| Warning | 1916 | Got overflow when converting '18446744073709551615' to INT. Value truncated |
|
+-----------+--------+-------------------------------------------------------------------------------+
|
28 rows
|