performance - max mysql queries per minute -
how many queries slave can handle per minute?
in case, used show status '%questions%' , found after interval of 1 minute, around 5,000 queries executed.
is normal behavior or can improved?
there many inter-related factors influence answer questions. include, not limited to
- the distribution of queries slave
- the timing , types of updates coming in via replication
- your dataset
- your hardware
- your mysql version , engines being employed
having said that, stat of "5000 questions per minute" not sufficient raise flags in books.
it might more worthwhile determine if application operating within acceptable range; e.g. application's average response time or worst case response time.
it's worth noting questions counter includes more selects. can't find comprehensive list or reference, but, examples, believe "updates, deletes, show status, use $db, show tables" increment questions status variable.
Comments
Post a Comment