MySQL Forums
Forum List  »  InnoDB

Re: innodb memory usage vs swap
Posted by: kevin foote
Date: September 10, 2010 12:26PM

Well lets see this day is getting better and better..
Just crashed w/ this my.cnf in place..

Ironically I now have all 0's in si/so columns.

------------ my.cnf --------------
[mysqld_safe]
nice = -15

[mysqld]
datadir = /var/lib/mysql
user = mysql
old_passwords = 1
bind-address = my.ip.here
default-character-set = utf8
default-collation = utf8_unicode_ci

# Log
log-error = /var/log/mysqld/mysqld.log
log_warnings = 1
#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 = 500
max_connect_errors = 1844674407370954751
wait_timeout = 300
interactive_timeout = 300
thread_cache_size = 50

## 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_file_per_table = 1
innodb_flush_log_at_trx_commit = 1
innodb_flush_method = O_DIRECT
innodb_max_dirty_pages_pct = 75
innodb_thread_concurrency = 10

## BINLOG SETTINGS
log-bin = /var/log/mysql/mydb2-bin
log-bin-index = /var/log/mysql/mydb2-bin.index
binlog-do-db = appdb1
binlog-do-db = appdb1QA
binlog-ignore-db = mysql
expire_logs_days = 10
sync_binlog = 1

Options: ReplyQuote


Subject
Views
Written By
Posted
6484
September 08, 2010 10:35PM
2169
September 10, 2010 12:01AM
4349
September 10, 2010 09:44AM
2166
September 10, 2010 09:59AM
Re: innodb memory usage vs swap
2157
September 10, 2010 12:26PM
6333
September 10, 2010 11:14PM
2910
September 14, 2010 08:42AM
2251
September 14, 2010 09:44AM
2226
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.