Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
mod_auth_mysql 100's of queries a second? mod_auth_mysql 100's of queries a second?
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 01-27-2005, 04:22 PM   #1
FiReC
Confirmed User
 
Industry Role:
Join Date: Jan 2002
Location: Land o Nubiles
Posts: 2,350
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?
FiReC is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-27-2005, 04:27 PM   #2
Fabuleux
Confirmed User
 
Join Date: May 2003
Location: The Netherlands
Posts: 2,543
Maybe someone is trying a brute force attack.
__________________
Fabuleux is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-27-2005, 04:37 PM   #3
JSA Matt
So Fucking Banned
 
Join Date: Aug 2003
Location: San Diego, CA
Posts: 5,464
Quote:
Originally Posted by Fabuleux
Maybe someone is trying a brute force attack.
Yeah it shouldn't authenticate every page...get ProxyPass
JSA Matt is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-27-2005, 04:39 PM   #4
FiReC
Confirmed User
 
Industry Role:
Join Date: Jan 2002
Location: Land o Nubiles
Posts: 2,350
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.
FiReC is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 01-27-2005, 04:43 PM   #5
FiReC
Confirmed User
 
Industry Role:
Join Date: Jan 2002
Location: Land o Nubiles
Posts: 2,350
its probably something really simple that im missing in the htaccess or httpd.conf
FiReC is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
mod_auth_mysql 100's of queries a second? mod_auth_mysql 100's of queries a second?
« Previous Thread | Next Thread »

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.