how to find no.of transaction in mysql

--0016361e890a9c199f048614e6b0
Content-Type: text/plain; charset=ISO-8859-1

Hi ,

Is it possible to find the no.of transactions happened on the database for
the specified duration of time ? it could be for past 2/3 days.

Thanks
Anand

--0016361e890a9c199f048614e6b0--

Re: how to find no.of transaction in mysql

--0016e64c051e97575f04861563b1
Content-Type: text/plain; charset=ISO-8859-1

Hi,
I think you can get only no. of transactions happned on the database since
it was started.

By using command "show status" ; variable "Questions" will give value of
no. of transactions happened on the database since database was started.

But there is way u can use, as I used to calculate query executed per
second.

> time=10
> orig=`mysql -e "show status" | awk '{if ($1 == "Questions") print $2}'`
> sleep $time
> last=`mysql -e "show status" | awk '{if ($1 == "Questions") print $2}'`
> diff=`expr $last - $orig`
> avg=`expr $diff / $time`
> echo "$avg"
>

Thanks,

On Sat, May 8, 2010 at 6:40 PM, Anand wrote:

> Hi ,
>
> Is it possible to find the no.of transactions happened on the database for
> the specified duration of time ? it could be for past 2/3 days.
>
> Thanks
> Anand
>



--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--0016e64c051e97575f04861563b1--

Re: how to find no.of transaction in mysql

--000feaed643014932704861569af
Content-Type: text/plain; charset=ISO-8859-1

or you can use some tools, there is tons of third tools you can use.

On Sat, May 8, 2010 at 7:15 PM, Prabhat Kumar wrote:

> Hi,
> I think you can get only no. of transactions happned on the database since
> it was started.
>
> By using command "show status" ; variable "Questions" will give value of
> no. of transactions happened on the database since database was started.
>
> But there is way u can use, as I used to calculate query executed per
> second.
>
>> time=10
>> orig=`mysql -e "show status" | awk '{if ($1 == "Questions") print $2}'`
>> sleep $time
>> last=`mysql -e "show status" | awk '{if ($1 == "Questions") print $2}'`
>> diff=`expr $last - $orig`
>> avg=`expr $diff / $time`
>> echo "$avg"
>>
>
> Thanks,
>
> On Sat, May 8, 2010 at 6:40 PM, Anand wrote:
>
>> Hi ,
>>
>> Is it possible to find the no.of transactions happened on the database for
>> the specified duration of time ? it could be for past 2/3 days.
>>
>> Thanks
>> Anand
>>
>
>
>
> --
> Best Regards,
>
> Prabhat Kumar
> MySQL DBA
> Datavail-India Mumbai
> Mobile : 91-9987681929
> www.datavail.com
>
> My Blog: http://adminlinux.blogspot.com
> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>



--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--000feaed643014932704861569af--