mysql question

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • grumpy
    Too lazy to set a custom title
    • Jan 2002
    • 9870
    #1

    mysql question

    Anybody here has some knowledge of tuning a mysql server?
    When the server gets a bit busy it seems that most of the sessions get locked. Machine has double PIII 800 512 meg of ram
    Hits when it gets locked around an 200 hits a minute
    Don't let greediness blur your vision | You gotta let some shit slide
    icq - 441-456-888
    Tags: None
    • AdultWire
      Confirmed User
      • Feb 2002
      • 962
      #2
      What do you mean by locked? What is the effect of this "lock" -- I have some experience with mysql. (I serve about 2.5 million mysql generated pages per day -- off one box)
      SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

        Comment

        • Lane
          Will code for food...
          • Apr 2001
          • 8496
          #3
          maybe you set the limit for number of connections too low? also dont use persistent connections, they do nothing but waste mysql resources..

            Comment

            • grumpy
              Too lazy to set a custom title
              • Jan 2002
              • 9870
              #4
              Adultwire
              Thanks a lot...that helped ( until now :-)
              Don't let greediness blur your vision | You gotta let some shit slide
              icq - 441-456-888

                Comment

                • AdultWire
                  Confirmed User
                  • Feb 2002
                  • 962
                  #5
                  The persistant thing wastes resources if you're running php as a CGI, but if you're running it as a module, it can do some good. Seems the problem here is slow table updates/no indexes.
                  SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

                    Comment

                    • AdultWire
                      Confirmed User
                      • Feb 2002
                      • 962
                      #6
                      Definately msg me or icq me and let me know if the problem is solved during peak hours tommorow.
                      SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

                        Comment

                        • The Hun
                          Confirmed User
                          • Jan 2001
                          • 1207
                          #7
                          Use PostgresQL, that goes slow on many request, but doesn't die like MySQL does. MySQL is unsuitable for things like counters and such, especially when you start doing bigger numbers

                            Comment

                            Previous template Next
                            Working...