Yes- I've documented this issue in a new question - please 
see: https://groups.google.com/d/msg/web2py/A7P4HoST-Lg/NZ3kmTTwVG0J


On Wednesday, April 17, 2013 3:08:38 AM UTC-4, Niphlod wrote:
>
> everyone with a different unique_key ?
>
> On Wednesday, April 17, 2013 12:43:35 AM UTC+2, Yarin wrote:
>>
>> OK, now I've run into some special weirdness- I don't know if it's 
>> related, but it makes no sense to me:
>>
>> When I run a count of session records grouped by client IP, I get some 
>> very big numbers at the top end:
>>
>> SELECT<https://my.sidekickhq.com/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Fselect.html&token=b7e16822d6a72a4a32629ba16b760d59>
>>  client_ip, 
>> COUNT<https://my.sidekickhq.com/phpMyAdmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.1%2Fen%2Fgroup-by-functions.html%23function_count&token=b7e16822d6a72a4a32629ba16b760d59>
>> ( * ) AS count
>> FROM `web2py_session_sidekick` 
>> GROUP BY client_ip
>> ORDER BY count DESC 
>> LIMIT 0 , 30
>>
>> Some client ips have 100+ session records associated with them!? For 
>> example, my own IP has 186 session records- including 13 where the 
>> modified_datetime field equals TODAY... This makes no sense.  I did not log 
>> into my app from 13 different devices today. Why would a single user 
>> connecting from a single device have so many session records??
>>
>>
>>
>>
>>
>>
>> On Tuesday, April 16, 2013 6:21:56 PM UTC-4, Yarin wrote:
>>>
>>> Largest session_data fields were 12 KiB
>>>
>>> On Tuesday, April 16, 2013 5:49:45 PM UTC-4, Niphlod wrote:
>>>>
>>>> either than a large blob/object in the session I really can't see how 
>>>> an update so simple (syntax-wise) takes 50 seconds (when the minimum 
>>>> reported time is 0.8ms) on mysql end.
>>>> edit: did you try to inspect how much data is in the "longest 
>>>> session_data" column ? 
>>>>
>>>

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to