re: question about locks with optimize table
Michael Widenius <[email protected]>
| Newsgroups | gmane.comp.db.mysql.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi! >>>>> "John" == John Esmet <[email protected]> writes: John> Hi Guys, John> I'm looking to modify mysql to allow a storage engine to run optimize John> table and have other cilents be able to select/insert/etc. where is a John> good place to start looking for modifications? I noticed sql_table.cc John> calls mysql_admin_table for optimize statements, which i assume does John> the table locking. Is this for existing or a new storage engine ? For a new storage engine, this should be done totally inside the engine and thus should only affect storage engine code. For existing engines, this is not that trivial as optimize table works by copying data to another table and then swapping files. This can't easily be done as long as other insert/selects are running. Regards, Monty Founder of MySQL and MariaDB -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/internals