RE: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
Will I be able to change my BDB tables into Innobase tables using Alter table and how does INNOBASE tables differ from the GEMINI tables (when they are available)? - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 7:03 AM To: [EMAIL PROTECTED] Subject: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x Hi, readers of the mailing list! Monty will roll a new distribution of MySQL 3.23.3x this weekend. Innobase will be included there and it will provide transactions, rollback, recovery, row level locking, and Oracle-like consistent read. Monty will leave for a vacation in Rio on Wednesday, so the new distribution should be ready at the latest on that day. Currently, Intel NT and Intel Linux versions have been tested. We will compile and test Solaris 32-bit and Linux Alpha 64-bit versions this weekend. Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - 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: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
On a related note, how mature is the Innobase code? It is mostly new? Or like NuSphere's Gemini, it is older code which has been adapted to fit in with MySQL's table handler interface? Thanks! Jeremy Hi, I am also very interested in finding more out about innobase - code maturity, company background, etc. I have asked around collegues, but havn't found out much. Does anyone know of any English language sites where this information can be found? My company uses MySQL and the next project will need transactional support. My bosses are not comfortable about using MySQL for financial type transactions at the moment (fair enough), but I need some information to encourage MySQLs continued use. Also, any news on the Gemini Project would be very welcome. ie progress, how it compares/contrasts to Innobase. What about BDB, it seems to me that the Berkley stuff isn't as hardcore as the other two. Is it up to the job of coping with critical financial transactions? Any information would be gratefully received, Robin - 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: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
Hi again! There were several questions on the mailing list, which I try to answer: - The MySQL manual says that you can convert between different table types using ALTER TABLE, the same should hold for the Innobase table type, though I must admit I have not yet tested it. ALTER TABLE is a high-level function, which should be taken care in MySQL code higher than the the table handler. - There is a Win NT version of MySQL/Innobase, and also Win95/98 version should work, but I have not tested it lately. I have developed Innobase on Win NT, and therefore the NT version should be in teh best shape of all versions. - There is currently no website dedicated to Innobase. I have left registration application for www.innobase.net, and a page should appear there in a few days. The website www.innobase.com is not my website, that is a German IT consultant firm specializing in Baan services. In MySQL manual, Section 8.6, on the MySQL website you can read some technical info about Innobase. - The origin of the Innobase database is in my work at University of Helsinki 1993-95. I studied how the performance of traditional disk-based relational databases could be improved. I wrote the 100 000 lines of code in Innobase during the next 3 years. When I was looking at commercializing my engine, it caught my eye that free databases are catching steam. I started collaborating with MySQL AB last September. - Innobase engine has not been used in applications yet. I have run MySQL tests and my own multithreaded stress tests on MySQL/Innobase, and it seems to work, but the final word of course will come from the people who will use it in real-world applications. I have designed Innobase so that it should be easy to maintain and debug: there are lots of comments in the source code, and in the full debug version there are lots of assertions: in that version it spends some 99 % of CPU time doing consistency checks to data structures. I have also written memory debugging to Innobase: it can notice memory leaks and overwrites. Semaphores in Innobase are ranked in the order they should be acquired when code is processed: the debug version constantly checks that the order is obeyed. The debug version also automatically detects deadlocks of threads, and prints diagnostic information about them (of course these deadlocks should not occur if the correct semaphore acquisition order is obeyed). - The main strengths of Innobase should lie in its speed and also in transaction management. To my knowledge MySQL/Innobase is the fastest relational transactional disk-based database engine currently existing. In transaction management an innovation is to store row-level locks as a bitmap: the locks fit in a space so small that lock escalation is not needed in real-world applications. Query processing in Innobase is optimized with an adaptive hash index mechanism: the database constantly checks if it would benefit from building partial hash indexes to the data existing in the buffer pool. The mechanism is such that it can use the hash index also to search for right places to insert index records for new rows: thus the hash indexes also speed up insertions to normal B-tree indexes. But, now I will continue with my porting project to Alpha 64-bit Linux. I will report to the mailing list tomorrow what is the release status then :). Best regards, Heikki Tuuri Innobase Oy Helsinki, Finland - 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: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
On Fri, Feb 16, 2001 at 03:02:38PM +0200, Heikki Tuuri wrote: Monty will roll a new distribution of MySQL 3.23.3x this weekend. Innobase will be included there and it will provide transactions, rollback, recovery, row level locking, and Oracle-like consistent read. Monty will leave for a vacation in Rio on Wednesday, so the new distribution should be ready at the latest on that day. Currently, Intel NT and Intel Linux versions have been tested. We will compile and test Solaris 32-bit and Linux Alpha 64-bit versions this weekend. Very cool! I see the change log entries in the on-line manual already, but the source tarball isn't on SourceForge yet. :-( Anyone have one yet? I'm looking to test out the Innobase code on FreeBSD 4.1 this weekend. On a related note, how mature is the Innobase code? It is mostly new? Or like NuSphere's Gemini, it is older code which has been adapted to fit in with MySQL's table handler interface? Thanks! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
Hi Jeremy! Very cool! I see the change log entries in the on-line manual already, but the source tarball isn't on SourceForge yet. :-( Anyone have one yet? No, we are still busy working on the distribution, and no one has it yet. I just 15 minutes ago got the Solaris version running :). Monty will be in Sweden tomorrow (Monday). The boss of MySQL AB, Allan Larsson, has his 50th birthday. When Monty gets back, he will continue rolling the tarball. But more info on Innobase later, it is 2 a.m. now and sleep is needed now. Regards, Heikki - 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: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
Is there a Windows version for InnoBase yet? Lee -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 8:03 AM To: [EMAIL PROTECTED] Subject: Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x Hi, readers of the mailing list! Monty will roll a new distribution of MySQL 3.23.3x this weekend. Innobase will be included there and it will provide transactions, rollback, recovery, row level locking, and Oracle-like consistent read. Monty will leave for a vacation in Rio on Wednesday, so the new distribution should be ready at the latest on that day. Currently, Intel NT and Intel Linux versions have been tested. We will compile and test Solaris 32-bit and Linux Alpha 64-bit versions this weekend. Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - 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
Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
Hi, readers of the mailing list! Monty will roll a new distribution of MySQL 3.23.3x this weekend. Innobase will be included there and it will provide transactions, rollback, recovery, row level locking, and Oracle-like consistent read. Monty will leave for a vacation in Rio on Wednesday, so the new distribution should be ready at the latest on that day. Currently, Intel NT and Intel Linux versions have been tested. We will compile and test Solaris 32-bit and Linux Alpha 64-bit versions this weekend. Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - 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
