server_hit and visit table growing very large

[Deepak Agarwal-2]

Our server_hit and visit table has crossed 100 GB individually. I tried
moving them to a separate entitygroup but in vain because it is coupled
with few other entities like party, content.

What would the best way to manage it. We surely don't want this data to be
resided on the db where we have our customers and orders data.

Also, these hits are important to us so I can't really off them from
serverstats properties file.

--
Thanks,
Deepak Agarwal,

Mobile: [phone]

[S K Pradeep kumar]

YOu can stop storing the data,

Here is the configuration.
framework\webapp\config\serverstats.properties

With regards,
S K Pradeep Kumar,
9035009495


On Thu, Dec 5, 2013 at 4:01 PM, Deepak Agarwal <[hidden email]> wrote:

> Our server_hit and visit table has crossed 100 GB individually. I tried
> moving them to a separate entitygroup but in vain because it is coupled
> with few other entities like party, content.
>
> What would the best way to manage it. We surely don't want this data to be
> resided on the db where we have our customers and orders data.
>
> Also, these hits are important to us so I can't really off them from
> serverstats properties file.
>
> --
> Thanks,
> Deepak Agarwal,
>
> Mobile: [phone]
>

[Sumit Pandit]

Following would help

http://web.archive.org/web/20070224121213/http://ofbizwiki.go-integral.com/Wiki.jsp?page=Pg_monitoring#section-Pg_monitoring-MonitoringAndMaintainingTheDatabase

----- Original Message -----
| From: "S K Pradeep Kumar" <[hidden email]>
| To: [hidden email]
| Sent: Thursday, December 5, 2013 4:33:52 PM
| Subject: Re: server_hit and visit table growing very large
|
| YOu can stop storing the data,
|
| Here is the configuration.
| framework\webapp\config\serverstats.properties
|
| With regards,
| S K Pradeep Kumar,
| 9035009495
|
|
| On Thu, Dec 5, 2013 at 4:01 PM, Deepak Agarwal <[hidden email]>
| wrote:
|
| > Our server_hit and visit table has crossed 100 GB individually. I
| > tried
| > moving them to a separate entitygroup but in vain because it is
| > coupled
| > with few other entities like party, content.
| >
| > What would the best way to manage it. We surely don't want this
| > data to be
| > resided on the db where we have our customers and orders data.
| >
| > Also, these hits are important to us so I can't really off them
| > from
| > serverstats properties file.
| >
| > --
| > Thanks,
| > Deepak Agarwal,
| >
| > Mobile: [phone]
| >
|
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you

[Deepak Dixit-2]

Hi Deepak,

You can modify code avoid logging of ajax request like auto completer, poup or any other this type of request.


Thanks & Regards
--
Deepak Dixit

On Dec 5, 2013, at 4:01 PM, Deepak Agarwal wrote:

> Our server_hit and visit table has crossed 100 GB individually. I tried
> moving them to a separate entitygroup but in vain because it is coupled
> with few other entities like party, content.
>
> What would the best way to manage it. We surely don't want this data to be
> resided on the db where we have our customers and orders data.
>
> Also, these hits are important to us so I can't really off them from
> serverstats properties file.
>
> --
> Thanks,
> Deepak Agarwal,
>
> Mobile: [phone]