[Nss-mysql-devel] [ 101504 ] id command VERY slow

[nobody]

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