[ic] Jobs are slowing IC
Jon Jensen
jon at endpoint.com
Fri Mar 18 20:19:14 UTC 2011
On Fri, 18 Mar 2011, Grant wrote:
> They're real IC Jobs and they're database-intensive. I use the default
> Jobs MaxServers 1 so they don't overlap.
Ok. Is your database running on the same machine as your app server? If
so, you may want to consider separating them onto different machines.
But before doing that, look at whether the database is actually
overloaded, or whether you have lock contention. If you're using MySQL,
are your tables MyISAM or InnoDB? MyISAM tables lock completely for any
kind of write, so no reads can happen till the writing is done. You may
need to switch to InnoDB, which as other benefits such as transactions as
well.
If you're using another database, you'll still want to look into lock
contention on both tables and indexes, etc.
You also may want to consider running more than one of your jobs at a
time, during off hours, if that makes sense for what they do.
Jon
--
Jon Jensen
End Point Corporation
http://www.endpoint.com/
More information about the interchange-users
mailing list