Blogs![[Selected]](http://fplanque.net/Img/down_small.gif){kind=small}
dev blog
| « WYSIWYG (XHTML) editors | Exporting MySQL databases » |
MySQL features by version breakdown
06.12.04
MySQL features by version breakdown
I could not find anything like this on the net, so I thought I'd make my own chart and share it... 
| MySQL version | 3.23.58 +InnoDB |
4.0.22 | 4.1.7 | 5.0 |
|---|---|---|---|---|
| Release date | 11-sept-03 | 27-oct-04 | 23-oct-04 | not stable yet |
| Row level locking | yes | yes | yes | yes |
| Transactions | yes | yes | yes | yes |
| Foreign keys | yes | yes | yes | yes |
| UNION | no | yes | yes | yes |
| Subqueries (derived tables) | no | no | yes | yes |
| Multiple table DELETEs | no | yes | yes | yes |
| Unicode UTF-8 support | yes | yes | yes | yes |
| Column level charset support | no | no | yes | yes |
| Timezone handling | no | no | yes | yes |
| Full text indexing (MyISAM only) | no UTF-8 | no UTF-8 | yes | yes |
| Stored procedures | no | no | no | yes |
| Rudimentary triggers | no | no | no | yes |
| Updatatable views | no | no | no | yes |
| Server side cursors | no | no | no | yes |
| Master/slave one way replication | yes | yes | yes | yes |
| Replication over SSL | no | no | yes | yes |
| Clustering (not available on Windows) | no | no | yes | yes |
Note: I have not included MySQL 3.23 without InnoDB because that version can do vitually nothing interesting. It's a pure joke. Unfortunately, it is the kind of joke hosting providers like to try on you when they claim they offer you a "DBMS"... yeah right... call it an electronic rollodex, no more 
I'm a little bit too lazy for styling this right now, sorry.
If you notice an error, please be so nice and report it. Thanks
1 comment
Comment from: abhiishek [Visitor] 
guys does anyone know about
audit trail facility ?
is it offered in mysql 5.0 or any other version of mysql ?
audit trail facility ?
is it offered in mysql 5.0 or any other version of mysql ?
2006-05-11 @ 09:23
Comment feed for this postComments are closed for this post.
