MySQL Forums
Forum List  »  InnoDB

innodb memory usage vs swap
Posted by: kevin foote
Date: September 08, 2010 10:35PM

Hi I have a question about keeping mysql using innodb engine out of swap.

I see this from top output:

PID USER PR NI VIRT SWAP RES SHR S %CPU %MEM TIME+ COMMAND
3194 mysql 0 -15 5272m 2.9g 2.3g 6568 S 31.2 30.1 1525:28 mysqld


This is saying half my innodb buffer is in swap?? This can't be good.

Here are the important parts of my.cnf on this host (RHEL5 x86_64, 8G mem)

------------- >%
# Log
log-error = /var/log/mysqld/mysqld.log
log_warnings = 2
#slow_query_log = 1
slow_query_log_file = /var/log/mysql/mydb2-slow.log

# Buffers and Connections
key_buffer = 2M
max_allowed_packet = 32M
sort_buffer_size = 1M
read_buffer_size = 1M
query_cache_size = 128M
connect_timeout = 60
max_connections = 350
max_connect_errors = 1844674407370954751
wait_timeout = 300
interactive_timeout = 300

## INNODB SETTINGS
innodb_data_home_dir = /var/lib/mysql/ibdata
innodb_data_file_path = ib_data1:100M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/ibdata_logs
innodb_log_file_size = 256M
innodb_log_files_in_group = 2
innodb_log_buffer_size = 32M
innodb_buffer_pool_size = 4G
innodb_additional_mem_pool_size = 20M
innodb_support_xa = 1
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
------------------------------------------ >%

I've also set a few tunables in /etc/sysctl.conf

kernel.shmmax = 68719476736
kernel.shmall = 429496
vm.nr_hugepages = 2048

I've seen two huge swap outs today which really spins up the thread count coming from my app-servers.

Any pointers on keeping this out of swap would be much appreciated..

thanks -kevin

Options: ReplyQuote


Subject
Views
Written By
Posted
innodb memory usage vs swap
7384
September 08, 2010 10:35PM
2574
September 10, 2010 12:01AM
5266
September 10, 2010 09:44AM
2664
September 10, 2010 09:59AM
2645
September 10, 2010 12:26PM
8922
September 10, 2010 11:14PM
3581
September 14, 2010 08:42AM
2794
September 14, 2010 09:44AM
2738
September 14, 2010 08:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.