EVOLUTION-MANAGER

Edit File: sizing_growth.test

# Tests for PERFORMANCE_SCHEMA

--source include/not_embedded.inc
--source include/have_perfschema.inc

#
# Important note:
# this test is extremely sensitive to how threads are running inside the server,
# so it has it's own -master.opt file, to enforce it runs alone in mysqld
#

# Setup

flush status;
flush tables;

# Remove to debug
--disable_result_log

# Make sure the internal server caches are all full
select * from performance_schema.mutex_instances;
select * from performance_schema.rwlock_instances;
select * from performance_schema.cond_instances;
select * from performance_schema.file_instances;

select count(*) from performance_schema.mutex_instances
  into @v0_mutex_instances;

select count(*) from performance_schema.rwlock_instances
  into @v0_rwlock_instances;

select count(*) from performance_schema.cond_instances
  into @v0_cond_instances;

select count(*) from performance_schema.file_instances
  into @v0_file_instances;

select count(*) from performance_schema.mutex_instances
  into @v1_mutex_instances;

select count(*) from performance_schema.rwlock_instances
  into @v1_rwlock_instances;

select count(*) from performance_schema.cond_instances
  into @v1_cond_instances;

select count(*) from performance_schema.file_instances
  into @v1_file_instances;

select count(name), name from performance_schema.mutex_instances
  group by name;

select count(name), name from performance_schema.rwlock_instances
  group by name;

select count(name), name from performance_schema.cond_instances
  group by name;

select count(event_name), event_name from performance_schema.file_instances
  group by event_name;

begin;
create table test.t1(a int) engine = innodb;
create table test.t2(a int) engine = innodb;
create table test.t3(a int) engine = innodb;
create table test.t4(a int) engine = innodb;
create table test.t5(a int) engine = innodb;
create table test.t6(a int) engine = innodb;
create table test.t7(a int) engine = innodb;
create table test.t8(a int) engine = innodb;
create table test.t9(a int) engine = innodb;
create table test.t10(a int) engine = innodb;

# Make sure there is at least 1 table handle,
# to fully initialize the storage engine share if needed.
select * from test.t1;
select * from test.t2;
select * from test.t3;
select * from test.t4;
select * from test.t5;
select * from test.t6;
select * from test.t7;
select * from test.t8;
select * from test.t9;
select * from test.t10;
commit;

select count(*) from performance_schema.mutex_instances
  into @v2_mutex_instances;

select count(*) from performance_schema.rwlock_instances
  into @v2_rwlock_instances;

select count(*) from performance_schema.cond_instances
  into @v2_cond_instances;

select count(*) from performance_schema.file_instances
  into @v2_file_instances;

select count(name), name from performance_schema.mutex_instances
  group by name;

select count(name), name from performance_schema.rwlock_instances
  group by name;

select count(name), name from performance_schema.cond_instances
  group by name;

select count(event_name), event_name from performance_schema.file_instances
  group by event_name;

select @v2_mutex_instances, @v1_mutex_instances, @v0_mutex_instances;
select @v2_rwlock_instances, @v1_rwlock_instances, @v0_rwlock_instances;
select @v2_cond_instances, @v1_cond_instances, @v0_cond_instances;
select @v2_file_instances, @v1_file_instances, @v0_file_instances;

select round((@v2_mutex_instances - @v1_mutex_instances) / 10)
  into @mutex_per_share;
select round((@v2_rwlock_instances - @v1_rwlock_instances) / 10)
  into @rwlock_per_share;
select round((@v2_cond_instances - @v1_cond_instances) / 10)
  into @cond_per_share;
select round((@v2_file_instances - @v1_file_instances) / 10)
  into @file_per_share;

connect (con1, localhost, root,,);
select "con1 connected";

connect (con2, localhost, root,,);
select "con2 connected";

connect (con3, localhost, root,,);
select "con3 connected";

connect (con4, localhost, root,,);
select "con4 connected";

connect (con5, localhost, root,,);
select "con5 connected";

connect (con6, localhost, root,,);
select "con6 connected";

connect (con7, localhost, root,,);
select "con7 connected";

connect (con8, localhost, root,,);
select "con8 connected";

connect (con9, localhost, root,,);
select "con9 connected";

connect (con10, localhost, root,,);
select "con10 connected";

connection default;

select count(*) from performance_schema.mutex_instances
  into @v3_mutex_instances;

select count(*) from performance_schema.rwlock_instances
  into @v3_rwlock_instances;

select count(*) from performance_schema.cond_instances
  into @v3_cond_instances;

select count(*) from performance_schema.file_instances
  into @v3_file_instances;

select count(name), name from performance_schema.mutex_instances
  group by name;

select count(name), name from performance_schema.rwlock_instances
  group by name;

select count(name), name from performance_schema.cond_instances
  group by name;

select count(event_name), event_name from performance_schema.file_instances
  group by event_name;

select @v3_mutex_instances, @v2_mutex_instances;
select @v3_rwlock_instances, @v2_rwlock_instances;
select @v3_cond_instances, @v2_cond_instances;
select @v3_file_instances, @v2_file_instances;

select round((@v3_mutex_instances - @v2_mutex_instances) / 10)
  into @mutex_per_con;
select round((@v3_rwlock_instances - @v2_rwlock_instances) / 10)
  into @rwlock_per_con;
select round((@v3_cond_instances - @v2_cond_instances) / 10)
  into @cond_per_con;
select round((@v3_file_instances - @v2_file_instances) / 10)
  into @file_per_con;

--connection con1

lock table test.t1 write, test.t2 write, test.t3 write, test.t4 write,
test.t5 write, test.t6 write, test.t7 write, test.t8 write, test.t9 write,
test.t10 write;