Quote:
Originally Posted by hedbonker
[You must be logged in to view images. Log in or Register.]
But I have to admit that I always wondered how many transactions per second the DB for Everquest was enduring when you had 800 people online...
|
This is going to be a little skewed since it's been in reduced functionality for about 14 hours, but:
This MySQL server has been running for 2 days, 20 hours, 53 minutes and 45 seconds. It started up on Mar 09, 2011 at 04:07 PM
Traffic 1 ø per hour
Received 36 GiB 530 MiB
Sent 48 GiB 716 MiB
Total 84 GiB 1,246 MiB
Query statistics: Since its startup, 32,484,538 queries have been sent to the server.
Total ø per hour ø per minute ø per second
32 M 471.50 k 7.86 k 130.97
Query type ø per hour %
delete 15 M 218.383 k 46.32%
select 8,279 k 120.171 k 25.49%
replace 3,842 k 55.762 k 11.83%
admin commands 1,873 k 27.187 k 5.77%
update 1,208 k 17.537 k 3.72%
insert 1,054 k 15.304 k 3.25%
set option 106 k 1.532 k 0.32%
insert select 34 k 493.179 0.10%
call procedure 21 k 305.853 0.06%
show table status 5,002 72.602 0.02%
replace select 411 5.966 0.00%
optimize 137 1.989 0.00%