[TriLUG] need consulting for LAMP server

[Matt Pusateri via TriLUG]

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