[TYPO3-core] RFC: core speedup

[Kasper Skårhøj]

Now we are talking!

I always wondered what you would use your database skills for with  
TYPO3 and now I know!

- kasper


On Mar 28, 2006, at 19:22 , 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-----
> _______________________________________________
> TYPO3-team-core mailing list
> TYPO3-team-core at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-team-core


- kasper

"A contribution a day keeps the fork away"
-------------------------------
kasper2006 at typo3.com | +45 20 999 115 | skype: kasperskaarhoej |  
gizmo: kasper_typo3