Am 03.02.2012 08:49, schrieb Paul J Stevens:
> On 02/02/2012 09:07 PM, Reindl Harald wrote:
> 
>> attached the whole maillog from login on horde3 until dovecot
>> confirms the succesfull login but never responds to horde and
>> only my password is obfuscated
> 
> Harry,
> 
> Please don't use syslog_logging_level, but file_logging_level.

done, while "syslog_logging_levelS" seems to be important

* log level set
* restarted all mail services
* > /var/log/dbmail.err
* horde login
* waited until the hammer-query was finished + 30 seconds

the only touch to the file was replacing my password
________________________

below also the whole mysqld configuration

the buffers are not too big since it is a backup-machine
but as said, dbmail-2.2 with the same config/mail-data and horde
does not trigger this problem and god beware more than one client
will ever trigger copy to temp table at the same time

[root@dbmail-test:~]$ rpm -qa | grep mysql-server
mysql-server-5.5.20-2.fc15.20120111.rh.x86_64
________________________

[mysqld]
socket                                  = /var/lib/mysql/mysql.sock
datadir                                 = /Volumes/dune/mysql_data
pid-file                                = /Volumes/dune/mysql_data/mysql.pid
tmpdir                                  = /tmp
character-set-server                    = utf8
collation-server                        = utf8_general_ci
default-time-zone                       = "Europe/Vienna"
default-storage-engine                  = innodb
lower_case_table_names                  = 1
log-error                               = 
/Volumes/dune/www-servers/_logs/mysql_error.log
slow_query_log                          = 0
slow_query_log_file                     = 
/Volumes/dune/www-servers/_logs/mysql_slow_query.log
general_log                             = 0
general_log_file                        = 
/Volumes/dune/www-servers/_logs/mysql_query.log
port                                    = 3306
old_passwords                           = 0
local-infile                            = 0
thread_concurrency                      = 16

ssl-ca                                  = /etc/mysql-ssl/ca.crt
ssl-cert                                = /etc/mysql-ssl/server.pem
ssl-key                                 = /etc/mysql-ssl/server.pem

delay-key-write                         = ALL
concurrent_insert                       = 2
open-files-limit                        = 1000
myisam-recover                          = "FORCE"
myisam_use_mmap                         = 1

wait_timeout                            = 604800
interactive_timeout                     = 604800

max_allowed_packet                      = 250M
max_connections                         = 50
max_tmp_tables                          = 150
max_connect_errors                      = 200
max_delayed_threads                     = 32

flush_time                              = 0

query_cache_limit                       = 512K
query_cache_min_res_unit                = 1K
query_cache_size                        = 15M
query_cache_type                        = 1

table_cache                             = 4000
thread_cache                            = 200
table_definition_cache                  = 768

tmp_table_size                          = 512M
max_heap_table_size                     = 256M

key_buffer_size                         = 150M
sort_buffer_size                        = 128K
read_rnd_buffer_size                    = 128K
join_buffer_size                        = 128K
read_buffer_size                        = 128K
preload_buffer_size                     = 128K
myisam_sort_buffer_size                 = 5M

innodb_buffer_pool_size                 = 2048M
innodb_buffer_pool_instances            = 4
innodb_purge_threads                    = 1
innodb_max_purge_lag                    = 200000
innodb_max_dirty_pages_pct              = 60
innodb_additional_mem_pool_size         = 10M
innodb_log_file_size                    = 512M
innodb_log_buffer_size                  = 32M
innodb_thread_concurrency               = 32
innodb_thread_sleep_delay               = 10
innodb_flush_log_at_trx_commit          = 2
innodb_support_xa                       = 1
innodb_lock_wait_timeout                = 50
innodb_table_locks                      = 0
innodb_checksums                        = 1
innodb_file_format                      = barracuda
innodb_file_per_table                   = 1
innodb_open_files                       = 600
innodb_io_capacity                      = 300
innodb_read_io_threads                  = 6
innodb_write_io_threads                 = 6
transaction-isolation                   = READ-COMMITTED

low-priority-updates
safe-user-create
skip-federated
skip-name-resolve
skip-networking
skip-partition
skip-archive
skip-blackhole
skip-symbolic-links
slave_compressed_protocol
large-pages

[client]
socket                                  = /var/lib/mysql/mysql.sock
port                                    = 3306
user                                    = root
ssl-ca                                  = /etc/mysql-ssl/ca.crt
ssl-cert                                = /etc/mysql-ssl/client.pem
ssl-key                                 = /etc/mysql-ssl/client.pem

[mysqladmin]
socket                                  = /var/lib/mysql/mysql.sock
port                                    = 3306
user                                    = root

[mysqld_safe]
socket                                  = /var/lib/mysql/mysql.sock
port                                    = 3306
log-error                               = 
/Volumes/dune/www-servers/_logs/mysql_error.log

Attachment: log.tar.gz
Description: GNU Zip compressed data

Attachment: signature.asc
Description: OpenPGP digital signature

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to