MySQL and Apache.....

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • RainMailer
    Confirmed User
    • Feb 2003
    • 826

    #1

    MySQL and Apache.....

    Hey guys for a very High traffic server how are you tweaking MySQL and Apache (I am on a Redhat Server) Also are you caching PHP for better performance?
    harbinc at gmail dot com
  • RainMailer
    Confirmed User
    • Feb 2003
    • 826

    #2
    bump
    harbinc at gmail dot com

    Comment

    • RainMailer
      Confirmed User
      • Feb 2003
      • 826

      #3
      bump
      harbinc at gmail dot com

      Comment

      • mryellow
        Confirmed User
        • May 2001
        • 934

        #4
        Very high?

        For a VERY high traffic site you can't use PHP or MySQL.

        -Ben
        Cyberwurx Hosting
        After trying 5 different hosts, I found the best.
        Since 1997 I've had 2 hours of downtime.
        Fast support, great techs, no hype, no gimmicks.

        <- I in no way endorse whatever just got stuck on the left of my post.

        Comment

        • RainMailer
          Confirmed User
          • Feb 2003
          • 826

          #5
          Originally posted by mryellow
          Very high?

          For a VERY high traffic site you can't use PHP or MySQL.

          -Ben
          Well lets dsay 100-200k per day
          harbinc at gmail dot com

          Comment

          • mryellow
            Confirmed User
            • May 2001
            • 934

            #6
            I've been told PHP limits out at about 500k. That'd be page views
            and not uniques.

            MySQL isn't a real database server, it works, it's fast for small
            stuff. However it doesn't do all the true database server stuff
            that Oracal and others do.

            It would all depend on the number of records and the queries. If
            you design the database correctly and only hit it when it's
            actually needed then you should be able to do it. If you are
            running huge queries on tens of thousands of records on every
            hit then MySQL will probably become the bottleneck before
            anything else.

            Spend a lot of time planning the code so as to reduce the amount
            of DB work, records, and queries.

            If you need to do a lot of work on a lot of hits then C and RAM are
            the go.

            -Ben
            Cyberwurx Hosting
            After trying 5 different hosts, I found the best.
            Since 1997 I've had 2 hours of downtime.
            Fast support, great techs, no hype, no gimmicks.

            <- I in no way endorse whatever just got stuck on the left of my post.

            Comment

            Working...