Salut, Am si eu un site care are ca backend mysql. Cum as putea sa limitez memoria pe care o foloseste mysql-ul? In momentul de fata my.cnf arata asa:
[mysqld] max_connections = 100 key_buffer = 8M myisam_sort_buffer_size = 8M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 1024 thread_cache_size = 64 wait_timeout = 1800 connect_timeout = 10 max_allowed_packet = 8M max_connect_errors = 10 query_cache_limit = 1M query_cache_size = 10M query_cache_type = 1 skip-innodb [mysqld_safe] open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 8M [myisamchk] key_buffer = 10M sort_buffer = 10M read_buffer = 8M write_buffer = 10M si in top PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 7147 mysql 15 0 34804 4940 4948 S 0.0 1.9 0:00.44 mysqld 7148 mysql 16 0 34804 4940 4948 S 0.0 1.9 1:34.64 mysqld 7149 mysql 15 0 34804 4940 4948 S 0.0 1.9 0:02.64 mysqld + inca vreo 12-14 childs :) Si asa ca si chestie cu ce tool as putea sa vad unde se duce memoria ?(cine cat foloseste) Multumesc, Stefan --- Detalii despre listele noastre de mail: http://www.lug.ro/
