[TYPO3] EM not reachable in general - Swapsize 1GB
typo3 at fm-world.ru
Wed Apr 12 12:24:38 CEST 2006
Harald Klotzberg wrote:
> back_log current value: 50
> binlog_cache_size current value: 32768
Do you need this? Extra disk activity. Turn off all logs!
> max_connect_errors current value: 10
Increase this one to a couple of thousands or mysql may start refusing
connections after dropping this number of them. I did not figure out
logic behind it but it is safe and better to have this value high.
> record_buffer current value: 131072
> record_rnd_buffer current value: 0
This should not be 0 because disables buffering of random reads.
> table_cache current value: 64
Looks quite low. What value do you have for Open_tables and
Opened_tables if you issue "show status" command?
> thread_concurrency current value: 10
Do you really have 5 processors? :) Normal value is 2*number of CPUs.
You can safely said it to 4*number of CPUs (thus 8 with one
> thread_cache_size current value: 0
Aha. Here is bad guy ;) You system is spending lot of kernel time
creating new threads. This is why your server is loaded so much. Check
with "show_status" how many connection did you have at peak and set
thread_cache_size to this value + 10%.
You need not to restart mysqld for this, just issue "set global
thread_cache_size=XXX" and continue monitoring your load. If it drops,
change value in my.cnf and restart mysqld.
> thread_stack current value: 65536
Should be 139K on most systems.
I do not see query cache settings. If you query cache is disabled,
system may perform very badly.
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)
More information about the TYPO3-english