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.
