On Sat, May 22, 2004 at 11:25:54PM -0500, mos wrote:
> >
> >Once I wiped this and tried Linux (both gentoo, with their
> >patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which
> >had just been released by the time I installed) this figure jumped to
> >35,000 queries per second.
>
> First of all congratulations on getting queries that fast. :)
>
> I have a few questions if you have the time:
>
> 1) Are you using MyISAM tables?
The test tables super-smack uses are in the test database and are
indeed MyISAM.
> 2) How large is the table's row size? And the result size returned?
Here's the create definition from super-smack (select-key.smack):
CREATE TABLE http_auth (
username char(25) not null primary key,
pass char(25),
uid integer not null,
gid integer not null
)
If integers are 4 bytes I make that 58 bytes per row?
And this is the query:
SELECT * FROM http_auth WHERE username = '$word'
So it fetches the entire row, 58 bytes.
> 3) Are you sorting the results?
No.
> 4) What percentage are selects and updates?
This particular test is 100% selects. super-smack also has an
update-select.smack which does 1:1 updates and selects.
> 5) On average, how many rows are being returned for the query?
1 - the username is a unique key.
--
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
