mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 21:32:18 +01:00
7468ccfadf
commit d1bb19b8f751875472211312c8e810143a7ba4b6
Author: Manuel Ung <mung@fb.com>
Date: Fri Feb 3 11:50:34 2017 -0800
Add cardinality stats to information schema
Summary: This adds cardinality stats to the INFORMATION_SCHEMA.ROCKSDB_INDEX_FILE_MAP table. This is the only missing user collected properties from SST files that we don't expose, which is useful for debugging cardinality bugs.
Reviewed By: hermanlee
Differential Revision: D4509156
fbshipit-source-id: 2d3918a
41 lines
981 B
Text
41 lines
981 B
Text
include/rpl_init.inc [topology=none]
|
|
include/rpl_default_connections.inc
|
|
create database db1;
|
|
create table db1.t1 (
|
|
`id` int(10) not null auto_increment,
|
|
`k` int(10),
|
|
`data` varchar(2048),
|
|
primary key (`id`),
|
|
key (`k`)
|
|
) engine=rocksdb;
|
|
create database slocket;
|
|
create table slocket.t1 (
|
|
`id` int(10) not null auto_increment,
|
|
`k` int(10),
|
|
`data` varchar(2048),
|
|
primary key (`id`),
|
|
key (`k`)
|
|
) engine=rocksdb;
|
|
include/rpl_stop_server.inc [server_number=2]
|
|
myrocks_hotbackup copy phase
|
|
myrocks_hotbackup move-back phase
|
|
include/rpl_start_server.inc [server_number=2]
|
|
select count(*) from db1.t1;
|
|
count(*)
|
|
250000
|
|
select count(*) from slocket.t1;
|
|
count(*)
|
|
2500
|
|
drop database slocket;
|
|
drop database db1;
|
|
drop database slocket;
|
|
include/rpl_stop_server.inc [server_number=2]
|
|
myrocks_hotbackup copy phase
|
|
myrocks_hotbackup move-back phase
|
|
include/rpl_start_server.inc [server_number=2]
|
|
select count(*) from db1.t1;
|
|
count(*)
|
|
250000
|
|
drop database db1;
|
|
drop database db1;
|
|
include/rpl_end.inc
|