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