[TYPO3] Typo3 Taking too much memory?

[Dmitry Dulepov]

Hi!

Amir M. wrote:
> Hi, thanks for the replies everyone.
> 
> As for phpmyadmin, yes, I do have phpmyadmin through cpanel.  Here are 
> the stats for my typo3 database which is being used:
> 11,181 Records    9.0 MB Size       1.2 MB Overhead

What typo3 version do you use? If it is 4.0 or newer consider using file 
cache instead of database cache. It is configured in install tool. Make 
sure you have config.sys_stat=0 and disable indexing if you do not need 
it (config.index_enable=0).

> Note, I also have a IPB forum installed for 2 years, and up until a few 
> months since I have started to really use Typo3 4.0 I have never had a 
> problem.  Here is it's stats which are MUCH larger:
> 2,258,165 Records      338.0 MB Size     193.4 KB Overhead

Well, 193.4KB is less than 1.2MB.

> "It appears the same problem has occurred today. [About AW Stats]  You 
> will need to upgrade to a higher level VPS package.  You are recieving 
> errors due to your memory failures.  This is caused by your mysql 
> connections.  Today you had over 133 connections."

So, it is related to connections. Firsts, you need to find who causes 
the problem. This should be easy if typo3 and forums are in different 
databases. "show processlist" in mysql console will show you active 
connections for each database. You may also use "mytop" (google for it) 
to see connections in real time (similar to process list in "top" command).

In any case go and disable persistent connections in Install tool. Since 
you have VPS, I advise to do it globally in php.ini.

> Yes, I am interested in improving typo3's speed.  However, right now my 
> entire site, including the forums, seems to be effected - to a point 
> where they are urging me to purchase a new hosting package, which I feel 
> is not needed at all because my site is not that large to constitute one 
> (not to mention not bringing in the necessary revenue yet).

Optimization is tricky. You will not be able to do it quickly and once. 
It usually takes some time: adjust parameter and watch how it affects 
performance. If you do not feel you can do it yourself, consider paying 
someone.

-- 
Dmitry Dulepov
http://typo3bloke.net/

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)