Scott R. Every (scott@emji.net)
Mon, 07 Jun 1999 08:39:22 -0400
Make sure to delete the config.cache file after modifying the configure
script or it will not see the new values(or lack of) for LFS.
I installed mysql and the Mysqlperl modules and ran all the bench testing.
Everything completely correctly. Results were:
Benchmark DBD suite: 2.0b
Date of test: 1999-06-06 10:22:07
Running tests on: Linux 2.2.7 ppc
Arguments:
Comments:
Limits from:
Server version: MySQL 3.22.22
ATIS: Total time: 126 wallclock secs (27.96 usr 8.96 sys + 0.00 cusr
0.00 csy
s = 0.00 CPU)
alter-table: Total time: 1517 wallclock secs ( 1.95 usr 0.25 sys + 0.00
cusr
0.00 csys = 0.00 CPU)
big-tables: Total time: 111 wallclock secs (25.89 usr 16.52 sys + 0.00
cusr 0.
00 csys = 0.00 CPU)
connect: Total time: 290 wallclock secs (143.17 usr 35.03 sys + 0.00 cusr
0.00
csys = 0.00 CPU)
create: Total time: 21 wallclock secs ( 3.68 usr 0.58 sys + 0.00 cusr
0.00 cs
ys = 0.00 CPU)
insert: Total time: 7588 wallclock secs (883.31 usr 186.04 sys + 0.00 cusr
0.0
0 csys = 0.00 CPU)
select: Estimated total time: 2889 wallclock secs (173.73 usr 27.20 sys +
0.00
cusr 0.00 csys = 0.00 CPU)
wisconsin: Total time: 48 wallclock secs (11.27 usr 3.69 sys + 0.00 cusr
0.00
csys = 0.00 CPU)
All 8 test executed successfully
Tests with estimated time have a + at end of line
Totals per operation:
Operation seconds usr sys cpu tests
alter_table_add 833 1.21 0.11 0.00 992
alter_table_drop 655 0.52 0.08 0.00 496
connect 40 22.17 3.87 0.00 10000
connect+select 51 39.94 6.74 0.00 10000
count 183 0.28 0.04 0.00 100
count_on_key 1611 63.67 7.59 0.00 50100 +
create+drop 4 0.92 0.19 0.00 1000
create_index 14 0.00 0.00 0.00 8
create_key+drop 5 1.53 0.15 0.00 1000
create_table 10 0.70 0.09 0.00 1031
delete_big 2737 0.02 0.01 0.00 15
delete_key 3 0.13 0.03 0.00 500
drop_index 14 0.02 0.00 0.00 8
drop_table 1 0.26 0.06 0.00 1028
insert 386 96.77 27.50 0.00 350768
insert_duplicates 48 16.46 5.97 0.00 300000
insert_key 1765 40.48 9.75 0.00 100000
insert_many_fields 35 1.62 0.33 0.00 2000
min_max 99 0.15 0.00 0.00 60
min_max_on_key 544 83.87 10.56 0.00 73000
multiple_value_inser 20 5.65 0.18 0.00 100000
order_by 170 62.41 24.05 0.00 10
order_by_key 122 62.97 24.12 0.00 10
select 17 3.90 2.32 0.00 20000
select_big 254 114.71 41.24 0.00 10080
select_distinct 30 5.35 1.40 0.00 800
select_group 231 5.67 1.09 0.00 3811
select_join 47 13.13 5.25 0.00 200
select_key 512 249.74 25.60 0.00 200000
select_key_prefix 551 248.87 40.38 0.00 200000
select_many_fields 75 24.25 16.19 0.00 2000
select_range 916 48.12 12.27 0.00 25420 +
select_range_prefix 79 23.08 3.65 0.00 25010
select_simple 50 24.90 5.13 0.00 20000
select_simple_join 4 2.06 0.61 0.00 500
update_key 4 0.15 0.06 0.00 500
update_key_big 78 0.11 0.03 0.00 501
update_of_key 376 0.18 0.02 0.00 256
wisc_benchmark 13 4.70 1.52 0.00 114
TOTALS 12587 1270.67 278.18 0.00 1511318 ++
s
--On Sat, Jun 5, 1999 10:58 PM -0600 Darron Froese <darron@odi.ca> wrote:
> On Fri, 4 Jun 1999, Dan Burcaw wrote:
>
>> Hey everybody,
>>
>> I have a few things to update you on..
>>
>> 5) mySQL WORKS!
>> I'll have RPMS soon.. basically Large File Summit (LFS) support is
>> broke on Sparc and PPC (and possibily Alpha) Linux systems. With this
>> disabled, mySQL works great. What does LFS do? It lets you have
>> huge files... basically if you need mySQL tables larger then 2GB
>> then you'll need to wait for LFS to get supported :)
>
> If you don't want to wait for the RPM's to come out, you can just comment
> out the section of the configure script that queries for LFS support.
> (There's only one section and it's easy to find) I did that and mysql
> built and started up just fine.
>
> Now I have to actually work with it....but at least it starts. ;-)
>
> Darron
> darron@odi.ca
> <http://i.am/darron/>
> PGP Key: http://pgp.ai.mit.edu:11371/pks/lookup?op=get&search=0xAF31C682
>
>
-- Scott R. Every - mailto:scott@emji.net EMJ Internet - http://www.emji.net voice : 1-888-258-8959 fax : 1-919-363-4425
This archive was generated by hypermail 2.0b3 on Wed Jun 30 1999 - 11:30:07 MDT