Windows-like registry for Linux?
Drew Van Zandt
drew.vanzandt at gmail.com
Tue Feb 14 14:55:00 EST 2006
Random snapshot of a MySQL server I run, that I consider fairly
low-volume. An order of magnitude less than you're talking about, but
then this server does a lot of webserving of photos.
Query statistics: Since its startup, 28,439,172 queries have been sent
to the server.
Total ø per hour ø per minute ø per second
28,439,172 255,621.52 4,260.36 71.01
Googled benchmark of several DB's (same base app, may be app's fault.)
Time in seconds for lots of MySQL INSERTs:
MySQL
INSERT MyISAM
5000 3.006
10000 4.967
15000 7.474
20000 9.996
25000 12.524
30000 15.034
35000 17.515
40000 20.040
45000 21.586
50000 23.980
Time in msec (milleseconds) for a select of the above inserted data:
SELECT * FROM a;
MySQL
QUERY1 MyISAM
5000 45
10000 157
15000 110
20000 240
25000 288
30000 352
35000 378
40000 415
45000 479
50000 525
Unfortunately I didn't find a good randomly-grabbed benchmark for
selection of one record.
--Drew
More information about the gnhlug-discuss
mailing list