-----Original Message----- From: Heikki Tuuri <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Sunday, January 06, 2002 7:54 AM Subject: Re: help with innodb my.ini config
>Hi! > >MySQL does not find your my.ini. > >Try renaming it to my.cnf and put it to the root directory of the C: drive >(assuming your MySQL installation as well as the operating system is on the >C: drive). > >Remove other my.ini or my.cnf files from your computer. > >If this does not help, use the defaults-file startup param: > >mysqld-max-nt --defaults-file=your_path_to_my_cnf --console --standalone > >Regards, > >Heikki > >-----Original Message----- >From: jds <[EMAIL PROTECTED]> >To: Heikki Tuuri <[EMAIL PROTECTED]> >Date: Sunday, January 06, 2002 12:41 AM >Subject: RE: help with innodb my.ini config > > >>heikki- >> >>so i did just that - now my.ini looks like this: >> >>#This File was made using the WinMySQLAdmin 1.3 Tool >>#12/21/2001 6:19:15 PM >>#innodb code added 1/5/2002 1550CST >> >>#Uncomment or Add only the keys that you know how works. >>#Read the MySQL Manual for instructions >> >>[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_data_home_dir= >># Data files must be able to >># hold your data and indexes >>innodb_data_file_path = c:/ibdata1:2000M;c:/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 >>[WinMySQLadmin] >>Server=C:/mysql/bin/mysqld-max-nt.exe >>user=u >>password=pw >> >>at the dos command, when i enter >> >>C:\mysql\bin>mysqld-max-nt --standalone >> >>i get >> >>cannot initialize InnoDB as 'innodb_data_file_path' is not set. >>if you do not want to<clip> >>if you want to use InnoDB tables, add, for example, >>innodb_data_file_path = /mysql/data/ibdata1:20M >><clip> >> >>so do i need to create these directories before i start mysqld-max-nt? >> >>i thought it created them- >> >> >>-----Original Message----- >>From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] >>Sent: Saturday, January 05, 2002 3:54 PM >>To: [EMAIL PROTECTED] >>Subject: Re: help with innodb my.ini config >> >> >>Hi! >> >>Yes: >> >>innodb_data_home_dir= >> >>Heikki >> >>-----Original Message----- >>From: jds <[EMAIL PROTECTED]> >>To: Heikki Tuuri <[EMAIL PROTECTED]> >>Date: Saturday, January 05, 2002 11:37 PM >>Subject: RE: help with innodb my.ini config >> >> >>>by an empty string you mean >>> >>>innodb_data_home_dir = >>> >>>sorry, i'm still pretty new at this- >>> >>>thanks very much for your aid, >>> >>>jd >>> >>>-----Original Message----- >>>From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] >>>Sent: Saturday, January 05, 2002 3:18 PM >>>To: [EMAIL PROTECTED] >>>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, >>> >>>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 >> > --------------------------------------------------------------------- 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
