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
