Description:
The cluster log statistics shows erroneous 'Abort Count' when doing PK reads on table with CLOB column.
--
2009-07-20 08:07:39 [MgmSrvr] INFO -- Node 4: Trans. Count = 5280, Commit Count = 0, Read Count = 5280, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15840, Concurrent Operations = 0, Abort Count = 5281 Scans = 0 Range scans = 0
2009-07-20 08:07:42 [MgmSrvr] INFO -- Node 4: Operations=5201
2009-07-20 08:07:43 [MgmSrvr] INFO -- Node 3: Operations=0
2009-07-20 08:07:43 [MgmSrvr] INFO -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0
2009-07-20 08:07:44 [MgmSrvr] INFO -- Node 4: Trans. Count = 5164, Commit Count = 0, Read Count = 5164, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15492, Concurrent Operations = 1, Abort Count = 5163 Scans = 0 Range scans = 0
2009-07-20 08:07:47 [MgmSrvr] INFO -- Node 4: Operations=5220
2009-07-20 08:07:48 [MgmSrvr] INFO -- Node 3: Operations=0
2009-07-20 08:07:48 [MgmSrvr] INFO -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0
2009-07-20 08:07:49 [MgmSrvr] INFO -- Node 4: Trans. Count = 5305, Commit Count = 0, Read Count = 5305, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15915, Concurrent Operations = 0, Abort Count = 5306 Scans = 0 Range scans = 0
2009-07-20 08:07:52 [MgmSrvr] INFO -- Node 4: Operations=5340
2009-07-20 08:07:53 [MgmSrvr] INFO -- Node 3: Operations=0
2009-07-20 08:07:53 [MgmSrvr] INFO -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0
2009-07-20 08:07:54 [MgmSrvr] INFO -- Node 4: Trans. Count = 5297, Commit Count = 0, Read Count = 5297, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15891, Concurrent Operations = 0, Abort Count = 5297 Scans = 0 Range scans = 0
How to repeat:
create table t1 (id int auto_increment primary key, name text) engine ndb;
insert into t1(name) values ('1234567890');
insert into t1(name) select name from t1;
..
mysqlslap --create-schema=test --query='select * from t1 where id=40' --iterations=10000
Suggested fix:
Fix log output.
Description: The cluster log statistics shows erroneous 'Abort Count' when doing PK reads on table with CLOB column. -- 2009-07-20 08:07:39 [MgmSrvr] INFO -- Node 4: Trans. Count = 5280, Commit Count = 0, Read Count = 5280, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15840, Concurrent Operations = 0, Abort Count = 5281 Scans = 0 Range scans = 0 2009-07-20 08:07:42 [MgmSrvr] INFO -- Node 4: Operations=5201 2009-07-20 08:07:43 [MgmSrvr] INFO -- Node 3: Operations=0 2009-07-20 08:07:43 [MgmSrvr] INFO -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0 2009-07-20 08:07:44 [MgmSrvr] INFO -- Node 4: Trans. Count = 5164, Commit Count = 0, Read Count = 5164, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15492, Concurrent Operations = 1, Abort Count = 5163 Scans = 0 Range scans = 0 2009-07-20 08:07:47 [MgmSrvr] INFO -- Node 4: Operations=5220 2009-07-20 08:07:48 [MgmSrvr] INFO -- Node 3: Operations=0 2009-07-20 08:07:48 [MgmSrvr] INFO -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0 2009-07-20 08:07:49 [MgmSrvr] INFO -- Node 4: Trans. Count = 5305, Commit Count = 0, Read Count = 5305, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15915, Concurrent Operations = 0, Abort Count = 5306 Scans = 0 Range scans = 0 2009-07-20 08:07:52 [MgmSrvr] INFO -- Node 4: Operations=5340 2009-07-20 08:07:53 [MgmSrvr] INFO -- Node 3: Operations=0 2009-07-20 08:07:53 [MgmSrvr] INFO -- Node 3: Trans. Count = 0, Commit Count = 0, Read Count = 0, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 0, Concurrent Operations = 0, Abort Count = 0 Scans = 0 Range scans = 0 2009-07-20 08:07:54 [MgmSrvr] INFO -- Node 4: Trans. Count = 5297, Commit Count = 0, Read Count = 5297, Simple Read Count = 0, Write Count = 0, AttrInfo Count = 15891, Concurrent Operations = 0, Abort Count = 5297 Scans = 0 Range scans = 0 How to repeat: create table t1 (id int auto_increment primary key, name text) engine ndb; insert into t1(name) values ('1234567890'); insert into t1(name) select name from t1; .. mysqlslap --create-schema=test --query='select * from t1 where id=40' --iterations=10000 Suggested fix: Fix log output.