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
help with innodb
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. 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
Help with InnoDB configuration
Hi. I need help with InnoDB configuration. - The machine is a 2 Pentium III 1000GHz, Memory 1G, 30GB SCSSI. - The operating system is FreeBSD 4.5. - The mysql server is 3.23.49 (using FreeBSD port). I read carefully section InnoDB in MySQL manual and set the innodb parameters as: # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:2000M innodb_data_home_dir = /mysql/ innodb_log_group_home_dir = /mysql/ innodb_log_arch_dir = /mysql/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=100M set-variable = innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=350M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Note: I use my-huge.cnf as my.cnf. I'm testing InnoDB against MyISAM. I have two databases with the same data one have MyISAM tables and the other InnoDB tables. The queries in MyISAM are faster than in InnoDB. The same query in MyISAM executes in 2:30 minutesand in InnoDB in 27:00 minutes. I think I must have some wrong in configuration. Thanks in advance. Iago. - 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
help with innodb my.ini config
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