[TriLUG] need consulting for LAMP server

[Warren Myers via TriLUG]

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