Re: help with innodb
Dobrý den, terça-feira, 19 de novembro de 2002, 23:10:11, napsal jste: PB> Hi, PB> I like to know if you can help me. I installed mysql-3.23.53-win.zip PB> which should have the Innodb feature as part of MySQL. However, I am PB> unable to create an Innodb database. The problem may be that one of my PB> variables which says "have_innodb" states that it is "Disabled". Do you PB> know how I can change this variable. PB> To let you know, I did have an earlier version of mysql on this system. PB> I have uninstalled it and installed the new version. PB> Any assistance you could give me would be greatly appreciated. PB> Kindly, PB> Peter Boivin The binary to execute on Windows NT to use InnoDB feature is the mysqld-max-nt.exe , after this, go to www.innodb.com/ibman.html and enable InnoDB in my.cnf options... to enable InnoDB change this param... innodb_data_file_path = ibdata1:300M innodb_data_home_dir = c:\mysql\data\ innodb_log_group_home_dir = c:\mysql\data\ innodb_log_arch_dir = c:\mysql\data\ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=15M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=2 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=6 set-variable = innodb_lock_wait_timeout=50 After this , only re-start the service ( with mysqld-max-nt.exe ) and try show variables like '%have%innodb%'; 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
Re: help with innodb
At 20:10 -0500 11/19/02, Peter Boivin wrote: Hi, I like to know if you can help me. I installed mysql-3.23.53-win.zip which should have the Innodb feature as part of MySQL. However, I am unable to create an Innodb database. The problem may be that one of my variables which says "have_innodb" states that it is "Disabled". Do you know how I can change this variable. Look for skip-innodb in one of your option files. If you find it, remove it and restart the server. To let you know, I did have an earlier version of mysql on this system. I have uninstalled it and installed the new version. Any assistance you could give me would be greatly appreciated. Kindly, Peter Boivin - 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
Re: help with innodb my.ini config
-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 >>if you want to use InnoDB tables, add, for example, >>innodb_data_file_path = /mysql/data/ibdata1:20M >> >> >>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 >>>
RE: help with innodb my.ini config
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 if you want to use InnoDB tables, add, for example, innodb_data_file_path = /mysql/data/ibdata1:20M so do i need to create these directories before i start mysqld-max-nt? i thought it created them...the man page on this is confusing to me. thanks in advance, 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? wou
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 uns
