-
can you see something like that in the my.cnf?
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
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
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
-
Hi,
The problem is resolved with Zimbra OSE 8.0.1. With this version i don't have errors and the upgrade work fine.