Jump to content

VV_silent

Approved members
  • Content Count

    5
  • Joined

  • Last visited

About VV_silent

  • Rank
    Newbie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hm. I can see statistic now, but I don't understand what was the problem. But I have a statistic gap , is it possible to recalculate statistic ? I can see data in rv_data_bkt_m table
  2. I have moved DB server server from one ip to another, and changed the conf.php to the new ip, but after that I don't have updated statistic, although Scheduled maintenance is running correctly. and mysql> SELECT * FROM rv_data_bkt_m order by interval_start desc limit 20; +---------------------+-------------+---------+-------+ | interval_start | creative_id | zone_id | count | +---------------------+-------------+---------+-------+ | 2019-11-12 20:35:00 | 820 | 9 | 6 | | 2019-11-12 20:35:00 | 735 | 36 | 15252 | | 2019-11-12 20:35:00 | 734 | 36 | 14984 | | 2019-11-12 20:35:00 | 733 | 47 | 254 | | 2019-11-12 20:35:00 | 723 | 43 | 16 | | 2019-11-12 20:35:00 | 722 | 48 | 61 | | 2019-11-12 20:35:00 | 718 | 47 | 203 | | 2019-11-12 20:35:00 | 717 | 47 | 271 | | 2019-11-12 20:35:00 | 716 | 47 | 214 | | 2019-11-12 20:35:00 | 712 | 43 | 62 | | 2019-11-12 20:35:00 | 711 | 43 | 45 | | 2019-11-12 20:35:00 | 710 | 43 | 41 | | 2019-11-12 20:35:00 | 709 | 43 | 55 | | 2019-11-12 20:35:00 | 707 | 47 | 269 | | 2019-11-12 20:35:00 | 705 | 10 | 2055 | | 2019-11-12 20:35:00 | 705 | 9 | 1965 | | 2019-11-12 20:35:00 | 704 | 10 | 1976 | | 2019-11-12 20:35:00 | 704 | 9 | 2100 | | 2019-11-12 20:35:00 | 703 | 10 | 2028 | | 2019-11-12 20:35:00 | 703 | 9 | 2052 | +---------------------+-------------+---------+-------+ 20 rows in set (0.00 sec) What else can I check ? I have already checked https://documentation.revive-adserver.com/display/DOCS/No+Statistics
  3. Hello. I have found some malware links at the end of htmlcache column, is it safe just to set it empty ? target="{target}"></a><script type="text/javascript">var _0x4cfb=["vI0TViwnRmqSxKA=","vpIMWCsm","sZgFR update rv_banners set htmlcache='' where bannerid=495;
  4. Hello. Is it possible to configure revive ad to use mysql slave for reading for example ? Currently I have around 14k ops on my db server and I'm searching for load balancing solution.
  5. Hello. What content stored in rv_unique table and can I somehow truncate this table? Because it is already 100GB and it's a problem for me.
×
×
  • Create New...