Re: Migration 4.0 to 4.1 performance problem
Is your query cache on? I'm trying to account for all the question/second. DMS + Com_ = 93 of 343. Query cache hits would add some more (because qc hits are not counted as Com_select hits). The 37 connections/second adds in too, but that's still only like 130 questions/second. If your qc is on, it should be doing 213 hits/s. If it's not, I'm curious were all this activity is coming from. "mysqlreport -qc" will show the qc stuff if qc is on.
The value of Questions does add up perfectly from what's available via SHOW STATUS, as is discussed in
http://hackmysql.com/com_quit . By extension, it seems the questions/second should too.
Subject
Views
Written By
Posted
2221
September 12, 2005 04:08PM
1519
September 12, 2005 05:20PM
1322
September 13, 2005 12:53AM
Re: Migration 4.0 to 4.1 performance problem
1701
September 13, 2005 11:17AM
1557
September 14, 2005 10:22AM
1573
September 15, 2005 03:49PM
2060
October 14, 2005 07:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.