[TriLUG] need consulting for LAMP server

[Todd Edwards via TriLUG]

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
>