[brlug-general] MySQL performance - Was: Re[2]: mosix clusters?

[Dustin Puryear]

An interesting story about MySQL:

http://weblog.mediatemple.net/weblog/2007/01/19/anatomy-of-mysql-on-the-grid/

---
Puryear Information Technology, LLC
Baton Rouge, LA * 225-706-8414
http://www.puryear-it.com

Author:
  "Best Practices for Managing Linux and UNIX Servers"
  "Spam Fighting and Email Security in the 21st Century"

Download your free copies:
  http://www.puryear-it.com/publications.htm


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
> http://www.puryear-it.com

> Author:
>   "Best Practices for Managing Linux and UNIX Servers"
>   "Spam Fighting and Email Security in the 21st Century"

> Download your free copies:
>   http://www.puryear-it.com/publications.htm


> Wednesday, January 17, 2007, 6:33:44 AM, you wrote:

>> I use cacti for performance monitoring.
>> http://cacti.net/
>> 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
>>> --
>>> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>>> 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
>>> http://mail.brlug.net/mailman/listinfo/general_brlug.net
>>>




> _______________________________________________
> General mailing list
> General at brlug.net
> http://mail.brlug.net/mailman/listinfo/general_brlug.net