[TriLUG] need consulting for LAMP server

Fri Jun 3 14:57:45 EDT 2016

mysql has a performance monitoring tool I can't find the url for. I
mean besides the enterprise version. Percona and mariadb might have
something too

There is also mtop (old) and mytop

On Fri, Jun 3, 2016 at 2:21 PM, Matt Pusateri via TriLUG
<trilug at trilug.org> wrote:
> If you think it's at all DB related, go get Monyog or sqlyog, well worth the price, think their might be a 30 day trial
>
> Matt P
>
> Sent from my iPhone
>
>> On Jun 3, 2016, at 12:39 PM, Todd Edwards via TriLUG <trilug at trilug.org> wrote:
>>
>> I came here to say this. You need to make sure your application isn't doing
>> too many joins, you're doing lookups by index where possible, etc...
>>
>> Poor SQL queries can destroy your performance.
>>
>> -- Todd
>>
>> On Fri, Jun 3, 2016 at 11:57 AM, Warren Myers via TriLUG <trilug at trilug.org>
>> wrote:
>>
>>> I'll second, third, and fourth that!
>>>
>>> Dumb example, I found the IN(...) syntax a decade ago was way *way* faster
>>> than sequential OR clauses - as in <2 seconds to run vs >500 (on the
>>> dataset I had at the time)
>>>
>>> On Fri, Jun 3, 2016 at 11:36 AM, Scott Lambdin via TriLUG <
>>> trilug at trilug.org
>>>> wrote:
>>>
>>>> One thing I have learned in my so called career is that a proper SQL
>>> person
>>>> can write far more efficient queries than us sysadmin types.  (okay,
>>> maybe
>>>> I should speak only for myself)
>>>>
>>>> Maybe have the queries sanity checked?
>>>>
>>>> --Scott
>>>>
>>>> On Fri, Jun 3, 2016 at 8:30 AM, Ken MacKenzie via TriLUG <
>>>> trilug at trilug.org>
>>>> wrote:
>>>>
>>>>> Another monitoring tool to try out is glances.  It is a python
>>> script.  A
>>>>> pip install of it might be easiest.  Nice output and shows disk IO as
>>>> part
>>>>> of its monitoring.
>>>>>
>>>>> Ken
>>>>>
>>>>> On Fri, Jun 3, 2016 at 7:09 AM, Ronald Kelley via TriLUG <
>>>>> trilug at trilug.org>
>>>>> wrote:
>>>>>
>>>>>> Is your DB setup for replication?  That could cause some issues
>>> during
>>>>>> heavy I/O.
>>>>>>
>>>>>>
>>>>>> Couple suggestions:
>>>>>>
>>>>>> During the busy time, run “iotop”, “htop”, and “nmon” in separate
>>>> windows
>>>>>> so you can see them together at one time.  These should help pinpoint
>>>>> where
>>>>>> the contention lies.  Also, suggest you creating a non-DB related
>>> HTML
>>>>> page
>>>>>> to see if you can load just a text page during the busy time.
>>>>>>
>>>>>> Try to narrow down the issue to CPU, RAM, Disk, or Network.  While 2x
>>>> SAS
>>>>>> drives sounds good, you might be hitting some sort of disk IO wait
>>>> issue
>>>>>> causing the DB to slow down.
>>>>> --
>>>>> This message was sent to: Scott Lambdin <lopaki at gmail.com>
>>>>> To unsubscribe, send a blank message to trilug-leave at trilug.org from
>>>> that
>>>>> address.
>>>>> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
>>>>> Unsubscribe or edit options on the web  :
>>>>> http://www.trilug.org/mailman/options/trilug/lopaki%40gmail.com
>>>>> Welcome to TriLUG: http://trilug.org/welcome
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> Eat like you give a damn.  Go vegan.
>>>> --
>>>> This message was sent to: Warren <volcimaster at gmail.com>
>>>> To unsubscribe, send a blank message to trilug-leave at trilug.org from
>>> that
>>>> address.
>>>> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
>>>> Unsubscribe or edit options on the web  :
>>>> http://www.trilug.org/mailman/options/trilug/volcimaster%40gmail.com
>>>> Welcome to TriLUG: http://trilug.org/welcome
>>>
>>>
>>>
>>> --
>>> *Warren Myers*
>>> http://antipaucity.com
>>> http://twitter.com/warrenmyers
>>> http://www.linkedin.com/in/warrenmyers
>>> https://www.digitalocean.com/?refcode=d197a961987a
>>> TXT WMYERS to 50500 | http://contxts.com
>>> --
>>> This message was sent to: Todd Edwards <todd at mtn.cc>
>>> To unsubscribe, send a blank message to trilug-leave at trilug.org from that
>>> address.
>>> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
>>> Unsubscribe or edit options on the web  :
>>> http://www.trilug.org/mailman/options/trilug/todd%40mtn.cc
>>> Welcome to TriLUG: http://trilug.org/welcome
>> --
>> This message was sent to: M. Pusateri <mpusateri at wickedtrails.com>
>> To unsubscribe, send a blank message to trilug-leave at trilug.org from that address.
>> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
>> Unsubscribe or edit options on the web    : http://www.trilug.org/mailman/options/trilug/mpusateri%40wickedtrails.com
>> Welcome to TriLUG: http://trilug.org/welcome
>
> --
> This message was sent to: raubvogel at gmail.com <raubvogel at gmail.com>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web  : http://www.trilug.org/mailman/options/trilug/raubvogel%40gmail.com
> Welcome to TriLUG: http://trilug.org/welcome