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… Read More »

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… Read More »

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.