On Fri, 2005-04-08 at 09:47 +1000, Scott Fagg wrote:
> Using InnoDB and binary logs gets about 1MB/s throughput on the server,
> but 5MB/s on the desktop.
is dma on? right drivers for the server? sounds like a problem along
those lines.
> I was wondering if a change of filesystem would help, but it sounds as
> though it would not.
it *some* areas it does... some others, it doesn't. i hope to analyse
the results further sometime soon.
one thing is for certain, create+drop is MUCH faster on XFS - but that's
not your time critical database operation :) (at least 300% faster than
ext3).
> Using MyISAM and turning off binary logs, gets me reasonable performance
> , so perhaps i have a filesystem problem or a storage array (hardware
> raid) problem.
could be driver issue - you should be getting higher performance than
what you are.
> I've also tried toggling between mysql v3 and v5, the FC3 kernel RPM and
> a vanilla kernel from kernel.org, but all that has had little impact.
performance of mysql 3 through 5 should be about the same or better
> Other processes can write to disc at much higher rates than mysql, so
> perhaps i should take this problem to a different forum ..
this is interesting... maybe try a bonnie++ run on the disk.
You may also need to tune mysql parameters - check out the manual or the
MySQL Administrator GUI tool (which also does some performance
monitoring).
--
Stewart Smith, Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@xxxxxxxxxxxxxxxx
Mobile: +61 4 3 8844 332
Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html
signature.asc
Description: This is a digitally signed message part
|