Hi Tom These are the lines:
USE dbmail; alter table mailboxes add index (name); alter table mailboxes add index (owner_idnr); alter table mailboxes add index (is_subscribed); alter table messages add index (mailbox_idnr); alter table messages add index (seen_flag); alter table messages add index (unique_id); alter table messages add index (status); Jacques "Robert L. Tom" <[EMAIL PROTECTED]> a dit : > > Jacques, > > Were those the ones about new indexes and tables to add > on dbmail? > Robert > > > Take a look at the archive i ask 2 or 3 weeks ago about > > the speed of dbmail compare to uwimap. > > > > Somebody give me 6 or 7 sql statements to add to dbmail. > > > > The response time after addind the statements made dbmail > > 70% faster > > > > Jacques > > > > > > > > "Robert L. Tom" <[EMAIL PROTECTED]> a dit : > > > >> > >> I am using dbmail 1.1 with mysql. > >> I have these default settings below for mysqld. > >> Is there anything I need to make larger or > >> smaller to make mysql faster working with DBmail? > >> > >> Robert > >> > >> > >> Possible variables for option --set-variable (-O) are: > >> back_log current value: 50 > >> bdb_cache_size current value: 8388600 > >> bdb_log_buffer_size current value: 0 > >> bdb_max_lock current value: 10000 > >> bdb_lock_max current value: 10000 > >> binlog_cache_size current value: 32768 > >> connect_timeout current value: 5 > >> delayed_insert_timeout current value: 300 > >> delayed_insert_limit current value: 100 > >> delayed_queue_size current value: 1000 > >> flush_time current value: 0 > >> innodb_mirrored_log_groups current value: 1 > >> innodb_log_files_in_group current value: 2 > >> innodb_log_file_size current value: 5242880 > >> innodb_log_buffer_size current value: 1048576 > >> innodb_buffer_pool_size current value: 8388608 > >> innodb_additional_mem_pool_size current value: 1048576 > >> innodb_file_io_threads current value: 4 > >> innodb_lock_wait_timeout current value: 50 > >> innodb_thread_concurrency current value: 8 > >> innodb_force_recovery current value: 0 > >> interactive_timeout current value: 28800 > >> join_buffer_size current value: 131072 > >> key_buffer_size current value: 8388600 > >> long_query_time current value: 10 > >> lower_case_table_names current value: 0 > >> max_allowed_packet current value: 1048576 > >> max_binlog_cache_size current value: 4294967295 > >> max_binlog_size current value: 1073741824 > >> max_connections current value: 100 > >> max_connect_errors current value: 10 > >> max_delayed_threads current value: 20 > >> max_heap_table_size current value: 16777216 > >> max_join_size current value: 4294967295 > >> max_sort_length current value: 1024 > >> max_tmp_tables current value: 32 > >> max_user_connections current value: 0 > >> max_write_lock_count current value: 4294967295 > >> myisam_max_extra_sort_file_size current value: 256 > >> myisam_max_sort_file_size current value: 2047 > >> myisam_sort_buffer_size current value: 8388608 > >> net_buffer_length current value: 16384 > >> net_retry_count current value: 10 > >> net_read_timeout current value: 30 > >> net_write_timeout current value: 60 > >> open_files_limit current value: 0 > >> query_buffer_size current value: 0 > >> record_buffer current value: 131072 > >> record_rnd_buffer current value: 0 > >> slave_net_timeout current value: 3600 > >> slow_launch_time current value: 2 > >> sort_buffer current value: 2097144 > >> table_cache current value: 64 > >> thread_concurrency current value: 10 > >> thread_cache_size current value: 0 > >> tmp_table_size current value: 33554432 > >> thread_stack current value: 65536 > >> wait_timeout current value: 28800 > >> > >> > >> > >> _______________________________________________ > >> Dbmail mailing list > >> [email protected] > >> https://mailman.fastxs.nl/mailman/listinfo/dbmail > >> > > > > > > > > -- > > [EMAIL PROTECTED] > > > > > > > > ________________________________________________________________ > > Commission scolaire de la Pointe-de-l'Ile > > http://www.cspi.qc.ca/ > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > -- [EMAIL PROTECTED] ________________________________________________________________ Commission scolaire de la Pointe-de-l'Ile http://www.cspi.qc.ca/
