Hey guys, so the FunnelFlux support can't get me a solution until tomorrow morning -- hoping maybe someone with a tech background can chime in..
I ran two large reports in FF two days ago, one of them completed in under an hour --> the other is still processing (yes three days for one report)...Due to the background job, which I believe this is how reports are pulled... stats from the last three days are completely messed up. For today, I have been at the same number for 6 hours now, the stats have not changed a bit. While waiting for FF support to get back to me, I messaged Beyond -- I have their Dedi 24GB -- their support team suggested I delete some clicks as my DB is a little over 19gigs. This is also strange since FF guided me through the DB compression process, the DB stayed the same size. After deleting over 7 million clicks from last month for one of my campaigns, the DB size essentially stayed the same if not increased by a tiny bit. I messaged FF yesterday afternoon for help, their tech support guy got back to me around 5am my time asking for SSH credentials, I provided them to him around 9am when I woke up and havent heard back since. VitaVee was kind enough to respond but he cant help until tomorrow morning as he is not at his computer.
Does anyone have any idea on how to cancel out a report so it does not block stats...and/or have any idea why the database is not decreasing in size after deleting traffic? I can use
Thanks in advance..
Problem solved. VitaVee gave me the queries to run and it worked. If anyone gets stuck with this in the future these are queries you need..
Delete from stats_reports where timestampCompleted is null;
Delete from background_jobs where title like '%report%' and timestampCompleted is null;