About 70Gb without compression but with file_per_table with about 320000
messages.
Am 13.06.2012, 23:51 Uhr, schrieb Jorge Bastos <mysql.jo...@decimal.pt>:
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
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
