Author Archives: Admin

Autocommit

You can control the behavior of transaction by setting the session variable called AUTOCOMMIT.

if AUTOCOMMIT is set to 1(the default),then each SQL statment(within a transaction or not) is

considered to be a complete transaction and committed by default finishes.

When AUTOCOMMIT is set to 0,by issuing the SET AUTOCOMMIT=0 command, the subsequent series of statements acts like a transaction, and no activities are committed until and explicit COMMIT statement is issued

You can execute these SQL commands in php using mysql_query() function.

Package installation steps in Plesk

Follow the following steps

#) Go to Tools and Settings->Application Vault

#) Go to the Tab My Apps->Add App

#) Choose the particular/Package file and Upload.

#) Go to Subscriptions->Click on particular Subscription

#) Click on Applications Tab->All Available Applications

#) Choose the avaliable category like (web,backoffice etc)

#) Click on install button.

What is ACID in Transaction

Transaction have the following four standard properties ,usually referred to by the acronym ACID.

* Atomicity-ensures that all operations within the work unit are completed successfully, otherwise the transaction is aborted at the point of failure and previous operations are rolled back to their former state.

*Consistency-ensures that the database properly changes states uon a successfully commited transaction.

*Isolation-enables transaction to operate independently of and transparent to to each other

*Durability-ensures that the result or effect of a committed transaction persists in case of a systemm failure

In Mysql, transactions begin with the statement BEGIN WORK and end with either a COMMIT or a ROLLBASCK statement.The SQL commands between the beginning and ending statements frorm the bulk of the transaction.

What is mean by Transaction?

A Transaction is a sequential group of database manipulation operation. which is performed as if it were one single work unit. Transaction will never be complete unless each individual operation within the group is successful.If any operation within the transaction fails,the entire transaction will fail.