around 10 GB and 60000 messages e-mail is not our core business, it's only to provide all services at once (domain,dns,design, development,web...)
but i am pretty sure you will also benefit from compression with 120 GB as long you are not cpu-bound because lesser disk-IO "innodb_io_capacity" may also make a difference it is io/per-second in whcih SAN-storages are measured Am 13.06.2012 23:51, schrieb Jorge Bastos: > One extra info, for both, > > Wich are the DB size each of you have? > I have 120GB now, InnoDB, with file_per_table. > > Jorge,s > >> we are using compressed tables since 2009 / MySQL 5.1 in 5.1 you needed >> innodb_plugin, 5.5 supports native >> >> be aware you need "innodb_file_per_table" for this feature >> >> innodb_buffer_pool_size = 3072M >> innodb_buffer_pool_instances = 3 >> innodb_purge_threads = 1 >> innodb_max_purge_lag = 200000 >> innodb_max_dirty_pages_pct = 60 >> innodb_additional_mem_pool_size = 64M >> innodb_log_file_size = 512M >> innodb_log_buffer_size = 256M >> 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 = 0 >> innodb_file_format = barracuda >> innodb_file_per_table = 1 >> innodb_open_files = 600 >> innodb_io_capacity = 300 >> innodb_read_io_threads = 8 >> innodb_write_io_threads = 8 >> transaction-isolation = READ-COMMITTED -- Reindl Harald the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40 icq: 154546673, http://www.thelounge.net/ http://www.thelounge.net/signature.asc.what.htm
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
