Dobrư den, quinta-feira, 21 de novembro de 2002, 09:58:47, napsal jste: IS> Hi all.
IS> The example mysql configuration files included in support-files directory of IS> MySQL distribution are optimized for MyISAM table type. IS> I want to tunnig the server optimized for InnoDB because I won't use MyISAM IS> table type except for mysql database and *.frm files. IS> I want to know which variables from my.cnf are only related for MyISAM table IS> type (and not for InnoDB) and which are the minimal values for these IS> variables. IS> I'm using MySQL 3.23.53a-max in a dual Pentimum III 1000GHz Linux box with IS> 1GB of memory. IS> Thanks in advance. IS> Iago Sineiro. no exists a "magic" formula for the optimize the InnoDB on MySQL , only see the manual and change the lines : innodb_data_home_dir = /usr/local/mysql4/var/ innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql4/var/ innodb_log_arch_dir = /usr/local/mysql4/var/ --------------------------------------------------------- # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high --------------------------------------------------------- set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=5M --------------------------------------------------------- # Set .._log_file_size to 25 % of buffer pool size --------------------------------------------------------- set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=2 set-variable = innodb_lock_wait_timeout=50 bye, ------------------------------------------------------------------------- ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento ------------------------------------------------------------------------- E S C R I B A I N F O R M A T I C A ------------------------------------------------------------------------- The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into "my eyes" look: cannot open my eyes ------------------------------------------------------------------------- Reply: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php