Can anyone tell me if i can use "SET AUTOCOMMIT=0" command with mysql? This command is sent to mysql by metabase package. But i allways get the error "You have an error in your SQL syntax near 'AUTOCOMMIT=0' at line 1"
No, you can't, at least not in the current stable release. Transactions are available in the current Beta. Check on mysql.com for details.