[ic] Jobs are slowing IC

Grant emailgrant at gmail.com
Mon Mar 21 23:07:08 UTC 2011


>> 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.

Yes, they're on the same server.

> 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 MyISAM is default then that's what I'm using.  I bet you're right
on with this.  I bet it's lock contention and I'll try switching to
InnoDB.

Thanks,
Grant


> 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



More information about the interchange-users mailing list