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 ;)
Comments from long ago:
Comment from: abhiishek
guys does anyone know about audit trail facility ?
is it offered in mysql 5.0 or any other version of mysql ?
2006-05-11 09-23