[TYPO3-dev] Idea: add transaction support to t3lib_db

Steffen Kamper info at sk-typo3.de
Tue Mar 8 10:12:46 CET 2011


Hi Dmitry,

Am 08.03.2011 10:03, schrieb Dmitry Dulepov:
> Hi!
>
> Steffen Kamper wrote:
>> btw - seems bad admins all around, i often see problems with not
>> existing innoDB, crashing innoDB tables etc. It seems not so easy to
>> seperate innoDB to not getting a monster file where you can't shrink it.
>
> I found that using file per table helps a lot with InnoDB. Firsts, it is
> faster. It should not be but it is! At least in my case (RAID1, LVM).
> Secondly, with a single huge file it is not possible to reclaim space.
> With file per table it is as simple as converting to myisam and back to
> innodb (also resorts the table in PK order, which makes it faster).
>

that's exactly what is needed imho. But i was faced to admins unable to 
configure it. Maybe you can post yor configuration how to do it this way?

vg Steffen




More information about the TYPO3-dev mailing list