View Issue Details

IDProjectCategoryView StatusLast Update
0015194phpList 3 applicationGeneralpublic23-03-09 16:23
Reporteruser4365Assigned To 
Status resolvedResolutionfixed 
Product Version2.10.5 
Fixed in Version2.11.3 
Summary0015194: usertracking produces high mysql serverload, causes cpu hog and kills server
Descriptionwhen enabling [USERTRACK] in outgoing newslettermails, the message opens by users kills the server.
Additional Informationhuge newsletterlists, 40.000 receivers+
huge outbound: over 10.000 emails per hour...

Bug caused by:


  $req = Sql_Query(sprintf('select distinct messageid, subject, sum(clicked) as totalclicks, count(distinct userid) as users, count(distinct linkid) as linkcount from %s as linktrack, %s as message
    where clicked and linktrack.messageid = %s group by messageid order by entered desc limit 50',



    Sql_Query(sprintf('update %s set viewed = now() where messageid = %d and userid = %d',
    Sql_Query(sprintf('update %s set viewed = viewed + 1 where id = %d',

Server: mysql 5.0.x
TagsNo tags attached.


There are no notes attached to this issue.