On 11/8/05, Ala'a Ibrahim <[EMAIL PROTECTED]> wrote: > About MySQL > Why (and when) shouldn't I upgrade from MySQL 4.0 to 4.1 hence that MySQL > 4.1 has this sub-quires which really turn life easier? > Why (and when) shouldn't I upgrade from MySQL 4.x to 5.x?
I believe upgrading to 4.1 would give you both a performance boost and lots of features. There is only one point to consider here that is usually the joy killer, the authentication method has changed and if you upgrade the mysql DB you will have to upgrade the libraries to be able to talk to 4.1. This is a feature that you can leave if you have an application already running by not "fixing" your 'mysql' DB. > > Why (and when) I have to STICK with the MyISAM tables, and not use InnoDB > tables hence the last provides Rollback, and commit which are very useful, > and my most important is the locking technique (in MyISAM the whole table is > locked, in InnoDB only the rows needed are locked)? > It really has to do with mostly with your application. If you are doing MOSTLY reads OR mostly writes ... stay with MyISAM. If you have a business application that has continuous concurrent queries that are both read/write ... switch to InnoDB. Remember that you can mix both engines per table. So this highly depends on what you do. Also, keep in mind that MyISAM is faster than InnoDB! But, depending on your app you might get an 'overall' performance gain by using InnoDB given for example that you wont be waiting for locks! If you have a more detailed question we can discuss this more extensively. -- abulyomon www.KiLLTHeUPLiNK.com _______________________________________________ General mailing list [email protected] http://mail.jolug.org/mailman/listinfo/general_jolug.org
