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
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
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 aim.prab...@gmail.com 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
Hi everyone
I have a PHP script that will run every minute and do a lot of SELECT
and UPDATE statments
All my tables are InnoDB and I'm using PHP 5 and POD class (
http://php.net/pod ) to connect to mysql, in my script I start the
transaction (using method beginTransaction() ) in the beginning
On Tue, Oct 31, 2006 at 08:58:04PM +0300, Ahmad Al-Twaijiry wrote:
is it possible that one of my script process will select the same data
that the other process is selecting or updating ? or if I run a second
process of my script it will not be able to read/write anything until
the first
Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports
transaction.
Thanks.
Andrew
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message -
From: Andrew Chan [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, April 17, 2002 8:57 PM
Subject: transaction with MySQL
Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports
transaction.
Thanks.
Andrew
Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports
transaction.
If I remember correctly, BDB has transaction support and was released during
3.23 development.
Sincerely,
Craig Vincent
-
Before posting
* Andrew Chan
Hi there, correct me if I am wrong. Only verion 4.x of MySQL supports
transaction.
You are wrong. :)
3.23.*-max binaries support BDB and InnoDB tables, both support
transactions.
URL: http://www.mysql.com/doc/B/D/BDB.html
URL: http://www.mysql.com/doc/I/n/InnoDB.html
Hi!
You can change the MySQL server program from
mysqld-nt.exe or any other mysqld*.exe to
mysqld-max.exe or mysqld-max-nt.exe (on NT and 2000)
without changing your MyISAM tables in any way.
The MyISAM part in these versions is identical.
To use InnoDB tables you have to add startup
On Wed, Jul 18, 2001 at 02:06:03PM -0700, Michael Tam wrote:
Hi all,
I am new using MySQL. I found out that the default table type used
in the binary isn't support transaction and would like to make
MySQL uses another table type which supports transaction. The
following are my
-max takes over??
Thank you very much.
Regards,
Michael
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Michael Tam [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Saturday, July 21, 2001 2:57 AM
Subject: Re: Transaction for MySQL
On Wed, Jul 18, 2001 at 02:06
On Sat, Jul 21, 2001 at 03:46:58AM -0700, Michael Tam wrote:
Hi Jeremy,
In question 2), what I meant is not uninstall MySql from Windows 2000
but the service of it by calling mysqld-nt --remove. That will take off
the service of the mysql-nt from being the default mysql daemon and
- Original Message -
From: Michael Tam [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 2:06 PM
Subject: Transaction for MySQL
Hi all,
I am new using MySQL. I found out that the default table type used in
the binary isn't support transaction and would like
Would someone help me out with these questions?
I know these may be something obvious/ in the manual .. etc but I
would
like to have someone showing me if I am on the right track and maybe
share
some of these in greater detail. Greatly appreciated.
Since the experts are too busy,
MT 1) which one should I use InnoDB or BDB? what kind of advantages
MT given by each type?
I'm not expert but AFAIK BDB databases doesn't work well (i.e. fast)
if they don't fit fully in RAM. Another important thing: InnoDB
provides row-level locking while BDB only page-level locking. Thus it
Hi all,
I am new using MySQL. I found out that the default table type used in the binary
isn't support transaction and would like to make MySQL uses another table type which
supports transaction. The following are my questions regarding the issue:
1) which one should I use InnoDB or
17 matches
Mail list logo