I have found that because the way MyISAM works, InnoDB is a better solution to prevent hangups due to the type of locking MyISAM uses. You have to edit your /etc/mysql/my.cnf in order to enable InnoDB
From "High Performance MySQL" by O'Reilly : innodb_data_file_path = ibdata1:400M innodb_data_home_dir = /usr/local/mysql/var/ innodb_log_group_home_dir = /usr/local/mysql/var/ innodb_log_arch_dir = /usr/local/mysql/var/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 innodb_buffer_pool_size=16M innodb_additional_mem_pool_size = 2M innodb_file_io_threads = 4 innodb_lock_wait_timeout = 50 MyISAM tables, if accessing many different times by many different processes, can causes buffering issues; especially on a large scale IP PBX. Read here on how to convert your MyISAM tables to InnoDB : http://dev.mysql.com/doc/mysql/en/Converting_tables_to_InnoDB.html -- Brian Wilkins Software Engineer [EMAIL PROTECTED] Heritage Communications Corporation Melbourne, FL USA 32935 321.308.4000 x33 http://www.hcc.net _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
