Innodb transactions

2005-01-28 Thread Ângelo M. Rigo
Hi I am using innodb tables to implement transactions on my system here is the pseudo code: SET AUTOCOMMIT = 0 BEGIN if(erro){ ROLLBACK } else { COMMIT } When i do commit a transaction and list the data im my web aplication the records are not acurate . How can i get the rigth data ?

show full processlist question

2005-01-28 Thread Ângelo M. Rigo
Hi I didn´t find it in the documentation I would like to know if the collumn time in the command show full processlist show the seconds the query is taking to execute!? Thank´s in advance - Yahoo! Acesso Grátis - Internet rápida e grátis. In

Creating indexes

2005-01-27 Thread Ângelo M. Rigo
Hi I have an aplication wich is opening to many connections even i am using persistent connectins and closing every connection i do open I have created indexes in all the fields i supose they are needed I would like to know if i can and how can i measure where indexes are needed or where

Inoodb transactions

2005-01-27 Thread Ângelo M. Rigo
Hi I am building a transactional sistem with mysql/innodb tables i would like to make sure my steps are rigth, i am using php on the webserver to manipulate these mysql tables. --- Also i try to use select ... read c