Calendar
Members
Search
Help
RSS Feed  Regenerateadserverstatistics.php |
OpenX Community Forums > Technical Support (2.8 & 2.6) > Configuration/Settings and Performance Tuning  |
 Dec 27 2008, 08:09 PM
Post
#1
|
|
|
Beginner  Group: Members Posts: 9 Joined: 1-October 08 Member No.: 23,459  |
Hi Guys,
Every so often our stats have a habit of going up into the billions and crashing the database. I have heard that regenerateAdServerStatistics.php can fix this issue and regenerate the stats for a specific time period so they show the correct numbers. We have our openX install set to keep data for 3 days, yesterday the database crashed after taking the numbers up to 35 million. I ran a fix on the raw impressions, and set the date/time in the regenerateAdServerStatistics.php file and ran it, only problem is it didnt actually regenerate any stats (for incorrectly reported hours, or hours that didnt show any data). Does anyone know why this is? I have set the database to run a backup every 12 hours, because of the unpredictability of the stats being able to show the correct amount of views. If regenerateAdServerStatistics.php isnt doing what it should, how would I get the correct stats date to show if it crashes inbetween the 12 hour backup? Cheers Adam |
 |
 
|
|
Dec 29 2008, 10:15 AM
Post
#2
|
|
|
Mentor Group: Members Posts: 7,442 Joined: 17-June 08 From: Poland Member No.: 21,806 |
Hi Adam,
The regenerateAdServerStatistics.php script can be run only for 1 hour period (when setting the time frame to regenerate). Please try to regenerate stats from a certain hour. This should work. |
|
|
|
|
Jan 1 2009, 05:51 PM
Post
#3
|
|
|
Beginner Group: Members Posts: 9 Joined: 1-October 08 Member No.: 23,459 |
Thanks for the reply,
The databse stopped showing impressions at midnight (although it is showinf clicks), I ran the script but nothing changed. Regenerating statistics for the range: "2009-01-01 02:00:00" to "2009-01-01 02:59:59" Press CTRL-C within 10 seconds to cancel... it still shows no impressions for that hour. Any suggestions? Cheers Adam |
|
|
|
|
Jan 2 2009, 12:23 PM
Post
#4
|
|
|
Mentor Group: Members Posts: 7,442 Joined: 17-June 08 From: Poland Member No.: 21,806 |
Hi Adam,
To regenerate your stats, your '_raw_data_' tables need to contain data from the perion you are trying to regenerate stats. Otherwise it wil not regenerate it. Please double check if your '_summary_' and '_raw_data_' tables are not corrupted. Please run REPAIR and CHECK commands on it. Additionally, I would recommend to decrease the time frame between maintenance executions from 60 mins to e.g. 30 to improve maintenence preformance. |
|
|
|
|
Mar 16 2009, 12:08 PM
Post
#5
|
|
|
Advanced Member Group: Members Posts: 54 Joined: 13-February 09 From: Tokyo Member No.: 25,784 |
QUOTE (Michal Czosnyka @ Jan 2 2009, 09:23 PM)  To regenerate your stats, your '_raw_data_' tables need to contain data from the perion you are trying to regenerate stats. Otherwise it wil not regenerate it. Please double check if your '_summary_' and '_raw_data_' tables are not corrupted. Please run REPAIR and CHECK commands on it. May I ask why data is needed in '_summary_' tables? In regenerateAdServerStatistics.php: CODE OA_Maintenance_Regenerate::clearIntermediateAndSummaryTables($oStartDate, $oEndDate); ...this function looks like it deletes all data within the specified time period within the '_intermediate_' as well as all '_summary_' tables. |
|
|
|
|