GoneNowBye Posted April 1, 2010 Share Posted April 1, 2010 Heya guys, long post in a while, i'm alittle stuck, I need a version of SQL which logs to a table the count (or something) of users' usage for example: Name | sel | upd | ins | del -------------------------------------- person_a | 12 | 13 | 18 | 20 person_b | 15 | 22 | 10 | 50 they were just some numbers but HOPEFULLY it shows what i mean i have found ExtSQL but i'd really like something which is just double click, i'm a windows user btw, i understand google did something but that's *nix only. Please Help Thanks Link to comment Share on other sites More sharing options...
GoneNowBye Posted April 1, 2010 Author Share Posted April 1, 2010 ADDITIONAL: no mysql version included because the suggestion may include that, (i'm happy to "downgrade" if need be) no other "READ BEFORE POST" statements apply Link to comment Share on other sites More sharing options...
GoneNowBye Posted April 1, 2010 Author Share Posted April 1, 2010 please help Link to comment Share on other sites More sharing options...
ignace Posted April 2, 2010 Share Posted April 2, 2010 There is no version that logs in this specific manner as SQL can not know the name (nor username) of the active user only the active account used by MySQL and this is either root or the account assigned to you by your hosting company Link to comment Share on other sites More sharing options...
GoneNowBye Posted April 2, 2010 Author Share Posted April 2, 2010 No thats not my question, i want to be able to track user's usage to mysql, like a webhost would, but i myself have my own server, any more thoughts? Link to comment Share on other sites More sharing options...
GoneNowBye Posted April 4, 2010 Author Share Posted April 4, 2010 anything? Link to comment Share on other sites More sharing options...
GoneNowBye Posted April 4, 2010 Author Share Posted April 4, 2010 Please i really need this Link to comment Share on other sites More sharing options...
fenway Posted April 4, 2010 Share Posted April 4, 2010 If you're talking about auditing, you'll need to have the DB wrapper log this somehow (triggers, inserts, meta data, query logs, etc.) and then report it yourself. Link to comment Share on other sites More sharing options...
GoneNowBye Posted April 4, 2010 Author Share Posted April 4, 2010 the first post example is what i'm looking for i'd like to know the number and types of queries people have done - idealy live Link to comment Share on other sites More sharing options...
GoneNowBye Posted April 5, 2010 Author Share Posted April 5, 2010 Oh comon please Link to comment Share on other sites More sharing options...
fenway Posted April 7, 2010 Share Posted April 7, 2010 That's quite enough. Link to comment Share on other sites More sharing options...
Recommended Posts