From: Daevid Vincent Date: May 24 2007 8:57pm Subject: FK support on myISAM, Parallelization, pronunciation and all kinds of goodness... List-Archive: http://lists.mysql.com/mysql/206987 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C0_01C79E0B.814DB1D0" ------=_NextPart_000_00C0_01C79E0B.814DB1D0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Whoa!? I was just reading this page = (http://en.wikipedia.org/wiki/MySQL), and noticed a few things... =20 " Foreign key support for all = storage engines will likely be released with MySQL 5.2=20 (although it has been present since version 3.23.44 for = InnoDB)." =20 Does this mean that myISAM tables will have FK support? So I can then = ditch this InnoDB with all the transaction bloat, and the fact that = auto_increment PK resets itself. http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html =20 And the second interesting thing is: =20 "Support for = parallelization is also part of the roadmap for future versions" =20 Does this mean we can have several mySQL servers all running as "one", = on different physical servers. Sort of like clustering, or maybe = RAID-ish? =20 What are the current roadmap dates(ish) for these features. And I'm sure = this has been asked a billion times, but when will 5.1 branch become GA = (again, ballpark)? =20 =20 =C3=90=C3=865=C3=8F=C3=90=20 =20 PS. Here's a bit of trivia for you if you don't feel like reading the = whole wikipedia page: =20 "MySQL"'s official pronunciation of the name is "My Ess Que Ell", = pronounced as /ma=C9=AA =C9=9Bs kju=CB=90 =C9=9Bl/, not "My sequel" = /ma=C9=AA si=CB=90kw=C9=99l/. However, the company does not take issue = with the pronunciation "My sequel" or other local variations. The "My" portion of the name comes from the name of Widenius's child, = spelled "My" but pronounced in = Swedish as m=C3=BC /my/ (or approximately in English, "me"). The "SQL" portion uses the fully spelled-out pronunciation of the = initials, S-Q-L = (Structured Query Language), not the "sequel" pronunciation. This = adheres to the official ANSI pronunciation but conflicts with the = earlier IBM database of that name.[5] = =20 The Swedish (MySQL AB is a Swedish company) word Myskv=C3=A4ll = (/myskv=C3=A6l/ "cozy evening", or "My's evening" as Mys kv=C3=A4ll) is = pronounced in a similar way, but this may be a coincidence. Nevertheless = this pronunciation is quite usual in Sweden. The dolphin symbol in the MySQL = logo was given the Swati = name Sakila in October 2002 after a naming contest ------=_NextPart_000_00C0_01C79E0B.814DB1D0--