-----Original Message----- From: Heikki Tuuri [mailto:Heik...@innodb.com] Sent: Saturday, January 05, 2002 3:18 PM To: mys...@lists.mysql.com Subject: Re: help with innodb my.ini config

Hi!

Your my.ini looks ok, except that you should set

innodb_data_home_dir

equal to an empty string if you give absolute paths in innodb_data_file_path

Regards,

Heikki Tuuri Innobase Oy

--- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

................. good day list,

i'm running 3.23.46a win on win2k and had no trouble installing and using myISAM tables

and using a access front end w/myodc - this was easy and fun.

now i'm trying to config to use innodb tables

i stopped the service and edited [mysqld] to [mysql-max-nt] in my.ini

and added the innodb parameters below to my other parameters.

?i don't need to delete the old parameters

basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M

when i add:

# innodb_data_home_dir = c:\ibdata # Data files must be able to # hold your data and indexes innodb_data_file_path = ibdata1:2000M;ibdata2:2000M # Set buffer pool size to 50 - 80 % # of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:\iblogs # .._log_arch_dir must be the same # as .._log_group_home_dir innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 # Set the log file size to about # 15 % of the buffer pool size set-variable = innodb_log_file_size=10M set-variable = innodb_log_buffer_size=8M # Set ..flush_log_at_trx_commit to # 0 if you can afford losing # a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50

do i?

i'm guessing together they form a complete set of parameter for mysqld-max-nt,

if this is the case, can i use both myisam and innodb table types?

AND

how do i edit innodb_data_file_path to use absolute paths?

would i use

innodb_data_file_path = c:/ibdata/ibdata1:2000M;c:/ibdata/ibdata2:2000M ?

i'm aware i have to create the innodb directories (c:/ibdata and c:/iblogs)

i'm new to dos, and aren't all dos paths referred to with c:/blah/blah, not c:\blah\blah???

so would this be a valid my.ini edit?

[mysqld-max-nt] basedir=C:/mysql #bind-address=24.26.165.120 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # #-------------------innodb modifications begin here----------- # innodb_data_home_dir = c:/ibdata # Data files must be able to # hold your data and indexes innodb_data_file_path = c:/ibdata/ibdata1:2000M;c:/ibdata/ibdata2:2000M # Set buffer pool size to 50 - 80 % # of your computer's memory set-variable = innodb_buffer_pool_size=356M set-variable = innodb_additional_mem_pool_size=10M innodb_log_group_home_dir = c:/iblogs # .._log_arch_dir must be the same # as .._log_group_home_dir innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 # Set the log file size to about # 15 % of the buffer pool size set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M # Set ..flush_log_at_trx_commit to # 0 if you can afford losing # a few last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50

and could anyone give me any additional advice on configuring this - i'm running a 1.33amd w 512mb ram and a partition of 10G-

thanks very much in advance - i've been trying and searching and i seem to be stuck on these questions.

thanks very, very much in advance,

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-jondavid=mn.r...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php