Differences between version 15 and revision by previous author of MySQL.
Other diffs: Previous Major Revision, Previous Revision, 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 11 | Last edited on Saturday, September 18, 2004 9:28:18 pm | by JohnMcPherson | Revert |
@@ -1,29 +1,40 @@
-[MySQL] is a [Relational|RelationalDataBase]/[PostRelational|
PostRelationalDataBase] DataBase
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.
+[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.
+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.
-;: ''Loud jarring chord!'
'
+If you want a relational DataBase, use [PostgreSQL]. You
'll love yourself forever if you do.
-;: ''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.''
+See also
[PostgreSQL], PostgresVsMysql, [DB2
], [Oracle
]
-;: __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
''
+> 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]
-If you want a relational [DataBase], use [PostgreSQL]. You'll love yourself forever if you do. See PostgresVsMysql.
+----
-; __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.
+ ''Loud jarring chord!''
-; __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.
+
''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
.''
-;
__How can I lessen the impact of having to switch later on?__ : Use PearDB in your [PHP] scripts, or DBI in your [Perl] scripts.
+ __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''
+
+----
+
+<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 RAND() FUNCTION, IT CAUSES YOUR DATABASE TO DISAPPEAR
+* 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
-
-----
-See also: http://www.mysql.com/
