[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