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, jd --------------------------------------------------------------------- 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
