Paul J Stevens пишет:
Artem Bokhan wrote:
[pid 32230] 15:51:01.121453 write(15, "* 403 FETCH (FLAGS () UID
5380)\r\n", 33) = 33 <0.000630>
[pid 32230] 15:51:01.122191 read(12, "Q", 1) = 1 <0.000014>
I see what you mean. The latest commit should improve this by draining
the self-pipe completely in 128 byte reads, rather than single byte
reads. Maybe bigger reads would be more efficient. Tests will tell.
Database layer also have too many syscalls..
[pid 12991] 18:42:09.223712 read(6,
"\f\0\0\1\0\6\0\0\0\t\0\0\0\0\...@\0\0\2\3def\6dbmail\3msg\17dbmail_messages\tseen_flag\tseen_flag\f?\0\1\0\0\0\1\t@\0\0\0H\0\0\3\3def\6dbmail\3msg\17dbmail_messages\ranswered_flag\ranswered_flag\f?\0\1\0\0\0\1\1\0\0\0\0F\0\0\4\3def\6dbmail\3msg\17dbmail_messages\fdeleted_flag\fdeleted_flag\f?\0\1\0\0\0\1\1\0\0\0\0F\0\0\5\3def\6dbmail\3msg\17dbmail_messages\fflagged_flag\fflagged_flag\f?\0\1\0\0\0\1\1\0\0\0\0B\0\0\6\3def\6dbmail\3msg\17dbmail_messages\ndraft_flag\ndraft_flag\f?\0\1\0\0\0\1\1\0\0\0\0D\0\0\7\3def\6dbmail\3msg\17dbmail_messages\vrecent_flag\vrecent_flag\f?\0\1\0\0\0\1\1\0\0\0\0L\0\0\10\3def\0\0\0006DATE_FORMAT(internal_date,
GET_FORMAT(DATETIME,\'ISO\'))\0\f?\0\252\0\0\0\375\200\0\0\0\0>\0\0\t\3def\6dbmail\2pm\22dbmail_physmessage\7rfcsize\7rfcsize\f?\0\25\0\0\0\10\1\0\0\0\0F\0\0\n\3def\6dbmail\3msg\17dbmail_messages\fmessage_idnr\fmessage_idnr\f?\0\25\0\0\0\10\3B\0\0\0\5\0\0\v\376\0\0\2\0",
16384) = 679 <0.000097>
[pid 12991] 18:42:09.224950 poll([{fd=6, events=POLLIN|POLLPRI}], 1, 0)
= 0 <0.000014>
[pid 12991] 18:42:09.225033 write(6, "\n\0\0\0\27\6\0\0\0\1\1\0\0\0",
14) = 14 <0.000017>
[pid 12991] 18:42:09.225128 read(6,
"\1\0\0\...@\0\0\2\3def\6dbmail\3msg\17dbmail_messages\tseen_flag\tseen_flag\f?\0\1\0\0\0\1\1\0\0\0\0h\0\0\3\3def\6dbmail\3msg\17dbmail_messages\ranswered_flag\ranswered_flag\f?\0\1\0\0\0\1\1\0\0\0\0f\0\0\4\3def\6dbmail\3msg\17dbmail_messages\fdeleted_flag\fdeleted_flag\f?\0\1\0\0\0\1\1\0\0\0\0f\0\0\5\3def\6dbmail\3msg\17dbmail_messages\fflagged_flag\fflagged_flag\f?\0\1\0\0\0\1\1\0\0\0\0b\0\0\6\3def\6dbmail\3msg\17dbmail_messages\ndraft_flag\ndraft_flag\f?\0\1\0\0\0\1\1\0\0\0\0d\0\0\7\3def\6dbmail\3msg\17dbmail_messages\vrecent_flag\vrecent_flag\f?\0\1\0\0\0\1\1\0\0\0\0\202\0\0\10\3def\0\0\0006date_format(internal_date,
GET_FORMAT(DATETIME,\'ISO\'))6DATE_FORMAT(internal_date,
GET_FORMAT(DATETIME,\'ISO\'))\f?\0\252\0\0\0\375\200\0\0\0\0>\0\0\t\3def\6dbmail\2pm\22dbmail_physmessage\7rfcsize\7rfcsize\f?\0\25\0\0\0\10\1\0\0\0\0F\0\0\n\3def\6dbmail\3msg\17dbmail_messages\fmessage_idnr\fmessage_idnr\f?\0\25\0\0\0\10\1\0\0\0\0\5\0\0\v\376\0\0B\0",
16384) = 722 <0.011414>
[pid 12991] 18:42:09.237157 gettimeofday({1235738529, 237206}, NULL) = 0
<0.000017>
[pid 12991] 18:42:09.237266 poll([{fd=6, events=POLLIN|POLLPRI}], 1, 0)
= 0 <0.000014>
[pid 12991] 18:42:09.237351 write(6, "\t\0\0\0\34\6\0\0\0\1\0\0\0", 13)
= 13 <0.000019>
[pid 12991] 18:42:09.237460 read(6,
"-\0\0\1\0\0\0\0\0\0\0\0\0\0232009-02-24
17:11:47\375\0\0\0\0\0\0\0\2\0\0\0\0\0\0\0\5\0\0\2\376\0\0B\0", 16384) =
58 <0.000082>
[pid 12991] 18:42:09.237731 poll([{fd=6, events=POLLIN|POLLPRI}], 1, 0)
= 0 <0.000014>
[pid 12991] 18:42:09.237818 write(6, "\t\0\0\0\34\6\0\0\0\1\0\0\0", 13)
= 13 <0.000018>
[pid 12991] 18:42:09.237917 read(6,
"-\0\0\1\0\0\0\0\0\0\0\0\0\0232009-02-24
17:11:51\375\0\0\0\0\0\0\0\4\0\0\0\0\0\0\0\5\0\0\2\376\0\0B\0", 16384) =
58 <0.000032>
[pid 12991] 18:42:09.238079 poll([{fd=6, events=POLLIN|POLLPRI}], 1, 0)
= 0 <0.000015>
[pid 12991] 18:42:09.238164 write(6, "\t\0\0\0\34\6\0\0\0\1\0\0\0", 13)
= 13 <0.000018>
[pid 12991] 18:42:09.238279 read(6,
"-\0\0\1\0\0\0\0\0\0\0\0\0\0232009-02-24
17:11:52\375\0\0\0\0\0\0\0\6\0\0\0\0\0\0\0\5\0\0\2\376\0\0B\0", 16384) =
58 <0.000019>
[pid 12991] 18:42:09.238420 poll([{fd=6, events=POLLIN|POLLPRI}], 1, 0)
= 0 <0.000085>
[pid 12991] 18:42:09.238592 write(6, "\t\0\0\0\34\6\0\0\0\1\0\0\0", 13)
= 13 <0.000018>
[pid 12991] 18:42:09.238747 read(6,
"-\0\0\1\0\0\0\0\0\0\0\0\0\0232009-02-24
17:12:28\271\0\0\0\0\0\0\0\10\0\0\0\0\0\0\0\5\0\0\2\376\0\0B\0", 16384)
= 58 <0.000019>
[pid 12991] 18:42:09.238891 poll([{fd=6, events=POLLIN|POLLPRI}], 1, 0)
= 0 <0.000030>
[pid 12991] 18:42:09.238992 write(6, "\t\0\0\0\34\6\0\0\0\1\0\0\0", 13)
= 13 <0.000016>
[pid 12991] 18:42:09.239088 read(6,
"-\0\0\1\0\0\0\0\0\0\0\0\0\0232009-02-24
17:12:50cb\17\0\0\0\0\0\n\0\0\0\0\0\0\0\5\0\0\2\376\0\0B\0", 16384) = 58
<0.000074>
[pid 12991] 18:42:09.239285 poll([{fd=6, events=POLLIN|POLLPRI}], 1, 0)
= 0 <0.000014>
[pid 12991] 18:42:09.239370 write(6, "\t\0\0\0\34\6\0\0\0\1\0\0\0", 13)
= 13 <0.000160>
[pid 12991] 18:42:09.239624 read(6,
"-\0\0\1\0\0\0\0\0\0\0\0\0\0232009-02-24
17:13:11!b\17\0\0\0\0\0\f\0\0\0\0\0\0\0\5\0\0\2\376\0\0B\0", 16384) = 58
<0.000052>
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev
