Re: To get Processlist and Status of MySQL ?

In infinite wisdom James Corteciano wrote: > [1 ] > Hi All, > > What is the other way to get the *processlist* and *status* of mysql server > on event that the mysql server cannot be able to reach due to hung or > crashed? GDB -- Raj Shekhar - If there's anythi

Re: InnoDB / Transactions question

Thanks for the clarification. Michael On May 17, 2010, at 2:28 PM, Michael Dykman wrote: > MyISAM does not support transactions so it is inherently in > 'autocommit mode' all the time. You will run into this with any > transactional database, be it InnoDB, Falcon, or Oracle and DB2 > installat

Re: InnoDB / Transactions question

MyISAM does not support transactions so it is inherently in 'autocommit mode' all the time. You will run into this with any transactional database, be it InnoDB, Falcon, or Oracle and DB2 installations for that matter. For many classes of application, avoiding autocommit and explicitly creating a

InnoDB / Transactions question

Hello, I'm currently writing a python program that scans some web directories and then stores some information in a local database. I'm playing with using InnoDB for this application as a test bed for using InnoDB in further applications, but I'm running into a couple issues. When I try to writ