Thanks. :) Robert
> 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 >> >> Dbmail@dbmail.org >> >> 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 >> Dbmail@dbmail.org >> https://mailman.fastxs.nl/mailman/listinfo/dbmail >> > > > > -- > [EMAIL PROTECTED] > > > > ________________________________________________________________ > Commission scolaire de la Pointe-de-l'Ile > http://www.cspi.qc.ca/
