Solved

mysql transaction per seconds

Posted on 2012-04-10
2
468 Views
Last Modified: 2012-04-25
hi
i belived
SHOW GLOBAL STATUS LIKE ‘com_insert’;

will tell you , how much insert happening in the db

but can you pleaes tell me
whats the theory behind finding out

how much transaction per second my server handling ??

we use innodb engine.
thanks
0
Comment
Question by:fosiul01
2 Comments
 
LVL 24

Accepted Solution

by:
johanntagle earned 500 total points
Comment Utility
If by transaction you mean group of commands, the last one being a commit, there's a com_commit counter.

But if you want to track each select, insert, update, delete, prepared statement, etc, you have to look at a lot of counters.  For example, depending on whether it gets the results from the query cache or a direct read from the tables, either the qcache_hits or the com_select counter gets incremented.  http://dev.mysql.com/doc/refman/5.1/en/server-status-variables.html#statvar_Com_xxx would be a good starting point.

Another way I can think of is to turn on the slow query log and set long_query_time = 0.  This will log all queries, which then you will parse using a tool like mysql_slow_log_parser (http://www.retards.org/projects/mysql/).  The summary report there can give how many times each query was run, which you can sum up to give you the total number of SQL's run during the time you were logging all commands.  WARNING: the logfile can get huge fast, and you need to run the parser on a machine with huge memory.
0
 
LVL 29

Author Comment

by:fosiul01
Comment Utility
hi thanks for reply ..

when you login to mysql , then press \s

it give you a Queries per second

examaple , mine is 300/s

is not it QPS ?

or that means diffferent thing .
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now