can you see something like that in the my.cnf?
here is my full my.cnf file:Code:[mysqld] basedir = /opt/zimbra/mysql datadir = /opt/zimbra/db/data socket = /opt/zimbra/db/mysql.sock pid-file = /opt/zimbra/db/mysql.pid bind-address = localhost port = 7306 user = zimbra tmpdir = /opt/zimbra/data/tmp
Code:[mysqld] basedir = /opt/zimbra/mysql datadir = /opt/zimbra/db/data socket = /opt/zimbra/db/mysql.sock pid-file = /opt/zimbra/db/mysql.pid bind-address = localhost port = 7306 user = zimbra tmpdir = /opt/zimbra/data/tmp external-locking slow_query_log = 1 slow_query_log_file = /opt/zimbra/log/myslow.log long-query-time = 1 log-queries-not-using-indexes thread_cache_size = 110 max_connections = 110 # We do a lot of writes, query cache turns out to be not useful. query_cache_type = 0 sort_buffer_size = 1048576 read_buffer_size = 1048576 # (Num mailbox groups * Num tables in each group) + padding table_cache = 1200 innodb_buffer_pool_size = 3435973840 innodb_log_file_size = 524288000 innodb_log_buffer_size = 8388608 innodb_file_per_table # Value is: 200 + max_connections + 2 * table_cache innodb_open_files = 2710 innodb_max_dirty_pages_pct = 10 innodb_flush_method = O_DIRECT innodb_flush_log_at_trx_commit = 0 max_allowed_packet = 16777216 [mysqld_safe] err-log = /opt/zimbra/log/mysqld.log pid-file = /opt/zimbra/db/mysql.pid


LinkBack URL
About LinkBacks

