On Fri, Nov 13, 2009 at 2:12 PM, Joseph Salisbury <[email protected]> wrote: > On Fri, Nov 13, 2009 at 9:14 AM, Mark van Harmelen > <[email protected]> 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.
Woops: s/cpustat/mpstat/g :-) > > 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 >> [email protected] >> https://lists.ubuntu.com/mailman/listinfo/ubuntu-server >> More info: https://wiki.ubuntu.com/ServerTeam >> > -- ubuntu-server mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-server More info: https://wiki.ubuntu.com/ServerTeam
