OK, first off, this website is kinda infuriating. Why can't I click on the message thread on the web, and reply that way? I'm not even sure this message will reach it's recipients. </rant>.
Anyhow, I was just reading on http://www.mysql.com/doc/en/Server_system_variables.html, there's a variable called 'init_connect', that's automatically done for every client that connects (not sure if this is new or not). So you can do stuff like: SET GLOBAL init_connect="SET AUTOCOMMIT=0";. Hope that helps! -e- "Jamie Murray" <[EMAIL PROTECTED]> wrote: > Hi Guys, > How can I disable autocommit in the database. Can this only be done per session as > opposed to having it done globally at the database level. You can turn off autocommit only per session. > Last where can I get a complete list and explanation of the buffer/memory areas of > mysql. > I checked the manual and it was brief at best. Did you look at ? http://www.mysql.com/doc/en/SHOW_VARIABLES.html http://www.mysql.com/doc/en/InnoDB_start.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com Thread -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
