CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Intermediate:
Mod_Auth_MySQL

 



Zimmy
New User

Mar 30, 2002, 3:41 PM

Post #1 of 4 (666 views)
Mod_Auth_MySQL Can't Post

hello All, (this might not be the right forum. But i hope you can help me)

I am using Mod_Auth_MySQL in replacment for .htpasswd

I am wounding if any has ever come across any problems with it.
The current problems i am having are...

-MySQL is working very very hard. and is making the site run SLOW.

I have a lot of traffic and i assume each time a user logs in it is doing 1 query for each page a member hits.
Is there anything in replacement to Mod_Auth_MySQL (besides .htpasswd
Could it be its not installed correctly ?

Anyone with some experience with this Apache Module that can help me out would be a bonus!

Thank you in advanced,

Drew


Coderifous
journeyman

Mar 30, 2002, 4:21 PM

Post #2 of 4 (663 views)
Re: [Zimmy] Mod_Auth_MySQL [In reply to] Can't Post

I use the mod_auth_mysql module with no problems or slowdown at all. In fact, it operates extremely fast for the site I'm using it on. ( 3 different servers in fact ) I'm running apache 1.3.something on windows NT 4.0 systems of various power. I'm running perl embedded (mod_perl) not that it should make a difference here.

I wonder why you are experiencing slow down...

I have experienced one time when I had to restart apache and the mysql server becuase the authorization wasn't working at all, but after the restart, faster than a speeding bullet.

And by the way, the lowest end of my servers ( a total joke given it's surroundings ) has a 200 mhz processor! How pathetic! But it still does it's job.

--Jim


Zimmy
New User

Mar 30, 2002, 4:32 PM

Post #3 of 4 (660 views)
Re: [Coderifous] Mod_Auth_MySQL [In reply to] Can't Post

Would you mind posting your .htaccess file so i can make sure I have the same configuration. I might be doing something there...

Also.. How much traffic are you bringing in ? This would make a difference right ?

I am on average at 5,000 - 10, 000 / day
Would this have anything to do with it ?

Thanx,


Drew


(This post was edited by Zimmy on Mar 30, 2002, 4:33 PM)


Coderifous
journeyman

Mar 31, 2002, 6:13 AM

Post #4 of 4 (646 views)
Re: [Zimmy] Mod_Auth_MySQL [In reply to] Can't Post

I don't use an .htaccess file, I just put directives in the apache httpd.conf to limit access to certain directories. Maybe that is the difference that matters. I haven't tried it with .htaccess files.

My server is handling less traffic, but your traffic shouldn't at all be near the capacity of your technology. So my knee jerk reaction would be "no" that's not the reason it's malfunctioning - but you'd be amazed at how many times I've been wrong before.

Does MySQL/Mod_Auth_Mysql lock the table every time an authorization is done? I wouldn't think that it would be necessary.

--Jim

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives