Hi Everybody, our server was down for 8 hours. I applogize in case anybody did try to access the table chart. Its up and running and of course I would appreciate any feedback.
http://www.knowd.co.jp/staff/nils/mysql-ttf.html Best regards Nils Valentin Tokyo/Japan 2003年 5月 30日 金曜日 17:34、Nils Valentin さんは書きました: > 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 > ================================================ -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] 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]
