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/[EMAIL PROTECTED]
