blob: 1c8b7df1ebdf93c23ad4994cc6841096aad98399 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
SET DEFAULT_STORAGE_ENGINE='tokudb';
# Establish connection conn1 (user = root)
drop table if exists s;
create table s (a int auto_increment, b int, c int, primary key (a));
# populate table s
# done inserting elements
set tokudb_create_index_online=1;
create index i_a on s(c);
# starting insert while create index is happening
# done with insert
select count(*) from s use index(primary);
count(*)
100000
select count(*) from s use index(i_a);
count(*)
100000
drop table s;
|
