[TYPO3-core] RFC: core speedup

[Dmitry Dulepov]

-----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-----