diff options
Diffstat (limited to 'isam/test_all.res')
| -rw-r--r-- | isam/test_all.res | 356 |
1 files changed, 356 insertions, 0 deletions
diff --git a/isam/test_all.res b/isam/test_all.res new file mode 100644 index 00000000000..756a05f869c --- /dev/null +++ b/isam/test_all.res @@ -0,0 +1,356 @@ +test2 -L -K -W -P +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 915 +Update records: 82 +Same-key-read: 6 +Delete records: 915 +Key cacheing used +Write cacheing used +Locking used +test2 -L -K -W -P -A +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 915 +Update records: 82 +Same-key-read: 6 +Delete records: 915 +Key cacheing used +Write cacheing used +Asyncron io with locking used +test2 -L -K -W -P -S -R1 -m500 +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 484 +Update records: 48 +Same-key-read: 3 +Delete records: 484 +Record pointer size: 1 +Key cacheing used +Write cacheing used +Locking used +test2 -L -K -R1 -m2000 ; Should give error 135 +- Creating isam-file +- Writing key:s +Error: 135 in write at record: 1122 +got error: 135 when using NISAM-database +test2 -L -K -P -S -R3 -m50 -b1000000 +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 50 +Update records: 5 +Same-key-read: 2 +Delete records: 50 +Record pointer size: 3 +Key cacheing used +Locking used +test2 -L -B +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 912 +Update records: 81 +Same-key-read: 5 +Delete records: 912 +Locking used +blobs used +test2 -L -K -W -P -m50 -l +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 50 +Update records: 5 +Same-key-read: 2 +Delete records: 50 +Key cacheing used +Write cacheing used +Locking used +Commands Used count Errors Recover errors +open 3 0 0 +write 150 0 0 +update 15 0 0 +delete 150 0 0 +close 3 0 0 +extra 18 0 0 +Total 339 0 0 +test2 -L -K -W -P -m50 -l -b100 +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 50 +Update records: 5 +Same-key-read: 2 +Delete records: 50 +Key cacheing used +Write cacheing used +Locking used +Commands Used count Errors Recover errors +open 4 0 0 +write 200 0 0 +update 20 0 0 +delete 200 0 0 +close 4 0 0 +extra 24 0 0 +Total 452 0 0 +time test2 +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 915 +Update records: 82 +Same-key-read: 6 +Delete records: 915 +4.77user 6.81system 0:15.07elapsed 76%CPU (0avgtext+0avgdata 0maxresident)k +0inputs+0outputs (0major+0minor)pagefaults 0swaps +time test2 -K +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 915 +Update records: 82 +Same-key-read: 6 +Delete records: 915 +Key cacheing used +6.09user 4.33system 0:11.66elapsed 89%CPU (0avgtext+0avgdata 0maxresident)k +0inputs+0outputs (0major+0minor)pagefaults 0swaps +time test2 -L +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 915 +Update records: 82 +Same-key-read: 6 +Delete records: 915 +Locking used +5.01user 5.20system 0:10.86elapsed 94%CPU (0avgtext+0avgdata 0maxresident)k +0inputs+0outputs (0major+0minor)pagefaults 0swaps +time test2 -L -K +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 915 +Update records: 82 +Same-key-read: 6 +Delete records: 915 +Key cacheing used +Locking used +5.63user 0.97system 0:07.85elapsed 84%CPU (0avgtext+0avgdata 0maxresident)k +0inputs+0outputs (0major+0minor)pagefaults 0swaps +time test2 -L -K -W +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 915 +Update records: 82 +Same-key-read: 6 +Delete records: 915 +Key cacheing used +Write cacheing used +Locking used +5.28user 1.32system 0:08.86elapsed 74%CPU (0avgtext+0avgdata 0maxresident)k +0inputs+0outputs (0major+0minor)pagefaults 0swaps +time test2 -L -K -W -S +- Creating isam-file +- Writing key:s +- Delete +- Update +- Same key: first - next -> last - prev -> first +- All keys: first - next -> last - prev -> first +- Test if: Read first - next - prev - prev - next == first +- Test if: Read last - prev - next - next - prev == last +- Test read key-part +- Read key (first) - next - delete - next -> last +- Read last of key - prev - delete - prev -> first +- Test if: Read rrnd - same +- Test ni_records_in_range +- ni_info +- ni_extra(CACHE) + ni_rrnd.... + ni_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 915 +Update records: 82 +Same-key-read: 6 +Delete records: 915 +Key cacheing used +Write cacheing used +Locking used +5.32user 0.62system 0:06.13elapsed 96%CPU (0avgtext+0avgdata 0maxresident)k +0inputs+0outputs (0major+0minor)pagefaults 0swaps |