List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:April 6 1999 4:34am
Subject:queries/sec?
View as plain text  
I tried to execute the bencmarks for mySQL, but they don't seem to work for me?

[root=ttyp1]# ./run-all-tests --server=mysql --cmp=mysql,pg,solid --log
Warning: Can't execute ATIS.  Check the file
'output/ATIS-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid'
Warning: Can't execute alter-table.  Check the file
'output/alter-table-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid'
Warning: Can't execute big-tables.  Check the file
'output/big-tables-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid'
Warning: Can't execute connect.  Check the file
'output/connect-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid'
Warning: Can't execute create.  Check the file
'output/create-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid'
Warning: Can't execute insert.  Check the file
'output/insert-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid'
Warning: Can't execute select.  Check the file
'output/select-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid'
Warning: Can't execute wisconsin.  Check the file
'output/wisconsin-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid'
Test finished. You can find the result in:
output/RUN-mysql-Linux_2.0.36_i686-cmp-mysql,pg,solid

I'm really interested in knowing how many queries per second I can perform?

what are the factors involoved?
I have a PII-333 w/64MB RAM and SCSI drive.
Let's say the database will have 30 VARCHAR fields and I'll be searching on an
INDEX with no other joins...

Is there a way for me to calculate this or a chart somewhere?
It would be great if your benchmark suite had tests like this in it...

Perhaps a way that I could create a test database using the same format and such
as the real database and just have some program pound on it to give me some
"benchmark" of what I could expect...

Also, thinking long term how do I load-ballance across multiple machines... I
don't need anything elaborate in the way of a description right now, but some
reassurance that it can be done.  I'm talking concievable 100 Million records
being accessed per DAY! (can mySQL handle that kind of load)?

oh yeah, it would be helpful if you had a "real world" users page -- where they
describe their computer and the databases and what benchmarks they're getting,
etc... so other's would know what to expect.

ÐÆ5IÐ         What is http://TheMatrix.com


Thread
queries/sec?Daevid Vincent6 Apr
  • Re: queries/sec?Daevid Vincent6 Apr
    • Re: queries/sec?Michael Widenius6 Apr
    • Re: queries/sec?Fernando Ulisses dos Santos6 Apr
  • Re: sql-bench problemsDaevid Vincent6 Apr