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