How to keep track of queries/user/hour and connections/hour

[farley99]

I noticed powweb keeps track of queries/user/hour and connections/hour, for each account with them, how do they do this?

MySQL: 1 MySQL database is included per package. Each additional database has a one time setup fee of $10. 3 user limit per database, 36,000 queries/user per hour and 3,600 connections per hour.

 

[sleipnir214]

I'm not familiar with the particular piece of software you're talking about.

But in general, you use user-defined script functions to perform database accesses. And those functions can have extra functionality to update the appropriate user records.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[farley99]

How do i count them though? how do i know userA is makeing 4,000 queries/hour and userB is making 40,000 queries/hour?

 

[sleipnir214]

Depends.

Are you looking for trend data, a count of the last hour, or a count since the beginning of the last whole hour?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[farley99]

Either one.

 

[sleipnir214]

Create a table with two columns, a username column and a column of type timestamp.

Every time your code performs a query, add an entry to this table. All you have to add is the username, MySQL will automatically set the value of the timestamp column.

Then query this new table for information.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!