Re: Database regression due to scheduler changes ?

David Lang
2005-11-07T22:35:45Z

Brian,
If I am understanding the data you posted, it looks like you are useing
sched_yield extensivly in your database. This is known to have significant
problems on SMP machines, and even bigger ones on NUMA machines, in part
becouse the process doing the sched_yield may get rescheduled immediatly
and not allow other processes to run (to free up whatever resource it's
waiting for). This causes the processor to look busy to the scheduler and
therefor the scheduler doesn't migrate other processes to the CPU that's
spinning on sched_yield. On NUMA machines this is even more noticable as
processes now have to migrate through an additional layer of the
scheduler.

have to tried eliminating the sched_yield to see what difference it makes?

David Lang

--
There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies.
-- C.A.R. Hoare