[TYPO3-core] RFC: core speedup

[Michael Stucki]

Hi Dmitry, 

while talking about DB optimization, please have a look at this interesting
page where Patrick (I think it was him?) has added some more indexes:

http://wiki.typo3.org/index.php/Performance_tuning

For further discussion I'd like to ask you to move this discussion to
another list (dev-list?) or wait until 4.0 is finished. There are more
important things to do at the moment:

http://bugs.typo3.org/

- michael

Dmitry Dulepov wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Hi!
> 
> Follow up. I am installing new server. Without major tuning it gives:
> ~ 1000 rq/s for test.txt
> ~ 830 rq/s for <? phpinfo(); ?>
> ~ 350 rq/s for a script that lists all databases and tables (so, no any
> mysql caching)
> ~ 9 rq/s with typo3
> 
> eAccelerator is installed.
> 
> I added a couple of indexes and moved cache_pages, cache_pagesection,
> fe_sessions and fe_session_data to InnoDb to avoid locking when records
> are simultaneously selected/inserted/updated/deleted in these tables.
> Now I got around 19 rq/s. Two times more with just a primitive db
> optimization...
> 
> One more note: "grep -R mysql_close /srv/www/web1/web" did not reveal
> anything. So, if typo3 has no_pconnect=0, it starts loosing connections
> very soon. Setting no_pconnect to 1 solves this problem but we would
> better close connection properly.
> 
> Command line for testing was:
> /opt/lampp/bin/ab -t 1000 -c 50 "http://testsite/"
> "ab" runs on a separate PC connected to the server through 100mbit hub
> (no other computers in the hub).
> 
> This is tested on RC1 system.
> 
> Dmitry.
> 
> Dmitry Dulepov wrote:
>> Many slow pieces slow down the whole system. Sometimes significantly.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> 
> iD8DBQFEKXDzRVcYnKJ8N6kRAs3SAKCSL4G0Q/EKVakxXQ2YxOTGRZdyUQCcD0B1
> JfWViTGhlHgDDvTfeOC8QVM=
> =1msK
> -----END PGP SIGNATURE-----

-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/