Comment 3 for bug 313176

Revision history for this message
Vladimir Kolesnikov (vkolesnikov) wrote :

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...