I created a little table chart showing the features of the different table types. Its not complete and might even contain wrong info. The information is taken from the the mysql manual and several books.
http://knowd.co.jp/staff/nils/mysql-ttf.html As I dont have (yet) had the time to try all features of each table type I would appreciate if anybody with experience could take a sharp look and point out to me anything that is obvious wrong in the chart. I want this to be a practical chart, meaning as live is there will be a difference between the documentattion and the real life. Please also let me know why it is wrong and on which system you made the experience. Perhaps you are using features which are not even mentioned on the chart ? Also in this case let me know please, I will update the chart. Of course I will make the final chart available so the everybody can use it. Note: The Gemini table was available only from Nusphere and is not sold or used anymore. I know this, but I want to create a chart which shows the feature of all possible table types on a technical base, to fully understand the advantages/disadvantages each type has or had. ( You will also find enclosed the ISAM table type which is probably not even used anymore ;-) Best regards and thank you for any feedback Nils Valentin Tokyo/Japan 2003年 5月 29日 木曜日 16:35、Nils Valentin さんは書きました: > Hi Jeremy, > > You are right it's not sold anymore, but that doesnt mean that it wasnt > good, right ;-). > > Apart from the fact that Gemini might be outdated or not, I am really more > interested in the technical features etc. > > Anyway thanks for the reply. > > Best regards > > Nils Valentin > > 2003年 5月 29日 木曜日 16:27、Jeremy Zawodny さんは書きました: > > On Tue, May 27, 2003 at 07:50:21AM -0400, Becoming Digital wrote: > > > MyISAM is the default MySQL table type. This is the table type of > > > choice for tables whose primary activity comes from SELECT > > > statements. There is no need for transaction-safe tables unless > > > INSERT, UPDATE, and/or DELETE actions will be performed frequently. > > > Remember that with transaction-safe tables comes an increase in the > > > amount of system resources needed to use those table types. > > > > > > BDB table type is a usable, transaction-safe table type, but it is > > > not the most optimized table type in the mix. BDB tables support > > > the basic elements of transactions as well as the AUTOCOMMIT > > > variable, but are not as popular or as developed as the InnoDB or > > > Gemini types. > > > > Gemini? I haven't heard that name for a while. I thought it was > > dead. Is NuSphere still selling their Gemini-enhanced MySQL? > > > > Jeremy > > -- > > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > > MySQL 4.0.8: up 114 days, processed 3,575,209,651 queries (360/sec. avg) > > -- > ================================================ > Valentin Nils > Internet Technology > > E-Mail: [EMAIL PROTECTED] > URL: http://www.knowd.co.jp/staff/nils > ------------------------------------------------ > 有限会社ナレッジデザイン > 〒182-0024 東京都調布市布田4-6-1 調布丸善ビル7F > Phone: 0424-40-7912 Fax: 0424-40-7913 > URL: http://www.knowd.co.jp > ================================================ -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp/staff/nils ------------------------------------------------ 有限会社ナレッジデザイン 〒182-0024 東京都調布市布田4-6-1 調布丸善ビル7F Phone: 0424-40-7912 Fax: 0424-40-7913 URL: http://www.knowd.co.jp ================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
