[Typo3-debian] memory consumption of apache/mysql (not php limit!)

[Hans J. Martin]

Hi Steffen,

I've set the limit to 16 MB and got the fatal exception in
 /var/lib/typo3/typo3_src-3.6.0/t3lib/class.t3lib_db.php on line 689
 - this is the well known mysql_wrapper which does nothing but returning the
mysql_fetch_assoc results.

I see that this is the point where the memory limit is reached - trying to
open other pages showed me different failures and finaly reloading the page
also (e.g. the loginpage with just two images and the loginform exist while
reloading it locallang.php)

I have deactivated the indexed search extension and some other plugins (for
different page rendering), so I don't get the error anymore. But the site is
still rather slow - top shows me again the need of 24M for each apache
process as well as several mysql processes needing up to 12 M - so the
system started swapping again...

Any suggestions?

@Jean-Marie: As I have seen servers with less 'power' and higher load you
don't have to woryy about that - it is just kind of 'how to make yourself
getting nuts' configuring thing..

TIA
Hans

Mem:    385304K total,   363696K used,    21608K free,     1592K buffers
Swap:   514040K total,   250636K used,   263404K free,    10984K cached

Snippets from my httpd.conf
Timeout 300
KeepAlive On
MaxKeepAliveRequests 0
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 350 # (don't need to serve more than 400 clients at the same time
i guess)
MaxRequestsPerChild 1000 (tried to decrease this to let the childs die
before they became big)

--8<---
my.cnf
skip-networking
key_buffer              = 16M
max_allowed_packet      = 1M
thread_stack            = 128K
skip-innodb
query_cache_limit       = 1048576
query_cache_size        = 26214400
query_cache_type        = 1
key_buffer              = 16M



"Steffen Mueller" <steffen at davis.kommwiss.fu-berlin.de> schrieb im
Newsbeitrag
news:mailman.1.1083929451.26440.typo3-debian at lists.netfielders.de...
> On 07.05.2004 09:11 Hans J. Martin wrote:
> >
> > unfortunatly our apache/mysql server seems to need a lot of memory for
> > running typo3 3.6.0. As I have set the php-memory limit to about 32 MB I
> > feel that this is an configuration error and not depending on typo3(?) -
so
> > this might be a little bit ot..
> >
> > When I reload a page about ten times I find approx. 10 apache
processes -
> > each with a memory ressource demand of 24 M and approx 16 mysql
processes
> > with 17 M.. (seen via top).
> >
>
> hi.
>
> just to exclude mistakes:
> consider php memory_limit applies to each apache thread.
> 10 apache threads * 32mb = 320 mb
> so the behavior of apache/php is totally right.
>
> indeed, mem consumtion is quite high on your server. e.g. on my machine,
> it's <3mb foreach apache and the same for mysql.
>
> what happens if you set php memory_limit to 16mb?
> you should get a fatal error saying the the memory limit was exceeded
> and it will try to point out what line made it go over.
>
> -- 
> cheers,
> Steffen
>
> ----------------------------------------------------------
> "Education is man's going forward from cocksure ignorance
> to thoughtful uncertainty." (Don Clarks' Scrapbook)
> ----------------------------------------------------------