This testcase:
INSTALL PLUGIN scalability_metrics SONAME 'scalability_metrics.so'; DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE t1(c1 SMALLINT ZEROFILL NULL); CREATE TABLE t5(c1 REAL NOT NULL); SET GLOBAL scalability_metrics_control = OFF; SET GLOBAL scalability_metrics_control = ON; CREATE TABLE t577 (c1 VARCHAR(10)); Connection ID (thread ID): 6; ;
Can crash the server. It can also produce a GLIBC crash. But it is very sporadic, and hard to trigger. Here are the mysqld options used;
--log-output=none --sql_mode=ONLY_FULL_GROUP_BY --plugin-load-add=audit_log=audit_log.so --plugin-load-add=tokudb=ha_tokudb.so --init-file=/home/roel/percona-qa/plugins.sql --tokudb-check-jemalloc=0 --performance-schema-max-rwlock-instances=0 --innodb-max-dirty-pages-pct-lwm=1 --log-slow-filter=filesort_on_disk --innodb-ft-sort-pll-degree=-1125899906842624 --tokudb_fanout=32 --tokudb-read-status-frequency=0 --tokudb-fs-reserve-percent=24 --tokudb_fanout=64 --tokudb_block_size=56732 --tokudb-cleaner-iterations=2"
Though likely many (especially the TokuDB ones) are not required. Sorry to not be more specific then this, it was not straightforward to get this far.
This testcase:
INSTALL PLUGIN scalability_metrics SONAME 'scalability_ metrics. so'; metrics_ control = OFF; metrics_ control = ON;
DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test;
CREATE TABLE t1(c1 SMALLINT ZEROFILL NULL);
CREATE TABLE t5(c1 REAL NOT NULL);
SET GLOBAL scalability_
SET GLOBAL scalability_
CREATE TABLE t577 (c1 VARCHAR(10));
Connection ID (thread ID): 6; ;
Can crash the server. It can also produce a GLIBC crash. But it is very sporadic, and hard to trigger. Here are the mysqld options used;
--log-output=none --sql_mode= ONLY_FULL_ GROUP_BY --plugin- load-add= audit_log= audit_log. so --plugin- load-add= tokudb= ha_tokudb. so --init- file=/home/ roel/percona- qa/plugins. sql --tokudb- check-jemalloc= 0 --performance- schema- max-rwlock- instances= 0 --innodb- max-dirty- pages-pct- lwm=1 --log-slow- filter= filesort_ on_disk --innodb- ft-sort- pll-degree= -11258999068426 24 --tokudb_fanout=32 --tokudb- read-status- frequency= 0 --tokudb- fs-reserve- percent= 24 --tokudb_fanout=64 --tokudb_ block_size= 56732 --tokudb- cleaner- iterations= 2"
Though likely many (especially the TokuDB ones) are not required. Sorry to not be more specific then this, it was not straightforward to get this far.