296186 – dev-db/mtop-0.6.6 does not show correct QPS

Bug 296186 - dev-db/mtop-0.6.6 does not show correct QPS

Summary: dev-db/mtop-0.6.6 does not show correct QPS

Status:	RESOLVED FIXED

Alias:	None

Product:	Gentoo Linux
Classification:	Unclassified
Component:	Current packages (show other bugs)
Hardware:	All Linux

Importance:	High normal (vote)
Assignee:	Gentoo Linux MySQL bugs team

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2009-12-08 14:23 UTC by Cyril Pascal
Modified:	2010-01-31 09:10 UTC (History)
CC List:	0 users

See Also:
Package list:
Runtime testing required:	---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Cyril Pascal 2009-12-08 14:23:29 UTC

With recent version of mysql (for instance dev-db/mysql-5.0.84-r1), mtop does not show correct number of queries per second (QPS).

It seems that mtop uses "show status" to count number of queries, which counts the number of queries in the connection. To have the global number of queries, I use "show global status".

I have build a small patch that fixes that problem :
http://cyril.me/ebuild/dev-db/mtop/

Reproducible: Always

Steps to Reproduce:
1. Install a recent version of mysql (like mysql-5.0.84-r1)
2. Install mtop-0.6.6
3. Run mtop.
Actual Results:  
QPS will be between 0 and 2.


Expected Results:  
QPS should represent the number of queries per second for the mysql server, not the number of queries per second for the current mysql connection.

Comment 1 Robin Johnson archtester

2010-01-31 07:51:23 UTC

InCVS.

Comment 2 Cyril Pascal 2010-01-31 09:10:18 UTC

Thanks for solving the problem. I did not know about mytop, I'll try it.