Fwd: Question relating to transactions on innodb tables.

Hi All Just a quick question relating to the use of transactions on innodb tables. We are doing some archiving on some innodb tables, however there seems to be some issues somewhere in the process with data not being updated accordingly. We would like to make use

Fwd: Question

---BeginMessage--- Long back I had set it and was working that time,For a long time I wasn't working on same, at this point how to check the same, I don't remember, can you guide , please. How do I check if mysql, php apache are configured, also any GUI graphical user interface for Apache

Fwd: Question: What sort of lock occurs during Optimization?

All, I've got a quick question - In section 7.11 of the manual on Optimize_Table it states that the table is "locked" during optimization. It does not state however, if this is a read-lock, a write-lock or both. Can you clarify? Thanks Since I'm not a member of this list, could any responses

Re: Fwd: Question: What sort of lock occurs during Optimization?

In the last episode (Mar 15), Mark Dombeck, Ph.D. said: All, I've got a quick question - In section 7.11 of the manual on Optimize_Table it states that the table is "locked" during optimization. It does not state however, if this is a read-lock, a write-lock or both. Can you clarify?