MySQL Performance/Design Help

Discussion in 'Site & Server Administration' started by chachi, Jul 20, 2005.

0
  1. #1
    Anyone done any MySQL training or have some recommended sources for MySQL performance tweaks or design improvements. We just had a 1.5GB db go down. I think we are at the point where we are going to need to really get a handle on performance MySQL db design.
     
    chachi, Jul 20, 2005 IP
  2. Crazy_Rob

    Crazy_Rob I seen't it!

    Messages:
    13,157
    Likes Received:
    1,366
    Best Answers:
    0
    Trophy Points:
    360
    #2
    Crazy_Rob, Jul 20, 2005 IP
  3. chachi

    chachi The other Jason

    Messages:
    1,600
    Likes Received:
    57
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Why don't you just send me yours, you don't need it :)
     
    chachi, Jul 20, 2005 IP
  4. Labcoat88

    Labcoat88 Peon

    Messages:
    192
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The MySQL site itself (Developer tab) is great. You can buy the definitive MySQL reference book as well, although all the info is already on the site.

    There are other MySQL-specific books on performance, but it sounds like you probably want a SQL book. Check out "Practical SQL Handbook" - one of the all-time best (and most accessible/readable) books on SQL. 95% of critical performance and design factors you will learn from this book and it will work on MySQL, Oracle, MS SQL, and so on.

    Practical SQL Handbook


    LC
     
    Labcoat88, Jul 21, 2005 IP