WARNINGS; CREATE TABLE test ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64) , ts TIMESTAMP , INDEX (ts) ) ENGINE = MyISAM; INSERT INTO test VALUES (NULL, 'short', NULL); INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; INSERT INTO test SELECT NULL, 'short', NULL FROM test; SELECT COUNT(*) FROM test; ---- CREATE TABLE t_pbxt_varchar_arl_4 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 4 ; INSERT INTO t_pbxt_varchar_arl_4 SELECT * FROM test; CREATE TABLE t_pbxt_varchar_arl_8 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 8 ; INSERT INTO t_pbxt_varchar_arl_8 SELECT * FROM test; CREATE TABLE t_pbxt_varchar_arl_16 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 16 ; INSERT INTO t_pbxt_varchar_arl_16 SELECT * FROM test; CREATE TABLE t_pbxt_varchar_arl_32 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 32 ; INSERT INTO t_pbxt_varchar_arl_32 SELECT * FROM test; CREATE TABLE t_pbxt_varchar_arl_64 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 64 ; INSERT INTO t_pbxt_varchar_arl_64 SELECT * FROM test; CREATE TABLE t_pbxt_varchar_arl_128 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 128 ; INSERT INTO t_pbxt_varchar_arl_128 SELECT * FROM test; ---- CREATE TABLE t_pbxt_varcharlong_arl_4 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64000) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 4; INSERT INTO t_pbxt_varcharlong_arl_4 SELECT * FROM test; CREATE TABLE t_pbxt_varcharlong_arl_8 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64000) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 8; INSERT INTO t_pbxt_varcharlong_arl_8 SELECT * FROM test; CREATE TABLE t_pbxt_varcharlong_arl_16 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64000) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 16; INSERT INTO t_pbxt_varcharlong_arl_16 SELECT * FROM test; CREATE TABLE t_pbxt_varcharlong_arl_32 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64000) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 32; INSERT INTO t_pbxt_varcharlong_arl_32 SELECT * FROM test; CREATE TABLE t_pbxt_varcharlong_arl_64 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64000) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 64; INSERT INTO t_pbxt_varcharlong_arl_64 SELECT * FROM test; CREATE TABLE t_pbxt_varcharlong_arl_128 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data VARCHAR(64000) , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 128; INSERT INTO t_pbxt_varcharlong_arl_128 SELECT * FROM test; ---- CREATE TABLE t_pbxt_tinytext_arl_4 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data TINYTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 4; INSERT INTO t_pbxt_tinytext_arl_4 SELECT * FROM test; CREATE TABLE t_pbxt_tinytext_arl_8 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data TINYTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 8; INSERT INTO t_pbxt_tinytext_arl_8 SELECT * FROM test; CREATE TABLE t_pbxt_tinytext_arl_16 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data TINYTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 16; INSERT INTO t_pbxt_tinytext_arl_16 SELECT * FROM test; CREATE TABLE t_pbxt_tinytext_arl_32 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data TINYTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 32; INSERT INTO t_pbxt_tinytext_arl_32 SELECT * FROM test; CREATE TABLE t_pbxt_tinytext_arl_64 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data TINYTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 64; INSERT INTO t_pbxt_tinytext_arl_64 SELECT * FROM test; CREATE TABLE t_pbxt_tinytext_arl_128 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data TINYTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 128; INSERT INTO t_pbxt_tinytext_arl_128 SELECT * FROM test; ---- CREATE TABLE t_pbxt_longtext_arl_4 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data LONGTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 4; INSERT INTO t_pbxt_longtext_arl_4 SELECT * FROM test; CREATE TABLE t_pbxt_longtext_arl_8 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data LONGTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 8; INSERT INTO t_pbxt_longtext_arl_8 SELECT * FROM test; CREATE TABLE t_pbxt_longtext_arl_16 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data LONGTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 16; INSERT INTO t_pbxt_longtext_arl_16 SELECT * FROM test; CREATE TABLE t_pbxt_longtext_arl_32 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data LONGTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 32; INSERT INTO t_pbxt_longtext_arl_32 SELECT * FROM test; CREATE TABLE t_pbxt_longtext_arl_64 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data LONGTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 64; INSERT INTO t_pbxt_longtext_arl_64 SELECT * FROM test; CREATE TABLE t_pbxt_longtext_arl_128 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , data LONGTEXT , ts TIMESTAMP , INDEX (ts) ) ENGINE = PBXT AVG_ROW_LENGTH = 128; INSERT INTO t_pbxt_longtext_arl_128 SELECT * FROM test; SHOW TABLE STATUS;