Transaction MySQL PHP

Back to a previous topic

[henry0]

I posted here for Coopster was involved in the previous TOPIC [webmasterworld.com]

I researched a bit the topic for I would like implementing such a logic

I found a nice tutorial
Here [dev.mysql.com]
and also an added value to the first one
There [software.newsforge.com]

New concern:
Due to the fact that real ATOMIC transaction fully empowered may only occur in an INNODB environment then the second tutorial makes sense
MySQL migration: MyISAM to InnoDB

In my case I can sacrifice a bit of speed to functionality

Your thoughts?

[Mr_Fern]

InnoDB is the only engine that offers real ACID-compliant transactions. If transactions are a must, InnoDB is the way to go. InnoDB also offers for more concurrency as its using row-level locking instead of table locking, and for heavily updated and searched tables, this will show better performance.

On my site I changed my user's table to InnoDB and have seen better performance. I haven't seen any loss in speed, only better performance.

The only negative I've encountered with InnoDB is the lack of the internal counter ( SELECT COUNT() queries scan the entire table) but that's small considering it's benefits.

[henry0]

The site that I intend moving to INNODB is in the
frequent user updates catagory
so that will do nicely

I haven't yet looked in depth to creating INNODB table

May I get that option in PHPmyAdmin for new tables?(I'll have to search for it)