diff options
Diffstat (limited to 'isam/test_all.res')
| -rw-r--r-- | isam/test_all.res | 207 |
1 files changed, 109 insertions, 98 deletions
diff --git a/isam/test_all.res b/isam/test_all.res index 756a05f869c..f6280dd9f98 100644 --- a/isam/test_all.res +++ b/isam/test_all.res @@ -11,16 +11,16 @@ test2 -L -K -W -P - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 915 -Update records: 82 +Write records: 907 +Update records: 87 Same-key-read: 6 -Delete records: 915 +Delete records: 907 Key cacheing used Write cacheing used Locking used @@ -37,16 +37,16 @@ test2 -L -K -W -P -A - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 915 -Update records: 82 +Write records: 907 +Update records: 87 Same-key-read: 6 -Delete records: 915 +Delete records: 907 Key cacheing used Write cacheing used Asyncron io with locking used @@ -62,16 +62,16 @@ test2 -L -K -W -P -S -R1 -m500 - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 484 -Update records: 48 -Same-key-read: 3 -Delete records: 484 +Write records: 475 +Update records: 44 +Same-key-read: 4 +Delete records: 475 Record pointer size: 1 Key cacheing used Write cacheing used @@ -79,8 +79,31 @@ 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 +- 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 +- Read first - delete - next -> last +- Read last - delete - prev -> first +- Test if: Read rrnd - same +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) +- Removing keys + +Following test have been made: +Write records: 1647 +Update records: 125 +Same-key-read: 8 +Delete records: 1647 +Record pointer size: 1 +Key cacheing used +Locking used test2 -L -K -P -S -R3 -m50 -b1000000 - Creating isam-file - Writing key:s @@ -92,9 +115,9 @@ test2 -L -K -P -S -R3 -m50 -b1000000 - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: @@ -118,16 +141,16 @@ test2 -L -B - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 912 -Update records: 81 +Write records: 903 +Update records: 86 Same-key-read: 5 -Delete records: 912 +Delete records: 903 Locking used blobs used test2 -L -K -W -P -m50 -l @@ -141,9 +164,9 @@ test2 -L -K -W -P -m50 -l - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: @@ -155,13 +178,13 @@ 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 +open 14 0 0 +write 700 0 0 +update 70 0 0 +delete 700 0 0 +close 14 0 0 +extra 84 0 0 +Total 1582 0 0 test2 -L -K -W -P -m50 -l -b100 - Creating isam-file - Writing key:s @@ -173,9 +196,9 @@ test2 -L -K -W -P -m50 -l -b100 - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: @@ -187,13 +210,13 @@ 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 +open 15 0 0 +write 750 0 0 +update 75 0 0 +delete 750 0 0 +close 15 0 0 +extra 90 0 0 +Total 1695 0 0 time test2 - Creating isam-file - Writing key:s @@ -207,18 +230,16 @@ time test2 - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 915 -Update records: 82 +Write records: 907 +Update records: 87 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 +Delete records: 907 time test2 -K - Creating isam-file - Writing key:s @@ -232,19 +253,17 @@ time test2 -K - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 915 -Update records: 82 +Write records: 907 +Update records: 87 Same-key-read: 6 -Delete records: 915 +Delete records: 907 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 @@ -258,19 +277,17 @@ time test2 -L - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 915 -Update records: 82 +Write records: 907 +Update records: 87 Same-key-read: 6 -Delete records: 915 +Delete records: 907 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 @@ -284,20 +301,18 @@ time test2 -L -K - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 915 -Update records: 82 +Write records: 907 +Update records: 87 Same-key-read: 6 -Delete records: 915 +Delete records: 907 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 @@ -311,21 +326,19 @@ time test2 -L -K -W - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 915 -Update records: 82 +Write records: 907 +Update records: 87 Same-key-read: 6 -Delete records: 915 +Delete records: 907 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 @@ -339,18 +352,16 @@ time test2 -L -K -W -S - 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) +- Test nisam_records_in_range +- nisam_info +- nisam_extra(CACHE) + nisam_rrnd.... + nisam_extra(NO_CACHE) - Removing keys Following test have been made: -Write records: 915 -Update records: 82 +Write records: 907 +Update records: 87 Same-key-read: 6 -Delete records: 915 +Delete records: 907 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 |