InnoDB or BDB?
Hi all! I am currently developing a small pos (point of sale) application. The pos will run on linux and will use java and mysql. I best guess, is that only one client will access the db during normal operations. I would like to know wich, in your opinion, should be the best option to use. The pos application should handle some degree of integrity and transaction safe, both bdb and innodb offers this two things, sooo would you mind telling me what would you use? and why? =) Also, pointng me to some url where i can compare bdb vs. innodb functionality would be greatly appreciated =) Best Regards! PS: we will most probably use 4.1 -- |...| | _ _|Victor Medina M | |\ \ \| | _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_|_| /_/ \_\|Tel: +58-241-8507325 - ext. 325 | ||Cel: +58-412-8859934 | ||geek by nature - linux by choice | |...| -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't stratup InnoDB and BDB for Max 4.0
Dear people, I have a problem with getting InnoDB and BDB to work. I use mySQL Max 4.0. I have even made sure that the skip-BDB and skip-InnoDB lines in the configuration .xml file are commented out. But still the 'variables' list in the winmysqladmin shows haveInnoDB and haveBDB as no. I really need them as I need to use FOREIGN KEY constraints and later even, transactions in my project. I tried using FOREIGN KEY contraint for 'ON DELETE' and expectedly it did not work. Can anyone please guide me as to how to set up InnoDB and BDB to work properly? Thanks, Paul - 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: Can't stratup InnoDB and BDB for Max 4.0
Paul, - Original Message - From: Paul Varkey [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, October 02, 2002 1:41 PM Subject: Can't stratup InnoDB and BDB for Max 4.0 Dear people, I have a problem with getting InnoDB and BDB to work. I use mySQL Max 4.0. I have even made sure that the skip-BDB and if you are running on Windows, I think some 4.0.x versions for Windows had the error that InnoDB was not compiled into mysqld.exe or mysqld-nt.exe. You have to use mysqld-max.exe or mysqld-max-nt.exe. All these are in the bin dir of the installation. Start from the MS-DOS prompt first so that you see what it prints: C:\mysql\bin mysqld-max --console After becoming familiar with the command line startup, you can try installing mysqld-max-... as a service, as explained in the manual. skip-InnoDB lines in the configuration .xml file are commented out. But still the 'variables' list in the winmysqladmin shows haveInnoDB and haveBDB as no. I really need them as I need to use FOREIGN KEY constraints and later even, transactions in my project. I tried using FOREIGN KEY contraint for 'ON DELETE' and expectedly it did not work. Can anyone please guide me as to how to set up InnoDB and BDB to work properly? Thanks, Paul 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 sql query - 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 or BdB
Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have now so it should come through ;) hihi I just discovered the power of transactions in databases and was wondering, which table type is better; BdB or InnoDB ? and if one is better than the other, why is it? Does BdB also support referential ingegrity as InnoDB does? Also, I was wondering what SIGNED or UNSIGNED integer are .. really don't have a clue about it :D That were some questions I was wondering about .. Greetz, Wouter -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. - 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 or BdB
Salutations. 1: I personally use InnoDB. I think Bdb tables were the first with transactions but I don't see a lot of people talking about using them these days. Also, InnoDB is being activly developed and between sleeping, eating and coding, Heikki answers questions here! :) 2: Signed integers can have a + or an - in front of them. (The + is implied, you don't actually see it) Because that takes up a bit, it means that signed integers represent smaller numbers than unsigned. Unsigned integers can represent larger numbers. (Ok, I'm over simplifying here but work with me) There is a limit on both types as to how big of a number they can store...check the docs. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Wouter van Vliet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 2:06 PM To: MySQL Mailinglist Subject: InnoDB or BdB Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have now so it should come through ;) hihi I just discovered the power of transactions in databases and was wondering, which table type is better; BdB or InnoDB ? and if one is better than the other, why is it? Does BdB also support referential ingegrity as InnoDB does? Also, I was wondering what SIGNED or UNSIGNED integer are .. really don't have a clue about it :D That were some questions I was wondering about .. Greetz, Wouter -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. - 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 or BdB
Hello, My perception of the InnoDB vs BDB question is that although the BDB is very impressive and long standing, it does not get the same level of attention that InnoDB seems to get from the good folks at MySQL AB. If I am not mistaken, BDB does not yet offer foreign key support. I have chosen InnoDB instead of BDB and have not been disappointed so far. A signed interger is one that can accept both positive and negative values. Because storing the sign of a number uses one bit, and unsigned interger can hold a larger positve value than an unsigned integer. For example, given a 16 bit interger, the maximum value for an unsigned is 2^16, and 2^15 for the signed version. Regards, Michael --- Wouter van Vliet [EMAIL PROTECTED] wrote: Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have now so it should come through ;) hihi I just discovered the power of transactions in databases and was wondering, which table type is better; BdB or InnoDB ? and if one is better than the other, why is it? Does BdB also support referential ingegrity as InnoDB does? Also, I was wondering what SIGNED or UNSIGNED integer are .. really don't have a clue about it :D That were some questions I was wondering about .. Greetz, Wouter -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. - 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 __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.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: Newbie question: Which is better InnoDB or BDB?
Hello. On Thu, May 23, 2002 at 11:53:49AM -0400, [EMAIL PROTECTED] wrote: Hello, I'm new to MySql. I plan to switch my Java/JDBC web application to use MySql. The application requires transactions so, as I understand it, I need the table types to be BDB or InnoDB. Can anyone offer comments on which file type is preferred? Is one more stable than another? InnoDB is more actively supported. Is there a significant difference in speed? Answers to such statements always depend on your kind of usage. I have looked in the manual. One difference I saw was page locking versus record locking. At this point, I'm not sure that difference is significant. That's the point. As long as you are not sure about your needs, there is no reason to bother. Just start with the table type which looks nicer to you at first glance. If you should learn that it doesn't fit your needs, the other table types are only one ALTER TABLE command away. Regards, Benjamin. -- [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
Newbie question: Which is better InnoDB or BDB?
Hello, I'm new to MySql. I plan to switch my Java/JDBC web application to use MySql. The application requires transactions so, as I understand it, I need the table types to be BDB or InnoDB. Can anyone offer comments on which file type is preferred? Is one more stable than another? Is there a significant difference in speed? I have looked in the manual. One difference I saw was page locking versus record locking. At this point, I'm not sure that difference is significant. Thanks for any comments. Rick - 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 or BDB ON DELETE RESTRICT
If I create a table like this: CREATE TABLE depts ( ID Int AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) ) TYPE=InnoDB; I add three Records to this table. THen I create this other table: CREATE TABLE employees( ID INT AUTO_INCREMENT PRIMARY KEY, name varchar(20), dept_id INT, FOREIGN KEY (dept_id) REFERENCES depts(ID) ON DELETE RESTRICT ) TYPE=InnoDB; Then I add 2 records to this table, one with value 1 on dept_id field and the other with value 2. I want: If I attempt to delete Record with ID 1 on table depts, that MySQL don't allows me to do so, or that it updates the records at table employees to be deleted or updated to value 2 on the field dept_id. i have InnoDB and BDB working on the System, but I don't know how to do this, every time I delete from table depts, nothing happens at the records at table employees, no warnings, no nothing. Any Idea ? I'm Using MySQL Max 4.0.1 on RedHat Linux Regards Yurais - 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
GEMNI,InnoDB and BDB
Any thoughts on the best support of transactional/ACID attributes for db tables in MySQL? Thank You, Anthony - 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