[TYPO3] EM not reachable in general - Swapsize 1GB
Harald Klotzberg
harald.klotzberg at netzbewohner.de
Wed Apr 12 16:07:09 CEST 2006
Hi Dmitry,
thanx! quite a lot of suggestions :)
I check all the stuff you suggested and changed it.
But it doesn´t help ...
Fatal error: Allowed memory size of 100663296 bytes exhausted (tried to
allocate 1 bytes) in
/srv/www/htdocs/typo3_src-4.0/typo3/mod/tools/em/class.em_index.php on line
2981
Tested with 32, 40, 64 and 96mb
About your question:
table_cache = 64
open_tables = 64
opened_tables = 3668
after the update
table_cache = 64
open_tables = 64
opened_tables = 124
Max_used_connections = 4 so i set thread_cache_size = 8
here are the current values:
mysql> SHOW STATUS;
+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| Aborted_clients | 0 |
| Aborted_connects | 1 |
| Bytes_received | 270821 |
| Bytes_sent | 2308002 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 83 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 45 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 21 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_select | 806 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 1 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 31 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 39 |
| Connections | 8 |
| Created_tmp_disk_tables | 1 |
| Created_tmp_tables | 2 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 15 |
| Handler_read_first | 226 |
| Handler_read_key | 709 |
| Handler_read_next | 419 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 151 |
| Handler_read_rnd_next | 3609 |
| Handler_update | 10 |
| Handler_write | 95 |
| Key_blocks_used | 180 |
| Key_read_requests | 2778 |
| Key_reads | 179 |
| Key_write_requests | 127 |
| Key_writes | 72 |
| Max_used_connections | 4 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 130 |
| Open_streams | 0 |
| Opened_tables | 124 |
| Questions | 1020 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 29 |
| Select_range_check | 0 |
| Select_scan | 47 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 60 |
| Sort_rows | 151 |
| Sort_scan | 7 |
| Table_locks_immediate | 1032 |
| Table_locks_waited | 0 |
| Threads_cached | 2 |
| Threads_created | 5 |
| Threads_connected | 3 |
| Threads_running | 1 |
| Uptime | 351 |
+--------------------------+---------+
back_log current value: 50
binlog_cache_size current value: 32768
connect_timeout current value: 5
delayed_insert_timeout current value: 300
delayed_insert_limit current value: 100
delayed_queue_size current value: 1000
flush_time current value: 0
interactive_timeout current value: 28800
join_buffer_size current value: 131072
key_buffer_size current value: 16773120
long_query_time current value: 10
lower_case_table_names current value: 0
max_allowed_packet current value: 1047552
max_binlog_cache_size current value: 4294967295
max_binlog_size current value: 1073741824
max_connections current value: 100
max_connect_errors current value: 32768
max_delayed_threads current value: 20
max_heap_table_size current value: 16777216
max_join_size current value: 4294967295
max_sort_length current value: 1024
max_tmp_tables current value: 32
max_user_connections current value: 0
max_write_lock_count current value: 4294967295
myisam_max_extra_sort_file_size current value: 256
myisam_max_sort_file_size current value: 2047
myisam_sort_buffer_size current value: 8388608
net_buffer_length current value: 7168
net_retry_count current value: 10
net_read_timeout current value: 30
net_write_timeout current value: 60
open_files_limit current value: 0
query_buffer_size current value: 0
record_buffer current value: 131072
record_rnd_buffer current value: 126976
slave_net_timeout current value: 3600
slow_launch_time current value: 2
sort_buffer current value: 524280
table_cache current value: 64
thread_concurrency current value: 4
thread_cache_size current value: 8
tmp_table_size current value: 33554432
thread_stack current value: 131072
wait_timeout current value: 28800
-----Original Message-----
From: typo3-english-bounces at lists.netfielders.de
[mailto:typo3-english-bounces at lists.netfielders.de] On Behalf Of Dmitry
Dulepov
Sent: Wednesday, April 12, 2006 12:25 PM
To: typo3-english at lists.netfielders.de
Subject: Re: [TYPO3] EM not reachable in general - Swapsize 1GB
Hi!
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 hyperthreaded
processor).
> 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.
Dmitry.
--
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)
_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
More information about the TYPO3-english
mailing list