One of the servers I maintain has 18 qps average and the load is 0.62,0.54,0.63 (1min, 5min, 15min) Beside the database and radius, that server is used for hundred other things and it works perfectly (1GB of RAM, dual core CPU) The point is not how much queries per second do you have. You can have a 2 qps who can overload the server.. On 06/07/2011 05:54 AM, OzSpots - Carl Sawers wrote:
Thanks for the advice everyone! I have removed scripts which caused the VERY slow queries and have now had the slow query log on for a few days. It is still showing loads of entry's but http access performance is not noticeably slow(on occasion there is a small delay). The slow queries appear to be mostly coming from radacct and radcheck when a wireless user is trying to authenticate...
Phpadmin states that there have been 300000 queries in only 25 hours which is 3 per second. (there is 4 database's including an analytics database also which will be included in this) 20% of the queries are from the 'change db' query.