Moodle 1.9.8 in server with 8GB RAM and 4 CPUs.
System:debian lenny with default apps and configs.
Problems:
1. Speed slow down heavily in some courses' homepage, especially when I click to save somenting even a tag. links looks like course/view.php?id=62... after modedit.php.
2. When I click to go back to former page from such pages like "course/modedit.php?update=6080&return=0" in edit mode, no respect offen. When I click to save, problem 1 happens.
Some of my configs:
A. my.cf
50 key_buffer = 512M
57 max_allowed_packet = 16M
58 thread_stack = 256K
59 #thread_cache_size = 64
60 thread_cache = 64
61 max_connections = 100
62 max_connect_errors = 30000
63 wait_timeout = 10
64 interactive_timeout = 10
65 tmp_table_size = 64M
66 max_heap_table_size = 64M
67 table_cache = 1024
68 thread_concurrency = 16
69 sort_buffer = 64M
70 record_buffer = 64M
71 #read_rnd_size = 64M
72 join_buffer_size = 4M
73 myisam_sort_buffer_size = 256M
74 # * Query Cache Configuration
75 #
76 query_cache_type = 1
77 query_cache_limit = 16M
78 query_cache_size = 32M
79 query_cache_min_res_unit = 2K
80 #
81 # * Logging and Replication
82 #
83 # Both location gets rotated by the cronjob.
84 # Be aware that this log type is a performance killer.
85 #log = /var/log/mysql/mysql.log
86 #
87 # Error logging goes to syslog. This is a Debian improvement
88 #
89 # Here you can see queries with especially long duration
90 log_slow_queries = /var/log/mysql/mysql-slow.log
91 long_query_time = 2
B. apache2.conf
83 KeepAlive On
84 MaxKeepAliveRequests 100
90 KeepAliveTimeout 3
102 <IfModule mpm_prefork_module>
103 StartServers 5
104 MinSpareServers 5
105 MaxSpareServers 10
106 MaxClients 150
107 MaxRequestsPerChild 30
108 </IfModule>
C. parts of top's show:
21909 www-data 20 0 246m 45m 4176 S 16 0.6 0:02.06 apache2
21899 www-data 20 0 250m 48m 4312 S 6 0.6 0:01.10 apache2
21671 www-data 20 0 256m 54m 4252 S 5 0.7 0:03.02 apache2
21925 www-data 20 0 244m 42m 3896 R 5 0.5 0:00.18 apache2
21900 www-data 20 0 246m 45m 4180 S 4 0.6 0:00.96 apache2
27694 mysql 20 0 747m 137m 5308 S 4 1.7 1:16.62 mysqld
21897 www-data 20 0 257m 55m 4156 S 1 0.7 0:01.60 apache2
21916 www-data 20 0 241m 39m 3900 S 1 0.5 0:00.44 apache2
Any help greatly appreciated.
Hugo