[brlug-general] MySQL performance - Was: Re: mosix clusters?
dustin at puryear-it.com
Tue Jan 23 09:55:34 CST 2007
An interesting story about MySQL:
Puryear Information Technology, LLC
Baton Rouge, LA * 225-706-8414
"Best Practices for Managing Linux and UNIX Servers"
"Spam Fighting and Email Security in the 21st Century"
Download your free copies:
Wednesday, January 17, 2007, 9:48:01 AM, you wrote:
> Cacti rocks. We use it all over the place.
> Puryear Information Technology, LLC
> Baton Rouge, LA * 225-706-8414
> "Best Practices for Managing Linux and UNIX Servers"
> "Spam Fighting and Email Security in the 21st Century"
> Download your free copies:
> Wednesday, January 17, 2007, 6:33:44 AM, you wrote:
>> I use cacti for performance monitoring.
>> It's like a beefed up MRTG.
>> On 1/16/07, -ray <ray at ops.selu.edu> wrote:
>>> On Mon, 15 Jan 2007, Dustin Puryear wrote:
>>> > You should, at a minimum, have sysstat (the Linux sar package)
>>> > installed on all of your servers and monitor that. Also, do some
>>> > remote SNMP performance monitoring to start seeing where your
>>> > bottlenecks are. Keep in mind that IO issues may appear as CPU issues
>>> > at times.
>>> Good point. And also memory issues may appear as I/O issues (swapping).
>>> The right order to track down bottlenecks is: Network->Memory->I/O->CPU.
>>> Read the vmstat and iostat man pages, and actually learn what those
>>> columns mean. :)
>>> What are you guys using for SNMP performance monitoring? We have some
>>> homegrown scripts that generate some RRD graphs. The pretty graphs are
>>> really good for trend analysis (and the boss likes them haha).
>>> > Oh, and finally, do realize that there is a difference between local
>>> > performance counters and end-to-end performance testing. An important
>>> "Hmmmm...It's really fast from my computer....not sure why it's so
>>> slow on your end..."
>>> Ray DeJean http://www.r-a-y.org
>>> Systems Engineer Southeastern Louisiana University
>>> IBM Certified Specialist AIX Administration, AIX Support
>>> General mailing list
>>> General at brlug.net
> General mailing list
> General at brlug.net
More information about the General