domain_traffic table growing huge

[ispcomm]

Hi all,

I have a domain_traffic table which is getting several gigabytes big. Is this normal?

It's causing the server to be unresponsive for up to a minute time when a reseller logs in (or when admin becomes a reseller with 'change').

I traced down the problem to being this SQL query:

SELECT /*!40001 SQL_NO_CACHE */ * FROM `domain_traffic`;

which is executed on each reseller login. As domain_traffic is several gigabytes on this particular server (yes... it's a busy worker) you can guess how long it takes.

Is this normal?

ispcomm