[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Nss-mysql-devel] [ 101504 ] id command VERY slow
From: |
nobody |
Subject: |
[Nss-mysql-devel] [ 101504 ] id command VERY slow |
Date: |
Fri, 06 Dec 2002 08:40:49 -0500 |
Support Request #101504, was updated on 2002-Nov-07 22:26
You can respond by visiting:
http://savannah.nongnu.org/support/?func=detailsupport&support_id=101504&group_id=443
Category: None
Status: Open
Priority: 5
Summary: id command VERY slow
By: gmorin
Date: 2002-Dec-06 14:40
Logged In: YES
user_id=230
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2) Gecko/20021128
Debian/1.2-1
Hi Marcus,
Actually I would like to know if using nscd really speeds
things up, could try it for 10 minutes and tell if you see a
big difference. Furthermore, MySQL provides a way to log
slow queries, could you try it to see if there are no
queries realted to MySQL in it ? (see
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Slow_query_log
for more details).
Regards,
Guillaume.
----------------------------------------------------------------------
By: marcus
Date: 2002-Dec-04 00:15
Logged In: NO
Browser: Mozilla/4.0 (compatible; MSIE 5.15; Mac_PowerPC)
Hi Guillaume
Thanks very much for your reply, but I'm afraid none of
your suggestions have made much difference. In fact,
the problem is getting worse. The ls command is also
very slow if the files being listed are owned by a user
stored in the nss-mysql database.
I have tried optimising and even rebuilding the mysql
database, but to no avail - and all of the important fields
are definitely indexed. I have also tried tuning the mysql
server with loads of extra memory etc, but still no
change. I have even tried updating glibc (to 2.2.4-31) in
case the newer nss api is faster.
nss-mysql is not in debug mode, it was built with the
defaults (./configure). Also, unfortunately I can't use
nscd as users must be able to change their username
without having to wait for the cache to refresh. I could
make them wait as a last resort, but I'm reluctant to as I
don't think this is really addressing the cause of the
problem.
Any more ideas would be very gratefully received.
Kindest regards
Marcus
----------------------------------------------------------------------
You can respond by visiting:
http://savannah.nongnu.org/support/?func=detailsupport&support_id=101504&group_id=443