Re: limitation on request per second

[Rick James]

MyISAM or InnoDB?
IDE or RAID?
How complicate is the query?
If InnoDB, what are the settings? And autocommit?
One table or many?
Settings for key_buffer_size and innodb_buffer_pool_size?
Any swapping going on?

InnoDB, with certain settings, will sync writes to disk before returning to the user. If you don't have much write cache (as you would with RAID w/BBWC), you won't be able to perform queries faster than one per disk hit.

With MyISAM, if you modify the smae table on each query, you are locking the table, thereby allowing only one at a time. Still, this should not run as slow as 33ms.

If there is swapping, things are not tuned well. Performance suffers.

One can write a query that will take an hour to run, and meanwhile lock the table so that it can do only 1 req/hour. (This leads to the question of how complicated your queries are.)

You should be able to get hundreds, maybe thousands of _simple_ queries per second.