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
