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.
