Hi, I have a question about the memory that mysql uses, Here is the info that top command displays:
7:39pm up 55 days, 2:51, 1 user, load average: 0.18, 0.08, 0.02
54 processes: 53 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 0.1% user, 10.1% system, 0.0% nice, 89.3% idle
CPU1 states: 0.0% user, 0.0% system, 0.0% nice, 100.0% idle
CPU2 states: 0.0% user, 0.0% system, 0.0% nice, 100.0% idle
CPU3 states: 0.0% user, 0.0% system, 0.0% nice, 100.0% idle
Mem: 3616400K av, 3592084K used, 24316K free, 0K shrd, 193468K buff
Swap: 2096440K av, 6300K used, 2090140K free 2276512K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 18538 mysql 15 0 936M 930M 2516 S 0.0 26.3 4:23 mysqld-max 19036 mysql 15 0 936M 930M 2516 S 0.0 26.3 4:51 mysqld-max 19037 mysql 20 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 19038 mysql 16 0 936M 930M 2516 S 0.0 26.3 0:01 mysqld-max 19039 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 19040 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:17 mysqld-max 19181 mysql 17 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 19182 mysql 15 0 936M 930M 2516 S 0.0 26.3 7:59 mysqld-max 19193 mysql 15 0 936M 930M 2516 S 0.0 26.3 1:03 mysqld-max 19196 mysql 15 0 936M 930M 2516 S 0.0 26.3 2:32 mysqld-max 16336 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 28450 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 28451 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 3004 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 7999 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 8161 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 8323 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 8474 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 27353 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 11775 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max 30268 mysql 15 0 936M 930M 2516 S 0.0 26.3 0:00 mysqld-max
I don't know if all of these processes consume all my memory.
Here is my.cnf file:
default-table-type=innodb
set-variable = key_buffer=850M set-variable = table_cache=1500 set-variable = sort_buffer=4M set-variable = record_buffer=4M set-variable = myisam_sort_buffer_size=750M innodb_data_home_dir = /var/lib/mysql innodb_log_group_home_dir = /var/lib/mysql innodb_log_arch_dir = /var/lib/mysql
innodb_flush_log_at_trx_commit=1 innodb_log_archive=0
set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_buffer_pool_size=850M set-variable = innodb_additional_mem_pool_size=250M set-variable = innodb_log_file_size=150M set-variable = innodb_log_buffer_size=8M set-variable = innodb_file_io_threads=5 set-variable = innodb_lock_wait_timeout=50
Any suggestions?...
Best Regards
_________________________________________________________________ MSN. Más Útil Cada Día http://www.msn.es/intmap/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]