QPs rate and com_insert rate for a busy server(discussion)
Posted on 2012-04-12
i am just trying to understand.. how you measure a busy server..( i m not asking for any explanation)
if I measure our server.
com_insert , I see in pick we get 90 to 100 insert/s
and Qps is : 300-320/s
till now we not having any performance problem..
but what i want know :
if any of you use a heavy mysql server( heavy load)
what is your insert rate (IOPS) ?? and Qps rate ??
if i use script, i can insert 5000 to 8000 insert/s
so that not not a problem..
i just want to compare our loads with other people's heavy mysql server load
if you have heavy mysql server.. can you tell me
in pick time... how busy is your server ??
(note : i know the performace depends on your query structure.. table structure so it will never be same for eveyr one)
i just want to get a general idea .thats it ...
thanks for sharing your statictics .