There's a performance problem:
mysql> show processlist; +----+------+-----------------+------+---------+------+--------+-------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------------+------+---------+------+--------+-------------------------------------------------------------------+ | 7 | root | localhost | test | Query | 5 | update | INSERT INTO t1 (c1) VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9) | | 8 | root | localhost:37669 | test | Query | 0 | NULL | show processlist | +----+------+-----------------+------+---------+------+--------+-------------------------------------------------------------------+ 2 rows in set (0.00 sec)
mysql> show create table t1; +-------+-------------------------------------------------------------------------------------+ | Table | Create Table | +-------+-------------------------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `c1` bigint(20) NOT NULL ) ENGINE=PBXT DEFAULT CHARSET=latin1 | +-------+-------------------------------------------------------------------------------------+ 1 row in set (0.00 sec)
A very simple INSERT w/o references takes > 5 seconds to execute...
There's a performance problem:
mysql> show processlist; -----+- ------- ------- --+---- --+---- -----+- -----+- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------- -----+ -----+- ------- ------- --+---- --+---- -----+- -----+- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------- -----+ 0),(1), (2),(3) ,(4),(5) ,(6),(7) ,(8),(9) | -----+- ------- ------- --+---- --+---- -----+- -----+- ------- +------ ------- ------- ------- ------- ------- ------- ------- ------- -----+
+----+-
| Id | User | Host | db | Command | Time | State | Info |
+----+-
| 7 | root | localhost | test | Query | 5 | update | INSERT INTO t1 (c1) VALUES(
| 8 | root | localhost:37669 | test | Query | 0 | NULL | show processlist |
+----+-
2 rows in set (0.00 sec)
mysql> show create table t1; -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---+ -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---+ -+----- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ---+
+------
| Table | Create Table |
+------
| t1 | CREATE TABLE `t1` (
`c1` bigint(20) NOT NULL
) ENGINE=PBXT DEFAULT CHARSET=latin1 |
+------
1 row in set (0.00 sec)
A very simple INSERT w/o references takes > 5 seconds to execute...