On Wed, Dec 5, 2012 at 9:33 AM, Keith Chew <keith.c...@gmail.com> wrote: > Any other ideas for me to trace this at a lower level would be greatly > appreciated. I think I will need to get deeper into linux's block > layer stuff, so perhaps this is not the correct place to ask the > question, but I thought I'd start here.
I have done a bit more comparison on the IO pattern when running MySQL and sqlite, using vmstat (results below). I can observe that sqlite causes a bit more bytes to be written to the disk, but not by much. Wait times are also reasonable. I wonder what could be causing sqlite to hang so long? Will try to remove all indexes to see if that narrows things down. Sqlite: 2 0 0 184148 51564 446224 0 0 0 28 290 602 0 0 86 14 0 1 0 0 184148 51572 446232 0 0 0 28 293 1041 26 7 51 16 0 0 0 0 184148 51580 446232 0 0 0 52 300 926 0 0 84 16 0 1 0 0 184024 51588 446232 0 0 0 28 293 1071 24 9 53 14 0 1 0 0 184024 51596 446228 0 0 0 36 287 802 0 1 83 16 0 2 0 0 183588 51604 446236 0 0 0 28 291 1004 10 4 45 41 0 0 0 0 184024 51612 446236 0 0 0 56 293 1003 16 3 65 17 0 0 0 0 184024 51620 446240 0 0 0 28 293 854 0 0 87 13 0 0 0 0 184024 51628 446244 0 0 0 40 292 1060 28 6 49 18 0 0 0 0 184024 51636 446240 0 0 0 40 293 598 0 1 82 17 0 1 0 0 184024 51644 446244 0 0 0 36 290 899 24 7 54 15 0 0 0 0 184024 51652 446248 0 0 0 36 292 591 0 1 90 9 0 1 0 0 183580 51660 446248 0 0 0 40 290 758 16 3 67 14 0 0 0 0 183900 51668 446248 0 0 0 36 291 730 11 3 71 16 0 1 0 0 183900 51676 446248 0 0 0 28 292 601 0 1 59 40 0 0 0 0 183900 51684 446252 0 0 0 36 292 894 25 8 67 0 0 1 0 0 183900 51692 446252 0 0 0 64 295 590 0 0 91 9 0 0 0 0 183900 51700 446256 0 0 0 28 289 860 25 7 55 13 0 Mysql: 2 0 0 192408 48120 448308 0 0 0 48 260 1076 30 5 62 3 0 0 0 0 195300 48128 450316 0 0 0 32 263 1027 15 4 71 10 0 2 1 0 194708 48128 450276 0 0 0 56 257 768 15 4 81 0 0 2 0 0 199004 48136 446400 0 0 0 52 263 722 10 2 85 3 0 1 0 0 197268 48144 448428 0 0 0 40 258 636 7 0 81 12 0 0 0 0 196896 48152 448456 0 0 0 36 260 916 22 9 59 10 0 1 0 0 198880 48152 446408 0 0 0 0 253 496 0 0 100 0 0 1 0 0 199012 48160 446264 0 0 0 24 258 765 28 9 63 0 0 1 0 0 199012 48168 446264 0 0 0 32 260 382 1 0 85 14 0 2 0 0 198868 48168 446264 0 0 0 0 254 701 23 8 69 0 0 0 0 0 199012 48176 446292 0 0 0 32 259 434 6 0 82 12 0 3 0 0 198832 48184 446280 0 0 0 32 259 445 0 2 86 12 0 1 0 0 199012 48184 446264 0 0 0 0 253 656 22 8 70 0 0 1 0 0 199012 48192 446264 0 0 0 32 259 412 6 1 79 14 0 1 0 0 198888 48200 446256 0 0 0 56 261 702 24 6 53 17 0 0 0 0 198888 48200 446264 0 0 0 56 266 376 0 1 96 3 0 1 0 0 198864 48208 446264 0 0 0 24 257 757 31 5 53 11 0 0 0 0 198888 48216 446264 0 0 0 32 259 382 1 1 85 13 0 2 0 0 198888 48216 446264 0 0 0 0 253 368 0 0 100 0 0 0 0 0 198888 48224 446268 0 0 0 36 258 430 6 1 73 20 0 1 0 0 197568 48232 444688 0 0 0 24 267 687 8 3 80 9 0 Regards Keith _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
