InnoDB, BDB
Hello, This question is probably repeated each week, but I am an absolute beginner with MySQL. Sorry for that. I've installed the precompiled binaries for Win, and I am very satisfied with MySQL. The only thing I couldn't find is support for transactions, although it was written in the documentation that support for BDB and InnoDB table types is activated in precompiled binaries. Is there something I've missed to configure (I've configured the necessary innodb_data_file_path and innodb_data_home_dir for InnoDB) or do I have to recompile MySQL with support for BDB and InnoDB activated? I've tried mysqld-max-nt and mysqld-max, but have_bdb and have_innodb variables were 'NO'. I use version 3.23.49. Thanks! Samim - 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: InnoDB, BDB
Samim, - Original Message - From: Samim [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, April 22, 2002 11:31 AM Subject: InnoDB, BDB Hello, This question is probably repeated each week, but I am an absolute beginner with MySQL. Sorry for that. I've installed the precompiled binaries for Win, and I am very satisfied with MySQL. The only thing I couldn't find is support for transactions, although it was written in the documentation that support for BDB and InnoDB table types is activated in precompiled binaries. Is there something I've missed to configure (I've configured the necessary innodb_data_file_path and innodb_data_home_dir for InnoDB) or do I have to recompile MySQL with support for BDB and InnoDB activated? I've tried mysqld-max-nt and mysqld-max, but have_bdb and have_innodb variables were 'NO'. I use version 3.23.49. the following manual section is a guide to creating an InnoDB database. If you have already installed mysqld... as a service, stop the service from the Control Panel of Windows. Start mysqld-max.exe from an MS-DOS prompt as instructed below. Best 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 [mysqld] # You can write your other MySQL server options here # ... # 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=70M 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 Note that InnoDB does not create directories: you have to create them yourself. Use the Unix or MS-DOS mkdir command to create the data and log group home directories. Check also that the MySQL server has the rights to create files in the directories you specify. Note that data files must be 2G in some file systems! The combined size of data files must be = 10 MB. The combined size of the log files must be 4G. If you do not specify innodb_data_home_dir, then the default is that InnoDB creates its data files to the datadir of MySQL. Then you cannot use absolute file paths in innodb_data_file_path. When you the first time create an InnoDB database, it is best that you start the MySQL server from the command prompt. Then InnoDB will print the information about the database creation to the screen, and you see what is happening. See below in section 3 what the printout should look like. For example, in Windows you can start mysqld-max.exe with: your-path-to-mysqldmysqld-max --standalone --console Where to put my.cnf or my.ini in Windows? The rules for Windows are the following: Only one of my.cnf or my.ini should be created. The my.cnf file should be placed in the root directory of the drive C:. The my.ini file should be placed in the WINDIR directory, e.g, C:\WINDOWS or C:\WINNT. You can use the SET command of MS-DOS to print the value of WINDIR. If your PC uses a boot loader where the C: drive is not the boot drive, then your only option is to use the my.ini file. Thanks! Samim - 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
Re: InnoDB, BDB
Samim, Monday, April 22, 2002, 11:20:48 AM, you wrote: S This question is probably repeated each week, but I am an absolute beginner S with MySQL. Sorry for that. I've installed the precompiled binaries for Win, S and I am very satisfied with MySQL. The only thing I couldn't find is S support for transactions, although it was written in the documentation that S support for BDB and InnoDB table types is activated in precompiled binaries. S Is there something I've missed to configure (I've configured the necessary S innodb_data_file_path and innodb_data_home_dir for InnoDB) or do I have to S recompile MySQL with support for BDB and InnoDB activated? I've tried S mysqld-max-nt and mysqld-max, but have_bdb and have_innodb variables were S 'NO'. I use version 3.23.49. You should install MySQL-Max for InnoDB and BDB tables support, you can read about mysqld-max at: http://www.mysql.com/doc/m/y/mysqld-max.html If you want to use InnoDB tables you must specify startup options in my.cnf file. You can find examples and info about configuration parameters at: http://www.mysql.com/doc/I/n/InnoDB_start.html S Thanks! S Samim -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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: InnoDB, BDB, and Gemini
On Fri, May 11, 2001 at 11:39:32AM -0700, Eric J. Schwertfeger wrote: Aside from what's in the manual, I have a little to offer. I just got InnoDB working yesterday, so take what I have to say with a grain of salt. And I'll add a bit, too. :-) Gemini: Currently in Beta testing, with no source code available. The code *was* in the MySQL bitkeeper repository at one point. I thought it still was. You might be able to get in on the beta program. I did, I figured we could test it using Linux emulation on FreeBSD. Boy, was I wrong. Not blaming NuSphere, however. I was just quite surprized when the remote install hung. After going into the area with the server, I found that some part of the install had triggered a halt on the server. Yuck. Yes, I was also hoping for FreeBSD support. But NuSphere needs to see significant demand for it. On the other hand, once it's released and the source code is there, making it work on FreeBSD might not be a huge chore. It already runs on Solaris, Linux, and Windows, right? :-) InnoDB: Some little voice inside my head is saying it's too good to be true. I wrote a program to take about a months worth of our live data (750K records) and stuff it into a database with a perl script via DBI. InnoDB ran about 50% faster than MyISAM, and about 18 *TIMES* faster than PostgreSQL. I wasn't expecting InnoDB to be faster than MyISAM, since InnoDB is transactional and MyISAM isn't, which is one of the reasons everyone uses to explain why (and when) MySQL is faster than PostgreSQL. InnoDB is pretty impressive, isn't it?! A few other differences: Gemini doesn't support BLOBs, and InnoDB is limited to 8000 byte BLOBs. Gemini is limited to 2G tables, and I'm not sure about InnoDB. You can have multiple InnoDB files, but I don't know if a table has to reside entirely in one file. Gemini's BLOB support was supposedly just implemented. I'm told it'll be part of the next beta cycle (roughly a week fro now, or so?). Gemini also has smaller maximum key sizes than MyISAM tables. This was a big issue for us, but they're working on removing that limitation. And the table size limits aren't supposed to be an issue much longer, either. Come to think of it, I know the recovery log had that limit, but I didn't think/know the tables did. I thought that was purely an OS issue--as it is with MyISAM. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 130 days, processed 803,952,600 queries (71/sec. avg) - 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
InnoDB, BDB, and Gemini
I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback, etc.). I am leaning toward InnoDB at this point but was wondering if anyone could offer any information, other than what is in the manual, regarding the pros and cons of these table types. TIA Kevin McBrearty ATG Automation Technologies Group Ltd. - 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: InnoDB, BDB, and Gemini
InnoDB definately provides more features that BDB, and is probably going to be faster, Gemini isn't available yet. BDB might be more complete/stable. So I'd say Gemini is out of the picture unless you are looking longer term. I'd do some testing with both we found some bugs in the 3.23.37 distribution with regard to BDB, Monty sais they are fix in .38 Kevin McBrearty wrote: I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback, etc.). I am leaning toward InnoDB at this point but was wondering if anyone could offer any information, other than what is in the manual, regarding the pros and cons of these table types. TIA Kevin McBrearty ATG Automation Technologies Group Ltd. - 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
RE: InnoDB, BDB, and Gemini
Goodday to you all Gemini tables are busy being beta tested, and therefore are available. I personally use them and so far so good. I really love having row level locking in MYSQL, and it works like a dream. contact www.nusphere.com for more info. There are currently running with 3.23.36 Enjoy Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Steve Ruby Sent: 11 May 2001 06:10 To: Kevin McBrearty; [EMAIL PROTECTED] Subject: Re: InnoDB, BDB, and Gemini InnoDB definately provides more features that BDB, and is probably going to be faster, Gemini isn't available yet. BDB might be more complete/stable. So I'd say Gemini is out of the picture unless you are looking longer term. I'd do some testing with both we found some bugs in the 3.23.37 distribution with regard to BDB, Monty sais they are fix in .38 Kevin McBrearty wrote: I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback, etc.). I am leaning toward InnoDB at this point but was wondering if anyone could offer any information, other than what is in the manual, regarding the pros and cons of these table types. TIA Kevin McBrearty ATG Automation Technologies Group Ltd. - 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 - 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: InnoDB, BDB, and Gemini
Have you noticed a significant speed decline using Gemini tables? RH -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:31 AM To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED] Subject: RE: InnoDB, BDB, and Gemini Goodday to you all Gemini tables are busy being beta tested, and therefore are available. I personally use them and so far so good. I really love having row level locking in MYSQL, and it works like a dream. contact www.nusphere.com for more info. There are currently running with 3.23.36 Enjoy Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Steve Ruby Sent: 11 May 2001 06:10 To: Kevin McBrearty; [EMAIL PROTECTED] Subject: Re: InnoDB, BDB, and Gemini InnoDB definately provides more features that BDB, and is probably going to be faster, Gemini isn't available yet. BDB might be more complete/stable. So I'd say Gemini is out of the picture unless you are looking longer term. I'd do some testing with both we found some bugs in the 3.23.37 distribution with regard to BDB, Monty sais they are fix in .38 Kevin McBrearty wrote: I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback, etc.). I am leaning toward InnoDB at this point but was wondering if anyone could offer any information, other than what is in the manual, regarding the pros and cons of these table types. TIA Kevin McBrearty ATG Automation Technologies Group Ltd. - 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 - 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
RE: InnoDB, BDB, and Gemini
In all honesty, I have personally not done any testing of Gemini v.s. other types as yet. I am busy converting my app from MS Access to MYSQL, once this is finished I will then be in a better position to answer this as I can test it. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: Robert Henkel [mailto:[EMAIL PROTECTED]] Sent: 11 May 2001 06:37 To: '[EMAIL PROTECTED]'; 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED] Subject: RE: InnoDB, BDB, and Gemini Have you noticed a significant speed decline using Gemini tables? RH -Original Message- From: Warren van der Merwe [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:31 AM To: 'Steve Ruby'; 'Kevin McBrearty'; [EMAIL PROTECTED] Subject: RE: InnoDB, BDB, and Gemini Goodday to you all Gemini tables are busy being beta tested, and therefore are available. I personally use them and so far so good. I really love having row level locking in MYSQL, and it works like a dream. contact www.nusphere.com for more info. There are currently running with 3.23.36 Enjoy Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Steve Ruby Sent: 11 May 2001 06:10 To: Kevin McBrearty; [EMAIL PROTECTED] Subject: Re: InnoDB, BDB, and Gemini InnoDB definately provides more features that BDB, and is probably going to be faster, Gemini isn't available yet. BDB might be more complete/stable. So I'd say Gemini is out of the picture unless you are looking longer term. I'd do some testing with both we found some bugs in the 3.23.37 distribution with regard to BDB, Monty sais they are fix in .38 Kevin McBrearty wrote: I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback, etc.). I am leaning toward InnoDB at this point but was wondering if anyone could offer any information, other than what is in the manual, regarding the pros and cons of these table types. TIA Kevin McBrearty ATG Automation Technologies Group Ltd. - 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 - 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
Re: InnoDB, BDB, and Gemini
On Fri, 11 May 2001, Kevin McBrearty wrote: I have re-read the appropriate manual sections several times, trying to decide what is the best option for my database table types. I am using 3.32.37 on Linux, and am torn between InnoDB, BDB, and Gemini table types. Transaction handling is very important for my application (commit, rollback, etc.). I am leaning toward InnoDB at this point but was wondering if anyone could offer any information, other than what is in the manual, regarding the pros and cons of these table types. Aside from what's in the manual, I have a little to offer. I just got InnoDB working yesterday, so take what I have to say with a grain of salt. BDB: I've worked with Berkley DB files (ver 1.8 and 2.? directly from C, not through MySQL) for several years at work, and they're rather fast for small databases, but the speed (for mixed inserts/lookups) drops off fast when you start getting past 10K records. By the time you've reached 100K records, you're running at 1/10th the speed you were at 1K records. For the tests I was doing, BDB was the one MySQL table type that ran slower than PostgreSQL (7.1.1) for 250K inserts, and dramatically slower than all others for selects that didn't involve an index. I didn't even run the rest of the tests. Gemini: Currently in Beta testing, with no source code available. You might be able to get in on the beta program. I did, I figured we could test it using Linux emulation on FreeBSD. Boy, was I wrong. Not blaming NuSphere, however. I was just quite surprized when the remote install hung. After going into the area with the server, I found that some part of the install had triggered a halt on the server. InnoDB: Some little voice inside my head is saying it's too good to be true. I wrote a program to take about a months worth of our live data (750K records) and stuff it into a database with a perl script via DBI. InnoDB ran about 50% faster than MyISAM, and about 18 *TIMES* faster than PostgreSQL. I wasn't expecting InnoDB to be faster than MyISAM, since InnoDB is transactional and MyISAM isn't, which is one of the reasons everyone uses to explain why (and when) MySQL is faster than PostgreSQL. I'm not claiming that is a fair comparison, as I'm doing more comparisions, and won't decide until I've crammed an entire years worth of data through both databases, including all necessary deletions/purges/lookups, etc, and it could be that the problem with PostgreSQL was the Pg DBI interface. A few other differences: Gemini doesn't support BLOBs, and InnoDB is limited to 8000 byte BLOBs. Gemini is limited to 2G tables, and I'm not sure about InnoDB. You can have multiple InnoDB files, but I don't know if a table has to reside entirely in one file. - 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
How Stable is InnoDB / BDB
I am in the process of building a database/php app that is going to require transaction support. Which table type should I go with? BerkeleyDB or Innobase?? It looks like the InnoDB has some neat features like row-level locking, etc. but is it stable enough for a production system, or should it be considered Alpha?? Thanks! Patrick - 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