MySql overload: auth mysql + cache?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello all,
I'm facing a major issue on one of my DB after an application upgrade
that switch to AuthMysql for a subversion server authentication
My DB server is overloaded by tons of:

> SELECT user.unix_pw, length(user.unix_pw) FROM user, user_group WHERE user.user_name=foo

I think it might come from authmysql as it seems there is no cache at
apache level for the authentication stuff.
But it might also come from a wrong configuration of mysql (indexes/innodb/...)

I googled a bit an found very few echo of this problem, do you already
heard about it ?

Thanks,
Manuel

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@xxxxxxxxxxxxxxxx
   "   from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx



[Index of Archives]     [Open SSH Users]     [Linux ACPI]     [Linux Kernel]     [Linux Laptop]     [Kernel Newbies]     [Security]     [Netfilter]     [Bugtraq]     [Squid]     [Yosemite News]     [MIPS Linux]     [ARM Linux]     [Linux Security]     [Linux RAID]     [Samba]     [Video 4 Linux]     [Device Mapper]

  Powered by Linux