… them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading…
Post: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
… running multiple cron jobs at the time may have. Here are few practices which should help you to keep your cron jobs under control… if you want to serialize jobs from multiple servers (for example you specially put script in CRON job on 2 servers for High… but information about cron errors should find you. Store Historical Run Times In a lot of cases when CRON job can’t complete…
Comment: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
…Watch out for your CRON jobs – Over at the MySQL Performance Blog, Peter Zaitsev gives some … guidelines on things to pay attention to when designing your cron jobs. Not just for databases. I like the idea of keeping…
Comment: Watch out for your CRON jobs
October 14, 2009 By 19 Comments
… back where cron job would periodically fire up 50 instances of php processes (which used mysql as a job queue and a job manager… of running multiple copies was handled via job_is_running, retry_count etc switches in jobs table and there were surprisingly low count of jobs which got stuck. Those who would…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… large data sets(ie some large aggregate queries) and batch jobs. It is not rare to see queries which were taking… the disk, which may be 100% busy running your batch job query. This is especially bad when you only have one… the lowest load. Do not just place it in the cron job for 4AM and forget about it, it may be still…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
… to run this from cron and trigger Nagios if anything’s wrong you have to set up two cron jobs and synchronize them…
Comment: Unused indexes by single query
September 14, 2008 By 14 Comments
… probably someone somewhere running reports off your database using a cron job on a server you didn’t even know existed, which… to work, its queries will take too long and their job will fail inexplicably. This process probably isn’t monitored properly…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… by hand instead of through the init script. Overly zealous cron jobs to delete old files in /tmp can do the same…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… path less expensive, use a layered approach to your caching. Cron jobs and summary tables can be used to make the miss…
Comment: MySQL 5.5.8 - in search of stability
January 5, 2011 By 11 Comments
… with real users driving it and things like backups and cron jobs running every now and then, we’d see stable performance…
