[Asterisk-Users] MySQL

Brian Wilkins brian at hcc.net
Mon Dec 13 02:40:33 MST 2004


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
brian at hcc.net

Heritage Communications Corporation
  Melbourne, FL     USA     32935
321.308.4000 x33
http://www.hcc.net




More information about the asterisk-users mailing list