t; the first 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]
information_schema table,
> however, I 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 G
> created) and I 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: +40
ere is no way to do this in MySQL, does anyone have any
> innovative suggestions as to how 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 t
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
Netwo
ne yet myself).
> >
> > I'd shut down the server process, move everything into place,
> > double-check permissions on the files, and then start the mysqld
> > server process back up.
Hm, I did that, that's what I get after doing it.
--
George-C
s, is there a way 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:ht
