afrayer
11-15-06, 11:11 AM
I have a Perl script that verifies URLs in a MySQL database. The script has been working for a few months (all post-migration), but as the database grows, the script naturally takes longer to execute.
The database now has something approaching 3,000 records. I don't think this is huge, but it is admittedly time consuming to check the URLs.
I think someone has decided it takes too long, as within the last few weeks the script has been dying, stating it could not connect to the database (even though nothing has changed except for volume).
I'm not sure how to troubleshoot this, and I don't think Level 1 support is going to get it, either.
I am assuming PowWeb can block individual scripts from accessing MySQL. Where do I find the restrictions on MySQL use? If I can figure out how to reduce the impact of the script, who would I need to contact to get the script's access restored?
The database now has something approaching 3,000 records. I don't think this is huge, but it is admittedly time consuming to check the URLs.
I think someone has decided it takes too long, as within the last few weeks the script has been dying, stating it could not connect to the database (even though nothing has changed except for volume).
I'm not sure how to troubleshoot this, and I don't think Level 1 support is going to get it, either.
I am assuming PowWeb can block individual scripts from accessing MySQL. Where do I find the restrictions on MySQL use? If I can figure out how to reduce the impact of the script, who would I need to contact to get the script's access restored?