It would be nice to have the possibility to exclude CREATE TEMPORARY TABLE statements from the log bin. Because such statements are really used not for updating a DB, but for constructing intermediary statements that eventually derive in a final INSERT/ UPDATE. I believe only this final statement should belong to the log bin.
I have set up a replicated system, and the large number of CREATE TEMPORARY TABLE performed on the Master DB is a needless drag on the system. Anybody can enlight me on this subject? Thanks Ignatius <MySQL> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php