Thanks Tim (off list) David and Joe regards mark <div class="gmail_quote">On Fri, Nov 13, 2009 at 7:14 PM, Joseph Salisbury <<a href="mailto:josephtsalisbury@gmail.com">josephtsalisbury@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div class="im">On Fri, Nov 13, 2009 at 2:12 PM, Joseph Salisbury <<a href="mailto:josephtsalisbury@gmail.com">josephtsalisbury@gmail.com</a>> wrote: > On Fri, Nov 13, 2009 at 9:14 AM, Mark van Harmelen > <<a href="mailto:markvanharmelen@gmail.com">markvanharmelen@gmail.com</a>> wrote: >> Hi everyone >> >> I've never done this before so all hints would be gratefully received. >> >> We are running a 9.04 server, with a single unthreaded process that is of >> interest, basically one that is busy transforming the contents of a mysql >> db. I want to find out if we can improve the performance of this process. >> >> Seems potential limitations are >> >> - limited by CPU speed >> - limited by access to mysql data on disc >> - limited by memory size, and therefore spending its time paging >> >> I'm wondering if anyone has any great commands and/or command options for >> me to start my investigations with, please. > > If you haven't already, install the sysstat package: > > sudo apt-get install sysstat > > This will give you some tools to gather performance statistics. To > start you need to identify where the bottleneck is. Use cpustat to > see if you are cpu bound, iostat to see if you are disk bound, vmstat > for pageing / memory stats, etc. </div>Woops: s/cpustat/mpstat/g :-) <div><div></div><div class="h5"> > > For more detailed analysis, you can install and use profiling tools > such as oprofile or systemtap. > >> >> Or any strategies, words of advice, or (instructional) sources that you >> found useful in tuning your own systems. > > This can be an open ended question when it comes to performance > tuning. The very simple answer is find your bottleneck and fix it. > There will always be a bottleneck and it will always move to another > resource once you fix it. The goal is to have your cpu become the > bottleneck(Then continue to tune your application). > > It is best to try and tune your application first to use the available > resource most efficiently. Don't just add more memory because your > swapping. First identify why the process is consuming so much memory > in the first place. > > Hope this helps, > > Joe > >> >> thanks >> mark >> >> >> >> >> >> >> >> -- >> ubuntu-server mailing list >> <a href="mailto:ubuntu-server@lists.ubuntu.com">ubuntu-server@lists.ubuntu.com</a> >> <a href="https://lists.ubuntu.com/mailman/listinfo/ubuntu-server" target="_blank">https://lists.ubuntu.com/mailman/listinfo/ubuntu-server</a> >> More info: <a href="https://wiki.ubuntu.com/ServerTeam" target="_blank">https://wiki.ubuntu.com/ServerTeam</a> >> > </div></div></blockquote></div>