Dear Edward, Thank you for the reply. I appreciate your informaton. Do you have by chance also any practical samples ?
f.e Until which table size might it be better to use f.e MyISAM and when would you use another format (Heap or a TST table ? f.e When you have have mostly read only access to data and the amount fits into the memory easily than you could think about using a HEAP type etc. How big should the query cache be compared to the table size ? I believe that what I am looking for is practical samples - or some rough guidelines whats known to work good. Best regards Nils Valentin Tokyo/Japan ----- 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. InnoDB is the more popular and stable transaction-safe table type in open-source MySQL and was designed specifically for high performance with large volumes of data, as well as overall CPU efficiency. Like BDB, support for it did not appear until v3.23.34. Gemini tables are available only in NuSphere's Enhanced MySQL and not in the open source version of MySQL. All of the above is paraphrased from SAMS "Teach Yourself MySQL in 24 Hrs." Who knew that book would actually come in handy. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Nils Valentin" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 27 May, 2003 03:58 Subject: Practical samples for table types Hello mysql fans ;-), This time I have a question which sounds simple, but I believe the answer might not be so easy. I would appreciate to hear from anybody some really good samples of which table type would be good for which occasion. I tried to look for some information perhaps a case study or something like this on the internet but I did not find anything like this. Either I looked for the wrong information or it doesnt exist yet. I understand that ISAM tables are OS dependent and obsolete since MyISAM replaced them. That still leaves 7 formats open. (MyISAM, Merge Tables, HEAP, BDB, InnoDB, GEMINI) I would appreciate a omparison chart or soemthing similar showing the features for each table type etc. I want to figure out f.e. if I can modify HEAP tables or perhaps even use them as slaves in a replication system. What will happen when transformin Innodb tables into BDB or Gemini format. Would that be a good idea or not (and why) ? While this is a complex topic I am approaching I dont expect a simple answer or anybody to know everything I am trying to get a more complete understanding of the tables disadvantages and advantages. While the documentation lists up all options for each table I believe it doesn't necessary describe for which purpose they are useful. Perhaps anybody around who was just thinking the same ? -- ================================================ Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp/staff/nils ------------------------------------------------ 譛蛾剞莨夂、セ繝翫Ξ繝�ず繝�じ繧、繝ウ 縲�82-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]