On Sun, 2009-12-13 at 20:14 -0800, Daniel Mejia wrote: > 1. Is the dbmail_messageblks table cant be optimized?
It can be optimized, but there's probably no good reason to do it. I did it once and it didn't increase the database speed it just took a long time to do it. > 2. What would u suggest the mysql.cnf config should be like for 2000+ users > & at least 1000 incoming mails per day? I've posted my mysql.cnf before. I had a few people pick it to pieces. I implemented some of them. So it's still not perfect but it does the job fine. This particular mysql.cnf is used on a Debian Etch server with a single 3GHz Celeron CPU, 3Gb RAM and a pair of 160Gb hard disks in software RAID-1. Serving 5000 mailboxes and between 25,000-30,000 emails/day: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking skip-name-resolve skip-name-resolve bind-address = 0.0.0.0 key_buffer = 1024M key_buffer_size = 16M max_allowed_packet = 128M table_cache = 2048 sort_buffer_size = 32M read_buffer_size = 8M read_rnd_buffer_size = 62M myisam_sort_buffer_size = 64M thread_concurrency = 4 thread_stack = 128K thread_cache_size = 8 max_connections = 1800 query_cache_limit = 5M query_cache_size = 512M log_bin = /storage/binlog/mysql-bin.log expire_logs_days = 5 max_binlog_size = 100M skip-bdb innodb_buffer_pool_size=100M innodb_log_file_size=192M innodb_log_buffer_size=8M innodb_file_per_table [mysqldump] quick quote-names max_allowed_packet = 128M [mysql] [isamchk] key_buffer = 16M _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
