Solved

mysql transaction per seconds

Posted on 2012-04-10
2
476 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 24

Accepted Solution

by:
johanntagle earned 500 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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

726 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