[TYPO3-core] RFC: performance improvemenets for database

Dmitry Dulepov dmitry at typo3.org
Fri Jan 26 11:28:12 CET 2007


Hi!

This is SVN patch request.

This patch was posted long time ago. Part of is by Masi, part by me. 
Corresponding thread is named "RFC: improving index of sys_template" and 
dates back to 04.10.2006.

Generally, there are two things there:
- default engine type is changed to InnoDB, which makes many queries to 
run much faster. Unline MyISAM, InnoDb does not lock records for reading 
when someone writes to records. After changing engine type I found that 
I do not get "Waiting for lock on..." anymore. Also InnoDb is much more 
error-resistant. I had several crashes for MyISAM and none for InnoDb so 
far.
- There are new indexes that speed up certain operations in BE&FE. See 
details in that old thread.

I understand it may be too late to get it into 4.1 before RC but I think 
it is worth to integrate it to trunk.

You may ask: what happens if user does not have InnoDb enabled? The 
answer comes from mysql manual ("CREATE PAGE" description): "If a 
storage engine is specified that is not available, MySQL uses the 
default engine instead. Normally, this is MyISAM."

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: db_perf.sql
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20070126/933bdc2e/attachment.pot 


More information about the TYPO3-team-core mailing list