SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Guru
    Join Date
    Feb 2002
    Posts
    625
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL 4.0 - your oppinions please

    Hello!

    Is anybody using MySQL 4.0 already?

    Is it worth to upgrade or would it be better to wait for at least beta release?

    If you are using it, did you have any problems so far?

  2. #2
    ..back with a vengeance... Ingoal's Avatar
    Join Date
    May 2002
    Location
    Benningen, Germany
    Posts
    6,260
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: MySQL 4.0 - your oppinions please

    Originally posted by datune
    Hello!

    Is anybody using MySQL 4.0 already?

    Is it worth to upgrade or would it be better to wait for at least beta release?

    If you are using it, did you have any problems so far?
    Nope, im not using it atm...and theres no way im gonna take the risk of using an alpha version....Im using mysql 3.23 atm...

    If you wanna go for MySQL4 i would wait on the beta release...

    Cheers Ingoal
    Advisor - Community Team
    CHD-magician + + =
    Some of my sites: [1|2|3|4|5|6|7|8|9|10]
    Newest site: ZZ.GD - t dsn't gt mch shrtr thn tht

  3. #3
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Actually it is supposed to be very stable

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  4. #4
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    as i've said before, i'd be using 4 without hesitation if i had my own server. it's tested very well before being released and i don't think little Web scripts will reveal any bugs.

    there are a bunch of things that i'd love about it (over 3.23). here's some i can think of now:

    • should be faster
    • should be scale better (i saw someone on the vBulletin forum that was having table locking problems with 3.23; switched to 4.0.1 and they went away).
    • query cache. will make queries a lot faster from tables that aren't often updated
    • SELECT SQL_CALC_FOUND_ROWS ... that will save you from having to 1) SELECT more rows that you need just to count them, or 2) run a seperate SELECT COUNT(*) query.



    of course, if you switch to 4, make sure you test the queries on 3.23 if there's any chance that the scripts will be run using it.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  5. #5
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I used 4.0 on my own PC for a while. However I had a problem with database corruption and now I have a database that I can't make any changes (alter, update, delete, drop, etc...)

    I switched back 3.23.49-NT and not had any problems yet though I am still trying to repair the other database.
    Wayne Luke
    ------------



Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •