Differences between version 15 and previous revision of MySQL.
Other diffs: Previous Major Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 15 | Last edited on Friday, October 22, 2004 8:51:26 am | by AristotlePagaltzis | Revert |
| Older page: | version 12 | Last edited on Sunday, September 19, 2004 1:08:25 pm | by AristotlePagaltzis | Revert |
@@ -1,7 +1,18 @@
[MySQL | http://www.mysql.com/] is a PostRelationalDataBase management system. It is the canonical example of a successful commercial OpenSource product. This has been attributed primarily to the fact that it's DualLicensed.
Some also say it is devil spawn or a horrible piece of badly written software. It's very fast at low loads because it's hardly more than a glorified flat file database with an [SQL] interface, but that comes at the expense of any feature anyone would find useful (transactions, as one example). It sucks at large joins and has trouble handling tables with a few million rows in them.
+
+If you want a relational DataBase, use [PostgreSQL]. You'll love yourself forever if you do.
+
+See also [PostgreSQL], PostgresVsMysql, [DB2], [Oracle]
+
+----
+
+> For a large portion of the new markets being created by [MySQL], this advantage ''~[easy to install while reasonably useful, Ed.]'' matters a lot more than missing features and poor [ACID] semantics. If this shocks you, then remember that [MySQL] is used for the InterNet-enabled version of what people used to use MS Access for. Compare [MySQL] to MicosoftAccess on technical grounds -- who wins?
+-- ''Ben Tilly'' in [20040629182643.8C4E33AA2A1@ws5-8.us4.outblaze.com | http://www.crynwr.com/cgi-bin/ezmlm-cgi?mss:9222]
+
+----
''Loud jarring chord!''
''The door flies open and BillGates of [Microsoft] enters, flanked by two junior cardinals. Steve Ballmer has goggles pushed over his forehead. Sam Palmisano ([IBM]) is just an idiot.''
@@ -9,19 +20,21 @@
__GATES__: ''Nobody'' expects the [InfoWorld Article | http://infoworld.com/articles/pl/xml/02/09/23/020923pldman.xml]! The chief thing missing from [MySQL] is subselects...subselects and views...views and subselects.... The two things missing are views and subselects...and triggers.... The ''three'' things missing are views, subselects and triggers...and an almost fanatical devotion to row-level transactions.... The ''four''... no... ''Amongst'' the things missing from MySQL ...are such elements as views, subselects.... I'll come in again.
''Exit and exeunt''
-If you want a relational DataBase, use [PostgreSQL]. You'll love yourself forever if you do. See PostgresVsMysql.
+----
-<br> __When should I use MySQL?__ :
- When your primary concern is the speed of simple SELECT queries for few concurrent users. Even then PostgreSQL is getting much quicker at these.
-<br> __When should I not use MySQL?__ :
+<br> __When should I use [
MySQL]
?__ :
+ When your primary concern is the speed of simple <tt>
SELECT</tt>
queries for few concurrent users. Even then [
PostgreSQL]
is getting much quicker at these.
+<br> __When should I not use [
MySQL]
?__ :
When you think "It's only going to ever be a small web site...", and there's a chance it could grow into a big one. If at any point you think you might need to change to something else, start with that other system instead.
<br> __How can I lessen the impact of having to switch later on?__ :
Use PearDB in your [PHP] scripts, or DBI in your [Perl] scripts.
+
+----
!!! WARNING
* DO NOT USE MYSQL'S <tt>RAND()</tt> FUNCTION, IT CAUSES YOUR DATABASE TO DISAPPEAR
* DO NOT LET MYSQL'S PARTITION FULL UP, IT CAUSES YOUR DATABASE TO CORRUPT
* DO NOT USE MYSQL UNDER LOAD, IT CAUSES YOUR DATABASE TO CORRUPT
* DON'T LOOK AT THE MYSQL SERVER IN THE WRONG TONE OF VOICE, IT CAUSES YOUR DATABASE TO CORRUPT
