script commit to the database or rollback ?
http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-isolation.html
--
George-Cristian Bîrzan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
don't get a consistent reading.
executing it multiple times, I get multiple numbers. (and no, the table
is static already, no updates/deletes etc)
That's a guesstimate if using InnoDB. Works for MyISAM...
--
George-Cristian Bîrzan
--
MySQL General Mailing List
For list archives: http
I could work around the problem? The
table is very large, so solutions involving multiple copies are tricky
to implement.
Convert the table to InnoDB, which uses row level locking, as opposed to
MyISAM which uses table level locking.
--
George-Cristian Bîrzan
Network Engineer
then restored the data from a dump.
Well, the thing is... There is no dump. Or rather, what we have is
rather old... :-P
--
George-Cristian Bîrzan
Network Engineer
___
RCS RDS Constanta
Tel.: +40341.400.401 / +40341.400.402
Fax: +40341.400.450
http://www.rcs
to fix this?
(Well, I have the .MYD and .MYI from back when the table was MyISAM, but I
lack the .frm, and using an older one makes MySQL segfault...)
--
George-Cristian Bîrzan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
.
Hm, I did that, that's what I get after doing it.
--
George-Cristian Bîrzan
Network Engineer
___
RCS RDS Constanta
Tel.: +40341.400.401 / +40341.400.402
Fax: +40341.400.450
http://www.rcs-rds.ro
___
Privileged/Confidential
On Wednesday 18 October 2006 23:36, Dan Buettner wrote:
George-Cristian - is it possible that the *.frm files also got moved
about??
Nope. What I'm thinking is the logs got moved, server restarted, it created
new ones and...
--
George-Cristian Bîrzan
Network Engineer