[transpetaflops]

Replying to myself here. Not a mysql expert but trying to learn... I found this:

mysql> select * from datastore where title = 'maxloggedin';
+-------------+----------------------------------------------------------------------------------------------------------------------+-------------+
| title       | data                                                                                                                 | unserialize |
+-------------+----------------------------------------------------------------------------------------------------------------------+-------------+
| maxloggedin | a:4:{s:13:"maxguestzdate";i:1208349349;s:9:"maxguestz";i:233;s:9:"maxonline";i:2;s:13:"maxonlinedate";i:1208350033;} |           1 | 
+-------------+----------------------------------------------------------------------------------------------------------------------+-------------+
1 row in set (0.01 sec)

The "maxguestz" value of 233 is probably the one I need to reset. What puzzles me is that I used the following command to reset the regular max users statistics:

UPDATE datastore SET data = '' WHERE title = 'maxloggedin'

But I fail to see how this command was able to successfully reset only the "maxonline" value since I see no references to it. I would assume that command would wipe the complete record which it didn't do obviously. I'd be most grateful for an explanation and a pointer to how I can modify the command to reset the Guest Tracking stats.