OpenWebAnalytics两周后巨大的数据库

Question

我使用OWA (开放网络分析)从2周以来，几个网站，共< 10k的页面浏览量和< 5k访问。这是owa数据库中几个表的大小(以MB为单位)：

| owa                | owa_session                                  |       2.80 |
| owa                | owa_request                                  |       4.44 |
| owa                | owa_click                                    |       5.30 |
| owa                | owa_domstream                                |     238.28 |
+--------------------+----------------------------------------------+------------+

只有2周的~ 250 MB开放网络分析数据，总的页面浏览量小于10k，这是正常的吗？

，这是否意味着它将是6.5GB每年以相同的访问率？，甚至~ 65 GB的分析数据，100 K页面的访问量？

是出了什么问题，还是量值是对的？

附加信息:根据mysqldump__，超过90%的表owa_domstream被浪费(或者这有用吗？)通过以下方式：

scroll","x":0,"y":290},{"timestamp":1477783331,"event_type":"dom.
scroll","x":0,"y":295},{"timestamp":1477783331,"event_type":"dom.
scroll","x":0,"y":299},{"timestamp":1477783331,"event_type":"dom.
scroll","x":0,"y":301},{"timestamp":1477783331,"event_type":"dom.
scroll","x":0,"y":302},{"timestamp":1477783331,"event_type":"dom.
scroll","x":0,"y":303},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":306},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":326},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":347},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":367},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":381},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":393},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":405},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":414},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":427},{"timestamp":1477783332,"event_type":"dom.
scroll","x":0,"y":434},{"timestamp":1477783332,"event_type":"dom.

Answer 1

正如OWA作者所述，解决方案是关闭该功能。

记录董斯莱斯。此设置控制OWA是否应该记录Domstreams。

为每一位访客记录每一页上的每一个鼠标移动。(管理页>一般配置选项)。

当此特性关闭时，在mysql中这样做是安全的：

delete from owa_domstream;

来缩小数据库的大小。