Hi lists,

We are running database with mixed tables myisam and innodb. I know that innodb supports transactions. My server is running with default

transaction-isolation=REPEATABLE READ

Whenever our cron runs stats updation scripts. It locks whole table and make other sql statements which updates the table waits for long time. How can achieve isolation correctly make other statements proceed without waiting. And my script updates record by record not as bunch.

should I use transactional statements like "start transaction" and "commit" to achieve ?

thanks in advance.

Saravanan




__________________________________________________ __________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

Hi Saravanan,

Please check http://forums.mysql.com/read.php?97,18003,18003

-Raj.

-----Original Message-----
From: Saravanan [mailto:suzuki_babu@yahoo.com]
Sent: Friday, March 21, 2008 1:59 PM
To: mysql@lists.mysql.com
Subject: innodb transaction not works

Hi lists,

We are running database with mixed tables myisam and innodb. I know that
innodb supports transactions. My server is running with default

transaction-isolation=REPEATABLE READ

Whenever our cron runs stats updation scripts. It locks whole table and
make other sql statements which updates the table waits for long time.
How can achieve isolation correctly make other statements proceed
without waiting. And my script updates record by record not as bunch.

should I use transactional statements like "start transaction" and
"commit" to achieve ?

thanks in advance.

Saravanan





__________________________________________________ ______________________
____________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=raj@hccs.com