On 01/18/2013 12:15 PM, John Hill wrote:
> About 14GB. 8GB memory was fine with DPM 1.8.3, so if it is inadequate
> now then something significant has changed - and there's nothing in
> the Release Notes highlighting the need for a larger machine for 1.8.4
> or 1.8.5.
Hi John,
I don't know very much about mysql, but Oracle would struggle
if the "buffer cache" was too small. It would have to keep paging
blocks out to fit new ones in, which made it waity. Maybe check that
you have decent buffers on your DB. I know there are some
settings in the /etc/my.cfg e.g. maybe
set-variable=innodb_buffer_pool_size=8000M,
(or query_cache_size=16000000???)
If you have 8GB of mem, some DBA's recommend using half of it
for the buffer cache (assuming nothing else but the OS runs there).
That's very naive, so I guess you'd have to select an appropriate size
if other services run there. I dunno - just a few ideas...
Steve
--
Steve Jones [log in to unmask]
System Administrator office: 220
High Energy Physics Division tel (int): 42334
Oliver Lodge Laboratory tel (ext): +44 (0)151 794 2334
University of Liverpool http://www.liv.ac.uk/physics/hep/
|