mod_auth_mysql 100's of queries a second?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • FiReC
    Confirmed User
    • Jan 2002
    • 2350

    #1

    mod_auth_mysql 100's of queries a second?

    With only a slight load on apache (few hundred processes) there are over 100 queries a second on the db box that is doing only member authentication. Is this common with mod auth mysql, it seems as tho the sessions aren't sticking and users are being authenticated against the db for each request to the page. Any thoughts?
    www.nubilefilms.com | www.nubiles.net | www.anilos.com | tubescript.nubiles.net | icq4162727
  • Fabuleux
    Confirmed User
    • May 2003
    • 2543

    #2
    Maybe someone is trying a brute force attack.

    Comment

    • JSA Matt
      So Fucking Banned
      • Aug 2003
      • 5464

      #3
      Originally posted by Fabuleux
      Maybe someone is trying a brute force attack.
      Yeah it shouldn't authenticate every page...get ProxyPass

      Comment

      • FiReC
        Confirmed User
        • Jan 2002
        • 2350

        #4
        that is definitly going on all the time, however i can see the logs and proxy pass should be taking care of those. the attempts are no where near 100 tries a second also something interesting is that the number of selects is really low compared to the number of change db queries, which is weird since there is only one db for this authentication scheme.
        www.nubilefilms.com | www.nubiles.net | www.anilos.com | tubescript.nubiles.net | icq4162727

        Comment

        • FiReC
          Confirmed User
          • Jan 2002
          • 2350

          #5
          its probably something really simple that im missing in the htaccess or httpd.conf
          www.nubilefilms.com | www.nubiles.net | www.anilos.com | tubescript.nubiles.net | icq4162727

          Comment

          Working...