RE: transaction support
Hi Chris, My apologies, I didn't correctly explain what I was looking for. I mean more of a solution to creating a client program. I'm thinking of php-gtk but not sure how well this works under windows, especially for printing reports. Thanks, Bryan On Sat, 17 Jan 2004, Chris Nolan wrote: Hmm...have you looked at Rekall? www.total-rekall.co.uk Also, you might want to check out OpenOffice.org's database interface features Regards, Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
I wanted to thank everyone for their responses and information regarding this. I apologize, I thought I had already replied. Anyhow, I proved my point to our software guy, enough that he is willing to look into it further. Although I have a feeling he isn't going to want to do it (but at least he sees what MySQL can do) so I'll probably be trying to do it myself. So if anyone knows of a way to get a full interface under windows (that can print nice invoices) and has a direct brain-input for learning, let me know :) Thanks again, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
Hmm...have you looked at Rekall? www.total-rekall.co.uk Also, you might want to check out OpenOffice.org's database interface features Regards, Chris On Sat, 2004-01-17 at 11:12, Bryan Koschmann - GKT wrote: I wanted to thank everyone for their responses and information regarding this. I apologize, I thought I had already replied. Anyhow, I proved my point to our software guy, enough that he is willing to look into it further. Although I have a feeling he isn't going to want to do it (but at least he sees what MySQL can do) so I'll probably be trying to do it myself. So if anyone knows of a way to get a full interface under windows (that can print nice invoices) and has a direct brain-input for learning, let me know :) Thanks again, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Direct your developer to www.vbmysql.com. This site is dedicated to supporting developers who want to use MySQL with VB. We will be happy to help him with anything he runs into while writing your system for you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[2]: transaction support
[MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION DK It depends why step 3 failed. DK If you want to rollback the transaction to the beginning on any error, DK you simply use an 'on error' statement in VB to trap the error, and send DK a rollback command when the error is detected. And what if the server lost connection with client computer ? there must be automatic rollback after certain 'time-out' period Data integrity logic should be ensured by client application (when to call 'start transaction' and when to call 'commit'), the server task is to ensure that logic - i.e. that at any given moment users see the database in integrity state and not at some point within transaction processing. If user has not commited transaction the database integrity state is still at the point before start transaction was called. Not user but server is responsible for rolling back not commited transactions, user can only help relief the server from major part of this problem by trying to rollback as many failed transactions as he can. however user cannot be responsible for rolling back all the transactions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re[3]: transaction support
correction: D Data integrity logic should be ensured by client application should be read as: Data integrity logic should be defined by client application -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re[2]: transaction support
Quoting DeBug [EMAIL PROTECTED]: [MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION DK It depends why step 3 failed. DK If you want to rollback the transaction to the beginning on any error, DK you simply use an 'on error' statement in VB to trap the error, and send DK a rollback command when the error is detected. And what if the server lost connection with client computer ? there must be automatic rollback after certain 'time-out' period Data integrity logic should be ensured by client application (when to call 'start transaction' and when to call 'commit'), the server task is to ensure that logic - i.e. that at any given moment users see the database in integrity state and not at some point within transaction processing. If user has not commited transaction the database integrity state is still at the point before start transaction was called. My $0.02 I have to disagree - especially when money is involved. To have the client define, check data integrity, and manipulate data in the database is just asking for trouble. Call me paranoid, but to trust a client in a non-secure environment to directly access and manipulate the database is just asking for a reverse-engineered attack against the database where the data will be compromised. At the very least, you are sending out database connectivity information out with the client that can be stolen and used to access the database. Given the means and the business necessity, I feel that having some sort of middleware on a secured server to validate data and communicate with the database is a much more secure methodology. This is a trivial piece of middleware to write, but can add a much needed layer of security to transactions. Let the secure server hosted middleware host the database connections and let the client talk to the middleware. Not user but server is responsible for rolling back not commited transactions, user can only help relief the server from major part of this problem by trying to rollback as many failed transactions as he can. however user cannot be responsible for rolling back all the transactions -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Morten Gulbrandsen wrote: http://www.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8q=MySQL+toy+marston Subject: Re: Can MySQL table handle 3 million+ entries? Newsgroups: comp.lang.php Date: 2003-04-11 15:20:10 PST MySQL is NOT a toy database - it is far superior to many I have used in my long career. The lack of constraints is NOT a weakness. It is eminently possible to create reliable applications without the need for database constraints - I should know because I have designed and built many applications that did not use database constraints (mainly because they were not available). Developers only rely on database constraints to circumvent their sloppy code. Anything that can be done within the database can also be done within application code. As an application developer, I don't trust employees (including myself) to enter the data correctly and hence don't let it pass unchecked but validate it in the application layer. I belief that is a rather common mindset amongst application developers, which matches best practice recommendations: http://www-106.ibm.com/developerworks/library/l-sp2.html As a database administrator, why should I trust application developers (including myself) to validate the data correctly and let the data pass unchecked? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
At 09:37 PM 1/5/2004, Bryan Koschmann - GKT wrote: Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still buggy -MyODBC is buggy and not used in production environments -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan I have previously used Borland's Delphi for various programs I needed to write in the M$ environment. This program was very solid and had very good ODBC support. While it has been awhile since I used it (version 2.0, they are now at or beyond 6.0) I have had many individuals claim that the Borland programming languages/compilers are the best and most stable compilers running under M$ Windows. Borland has various Visual programming languages available. you might want to suggest your programming try one of Borland's programs over the MS programs, if you really don't care to use M$ products. When I am forced to use M$ platform, I use every means at my disposal to use non-M$ products to accomplish the job. I use Apache for Web Servers, Perl for Web Scripting, ColdFusion for dynamic web sites accessing various DBs, Bind for DNS, MySQL for all new DBs, etc. For those of us that prefer to not use M$, but are forced to use the OS, I always try my best to make sure I can at least program in something other than MS. Whenever I am forced to program using a M$ compiler, I always add a line to all agreements, that code broken is not the fault of the programmer, but rather the fault of M$ and their constant change in procedures, compilers, and bugs. I have never heard and programmer who uses M$ C Compiler ever say they have had there program work right and stay working after each and every patch, or upgrade of the M$ compiler and operating system. Most programmers who use M$ C compiler constantly complain they must write code that works around a bug in the compiler or OS, only to have to rewrite the code after M$ tries to fix their bug. Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
transaction support
Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still buggy -MyODBC is buggy and not used in production environments -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Bryan Koschmann - GKT wrote: Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support InnoDB tables have transaction support. -MySQL is still buggy No it's not. That's a bit of a nebulous claim. -MyODBC is buggy and not used in production environments Not for us. We've been using it in a production environment for 4 years with no issues. -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL Absolute bulldust. The drivers are free, and not 3rd party drivers, but developed by MySQL, alongside the server product. It sounds like you have a stubbord software developer on your hands who doesn't want to use anything other than M$ toys. I suggest you get another software developer, or at least threaten to. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
Bryan, Although this doesn't answer your initial request...why are you wanting to 'argue' with this guy over the database to use. If he won't code for the application to use MySQL (which isn't all that hard in VB regardless of what he says) then get another coder...as simple as that. There's a plethora of coding contractor sites out there any of which probably have a good base of coders with the skills you need capable of coding your software using VB and MySQL. Craig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
On Jan 5, 2004, at 9:37 PM, Bryan Koschmann - GKT wrote: -No explicit transactional support Wrong. InnoDB tables support transactions. -MySQL is still buggy Care to have him specify what bugs he is referring to? I've been using MySQL for 2 years now, and use Microsoft SQL Server for about 3 years before that. I ran into some MSSQL bugs, but have yet to run into anything more than documentation bugs in MySQL. -MyODBC is buggy and not used in production environments There are some problems with MyODBC when used with some Microsoft products. The cynic in me feels that Microsoft deliberately creates these bugs, since I've used the exact same ODBC drivers with non-Microsoft products without a problem. I've used the MyODBC drivers in productions apps with Microsoft Visual FoxPro as the front end for over a year now, and have yet to have a problem. -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL See above. This is a total crock. Overall, sounds more like he is comfortable with Microsoft SQL Server, and is fabricating these arguments as excuses he can use to stay in his comfort zone. As a consultant myself, I would be very suspicious of anyone who tailors a solutions to his needs instead of yours. I'd not only consider using MySQL, I'd consider looking for a different developer. ___/ / __/ / / Ed Leafe Linux Love: unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
On Mon, 5 Jan 2004, Craig Vincent wrote: Although this doesn't answer your initial request...why are you wanting to 'argue' with this guy over the database to use. If he won't code for the application to use MySQL (which isn't all that hard in VB regardless of what he says) then get another coder...as simple as that. There's a plethora of coding contractor sites out there any of which probably have a good base of coders with the skills you need capable of coding your software using VB and MySQL. Craig (and others) It's a good question and implied by Daniel as well. I should have stated the reason in the beginning. The coder is not only an old employee but a good friend as well, and basically writes the software in exchange for discounts on computer parts. While he is set on M$ stuff, he has always been open to MySQL to a point. The problem is he is perfectly comfortable with M$ products and just doesn't see the need to look at MySQL. Here is the explanation I just received when asking for the difference between transaction support: - MySQL uses single-action implicit and explicit transactions, but they do not automatically roll back on failure. SQL Server user single action implicit and batch explicit transactions as well as supporting transaction nesting (transactions inside of parent transactions) and on failure the entire batch and any parent / peer transactions are rolled back. EXAMPLE (bank transfer): [SqlServer] 1: BEGIN TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 due to an error, every change would be undone including the withdrawal and everything would be ok. The transaction could be retried later. [MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 the transaction would be hung and even if rolled back by server admin the money would still be gone from account 32146 --- Is this actually correct, or is it correct but there is a different way to do this with MySQL? Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Well, I think this statement does it all, http://www.google.com/groups?hl=enlr=ie=UTF-8oe=UTF-8q=MySQL+toy+marston Subject: Re: Can MySQL table handle 3 million+ entries? Newsgroups: comp.lang.php Date: 2003-04-11 15:20:10 PST MySQL is NOT a toy database - it is far superior to many I have used in my long career. The lack of constraints is NOT a weakness. It is eminently possible to create reliable applications without the need for database constraints - I should know because I have designed and built many applications that did not use database constraints (mainly because they were not available). Developers only rely on database constraints to circumvent their sloppy code. Anything that can be done within the database can also be done within application code. I have seen what happens when poor programmers try to shift logic from their code into the database - they get it wrong and then blame the database for their incompetence. I am used to designing and building applications without relying on database 'features', so I write my code accordingly. It also means that the logic is maintained in one place and not it bits and pieces here and there. Tony Marston http://www.tonymarston.co.uk/php-mysql/index.html some advantage does MySQL have, Rock stable, fast, good support, I got much respone from a comparison about what other developers feel here, http://groups.google.com/groups?q=mysql+gulbrandsen+rdbmshl=enlr=ie=UTF-8oe=UTF-8selm=60ca69db.0308210016.822e230%40posting.google.comrnum=1 Yours sincerely Morten Gulbrandsen - Original Message - From: Bryan Koschmann - GKT [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:37 AM Subject: transaction support Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still buggy -MyODBC is buggy and not used in production environments -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Bryan Koschmann - GKT [EMAIL PROTECTED] [2004:01:05:18:58:12-0800] scribed: snip / Here is the explanation I just received when asking for the difference between transaction support: - MySQL uses single-action implicit and explicit transactions, but they do not automatically roll back on failure. SQL Server user single action implicit and batch explicit transactions as well as supporting transaction nesting (transactions inside of parent transactions) and on failure the entire batch and any parent / peer transactions are rolled back. http://www.mysql.com/doc/en/InnoDB.html http://www.mysql.com/doc/en/InnoDB_Deadlock_detection.html http://www.mysql.com/doc/en/Error_handling.html hth -- Best Regards, mds mds resource 877.596.8237 - Dare to fix things before they break . . . - Our capacity for understanding is inversely proportional to how much we think we know. The more I know, the more I know I don't know . . . -- pgp0.pgp Description: PGP signature
Re: transaction support
Bryan Koschmann - GKT wrote: [MySQL] 1: START TRANSACTION 2: WITHDRAW $50 from account 32146. 3: DEPOSIT $50 into account 12345. 4: LOG transfer (date/time/teller/etc...) for auditing. 5: COMMIT TRANSACTION if this failed at step 3 the transaction would be hung and even if rolled back by server admin the money would still be gone from account 32146 It depends why step 3 failed. Have a look at http://www.innodb.com/ibman.php#Error_handling If you want to rollback the transaction to the beginning on any error, you simply use an 'on error' statement in VB to trap the error, and send a rollback command when the error is detected. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: transaction support
Hi, I have been using MySQL since 3.2x and now 4.0.1x in Windows NT and Windows 2000 IIS / .asp environment including MyODBC for more than 4 years now, and never lost any data. Setup problems have been solved by reading and following instruction in the manual, or asking in the support / newsgroups. So, you can have a pricewise cheap database (remember to contribute to the company), with free worldwide support, or a expensive SQL server with only payable support - if you contribute the same amount to MySQL as to MS, you might probably (almost) get your personal supportline. Best regards Peter Copenhagen denmark - Original Message - From: Bryan Koschmann - GKT [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 3:37 AM Subject: transaction support Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support -MySQL is still buggy -MyODBC is buggy and not used in production environments -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: transaction support
Hi We have been running MySql since 1998 and have never had any data corruption We have servers running millions of queries a day and they are bullet proof. Hi, I'm trying to get a software designer to write us some software using MySQL as the database server (he currently requires MS SQL). It is all windows based software (written in VB). So far his arguments against it are this (not my words): -No explicit transactional support wrong http://www.mysql.com/doc/en/ANSI_diff_Transactions.html -MySQL is still buggy wrong MySql code audit showed it was 6 times less buggy than most commercial software http://www.reasoning.com/newsevents/pr/12_15_03.html just whisper the word 'slammer' in his ear and see what response you get :) -MyODBC is buggy and not used in production environments don't know - we use php, but I have used MyODBC occasionally without problems -Only way to connect using ODBC is third party drivers that cost over half as much as MS SQL wrong MyODBC is available under GPL http://www.mysql.com/products/myodbc/index.html unless you sell your software in which case licence fees may be due, but they are very reasonable. HTH Peter This is just for our current software, the new software he is bidding on says he would use .NET so that supposedely causes other problems. Now, I know there are a few discrepancies there but I just don't know enough to argue it. I * need* to use MySQL as the server because of cost reasons. I *WANT* to use MySQL because I don't care for MS choose not to run their products. If you can give me any information to help me argue this I would really appreciate it. Thanks, Bryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
oledb provider with transaction support?
i downloaded oledb provider from mysql.com, i use Delphi's ADO. but i found that this oledb provider does not support transaction. is there any oledb provider that does support transaction? thanks
Transaction support
Hi, Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction support
# [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction support
# [EMAIL PROTECTED] / 2003-06-24 12:29:33 +0200: # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? # [EMAIL PROTECTED] / 2003-06-24 04:00:02 -0700: Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? Yes mysql supports transactions ... they only work on innodb bdb and gemini table types # [EMAIL PROTECTED] / 2003-06-24 19:07:46 +0800: Hello, Roman Neuhauser, Install Innodb,mysql really has transaction,u may use java code with it or run sql statment directly in mysql. === At 2003-06-24, 12:29:00 you wrote: === # [EMAIL PROTECTED] / 2003-06-24 15:15:33 +0530: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Did you know MySQL has documentation? I have sent a followup to a post to this list, and received two off-the-list replies as if I had asked the original question instead of answering it. This is not the first time such thing has happened, and given this behavior is specific to this list I wonder whether MySQL attracts people with reading problems? -- If you cc me or remove the list(s) completely I'll most likely ignore your message.see http://www.eyrie.org./~eagle/faqs/questions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction support
Palaparthy [EMAIL PROTECTED] wrote: Does MYSQL support transaction concept, which includes issues like commiting data , rollbacking etc??? Yes. http://www.mysql.com/doc/en/ANSI_diff_Transactions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction Support with MyISAM
On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote: Dear Friends, The last help I got was truly worth a zillion. Such a bargin! 1. How can i have commit/rollback functions using MyIsam database which is default database engine for MySql? i am using vb You cannot. MyISAM tables are not transactional. BDB and InnoDB are. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 51 days, processed 1,775,767,802 queries (396/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Transaction Support with MyISAM
Mr. Zawodny is right MyISAM natively does not support Transactions, but Transactions can be done with a set of myISAM tables and a lot of code specific to supporting transactions w/o a race condition. Basically it's a long a tedious process of writing code to support a ticket server (a unique id for every row in any table separated out into a different table or database), then use this to simulate a commit and rollback. If you go this route (don't: use INNODB) you'll have to worry about race conditions, bugs etc. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 11:48 PM To: Nitin Nanivadekar Cc: [EMAIL PROTECTED] Subject: Re: Transaction Support with MyISAM On Wed, Mar 26, 2003 at 09:03:35PM -0800, Nitin Nanivadekar wrote: Dear Friends, The last help I got was truly worth a zillion. Such a bargin! 1. How can i have commit/rollback functions using MyIsam database which is default database engine for MySql? i am using vb You cannot. MyISAM tables are not transactional. BDB and InnoDB are. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.8: up 51 days, processed 1,775,767,802 queries (396/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Transaction support
Hello, I experiencing a problem I hope someone here can help with: I have several C-coded clients running and performing inserts and updates on a database. I would like to make sure that the -entire- client session is atomic. i.e. if a client dies in the middle of the computation (not uncommon) then all of the updates are rolled back. I take it I can do that by using InnoDB tables and transactions the problems: - the number of updates and inserts per client is large ~ 10,000 or so inserts/updates on many tables. I need ALL of them to be one single atomic operation. is there any limit on the size of a transaction. any way to increase such a limit? - if the client dies in the middle of the computation it obviously won't be able to issue an explicit rollback. what happens in this instance. is possible to set things up so that an automatic rollback takes place. - this might be tricky. but during most inserts my C program retrieves row ids (using mysql_insert_id() function. this id is then used in subsequent inserts. would that still work with transactions. i.e. without committing an insert to a table, what would mysql_insert_id return? - would performance with such large transactions be substantially degraded? this is rather important issue for me. I'd really appreciate any help in this regard. many thanks in advance Murad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Transaction Support with MyISAM
Dear Friends, The last help I got was truly worth a zillion. 1. How can i have commit/rollback functions using MyIsam database which is default database engine for MySql? i am using vb 2. is there any intelligent program (not ODBC/JDBC drivers anyway) available that can be run on a server provide a bridge between Myql client? it becomes necessary to have some stored procedure support using these tools. -Thanks -Nitin __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Transaction Support in mysql13.23.54
hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. I am connecting to the mysql database thru my java web-app. thank you in advance. regards, nirmal (23 jan 03) Go to this page: http://www.innodb.com/howtouse.html and have a look under: How to create tables in the InnoDB format. Basically you will at least have to specify this line in C:\WINDOWS\my.ini and restart your mysql-max server: innodb_data_file_path=ibdata1:30M All the best, Pål Arne Hoff - 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: Transaction Support in mysql13.23.54
Correct me if I am wrong, but I believe mysql 3.23.54 does not support transaction support, version 3.23.54 has row locking only. Transaction feature starts with version 4.0.x. Bob - Original Message - From: Nirmal Shah [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 7:56 PM Subject: Transaction Support in mysql13.23.54 hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. I am connecting to the mysql database thru my java web-app. thank you in advance. regards, nirmal (23 jan 03) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [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: Transaction Support in mysql13.23.54
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote: hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. You might check your connection to, I received a similar on a machine connecting through perl/DBI, and the problem was that the DBI package merely needed upgrading, mysql had been set up correctly. If your mysql really is set up right, you could verify this by trying to perform a transaction via command line. If it works there, it's your connection most likely. - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+MCoIA10/0O8cAHgRAgRWAKC1sZxyOoV+He8dZSe+vHbmTwlyMgCfVqrs c6+peQEq9/gIBwOxASBfYDk= =Y/8s -END PGP SIGNATURE- - 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: Transaction Support in mysql13.23.54
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Robert Tam wrote: Correct me if I am wrong, but I believe mysql 3.23.54 does not support transaction support, version 3.23.54 has row locking only. Transaction feature starts with version 4.0.x. Bob You're corrected :) 3.23.54 supports InnoDB which has transactions. The real question is, is what JDBC driver is giving the problems with 'No Transaction Support' It either must be a very old version of MM.MySQL or the JDBC-ODBC bridge. You should upgrade to MySQL Connector/J 3.0.x (Which is what MM.MySQL has become, now that I, the developer behind MM.MySQL am employed by MySQL AB). It supports transactions :) See http://www.mysql.com/products/connector-j/ -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+MFZFtvXNTca6JD8RArklAKCnRX99M+OiVYm0gclzJj+b5xeAiQCgkU0D Gz1lK5Yw1qSxK7/V6pK/Mpw= =kUJ5 -END PGP SIGNATURE- - 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: Transaction Support in mysql13.23.54
I had this problem with my new install on windows. In my case in turned out to be that the tables were not created as innoDB even though I had specified type=innoDB. I'm not sure why this happened but I fixed the problem by recreating the tables after I made sure that I have innoDB server running. I issued NET STOP MySQL to shut down the mysql server that was running and started mysqld-max-nt --console And then I recreated my tables with type=innoDB option and it worked. - Original Message - From: Jayce^ [EMAIL PROTECTED] To: Nirmal Shah [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 9:44 AM Subject: Re: Transaction Support in mysql13.23.54 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 22 January 2003 08:56 pm, Nirmal Shah wrote: hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. You might check your connection to, I received a similar on a machine connecting through perl/DBI, and the problem was that the DBI package merely needed upgrading, mysql had been set up correctly. If your mysql really is set up right, you could verify this by trying to perform a transaction via command line. If it works there, it's your connection most likely. - -- - --Jayce^ -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE+MCoIA10/0O8cAHgRAgRWAKC1sZxyOoV+He8dZSe+vHbmTwlyMgCfVqrs c6+peQEq9/gIBwOxASBfYDk= =Y/8s -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [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
Transaction Support in mysql13.23.54
hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. I am connecting to the mysql database thru my java web-app. thank you in advance. regards, nirmal (23 jan 03) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
transaction support in mysql3.23.54-win
hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i can use commit - rollback on mysql database tables. thank you in advance. regards, nirmal (04 jan 03) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
Reg. Transaction support
Hello All, I would like to know the some details regarding the transaction support in Mysql Version 4. May i know where can i find the related stuffs. Thanx in advance -- You feel a whole lot more like you do now than you did when you used to. Regards, Charitha - 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: Reg. Transaction support
Hello All, I would like to know the some details regarding the transaction support in Mysql Version 4. May i know where can i find the related stuffs. Transactions are supported in the current 3.23.53 release of MySQL-Max and MySQL 4 (Pro version I think) with the InnoDB table type. You will need to read up on the InnoDB table type (see http://www.mysql/doc). Basically you will need to create a my.cnf file to create some space for your InnoDB tables, then create tables in mysql with: CREATE TABLE mytable () TYPE=InnoDB; Then you can use transactions: BEGIN; INSERT INTO mytable ... ; UPDATE mytabe ... ; DELETE FROM mytable ... ; COMMIT; or ROLLBACK; www.mysql.com/doc and search for InnoDB or transaction! Have fun, Josh - 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
MySQL and MTS: Transaction Support
Has anyone tried to incorporate the Transaction Support of InnoDB Databases in MySQL to the setcomplete and setabort commands of Microsoft Transaction Server? Is it possible to do this? Thank you for your support. = Regor Vincent M. Nono Junior Programmer Content Sciences, Inc. SPI Bldg. Pascor Drv., Sto. Nino, Paranaque City __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! 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
Transaction Support Configuration
I have a managed dedicated server that was recently upgraded to MySQL version 3.23.51 in order to take advantage of transaction processing. However, when my script tries to turn off auto-commit, I receive this message... Transactions not supported by database. Are there any configuration settings that need to be defined for transaction processing to function? - 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
Transaction Support in MySQL
Hi, I am using MySQL 3.23.40 on LINUX Redhat 7.1 version. My application is an OLTP application and depends heavily on transactions. Since MySQL doesn't support transactions for the stable releases, is there any work around to solve this problem. Could any one help how to cope up without transactons in mysql. The Help manual provided with the software doesn't help a great deal. Regards Aravind For Stock Quotes, Finance News, Insurance, Tax Planners, Mutual Funds... Visit http://in.finance.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: Transaction Support in MySQL
Hi Arawind, Could any one help how to cope up without transactons in mysql. The Help manual provided with the software doesn't help a great deal. Oneway is to incorporte transaction processing functionalities in the middle layer application. eg. before commiting persistent objects used for backend database from mysql. Or if you are using php scripts, then modify the scripts for transaction functionalities before commiting the changes into mysql. -- Prabhu Regards Aravind For Stock Quotes, Finance News, Insurance, Tax Planners, Mutual Funds... Visit http://in.finance.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 --- Beauty is bought by judgement of the eye. -- Shakespeare --- Prabhu SR. Sankhya Technologies Private Limited, Chennai-34. --- - 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
Transaction Support
Hello As I understand it, MySQL with InnoDB or BDB support can support transactions. Is there a doc on the shortcomings of these tables and which one is better? MySQL documentation has a shortcomings page for InnoDB (but couldn't find one for BDB) http://www.mysql.com/doc/I/n/InnoDB_restrictions.html Any suggestions with which type to go with? What have been the experience with either/both? How does the future look for both? Both maintain log files to do rollbacks. Is this how PGSQL does this too? How do these tables compare to dbs with native transaction support (like Oracle, MSSQL, and PostgreSQL) ? Thanks - 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: Transaction Support
On Mon, Oct 22, 2001 at 11:14:58AM -0400, Victor wrote: Hello As I understand it, MySQL with InnoDB or BDB support can support transactions. Is there a doc on the shortcomings of these tables and which one is better? MySQL documentation has a shortcomings page for InnoDB (but couldn't find one for BDB) http://www.mysql.com/doc/I/n/InnoDB_restrictions.html Any suggestions with which type to go with? What have been the experience with either/both? How does the future look for both? The future looks very bright for InnoDB. It is faster and scales better than BDB, and it uses more granular locks. Both maintain log files to do rollbacks. Is this how PGSQL does this too? InnoDB uses a mult-versioning scheme, which is what PostreSQL does. So in that respect they're quite similar. How do these tables compare to dbs with native transaction support (like Oracle, MSSQL, and PostgreSQL) ? InnoDB was largely modeled after Oracle. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 46 days, processed 1,018,046,439 queries (253/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
Re: Not so good transaction support
What you are trying to perform is doable with InnoDB table handler. Unlike BDB, InnoDB has multi-versioning and consistent reads. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Not so good transaction support
1. Please explain the above in detail. It depends on the type of table you're using. If you're using a table type that only supports table-level locking, then each transaction is isolated by being suspended until the previous transaction is done. This is slower if you do a lot of longer transactions but quite safe. I think the only difference is functions(COMMIT, ROLLBACK) support. This is true, for some table types -- for others, you'll find things work as you expected -- see InnoDB or that other table type (Gemini :-). -- Michael T. Babcock http://www.fibrespeed.net/~mbabcock/ - 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
Not so good transaction support
Hi. I downloaded mysql 3.23.40 from www.mysql.com. This site announces that this mysql version supports transaction which was not supported in older mysql. I was so happy to find that. So I tested that support. The case was following. I launched two mysql - one in A terminal window and other in B terminal window. And I created the table using 'create table foodb (name char(20), email char(30)) type=BDB;' In A I entered the followings. mysqlset autocommit=0; mysqlbegin; mysqlinsert into foodb values('charley', '[EMAIL PROTECTED]'); it's just before enter COMMIT. After that, I entered the followings in B. mysqlselect * from foodb; In this case, B's mysql suspended. But B contiued to execute above SELECT query after I entered COMMIT in A. I think this is not true transaction. B's query should be able to be executed before A's COMMIT query. Oracle8(sqlplus) executes this situation correctly. Question. 1. Please explain the above in detail. 2. If the above situation is the transaction which mysql supports, what's difference between LOCK TABLE and TRANSACTION? I think the only difference is functions(COMMIT, ROLLBACK) support. 3. I think the above transaction causes the performance to be lowered which mysql is better than other RDBMS in. I want your explanation. Please answer to me as soon as possible because I must port my server application using oracle 8 into that using mysql. Thank you for reading and thanks in advance. my email address is mailto:[EMAIL PROTECTED]. Don't send to [EMAIL PROTECTED] please. - 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
Transaction Support in MySQL
What sort of support for transactions and table/record locking is there in MySQL right now? I had heard that only table locking was supported, and limited support for transactions. Aaron - 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: Transaction Support in MySQL
On Fri, 22 Jun 2001 15:17:18 -0700, Alberni-dot-Net Tech Mailing Lists [EMAIL PROTECTED] wrote: What sort of support for transactions and table/record locking is there in MySQL right now? I had heard that only table locking was supported, and limited support for transactions. we've had good success with MySQL w/Innobase for transaction usage. Mainly for development testing but so far so good,..we're happy with it. We use Perl w/DBI 1.18 and DBD::mysql Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - 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
mySql and trigger/transaction support
does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [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: mySql and trigger/transaction support
Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [EMAIL PROTECTED] RTFM 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: mySql and trigger/transaction support
MySQL supports transactions in beta form if you use a Berkley table. Check the homepage for more information. Triggers are in the todo pile though. At 09:44 AM 4/24/2001 -1000, Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [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 - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] If it is not right do not do it; if it is not true do not say it. - Marcus Aurelius - 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: mySql and trigger/transaction support
RTFM=Read The Fucking Manual now you know. On Tue, 24 Apr 2001 21:37:44 +0100 (BST) Peter Skipworth [EMAIL PROTECTED] wrote: I for one vote to not bother with abbreviations from now on - let's just spell it out loud and clear ;) *grin* P On Tue, 24 Apr 2001, Steve Ruby wrote: Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [EMAIL PROTECTED] RTFM 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 -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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: mySql and trigger/transaction support
Now gentlemen please let's use appropriate language when posting to the list, after all it is a public list and we don't want to offend anybody At 22:04 24/04/2001 +0100, Peter Skipworth wrote: Like duh! =) On Tue, 24 Apr 2001, Rene Tegel wrote: RTFM=Read The Fucking Manual now you know. On Tue, 24 Apr 2001 21:37:44 +0100 (BST) Peter Skipworth [EMAIL PROTECTED] wrote: I for one vote to not bother with abbreviations from now on - let's just spell it out loud and clear ;) *grin* P On Tue, 24 Apr 2001, Steve Ruby wrote: Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [EMAIL PROTECTED] RTFM 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 -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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 -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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 Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK ___/ - 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: mySql and trigger/transaction support
Like duh! =) On Tue, 24 Apr 2001, Rene Tegel wrote: RTFM=Read The Fucking Manual now you know. On Tue, 24 Apr 2001 21:37:44 +0100 (BST) Peter Skipworth [EMAIL PROTECTED] wrote: I for one vote to not bother with abbreviations from now on - let's just spell it out loud and clear ;) *grin* P On Tue, 24 Apr 2001, Steve Ruby wrote: Matthew Hafner wrote: does mySql support triggers or transactions Matthew Hafner Web Applications Engineer The Ohana Foundation 1099 Alakea st 22nd floor Honolulu, HI, 96813 1-877-61-ohana [EMAIL PROTECTED] RTFM 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 -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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 -- --- Peter Skipworth Perl Developer/Unix Systems Administrator [EMAIL PROTECTED] +44 795 055 0029 --- 4c 61 20 6c 6f 79 52 75 62 20 73 41 20 65 52 61 20 45 65 62 4f 4c 47 6e 74 20 20 4f 53 75 00 0a - 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
BDB Transaction support on NT?
Hi, Does anyone know if the DBD Transaction Safe Table support has been implemented (and working) for the NT release of 3.23.33 ? I have created tables with type=BDB but fail to have any joy with transactions Cheers, Bruce Percy Peopledoc 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
Transaction support in MySQL?
I'm wondering if MySQL supports transaction? Since I have an application to use MySQL JDBC to perform several insert statements and then do a rollback, all data saved to the database without rolling back. -Eric - 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: Transaction support in MySQL?
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Transactions http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#BDB -tcl. On Tue, 13 Feb 2001, Eric Kwong wrote: I'm wondering if MySQL supports transaction? Since I have an application to use MySQL JDBC to perform several insert statements and then do a rollback, all data saved to the database without rolling back. -Eric - 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