Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

mysql transaction per seconds

Posted on 2012-04-10
2
Medium Priority
?
485 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 2000 total points
ID: 37830870
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
ID: 37834797
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

916 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