[Nss-mysql-devel] [bug #4192] Nonsensical join

[nobody]

=================== BUG #4192: LATEST MODIFICATIONS ==================
http://savannah.nongnu.org/bugs/?func=detailbug&bug_id=4192&group_id=443

Changes by: Guillaume Morin <address@hidden>
Date: Mon 07/07/2003 at 15:48 (Europe/Paris)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Invalid
         Assigned to | None                      | gmorin


------------------ Additional Follow-up Comments ----------------------------
Marcus,

It is an ipop issue. NSS MySQL implement the NSS API so I guess ipop calls 
getgrent which returns all results. I am still maintaining the project. I have 
moved to a new job 
(and a new country) so I have been very busy recently. 

What I suggest is to try the CVS version which should be faster and try to 
install nscd. Some people have reported problems with it and some said it works 
flawless. You might want to give it a try.

You can also use the MySQL "EXPLAIN" command to see if the query you pasted 
makes a good use of indexes.

Guillaume.



=================== BUG #4192: FULL BUG SNAPSHOT ===================


Submitted by: marcusjhdon             Project: NSS MySQL                    
Submitted on: Fri 07/04/2003 at 15:30
Category:  None                       Severity:  5 - Major                  
Bug Group:  None                      Resolution:  Invalid                  
Assigned to:  gmorin                  Status:  Open                         

Summary:  Nonsensical join

Original Submission:  Hi

I have noticed that when we get an ipop login, the following query is used by 
nss_mysql:

select groups.groupName,groups.groupId + 
2000,groups.groupPassword,users.userName from groups LEFT JOIN usersGroups on 
groups.groupId=usersGroups.groupId LEFT JOIN users on 
usersGroups.userId=users.userId and users.status = 'A' where 1 = 1 and 
groups.status = 'A'

The result of this is to return every single user, of which we have around 
30,000! We have a load balancers cluster of 4 machines, but our pop server is 
now so busy that if one machine goes offline, the others struggle to cope 
unless we stop ipop.

Is this likely to be a bug with nss_mysql or ipop? Also, are you still working 
on this project, since I notice there has been little activity recently?

Thanks in advance.

Marcus

Follow-up Comments
*******************

-------------------------------------------------------
Date: Mon 07/07/2003 at 15:48       By: gmorin
Marcus,

It is an ipop issue. NSS MySQL implement the NSS API so I guess ipop calls 
getgrent which returns all results. I am still maintaining the project. I have 
moved to a new job 
(and a new country) so I have been very busy recently. 

What I suggest is to try the CVS version which should be faster and try to 
install nscd. Some people have reported problems with it and some said it works 
flawless. You might want to give it a try.

You can also use the MySQL "EXPLAIN" command to see if the query you pasted 
makes a good use of indexes.

Guillaume.


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.nongnu.org/bugs/?func=detailbug&bug_id=4192&group_id=443

_______________________________________________
  Message sent via/by Savannah
  http://savannah.nongnu.org/