Sponsored Content
Top Forums Web Development [Solved] Disable mySQL autocommit Post 302532035 by radoulov on Sunday 19th of June 2011 12:10:34 PM
Old 06-19-2011
Hi Scott,
which storage engine are you using (show create table <table_name>;)?
Bear in mind that MySQL 5.0.x default's storage engine is MyISAM and that storage engine doesn't support transactions (you cannot rollback a statement).

You should take a look at InnoDB if you need transactions (start transaction; do your work; commit or rollback).

InnoDB is the default storage engine in 5.5 (I'm not sure when exactly it became the default storage engine).
This User Gave Thanks to radoulov For This Post:
 

7 More Discussions You Might Find Interesting

1. AIX

how to set AUTOCOMMIT option in AIX

Hi, Can anybody tell,how to set the auto commit option in AIX,i have tried with environmental variables option like 'export db2option=-c +a'. But its not working in my environment. is there any other option? (1 Reply)
Discussion started by: DB2AIX
1 Replies

2. Shell Programming and Scripting

How to disable Enable/Disable Tab Key

Hi All, I have bash script, so what is sintax script in bash for Enable and Disable Tab Key. Thanks for your help.:( Thanks, Rico (1 Reply)
Discussion started by: carnegiex
1 Replies

3. UNIX for Dummies Questions & Answers

[SOLVED] mysql.sock is missing..

mysql.sock file is missing in /opt/lampp/etc/ is there any backup file available in unix... since without that file .. project is not opening.. reply me as soon as possible ... (19 Replies)
Discussion started by: senkerth
19 Replies

4. UNIX and Linux Applications

command to check value of autocommit and isolation level

Hi, Pls let me know command to get following: 1. how to check current value of autocommit 2. how to check current value of isolation level I am using mysql-5.0.26 on unix -Thanks (2 Replies)
Discussion started by: newbielgn
2 Replies

5. Red Hat

SSL/TLS renegotiation DoS -how to disable? Is it advisable to disable?

Hi all Expertise, I have following issue to solve, SSL / TLS Renegotiation DoS (low) 222.225.12.13 Ease of Exploitation Moderate Port 443/tcp Family Miscellaneous Following is the problem description:------------------ Description The remote service encrypts traffic using TLS / SSL and... (2 Replies)
Discussion started by: manalisharmabe
2 Replies

6. Emergency UNIX and Linux Support

[Solved] EMERGENCY - can I revert 1 hour of mysql changes

I know, its stupid.. MYSQL on CENTOS 5 using WHM Imported a lot of users/posts from old forum to new forum, but my backup was lost. Can I somehow simply remove all mysql table changes for the last 3 hours, returning to pre-import status. ---------- Post updated at 03:44 AM ----------... (6 Replies)
Discussion started by: lawstudent
6 Replies

7. Emergency UNIX and Linux Support

[Solved] Mysql - Take data from row and copy it to another row

Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :( Dear community, I have a table with two rows like: Row1 Row2 ======= ======= 7,3 text 1 1,3 text 2 1,2,3 blabla What i need to do is add/copy... (2 Replies)
Discussion started by: Lord Spectre
2 Replies
INGRES_AUTOCOMMIT(3)							 1						      INGRES_AUTOCOMMIT(3)

ingres_autocommit - Switch autocommit on or off

SYNOPSIS
bool ingres_autocommit (resource $link) DESCRIPTION
ingres_autocommit(3) is called before opening a transaction (before the first call to ingres_query(3) or just after a call to ingres_roll- back(3) or ingres_commit(3)) to switch the autocommit mode of the server on or off (when the script begins the autocommit mode is off). When autocommit mode is on, every query is automatically committed by the server, as if ingres_commit(3) was called after every call to ingres_query(3). To see if autocommit is enabled use, ingres_autocommit_state(3). By default Ingres will rollback any uncommitted transactions at the end of a request. Use this function or ingres_commit(3) to ensure your data is committed to the database. PARAMETERS
o $link - The connection link identifier RETURN VALUES
Returns TRUE on success or FALSE on failure. SEE ALSO
ingres_autocommit_state(3), ingres_query(3), ingres_rollback(3), ingres_commit(3). PHP Documentation Group INGRES_AUTOCOMMIT(3)
All times are GMT -4. The time now is 07:12 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy