From trilug at trilug.org  Mon May 30 10:43:12 2016
From: trilug at trilug.org (Keith Woodie via TriLUG)
Date: Mon, 30 May 2016 14:43:12 +0000
Subject: [TriLUG] OT Keyboards
In-Reply-To: <dcfd4301-9de8-67c3-a54a-e752b19bc029@millennium-technology.com>
References: <CALb-siCL3=s_rJF01Q9VaWUBs6K9CuJ5XRWWt=8VOZZ=ro+Wkw@mail.gmail.com>
 <CANLWi6kLkOWW2dN2ZBFpbiGDH54dOuxk2fKU-T38wxnYnk=_Aw@mail.gmail.com>
 <CALb-siD+MhZpUBoEhSgVQ5zC4ky2Nt67Lsy2CQJiv-8pwEdsRg@mail.gmail.com>
 <CAPjrFiPaUsAGhJDGCEKHkVDJHeEN340rpevK-PcJ08cGM_fAVA@mail.gmail.com>
 <CAB+J3AJ72SCRUGjn3b0A4K+MF-Y+XUozy+x=GaUi-S_23mFXiA@mail.gmail.com>
 <dcfd4301-9de8-67c3-a54a-e752b19bc029@millennium-technology.com>
Message-ID: <CALb-siA7=SLaJqOzQe+3cnxATMUNuVDa8G-rUepKWLrJ=jJe2g@mail.gmail.com>

I went with the Das Keyboard 4C Ultimate (blank keys).   Thanks for the
good discussion.

On Sun, May 29, 2016 at 4:01 PM David Both via TriLUG <trilug at trilug.org>
wrote:

> I have  several of the Unicomp buckling spring keyboards from
> http://www.pckeyboard.com/page/product/UB40P4A. They are as much like
> the great old IBM model M as you can get. I love the feel and the sound
> they make. I will never go back to other types of keyboards. I have
> tried many different mush-key keyboards, and a few of the other
> mechanical that have Cherry MX keys. I like the Cherry MX but the feel
> was still not quite right and they always broke within a year.
>
>
>
> On 05/29/2016 02:53 PM, Greg Brown via TriLUG wrote:
> > I *LOVED* the old IBM Model M.  Pure typing bliss.
> >
> > On Sun, May 29, 2016 at 2:34 PM, Wes Garrison via TriLUG <
> trilug at trilug.org>
> > wrote:
> >
> >> You need a buckling-spring keyboard:
> >> http://www.pckeyboard.com/page/product/UB40P4A
> >>
> >>  From the folks that used to make the venerable Model M. It's not quite
> the
> >> same quality as a Model M, but it's darned close.
> >>
> >> You can also check out WASD Keyboards <http://www.wasdkeyboards.com/>.
> >>
> >> They use Cherry MX switches, but I've found that even the Cherry MX
> Green
> >> switches aren't as "tough" as the buckling spring.
> >>
> >> -Wes
> >>
> >> _________________________________
> >> Wesley S. Garrison
> >> Network Engineer
> >> Xitech Communications, Inc.
> >> phone:  (919) 260-0803
> >> fax:       (919) 932-5051
> >> __________________________________
> >> "Lead us not into temptation, but deliver us from email."
> >>
> >> On Sun, May 29, 2016 at 1:55 PM, Keith Woodie via TriLUG <
> >> trilug at trilug.org>
> >> wrote:
> >>
> >>> I write quite a bit of code. I have been buying Logitech keyboards, but
> >>> about 1 to 1 1/2 years in the keys start sticking.
> >>>
> >>> I had a ergonomic Microsoft keyboard in college that I loved, however I
> >>> feel like the newer models look just as cheaply built as the logitech
> >> that
> >>> I am looking to replace.
> >>>
> >>> The Das keyboard appears to be mechanical, and should be tougher right?
> >>>
> >>> Thanks
> >>> On Sun, May 29, 2016 at 1:46 PM Matt Whitlow <
> >>> matt.church.whitlow at gmail.com>
> >>> wrote:
> >>>
> >>>> What's your main use, if typing I would go with a DasKeyboard.
> >>>> On May 29, 2016 1:45 PM, "Keith Woodie via TriLUG" <trilug at trilug.org
> >
> >>>> wrote:
> >>>>
> >>>>> Any recommendations on keyboards? Tired of buying cheap ones that
> wear
> >>> out
> >>>>> in no time.
> >>>>>
> >>>> --
> >>>>> This message was sent to: Matt Whitlow <
> matt.church.whitlow 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/matt.church.whitlow%40gmail.com
> >>>>> Welcome to TriLUG: http://trilug.org/welcome
> >>>>
> >>> --
> >>> This message was sent to: Wes <wes at xitechusa.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/wes%40xitechusa.com
> >>> Welcome to TriLUG: http://trilug.org/welcome
> >>>
> >> --
> >> This message was sent to: Greg Brown <gwbrown1 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/gwbrown1%40gmail.com
> >> Welcome to TriLUG: http://trilug.org/welcome
> >>
>
> --
>
>
> *********************************************************
> David P. Both, RHCE
> Millennium Technology Consulting LLC
> Raleigh, NC, USA
> 919-389-8678
>
> dboth at millennium-technology.com
>
> www.millennium-technology.com
> www.databook.bz - Home of the DataBook for Linux
> DataBook is a Registered Trademark of David Both
> *********************************************************
> This communication may be unlawfully collected and stored by the National
> Security Agency (NSA) in secret. The parties to this email do not consent
> to the
> retrieving or storing of this communication and any related metadata, as
> well as
> printing, copying, re-transmitting, disseminating, or otherwise using it.
> If you
> believe you have received this communication in error, please delete it
> immediately.
>
> --
> This message was sent to: Keith Woodie <kwoodie 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/kwoodie%40gmail.com
> Welcome to TriLUG: http://trilug.org/welcome

From trilug at trilug.org  Mon May 30 11:34:14 2016
From: trilug at trilug.org (Alan Porter via TriLUG)
Date: Mon, 30 May 2016 11:34:14 -0400
Subject: [TriLUG] Changing DNS Servers (was Request for help:
 residential internet service provider options.)
In-Reply-To: <5745EBC4.7060507@bronord.com>
References: <alpine.DEB.2.10.1605251633100.5418@www.wm7d.net>
 <5745EBC4.7060507@bronord.com>
Message-ID: <574C5D76.8050206@trilug.org>


> Resolv.conf is no longer a static file and gets re-written by the system.

This depends.

If you have the "resolvconf" package installed, or if you are running 
network-manager, then this file might get overwritten.  If not, then the 
file stays put.

There are several ways to configure DNS, and it's super flexible (and 
therefore confusing).

I have both dnsmasq and unbound running on my router.  Dnsmasq is a 
local DHCP server and a caching DNS server, and it forwards any cache 
misses to an upstream DNS server.  For the truly paranoid, unbound is a 
recursive DNS server that does the name lookups itself.

So there might be a few places you can set your nameserver that will 
affect the /etc/resolv.conf file:
  - /etc/resolv.conf itself, if you do not have something that overwrites it
  - /etc/resolvconf/*, which allows packages like unbound and dnsmasq to 
plug entries in
  - /etc/dhcp/dhclient.conf - try the "supersede domain-name-servers" option
  - /etc/network/interfaces can have entries that will affect 
/etc/resolv.conf

Alan



From trilug at trilug.org  Mon May 30 14:36:29 2016
From: trilug at trilug.org (Lance A. Brown via TriLUG)
Date: Mon, 30 May 2016 14:36:29 -0400
Subject: [TriLUG] OT Keyboards
In-Reply-To: <dcfd4301-9de8-67c3-a54a-e752b19bc029@millennium-technology.com>
References: <CALb-siCL3=s_rJF01Q9VaWUBs6K9CuJ5XRWWt=8VOZZ=ro+Wkw@mail.gmail.com>
 <CANLWi6kLkOWW2dN2ZBFpbiGDH54dOuxk2fKU-T38wxnYnk=_Aw@mail.gmail.com>
 <CALb-siD+MhZpUBoEhSgVQ5zC4ky2Nt67Lsy2CQJiv-8pwEdsRg@mail.gmail.com>
 <CAPjrFiPaUsAGhJDGCEKHkVDJHeEN340rpevK-PcJ08cGM_fAVA@mail.gmail.com>
 <CAB+J3AJ72SCRUGjn3b0A4K+MF-Y+XUozy+x=GaUi-S_23mFXiA@mail.gmail.com>
 <dcfd4301-9de8-67c3-a54a-e752b19bc029@millennium-technology.com>
Message-ID: <b271123f-11d4-3c68-ac42-4f268099cac3@bearcircle.net>



David Both via TriLUG wrote on 5/29/2016 3:02 PM:
> I have  several of the Unicomp buckling spring keyboards from
> http://www.pckeyboard.com/page/product/UB40P4A. They are as much like
> the great old IBM model M as you can get. I love the feel and the sound
> they make. I will never go back to other types of keyboards. I have
> tried many different mush-key keyboards, and a few of the other
> mechanical that have Cherry MX keys. I like the Cherry MX but the feel
> was still not quite right and they always broke within a year.

I have two Unicomp buckling spring keyboards and absolutely love them.
The only drawback is the noise level if you spend time on phone calls
and need to continue typing.  I have to make sure to mute my mic when
not speaking.  Even with a headset and good mic, the clacking comes
through strongly.  Don't ask me how I know. :-)

--[Lance]

From trilug at trilug.org  Mon May 30 14:36:57 2016
From: trilug at trilug.org (Grawburg via TriLUG)
Date: Mon, 30 May 2016 14:36:57 -0400
Subject: [TriLUG] OT Keyboards
In-Reply-To: <mailman.0.1464624001.17108.trilug@trilug.org>
References: <mailman.0.1464624001.17108.trilug@trilug.org>
Message-ID: <bf17fe4c7fe823da64216c4db90233af@myglnc.com>

I've used a Unicomp with a Trackpoint (like my Thinkpad) for a couple of years. Worth the $105.
http://www.pckeyboard.com/page/product/UB40PGA

Brian Grawburg

-----Original Message----- 

> Subject: [TriLUG] OT Keyboards 
> 
> Any recommendations on keyboards? Tired of buying cheap ones that wear out
> in no time.

-- 
[This was sent from a PC running Debian 7, 64-bit Linux. No Microsoft products were used.]





From trilug at trilug.org  Mon May 30 16:41:06 2016
From: trilug at trilug.org (Steve Litt via TriLUG)
Date: Mon, 30 May 2016 16:41:06 -0400
Subject: [TriLUG] OT Keyboards
In-Reply-To: <CALxSUCWdQ8UgMDQWoKauPheZX1NH3sbs2mHEzqPSME6BAmb1Gw@mail.gmail.com>
References: <CALb-siCL3=s_rJF01Q9VaWUBs6K9CuJ5XRWWt=8VOZZ=ro+Wkw@mail.gmail.com>
 <CALxSUCWdQ8UgMDQWoKauPheZX1NH3sbs2mHEzqPSME6BAmb1Gw@mail.gmail.com>
Message-ID: <20160530164106.71a4ba56@mydesk.domain.cxm>

On Sun, 29 May 2016 14:52:47 -0400
Steve Holton via TriLUG <trilug at trilug.org> wrote:

> Take a look at http://perixx.com/en/products/perixx-pro-9.html
> 
> May not suit your style.
> 
> This is a traditional 'generic' keyboard, full size, no media keys,
> full-stroke keys, no included USB hub.
> 
> I bought one because I wanted a white keyboard with black lettering.

How does it feel? Does it "collapse" toward the bottom, so you have
tactile feedback that the key's been successfully pressed?

SteveT

Steve Litt 
May 2016 featured book: Rapid Learning for the 21st Century
http://www.troubleshooters.com/rl21

From trilug at trilug.org  Mon May 30 18:12:40 2016
From: trilug at trilug.org (Steve Holton via TriLUG)
Date: Mon, 30 May 2016 18:12:40 -0400
Subject: [TriLUG] OT Keyboards
In-Reply-To: <20160530164106.71a4ba56@mydesk.domain.cxm>
References: <CALb-siCL3=s_rJF01Q9VaWUBs6K9CuJ5XRWWt=8VOZZ=ro+Wkw@mail.gmail.com>
 <CALxSUCWdQ8UgMDQWoKauPheZX1NH3sbs2mHEzqPSME6BAmb1Gw@mail.gmail.com>
 <20160530164106.71a4ba56@mydesk.domain.cxm>
Message-ID: <CALxSUCWwAvJA28TKNT+_yz__BwNspMYxijyj2AoCFGeCMFQRJg@mail.gmail.com>

I think I know what you mean. I'd say yes.

The force required for the bottom-half if the stroke is less than the force
required for the top half.
Or, put another way, with key repeat turned off, it's exceedingly hard to
enter a letter twice without
accidentally letting enough pressure off the key for it to spring fully
back to the top.


On Mon, May 30, 2016 at 4:41 PM, Steve Litt <slitt at troubleshooters.com>
wrote:

> On Sun, 29 May 2016 14:52:47 -0400
> Steve Holton via TriLUG <trilug at trilug.org> wrote:
>
> > Take a look at http://perixx.com/en/products/perixx-pro-9.html
> >
> > May not suit your style.
> >
> > This is a traditional 'generic' keyboard, full size, no media keys,
> > full-stroke keys, no included USB hub.
> >
> > I bought one because I wanted a white keyboard with black lettering.
>
> How does it feel? Does it "collapse" toward the bottom, so you have
> tactile feedback that the key's been successfully pressed?
>
> SteveT
>
> Steve Litt
> May 2016 featured book: Rapid Learning for the 21st Century
> http://www.troubleshooters.com/rl21
>



-- 
Steve Holton
sph0lt0n at gmail.com

From trilug at trilug.org  Fri Jun  3 00:35:22 2016
From: trilug at trilug.org (Wes Garrison via TriLUG)
Date: Fri, 3 Jun 2016 00:35:22 -0400
Subject: [TriLUG] need consulting for LAMP server
Message-ID: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>

Folks,

I need help figuring out why my page load times atrocious during busy times
- we're talking 15 - 20 seconds for our internal pages *over our LAN* during
peak hours.

Here are the basics:
Debian 8 "Jessie" up to date as of this very minute
Apache 2.4 running mpm_prefork
MySql 5.5 using mostly InnoDB tables
Perl 5.20 via mod_perl

Server is a real machine with 16 cores at 1.8Ghz, 128GiB ECC RAM, and dual
15k RPM SAS drives.  It is hosted on a dedicated symmetric 100Mbps fiber
optic line.  It should be fast.

I'm only using about 17 GiB of RAM during peak times, so that doesn't seem
to be the issue.

I have noticed that when it's busy, *top *shows *mysqld *using 700% - 1200%
of CPU, which seems like a big problem to me.

*apache2.conf* config is:
KeepAlive On
MaxKeepAliveRequests 0  # unlimited keep alive requests
KeepAliveTimeout 5

Apache *mpm_prefork *config is:
StartServers            5
MinSpareServers         5
MaxSpareServers         10
MaxRequestWorkers       500  # 500 processes!!!
ServerLimit             500
MaxConnectionsPerChild  0     # unlimited connections per child process

running apache2 mod_status shows that the number of connections is rarely
above 70.

*my.cnf* config is:
bind-address = 127.0.0.1  # only allow connections from local machine
innodb_buffer_pool_size = 15G  # most tables are innodb, and 15G is more
than enough
key_buffer              = 1G
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
max_connections        = 500
table_cache            = 1200
query_cache_limit       = 1M
query_cache_size        = 500M

mysqltuner stats look decent:
-------- Storage Engine Statistics
-------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: *577M* (Tables: 32)
[--] Data in InnoDB tables: *4G* (Tables: 45)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 55

-------- Security Recommendations
 -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics
-------------------------------------------------
[--] Up for: 4d 22h 57m 22s (37M q [87.054 qps], 1M conn, TX: 32B, RX: 5B)
[--] Reads / Writes: 95% / 5%
[--] Total buffers: 16.5G global + 2.7M per thread (500 max threads)
[OK] Maximum possible memory usage: 17.8G (14% of installed RAM)
[OK] Slow queries: 0% (14/37M)
[OK] Highest usage of available connections: 12% (61/500)
[OK] Key buffer size / total MyISAM indexes: 1.0G/280.0M
[!!] Key buffer hit rate: 91.7% (7K cached / 617 reads)
[OK] Query cache efficiency: 71.1% (24M cached / 35M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (10K temp sorts / 1M sorts)
[OK] Temporary tables created on disk: 0% (9K on disk / 1M total)
[OK] Thread cache hit rate: 95% (55K created / 1M connections)
[OK] Table cache hit rate: 97% (243 open / 250 opened)
[OK] Open file limit used: 3% (113/2K)
[OK] Table locks acquired immediately: 99% (14M immediate / 14M locks)
[OK] InnoDB buffer pool / data size: 15.0G/4.2G
[OK] InnoDB log waits: 0

To my eyes, everything looks good.

Is there anything that seems obviously wrong that I'm missing?

This is for business, so I'm happy to do a paid consultation if this gets
outside the scope of the TriLUG list.

-Wes

_________________________________
Wesley S. Garrison
Network Engineer
Xitech Communications, Inc.
phone:  (919) 260-0803
fax:       (919) 932-5051
__________________________________
"Lead us not into temptation, but deliver us from email."

From trilug at trilug.org  Fri Jun  3 06:20:55 2016
From: trilug at trilug.org (Phil Smith via TriLUG)
Date: Fri, 3 Jun 2016 10:20:55 +0000 (UTC)
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
Message-ID: <1253832002.4275976.1464949255950.JavaMail.yahoo@mail.yahoo.com>

It's been a long time since I used Debian, but back then they had a 'server' and 'desktop' kernel package (I built my own from source, there are thousands of configuration options).  Looking through the kernel packages section, there seems to be only one Debian amd64 kernel now.  There are some options in building the kernel that tune it for server usage where all tasks receive predictable time slices under heavy load, whereas a desktop kernel would try to make the foreground task such as playing a game more responsive at the expense of background tasks.  Since hardware is so fast today, a badly configured kernel can still appear fast under light load.  


Even on the desktop, the defaults for tickless timers, etc. need some tuning, for example, a couple of symptoms I'm still working on are: at the (non graphical) login prompt, the password is echoed as Gentoo, like most distros, is trying to run many things in parallel during init to win the 'fastest boot' contest.  Another issue is when the palemoon browser (and firefox from which is descended) are having trouble loading a page, they sort of lock up and this affects the rest of the desktop, so the kernel is allowing excessive time slices to tasks doing heavy socket of file i/o (kernel level vs. userspace preemption).  These symptoms are likelier to show up when you have older hardware than what the kernel developers use and test on.

I've no experience with LAMP where P=Perl vs. P=PHP, but I've seen a server farm of ~1000 physical blade servers run 'slow' with JAVA apps, and apparently Python has an incurable 'big lock' problem with multithreading so you might want to search what interpretive Perl's limitations are.


If writing a socket server app in a language like 'C', you accept connections quickly but then only queue the request, and pull requests from the queue with a reasonable number of threads that do not bog down the system, so possibly Apache is being allowed to dispatch too many tasks/threads at once.

A simple way to lock up almost any system is with node.js, which likes to do everything asynchronously, in parallel.  A few lines of code that act on every file in a directory (at the same time) may cause you to have to power off the system to regain control, and will take much longer to complete than if the tasks were done one file at a time.

Since you mentioned 'peak daytime hours' one cause of that is 'daisy chained switches' -- go in the server room during your slowdown and watch the blinking lights.

From trilug at trilug.org  Fri Jun  3 07:09:39 2016
From: trilug at trilug.org (Ronald Kelley via TriLUG)
Date: Fri, 3 Jun 2016 07:09:39 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
Message-ID: <6666D8B9-D1C6-4311-8719-52E4447B744A@gmail.com>

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.







On Jun 3, 2016, at 12:35 AM, Wes Garrison via TriLUG <trilug at trilug.org> wrote:

Folks,

I need help figuring out why my page load times atrocious during busy times
- we're talking 15 - 20 seconds for our internal pages *over our LAN* during
peak hours.

Here are the basics:
Debian 8 "Jessie" up to date as of this very minute
Apache 2.4 running mpm_prefork
MySql 5.5 using mostly InnoDB tables
Perl 5.20 via mod_perl

Server is a real machine with 16 cores at 1.8Ghz, 128GiB ECC RAM, and dual
15k RPM SAS drives.  It is hosted on a dedicated symmetric 100Mbps fiber
optic line.  It should be fast.

I'm only using about 17 GiB of RAM during peak times, so that doesn't seem
to be the issue.

I have noticed that when it's busy, *top *shows *mysqld *using 700% - 1200%
of CPU, which seems like a big problem to me.

*apache2.conf* config is:
KeepAlive On
MaxKeepAliveRequests 0  # unlimited keep alive requests
KeepAliveTimeout 5

Apache *mpm_prefork *config is:
StartServers            5
MinSpareServers         5
MaxSpareServers         10
MaxRequestWorkers       500  # 500 processes!!!
ServerLimit             500
MaxConnectionsPerChild  0     # unlimited connections per child process

running apache2 mod_status shows that the number of connections is rarely
above 70.

*my.cnf* config is:
bind-address = 127.0.0.1  # only allow connections from local machine
innodb_buffer_pool_size = 15G  # most tables are innodb, and 15G is more
than enough
key_buffer              = 1G
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
max_connections        = 500
table_cache            = 1200
query_cache_limit       = 1M
query_cache_size        = 500M

mysqltuner stats look decent:
-------- Storage Engine Statistics
-------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: *577M* (Tables: 32)
[--] Data in InnoDB tables: *4G* (Tables: 45)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 55

-------- Security Recommendations
-------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics
-------------------------------------------------
[--] Up for: 4d 22h 57m 22s (37M q [87.054 qps], 1M conn, TX: 32B, RX: 5B)
[--] Reads / Writes: 95% / 5%
[--] Total buffers: 16.5G global + 2.7M per thread (500 max threads)
[OK] Maximum possible memory usage: 17.8G (14% of installed RAM)
[OK] Slow queries: 0% (14/37M)
[OK] Highest usage of available connections: 12% (61/500)
[OK] Key buffer size / total MyISAM indexes: 1.0G/280.0M
[!!] Key buffer hit rate: 91.7% (7K cached / 617 reads)
[OK] Query cache efficiency: 71.1% (24M cached / 35M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (10K temp sorts / 1M sorts)
[OK] Temporary tables created on disk: 0% (9K on disk / 1M total)
[OK] Thread cache hit rate: 95% (55K created / 1M connections)
[OK] Table cache hit rate: 97% (243 open / 250 opened)
[OK] Open file limit used: 3% (113/2K)
[OK] Table locks acquired immediately: 99% (14M immediate / 14M locks)
[OK] InnoDB buffer pool / data size: 15.0G/4.2G
[OK] InnoDB log waits: 0

To my eyes, everything looks good.

Is there anything that seems obviously wrong that I'm missing?

This is for business, so I'm happy to do a paid consultation if this gets
outside the scope of the TriLUG list.

-Wes

_________________________________
Wesley S. Garrison
Network Engineer
Xitech Communications, Inc.
phone:  (919) 260-0803
fax:       (919) 932-5051
__________________________________
"Lead us not into temptation, but deliver us from email."
-- 
This message was sent to: Ron Kelley <rkelleyrtp 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/rkelleyrtp%40gmail.com
Welcome to TriLUG: http://trilug.org/welcome


From trilug at trilug.org  Fri Jun  3 07:33:20 2016
From: trilug at trilug.org (Jeremy Davis via TriLUG)
Date: Fri, 3 Jun 2016 07:33:20 -0400
Subject: [TriLUG] 9 June Meeting Reminder and Call for Raspberry Pi Speakers
Message-ID: <CACSroP3g8V+DjtAxiV87obups2inDOZhnou2LPQn9rHfabSgpA@mail.gmail.com>

TriLUG has an excellent talk lined up for 9 June 7-9pm. Topic includes open
hardware and running an source business. Come see the awesome creations of
ManiacalLabs and learn about the Kickstarter experiences that helped them
get started. There will purposely be plenty of time left after the talk for
install demos and Q and A. So come prepared to ask questions and to be
fascinated by LED eye candy.
https://trilug.org/Open-Hardware-for-Fun-and-Profit

Also:

Call for Raspberry Pi Speakers to Present at Triangle Linux User Group
meeting 14-July-2016 at the RTP Frontier.

TriLUG RPi Presenter Signup Form
https://airtable.com/shr6VjQTCYHt38oNz

trilug.org/TriLUG-RPi-Talks-14-July-2016

Jeremy Davis
TriLUG PR

From trilug at trilug.org  Fri Jun  3 08:30:47 2016
From: trilug at trilug.org (Ken MacKenzie via TriLUG)
Date: Fri, 3 Jun 2016 08:30:47 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <6666D8B9-D1C6-4311-8719-52E4447B744A@gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <6666D8B9-D1C6-4311-8719-52E4447B744A@gmail.com>
Message-ID: <CAA2Opa30-eGcXVbTmBz7tpwtYD=_fQvkb_j24qvuqLvr6bGLFg@mail.gmail.com>

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.
>
>
>
>
>

From trilug at trilug.org  Fri Jun  3 11:36:57 2016
From: trilug at trilug.org (Scott Lambdin via TriLUG)
Date: Fri, 3 Jun 2016 11:36:57 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAA2Opa30-eGcXVbTmBz7tpwtYD=_fQvkb_j24qvuqLvr6bGLFg@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <6666D8B9-D1C6-4311-8719-52E4447B744A@gmail.com>
 <CAA2Opa30-eGcXVbTmBz7tpwtYD=_fQvkb_j24qvuqLvr6bGLFg@mail.gmail.com>
Message-ID: <CA+Saneykt=RiRsXYfoTcQ+dHVVGGziVO1U+qXErk=XME6z8Ufw@mail.gmail.com>

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.

From trilug at trilug.org  Fri Jun  3 11:57:00 2016
From: trilug at trilug.org (Warren Myers via TriLUG)
Date: Fri, 3 Jun 2016 11:57:00 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CA+Saneykt=RiRsXYfoTcQ+dHVVGGziVO1U+qXErk=XME6z8Ufw@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <6666D8B9-D1C6-4311-8719-52E4447B744A@gmail.com>
 <CAA2Opa30-eGcXVbTmBz7tpwtYD=_fQvkb_j24qvuqLvr6bGLFg@mail.gmail.com>
 <CA+Saneykt=RiRsXYfoTcQ+dHVVGGziVO1U+qXErk=XME6z8Ufw@mail.gmail.com>
Message-ID: <CAP01zHEoT2gUKCWug-kydR9JN6m71pyEHXPvwEb6kDAnnV6iBA@mail.gmail.com>

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

From trilug at trilug.org  Fri Jun  3 12:39:22 2016
From: trilug at trilug.org (Todd Edwards via TriLUG)
Date: Fri, 3 Jun 2016 12:39:22 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAP01zHEoT2gUKCWug-kydR9JN6m71pyEHXPvwEb6kDAnnV6iBA@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <6666D8B9-D1C6-4311-8719-52E4447B744A@gmail.com>
 <CAA2Opa30-eGcXVbTmBz7tpwtYD=_fQvkb_j24qvuqLvr6bGLFg@mail.gmail.com>
 <CA+Saneykt=RiRsXYfoTcQ+dHVVGGziVO1U+qXErk=XME6z8Ufw@mail.gmail.com>
 <CAP01zHEoT2gUKCWug-kydR9JN6m71pyEHXPvwEb6kDAnnV6iBA@mail.gmail.com>
Message-ID: <CAHJ3xVsLe=7yzrqdTpE8NnVYWU4n7U+POb3utxn24bjpj371qQ@mail.gmail.com>

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
>

From trilug at trilug.org  Fri Jun  3 13:37:33 2016
From: trilug at trilug.org (Scott Lambdin via TriLUG)
Date: Fri, 3 Jun 2016 13:37:33 -0400
Subject: [TriLUG] 9 June Meeting Reminder and Call for Raspberry Pi
	Speakers
In-Reply-To: <CACSroP3g8V+DjtAxiV87obups2inDOZhnou2LPQn9rHfabSgpA@mail.gmail.com>
References: <CACSroP3g8V+DjtAxiV87obups2inDOZhnou2LPQn9rHfabSgpA@mail.gmail.com>
Message-ID: <CA+Sanexfr4kdY6_htvs_vak68hVsmGZs4QuTqXo_wjKGU4oqUg@mail.gmail.com>

here is a good speaker:
http://raspi.tv/wp-content/uploads/2014/08/PiHut-speaker_700.jpg

--Scott

On Fri, Jun 3, 2016 at 7:33 AM, Jeremy Davis via TriLUG <trilug at trilug.org>
wrote:

> TriLUG has an excellent talk lined up for 9 June 7-9pm. Topic includes open
> hardware and running an source business. Come see the awesome creations of
> ManiacalLabs and learn about the Kickstarter experiences that helped them
> get started. There will purposely be plenty of time left after the talk for
> install demos and Q and A. So come prepared to ask questions and to be
> fascinated by LED eye candy.
> https://trilug.org/Open-Hardware-for-Fun-and-Profit
>
> Also:
>
> Call for Raspberry Pi Speakers to Present at Triangle Linux User Group
> meeting 14-July-2016 at the RTP Frontier.
>
> TriLUG RPi Presenter Signup Form
> https://airtable.com/shr6VjQTCYHt38oNz
>
> trilug.org/TriLUG-RPi-Talks-14-July-2016
>
> Jeremy Davis
> TriLUG PR
> --
> 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.

From trilug at trilug.org  Fri Jun  3 13:52:58 2016
From: trilug at trilug.org (Craig Cook via TriLUG)
Date: Fri, 3 Jun 2016 17:52:58 +0000 (UTC)
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <mailman.1.1464969601.18380.trilug@trilug.org>
References: <mailman.1.1464969601.18380.trilug@trilug.org>
Message-ID: <124018231.795871.1464976378040.JavaMail.yahoo@mail.yahoo.com>

Sounds like high CPU usage for MySQL.  Last I checked, MySQL is single threaded.  What queries are running during your slowness?  e.g. if you have enough really slow queries it could slow down your overall response time.

Take a look at innotop as a good tool.

"show engine innodb status"

may also be a useful command to run in the DB.

Investigate your slow query log as well.

Craig

From trilug at trilug.org  Fri Jun  3 14:21:57 2016
From: trilug at trilug.org (Matt Pusateri via TriLUG)
Date: Fri, 3 Jun 2016 14:21:57 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAHJ3xVsLe=7yzrqdTpE8NnVYWU4n7U+POb3utxn24bjpj371qQ@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <6666D8B9-D1C6-4311-8719-52E4447B744A@gmail.com>
 <CAA2Opa30-eGcXVbTmBz7tpwtYD=_fQvkb_j24qvuqLvr6bGLFg@mail.gmail.com>
 <CA+Saneykt=RiRsXYfoTcQ+dHVVGGziVO1U+qXErk=XME6z8Ufw@mail.gmail.com>
 <CAP01zHEoT2gUKCWug-kydR9JN6m71pyEHXPvwEb6kDAnnV6iBA@mail.gmail.com>
 <CAHJ3xVsLe=7yzrqdTpE8NnVYWU4n7U+POb3utxn24bjpj371qQ@mail.gmail.com>
Message-ID: <8C5DA66B-19A1-43E4-9C1A-36138976A9E6@wickedtrails.com>

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


From trilug at trilug.org  Fri Jun  3 14:24:34 2016
From: trilug at trilug.org (Jeremy Davis via TriLUG)
Date: Fri, 3 Jun 2016 14:24:34 -0400
Subject: [TriLUG] 9 June Meeting Reminder and Call for Raspberry Pi
	Speakers
In-Reply-To: <CA+Sanexfr4kdY6_htvs_vak68hVsmGZs4QuTqXo_wjKGU4oqUg@mail.gmail.com>
References: <CACSroP3g8V+DjtAxiV87obups2inDOZhnou2LPQn9rHfabSgpA@mail.gmail.com>
 <CA+Sanexfr4kdY6_htvs_vak68hVsmGZs4QuTqXo_wjKGU4oqUg@mail.gmail.com>
Message-ID: <CACSroP1riC8UR1zsJkDWTMZfdUTSHzx-C4t7kJF-MZBz-Vf0fg@mail.gmail.com>

Plug that speaker into a Sonic Pi and you could do a Moogfest performance.

http://sonic-pi.net/



On Friday, June 3, 2016, Scott Lambdin <lopaki at gmail.com> wrote:

> here is a good speaker:
> http://raspi.tv/wp-content/uploads/2014/08/PiHut-speaker_700.jpg
>
> --Scott
>
> On Fri, Jun 3, 2016 at 7:33 AM, Jeremy Davis via TriLUG <trilug at trilug.org
> <javascript:_e(%7B%7D,'cvml','trilug at trilug.org');>> wrote:
>
>> TriLUG has an excellent talk lined up for 9 June 7-9pm. Topic includes
>> open
>> hardware and running an source business. Come see the awesome creations of
>> ManiacalLabs and learn about the Kickstarter experiences that helped them
>> get started. There will purposely be plenty of time left after the talk
>> for
>> install demos and Q and A. So come prepared to ask questions and to be
>> fascinated by LED eye candy.
>> https://trilug.org/Open-Hardware-for-Fun-and-Profit
>>
>> Also:
>>
>> Call for Raspberry Pi Speakers to Present at Triangle Linux User Group
>> meeting 14-July-2016 at the RTP Frontier.
>>
>> TriLUG RPi Presenter Signup Form
>> https://airtable.com/shr6VjQTCYHt38oNz
>>
>> trilug.org/TriLUG-RPi-Talks-14-July-2016
>>
>> Jeremy Davis
>> TriLUG PR
>> --
>> This message was sent to: Scott Lambdin <lopaki at gmail.com
>> <javascript:_e(%7B%7D,'cvml','lopaki at gmail.com');>>
>> To unsubscribe, send a blank message to trilug-leave at trilug.org
>> <javascript:_e(%7B%7D,'cvml','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.
>


-- 
Jeremy Davis
@jeremydavis0_0
www.linkedin.com/in/jeremydavisprofile/
www.trianglecareerdevelopment.com

From trilug at trilug.org  Fri Jun  3 14:57:45 2016
From: trilug at trilug.org (Mauricio Tavares via TriLUG)
Date: Fri, 3 Jun 2016 14:57:45 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <8C5DA66B-19A1-43E4-9C1A-36138976A9E6@wickedtrails.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <6666D8B9-D1C6-4311-8719-52E4447B744A@gmail.com>
 <CAA2Opa30-eGcXVbTmBz7tpwtYD=_fQvkb_j24qvuqLvr6bGLFg@mail.gmail.com>
 <CA+Saneykt=RiRsXYfoTcQ+dHVVGGziVO1U+qXErk=XME6z8Ufw@mail.gmail.com>
 <CAP01zHEoT2gUKCWug-kydR9JN6m71pyEHXPvwEb6kDAnnV6iBA@mail.gmail.com>
 <CAHJ3xVsLe=7yzrqdTpE8NnVYWU4n7U+POb3utxn24bjpj371qQ@mail.gmail.com>
 <8C5DA66B-19A1-43E4-9C1A-36138976A9E6@wickedtrails.com>
Message-ID: <CAHEKYV4AinEmoT1Ghmy4j7h_1ZPYfLUDHZXP2jQjwUFsopXeVw@mail.gmail.com>

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

From trilug at trilug.org  Fri Jun  3 16:32:04 2016
From: trilug at trilug.org (Wes Garrison via TriLUG)
Date: Fri, 3 Jun 2016 16:32:04 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <op.yig39havrns8nc@odin>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <op.yig39havrns8nc@odin>
Message-ID: <CAPjrFiM9R6WMMsCJipoUWM2S9SCk-i00YQ9Bm+3pFSdXEVoDOA@mail.gmail.com>

Lots of great info here, thanks for all the suggestions.

I think Peter Neilson may have put his finger on it.  I was searching for
various combinations of "mysql high cpu usage" and forgot about InnoDB.

I changed the engine for a lot of our tables a few months ago from MyISAM
to InnoDB and we do indeed have a lot of random primary keys.

I'll try adding auto_increment primary keys and see if that improves things.

There isn't really anything of consequence in the slow queries log, I don't
do a lot of large table joins, not using replication, and we're nowhere
near the max concurrent users.

I'll try to isolate the issue to CPU, Disk, or Network as Ronald suggested
using “iotop”, “htop”, and “nmon”.

I'll also check out InnoTop, MyTop, MonYog and sqlYog, and glances.

First I'm going to try changing the keys to be non-random and see how that
works out.

-Wes

_________________________________
Wesley S. Garrison
Network Engineer
Xitech Communications, Inc.
phone:  (919) 260-0803
fax:       (919) 932-5051
__________________________________
"Lead us not into temptation, but deliver us from email."

On Fri, Jun 3, 2016 at 4:52 AM, Peter Neilson <neilson at windstream.net>
wrote:

>
>>
> I'd think about InnoDB first. If for some reason it thinks that a random
> key needs to be inserted it has to reshuffle everything, moving large
> chunks of stuff around in tables.
>
> Here's a stackoverflow about the difficulty:
>
> http://stackoverflow.com/questions/9819271/why-is-mysql-innodb-insert-so-slow
>
> This analysis is based on nothing more than about five minutes of poking
> around with Google and favoring stackoverflow results against other
> opinions. I am not an authority on any DB stuff. I've just occasionally
> noticed that page sloth seems to result from DB server problems as opposed
> to clogging in the network or in the rendering engines.
>

From trilug at trilug.org  Sat Jun  4 12:25:55 2016
From: trilug at trilug.org (=?UTF-8?Q?Crist=C3=B3bal_Palmer?= via TriLUG)
Date: Sat, 04 Jun 2016 16:25:55 +0000
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAPjrFiM9R6WMMsCJipoUWM2S9SCk-i00YQ9Bm+3pFSdXEVoDOA@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <op.yig39havrns8nc@odin>
 <CAPjrFiM9R6WMMsCJipoUWM2S9SCk-i00YQ9Bm+3pFSdXEVoDOA@mail.gmail.com>
Message-ID: <CAHYWVrwudESGCNr3i15OTgxsPwtO_+iaTL2r27MJktVBOU3fVw@mail.gmail.com>

I got to this: "I'll try adding auto_increment primary keys and see if that
improves things," and had to respond.

Many things can impact query response time, but to oversimplify: you want
fewer joins and more index-only queries. Adding an index only helps if
you're actually going to query that index. Don't add indexes in scattershot
fashion. An auto-increment primary key can ease and speed up indexing, and
can produce a small index, but if you can't query that index (because your
app doesn't use it)....

-CMP


On Fri, Jun 3, 2016 at 4:33 PM Wes Garrison via TriLUG <trilug at trilug.org>
wrote:

> Lots of great info here, thanks for all the suggestions.
>
> I think Peter Neilson may have put his finger on it.  I was searching for
> various combinations of "mysql high cpu usage" and forgot about InnoDB.
>
> I changed the engine for a lot of our tables a few months ago from MyISAM
> to InnoDB and we do indeed have a lot of random primary keys.
>
> I'll try adding auto_increment primary keys and see if that improves
> things.
>
> There isn't really anything of consequence in the slow queries log, I don't
> do a lot of large table joins, not using replication, and we're nowhere
> near the max concurrent users.
>
> I'll try to isolate the issue to CPU, Disk, or Network as Ronald suggested
> using “iotop”, “htop”, and “nmon”.
>
> I'll also check out InnoTop, MyTop, MonYog and sqlYog, and glances.
>
> First I'm going to try changing the keys to be non-random and see how that
> works out.
>
> -Wes
>
> _________________________________
> Wesley S. Garrison
> Network Engineer
> Xitech Communications, Inc.
> phone:  (919) 260-0803
> fax:       (919) 932-5051
> __________________________________
> "Lead us not into temptation, but deliver us from email."
>
> On Fri, Jun 3, 2016 at 4:52 AM, Peter Neilson <neilson at windstream.net>
> wrote:
>
> >
> >>
> > I'd think about InnoDB first. If for some reason it thinks that a random
> > key needs to be inserted it has to reshuffle everything, moving large
> > chunks of stuff around in tables.
> >
> > Here's a stackoverflow about the difficulty:
> >
> >
> http://stackoverflow.com/questions/9819271/why-is-mysql-innodb-insert-so-slow
> >
> > This analysis is based on nothing more than about five minutes of poking
> > around with Google and favoring stackoverflow results against other
> > opinions. I am not an authority on any DB stuff. I've just occasionally
> > noticed that page sloth seems to result from DB server problems as
> opposed
> > to clogging in the network or in the rendering engines.
> >
> --
> This message was sent to: Cristóbal Palmer <cmp at cmpalmer.org>
> 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/cmp%40cmpalmer.org
> Welcome to TriLUG: http://trilug.org/welcome

From trilug at trilug.org  Sat Jun  4 12:30:43 2016
From: trilug at trilug.org (David Brain via TriLUG)
Date: Sat, 4 Jun 2016 12:30:43 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAHYWVrwudESGCNr3i15OTgxsPwtO_+iaTL2r27MJktVBOU3fVw@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <op.yig39havrns8nc@odin>
 <CAPjrFiM9R6WMMsCJipoUWM2S9SCk-i00YQ9Bm+3pFSdXEVoDOA@mail.gmail.com>
 <CAHYWVrwudESGCNr3i15OTgxsPwtO_+iaTL2r27MJktVBOU3fVw@mail.gmail.com>
Message-ID: <CAOSWJQ-hJAeVa=cqtBzHDY_mL6cXuLZODvGi-q2+CeUOK2YVPg@mail.gmail.com>

Hi,

Take a look at the tuning for innodb - this seems to be a decent guide
(https://www.percona.com/blog/2013/09/20/innodb-performance-optimization-basics-updated/)
-  mysql's defaults are more suitable for a small/test DB.

A 'show full processlist \G' in mysql will give you a list of what's
currently running, which may reveal lock issues etc.  You can also set
up slow query logging
(http://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html) which
will log specific queries that are taking 'too long'.

David.

On Sat, Jun 4, 2016 at 12:25 PM, Cristóbal Palmer <trilug at trilug.org> wrote:
> I got to this: "I'll try adding auto_increment primary keys and see if that
> improves things," and had to respond.
>
> Many things can impact query response time, but to oversimplify: you want
> fewer joins and more index-only queries. Adding an index only helps if
> you're actually going to query that index. Don't add indexes in scattershot
> fashion. An auto-increment primary key can ease and speed up indexing, and
> can produce a small index, but if you can't query that index (because your
> app doesn't use it)....
>
> -CMP
>
>
> On Fri, Jun 3, 2016 at 4:33 PM Wes Garrison via TriLUG <trilug at trilug.org>
> wrote:
>
>> Lots of great info here, thanks for all the suggestions.
>>
>> I think Peter Neilson may have put his finger on it.  I was searching for
>> various combinations of "mysql high cpu usage" and forgot about InnoDB.
>>
>> I changed the engine for a lot of our tables a few months ago from MyISAM
>> to InnoDB and we do indeed have a lot of random primary keys.
>>
>> I'll try adding auto_increment primary keys and see if that improves
>> things.
>>
>> There isn't really anything of consequence in the slow queries log, I don't
>> do a lot of large table joins, not using replication, and we're nowhere
>> near the max concurrent users.
>>
>> I'll try to isolate the issue to CPU, Disk, or Network as Ronald suggested
>> using “iotop”, “htop”, and “nmon”.
>>
>> I'll also check out InnoTop, MyTop, MonYog and sqlYog, and glances.
>>
>> First I'm going to try changing the keys to be non-random and see how that
>> works out.
>>
>> -Wes
>>
>> _________________________________
>> Wesley S. Garrison
>> Network Engineer
>> Xitech Communications, Inc.
>> phone:  (919) 260-0803
>> fax:       (919) 932-5051
>> __________________________________
>> "Lead us not into temptation, but deliver us from email."
>>
>> On Fri, Jun 3, 2016 at 4:52 AM, Peter Neilson <neilson at windstream.net>
>> wrote:
>>
>> >
>> >>
>> > I'd think about InnoDB first. If for some reason it thinks that a random
>> > key needs to be inserted it has to reshuffle everything, moving large
>> > chunks of stuff around in tables.
>> >
>> > Here's a stackoverflow about the difficulty:
>> >
>> >
>> http://stackoverflow.com/questions/9819271/why-is-mysql-innodb-insert-so-slow
>> >
>> > This analysis is based on nothing more than about five minutes of poking
>> > around with Google and favoring stackoverflow results against other
>> > opinions. I am not an authority on any DB stuff. I've just occasionally
>> > noticed that page sloth seems to result from DB server problems as
>> opposed
>> > to clogging in the network or in the rendering engines.
>> >
>> --
>> This message was sent to: Cristóbal Palmer <cmp at cmpalmer.org>
>> 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/cmp%40cmpalmer.org
>> Welcome to TriLUG: http://trilug.org/welcome
> --
> This message was sent to: dbrain at gmail.com <dbrain 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/dbrain%40gmail.com
> Welcome to TriLUG: http://trilug.org/welcome

From trilug at trilug.org  Sat Jun  4 13:35:19 2016
From: trilug at trilug.org (Michael Kimsal via TriLUG)
Date: Sat, 4 Jun 2016 13:35:19 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAHYWVrwudESGCNr3i15OTgxsPwtO_+iaTL2r27MJktVBOU3fVw@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <op.yig39havrns8nc@odin>
 <CAPjrFiM9R6WMMsCJipoUWM2S9SCk-i00YQ9Bm+3pFSdXEVoDOA@mail.gmail.com>
 <CAHYWVrwudESGCNr3i15OTgxsPwtO_+iaTL2r27MJktVBOU3fVw@mail.gmail.com>
Message-ID: <CALx6ktoSNptaCJFq9_m25-O-_=ScK0BZL8xPndQ=bkfgyJrt+w@mail.gmail.com>

Apologies for the bad reply - I don't have the original email to reply to.

Wes, you mentioned 15-20 second page load times, and have since been
talking about MySQL optimization, and then pointed out in another reply
that there's "nothing of consequence" in the slow query log.

If you verify that the slow query log is, in fact, working properly, and
this was a DB problem, you'd see 15 second times in the slow query log.

I would submit the problem is not in the querying, but the processing of
those results by whatever app is processing the results in to a page.

Log all your queries for a particularly slow page request.

Run those queries again by hand, outside the app - is anything egregiously
slow?



On Sat, Jun 4, 2016 at 12:25 PM, Cristóbal Palmer <trilug at trilug.org> wrote:

> I got to this: "I'll try adding auto_increment primary keys and see if that
> improves things," and had to respond.
>
> Many things can impact query response time, but to oversimplify: you want
> fewer joins and more index-only queries. Adding an index only helps if
> you're actually going to query that index. Don't add indexes in scattershot
> fashion. An auto-increment primary key can ease and speed up indexing, and
> can produce a small index, but if you can't query that index (because your
> app doesn't use it)....
>
> -CMP
>
>
> On Fri, Jun 3, 2016 at 4:33 PM Wes Garrison via TriLUG <trilug at trilug.org>
> wrote:
>
> > Lots of great info here, thanks for all the suggestions.
> >
> > I think Peter Neilson may have put his finger on it.  I was searching for
> > various combinations of "mysql high cpu usage" and forgot about InnoDB.
> >
> > I changed the engine for a lot of our tables a few months ago from MyISAM
> > to InnoDB and we do indeed have a lot of random primary keys.
> >
> > I'll try adding auto_increment primary keys and see if that improves
> > things.
> >
> > There isn't really anything of consequence in the slow queries log, I
> don't
> > do a lot of large table joins, not using replication, and we're nowhere
> > near the max concurrent users.
> >
> > I'll try to isolate the issue to CPU, Disk, or Network as Ronald
> suggested
> > using “iotop”, “htop”, and “nmon”.
> >
> > I'll also check out InnoTop, MyTop, MonYog and sqlYog, and glances.
> >
> > First I'm going to try changing the keys to be non-random and see how
> that
> > works out.
> >
> > -Wes
> >
> > _________________________________
> > Wesley S. Garrison
> > Network Engineer
> > Xitech Communications, Inc.
> > phone:  (919) 260-0803
> > fax:       (919) 932-5051
> > __________________________________
> > "Lead us not into temptation, but deliver us from email."
> >
> > On Fri, Jun 3, 2016 at 4:52 AM, Peter Neilson <neilson at windstream.net>
> > wrote:
> >
> > >
> > >>
> > > I'd think about InnoDB first. If for some reason it thinks that a
> random
> > > key needs to be inserted it has to reshuffle everything, moving large
> > > chunks of stuff around in tables.
> > >
> > > Here's a stackoverflow about the difficulty:
> > >
> > >
> >
> http://stackoverflow.com/questions/9819271/why-is-mysql-innodb-insert-so-slow
> > >
> > > This analysis is based on nothing more than about five minutes of
> poking
> > > around with Google and favoring stackoverflow results against other
> > > opinions. I am not an authority on any DB stuff. I've just occasionally
> > > noticed that page sloth seems to result from DB server problems as
> > opposed
> > > to clogging in the network or in the rendering engines.
> > >
> > --
> > This message was sent to: Cristóbal Palmer <cmp at cmpalmer.org>
> > 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/cmp%40cmpalmer.org
> > Welcome to TriLUG: http://trilug.org/welcome
> --
> This message was sent to: mgkimsal at gmail.com <mgkimsal 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/mgkimsal%40gmail.com
> Welcome to TriLUG: http://trilug.org/welcome




-- 

Michael Kimsal
http://kims.al <http://michaelkimsal.com>
919.827.4724

From trilug at trilug.org  Fri Jun  3 19:08:24 2016
From: trilug at trilug.org (Peter Neilson via TriLUG)
Date: Fri, 03 Jun 2016 19:08:24 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAPjrFiM9R6WMMsCJipoUWM2S9SCk-i00YQ9Bm+3pFSdXEVoDOA@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
 <op.yig39havrns8nc@odin>
 <CAPjrFiM9R6WMMsCJipoUWM2S9SCk-i00YQ9Bm+3pFSdXEVoDOA@mail.gmail.com>
Message-ID: <op.yih7wax5rns8nc@odin>

Thank you for asking this question, Wes, because it helped me discover a  
strange e-mail bug. Apparently my e-mail to trilug at trilug.org goes into a  
cosmic bit-bucket!

I looked for my posting to appear, and it never did. I sent it a second  
time with an apology for duplication. Ditto nada. I sent a test message.  
Again, nada.

Now I have Brian Gerard and the Steering Committee looking into it.

Anyway, I'm glad I seem to have helped. Sometimes it's just having the  
right attitude, a bit of off-the-wall knowledge or experience, some  
half-baked google-fu, and raw good luck.

I'm CC-ing this note to the list. If it does not show up there, feel free  
to forward it there.

-Peter

On Fri, 03 Jun 2016 16:32:04 -0400, Wes Garrison <wes at xitechusa.com> wrote:

> Lots of great info here, thanks for all the suggestions.
>
> I think Peter Neilson may have put his finger on it.  I was searching for
> various combinations of "mysql high cpu usage" and forgot about InnoDB.
>
> I changed the engine for a lot of our tables a few months ago from MyISAM
> to InnoDB and we do indeed have a lot of random primary keys.
>
> I'll try adding auto_increment primary keys and see if that improves  
> things.
>
> There isn't really anything of consequence in the slow queries log, I  
> don't
> do a lot of large table joins, not using replication, and we're nowhere
> near the max concurrent users.
>
> I'll try to isolate the issue to CPU, Disk, or Network as Ronald  
> suggested
> using “iotop”, “htop”, and “nmon”.
>
> I'll also check out InnoTop, MyTop, MonYog and sqlYog, and glances.
>
> First I'm going to try changing the keys to be non-random and see how  
> that
> works out.
>
> -Wes
>
> _________________________________
> Wesley S. Garrison
> Network Engineer
> Xitech Communications, Inc.
> phone:  (919) 260-0803
> fax:       (919) 932-5051
> __________________________________
> "Lead us not into temptation, but deliver us from email."
>
> On Fri, Jun 3, 2016 at 4:52 AM, Peter Neilson <neilson at windstream.net>
> wrote:
>
>>
>>>
>> I'd think about InnoDB first. If for some reason it thinks that a random
>> key needs to be inserted it has to reshuffle everything, moving large
>> chunks of stuff around in tables.
>>
>> Here's a stackoverflow about the difficulty:
>>
>> http://stackoverflow.com/questions/9819271/why-is-mysql-innodb-insert-so-slow
>>
>> This analysis is based on nothing more than about five minutes of poking
>> around with Google and favoring stackoverflow results against other
>> opinions. I am not an authority on any DB stuff. I've just occasionally
>> noticed that page sloth seems to result from DB server problems as  
>> opposed
>> to clogging in the network or in the rendering engines.

From trilug at trilug.org  Fri Jun  3 23:16:17 2016
From: trilug at trilug.org (Peter Neilson via TriLUG)
Date: Fri, 03 Jun 2016 23:16:17 -0400
Subject: [TriLUG] test 3
Message-ID: <op.yiijdfsbrns8nc@odin>

??

From trilug at trilug.org  Fri Jun  3 23:16:36 2016
From: trilug at trilug.org (Peter Neilson via TriLUG)
Date: Fri, 03 Jun 2016 23:16:36 -0400
Subject: [TriLUG] test2
Message-ID: <op.yiihstr3rns8nc@odin>

Did it go through this time?

From trilug at trilug.org  Fri Jun  3 22:33:26 2016
From: trilug at trilug.org (Peter Neilson via TriLUG)
Date: Fri, 03 Jun 2016 22:33:26 -0400
Subject: [TriLUG] test
Message-ID: <op.yiihd02prns8nc@odin>

Did it go through this time?

From trilug at trilug.org  Sat Jun  4 16:24:59 2016
From: trilug at trilug.org (Jeremy Davis via TriLUG)
Date: Sat, 4 Jun 2016 16:24:59 -0400
Subject: [TriLUG] test
In-Reply-To: <op.yiihd02prns8nc@odin>
References: <op.yiihd02prns8nc@odin>
Message-ID: <CACSroP3hJyJyj7CWjrxD-H1EnvotSgD_vPBB8w=3Yod+frLbqw@mail.gmail.com>

I got 3 of your tests from the TriLUG general discussion list

Jeremy

On Friday, June 3, 2016, Peter Neilson via TriLUG <trilug at trilug.org> wrote:

> Did it go through this time?
> --
> This message was sent to: Jeremy Davis <jeremyhwllc 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/jeremyhwllc%40gmail.com
> Welcome to TriLUG: http://trilug.org/welcome



-- 
Jeremy Davis
@jeremydavis0_0
www.linkedin.com/in/jeremydavisprofile/
www.trianglecareerdevelopment.com

From trilug at trilug.org  Sat Jun  4 16:26:10 2016
From: trilug at trilug.org (Jeremy Davis via TriLUG)
Date: Sat, 4 Jun 2016 16:26:10 -0400
Subject: [TriLUG] test
In-Reply-To: <CACSroP3hJyJyj7CWjrxD-H1EnvotSgD_vPBB8w=3Yod+frLbqw@mail.gmail.com>
References: <op.yiihd02prns8nc@odin>
 <CACSroP3hJyJyj7CWjrxD-H1EnvotSgD_vPBB8w=3Yod+frLbqw@mail.gmail.com>
Message-ID: <CACSroP08C97xWxd1rea8XCVknyCrHJwuKEFhB6oWJ91J_4+abw@mail.gmail.com>

actually 4 I think

On Saturday, June 4, 2016, Jeremy Davis <jeremyhwllc at gmail.com> wrote:

> I got 3 of your tests from the TriLUG general discussion list
>
> Jeremy
>
> On Friday, June 3, 2016, Peter Neilson via TriLUG <trilug at trilug.org
> <javascript:_e(%7B%7D,'cvml','trilug at trilug.org');>> wrote:
>
>> Did it go through this time?
>> --
>> This message was sent to: Jeremy Davis <jeremyhwllc 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/jeremyhwllc%40gmail.com
>> Welcome to TriLUG: http://trilug.org/welcome
>
>
>
> --
> Jeremy Davis
> @jeremydavis0_0
> www.linkedin.com/in/jeremydavisprofile/
> www.trianglecareerdevelopment.com
>
>

-- 
Jeremy Davis
@jeremydavis0_0
www.linkedin.com/in/jeremydavisprofile/
www.trianglecareerdevelopment.com

From trilug at trilug.org  Sat Jun  4 16:33:40 2016
From: trilug at trilug.org (Steve Litt via TriLUG)
Date: Sat, 4 Jun 2016 16:33:40 -0400
Subject: [TriLUG] need consulting for LAMP server
In-Reply-To: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
References: <CAPjrFiN925yNJ9cDtXyhgPU95MowWsA3zrfspZfYwibVGRNg+A@mail.gmail.com>
Message-ID: <20160604163340.20405d03@mydesk.domain.cxm>

On Fri, 3 Jun 2016 00:35:22 -0400
Wes Garrison via TriLUG <trilug at trilug.org> wrote:

> Folks,
> 
> I need help figuring out why my page load times atrocious during busy
> times
> - we're talking 15 - 20 seconds for our internal pages *over our LAN*
> during peak hours.

* When did you first notice this?

* Did you notice any other things around that same time?

* Was anything changed around that same time?

* Are there any other noticeable symptoms displayed anywhere connected
  to your network or database?

* When, as an experiment, you hammer your program hard during non-peak
  times, which actions reproduce this symptom the most?

SteveT

Steve Litt
June 2016 featured book: Troubleshooting: Why Bother?
http://www.troubleshooters.com/twb

From trilug at trilug.org  Sat Jun  4 19:04:23 2016
From: trilug at trilug.org (Moose Barry via TriLUG)
Date: Sat, 4 Jun 2016 19:04:23 -0400
Subject: [TriLUG] test
In-Reply-To: <CACSroP08C97xWxd1rea8XCVknyCrHJwuKEFhB6oWJ91J_4+abw@mail.gmail.com>
References: <op.yiihd02prns8nc@odin>
 <CACSroP3hJyJyj7CWjrxD-H1EnvotSgD_vPBB8w=3Yod+frLbqw@mail.gmail.com>
 <CACSroP08C97xWxd1rea8XCVknyCrHJwuKEFhB6oWJ91J_4+abw@mail.gmail.com>
Message-ID: <743FC371-CE0A-4CD1-A0E4-51FA1829D7B9@gmail.com>

I got the tests. Not sure if you wanted responses,
Moose

Sent from my PDA
"There is no wealth but life" 
Live and love everyday my dear.

> On Jun 4, 2016, at 4:26 PM, Jeremy Davis via TriLUG <trilug at trilug.org> wrote:
> 
> actually 4 I think
> 
>> On Saturday, June 4, 2016, Jeremy Davis <jeremyhwllc at gmail.com> wrote:
>> 
>> I got 3 of your tests from the TriLUG general discussion list
>> 
>> Jeremy
>> 
>> On Friday, June 3, 2016, Peter Neilson via TriLUG <trilug at trilug.org
>> <javascript:_e(%7B%7D,'cvml','trilug at trilug.org');>> wrote:
>> 
>>> Did it go through this time?
>>> --
>>> This message was sent to: Jeremy Davis <jeremyhwllc 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/jeremyhwllc%40gmail.com
>>> Welcome to TriLUG: http://trilug.org/welcome
>> 
>> 
>> 
>> --
>> Jeremy Davis
>> @jeremydavis0_0
>> www.linkedin.com/in/jeremydavisprofile/
>> www.trianglecareerdevelopment.com
> 
> -- 
> Jeremy Davis
> @jeremydavis0_0
> www.linkedin.com/in/jeremydavisprofile/
> www.trianglecareerdevelopment.com
> -- 
> This message was sent to: Moustapha Barry <mooseeds 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/mooseeds%40gmail.com
> Welcome to TriLUG: http://trilug.org/welcome

From trilug at trilug.org  Sat Jun  4 20:18:01 2016
From: trilug at trilug.org (Wes Garrison via TriLUG)
Date: Sat, 4 Jun 2016 20:18:01 -0400
Subject: [TriLUG] test
In-Reply-To: <743FC371-CE0A-4CD1-A0E4-51FA1829D7B9@gmail.com>
References: <op.yiihd02prns8nc@odin>
 <CACSroP3hJyJyj7CWjrxD-H1EnvotSgD_vPBB8w=3Yod+frLbqw@mail.gmail.com>
 <CACSroP08C97xWxd1rea8XCVknyCrHJwuKEFhB6oWJ91J_4+abw@mail.gmail.com>
 <743FC371-CE0A-4CD1-A0E4-51FA1829D7B9@gmail.com>
Message-ID: <CAPjrFiPN-6Zh7wzL4bPAeovBynNdmJrMiHLr7FcMjR9Va9e2JA@mail.gmail.com>

Yeah, something was holding up Peter's email.  These were sent last night
and didn't arrive until this afternoon.

_________________________________
Wesley S. Garrison
Network Engineer
Xitech Communications, Inc.
phone:  (919) 260-0803
fax:       (919) 932-5051
__________________________________
"Lead us not into temptation, but deliver us from email."

On Sat, Jun 4, 2016 at 7:04 PM, Moose Barry via TriLUG <trilug at trilug.org>
wrote:

> I got the tests. Not sure if you wanted responses,
> Moose
>
> Sent from my PDA
> "There is no wealth but life"
> Live and love everyday my dear.
>
> > On Jun 4, 2016, at 4:26 PM, Jeremy Davis via TriLUG <trilug at trilug.org>
> wrote:
> >
> > actually 4 I think
> >
> >> On Saturday, June 4, 2016, Jeremy Davis <jeremyhwllc at gmail.com> wrote:
> >>
> >> I got 3 of your tests from the TriLUG general discussion list
> >>
> >> Jeremy
> >>
> >> On Friday, June 3, 2016, Peter Neilson via TriLUG <trilug at trilug.org
> >> <javascript:_e(%7B%7D,'cvml','trilug at trilug.org');>> wrote:
> >>
> >>> Did it go through this time?
> >>> --
> >>> This message was sent to: Jeremy Davis <jeremyhwllc 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/jeremyhwllc%40gmail.com
> >>> Welcome to TriLUG: http://trilug.org/welcome
> >>
> >>
> >>
> >> --
> >> Jeremy Davis
> >> @jeremydavis0_0
> >> www.linkedin.com/in/jeremydavisprofile/
> >> www.trianglecareerdevelopment.com
> >
> > --
> > Jeremy Davis
> > @jeremydavis0_0
> > www.linkedin.com/in/jeremydavisprofile/
> > www.trianglecareerdevelopment.com
> > --
> > This message was sent to: Moustapha Barry <mooseeds 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/mooseeds%40gmail.com
> > Welcome to TriLUG: http://trilug.org/welcome
> --
> This message was sent to: Wes <wes at xitechusa.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/wes%40xitechusa.com
> Welcome to TriLUG: http://trilug.org/welcome
>

From trilug at trilug.org  Sat Jun  4 22:28:23 2016
From: trilug at trilug.org (Joseph Mack NA3T via TriLUG)
Date: Sun, 5 Jun 2016 02:28:23 +0000 (GMT)
Subject: [TriLUG] outgoing mail problem on pilot
Message-ID: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>

This is for one of the sysadmins on pilot:

I just sent an e-mail to the problem report form on pilot. On pressing submit I 
got "you have been banned from posting"

The original problem: I use alpine on pilot for mail.

Just now I got a TLS error on attempting to send. The error message said that 
this is normal (if it is, it hasn't happened before) that alpine was 
misconfigured and to change the name of the mailserver to 
"mail.trilug.org/notls". I changed the outgoing mailserver string from 
"mail.trilug.org/ssl" to the above string. Then on sending e-mail I got "invalid 
servername". I changed the name back (at least I thought I did) and got the 
"invalid servername" error again (and not the invalid TLS error), so maybe 
there's something wrong with the servername still.

Can you fix the TLS error and the servername error please?

Thanks Joe

-- 
Joseph Mack NA3T EME(B,D), FM05lw North Carolina
jmack (at) austintek (dot) com - azimuthal equidistant
map generator at http://www.wm7d.net/azproj.shtml
Homepage http://www.austintek.com/ It's GNU/Linux!

From trilug at trilug.org  Sat Jun  4 22:54:56 2016
From: trilug at trilug.org (Joseph Mack NA3T via TriLUG)
Date: Sun, 5 Jun 2016 02:54:56 +0000 (GMT)
Subject: [TriLUG] outgoing mail problem on pilot
In-Reply-To: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>
References: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>
Message-ID: <alpine.DEB.2.10.1606050248040.31442@www.wm7d.net>

On Sun, 5 Jun 2016, Joseph Mack NA3T via TriLUG wrote:

> This is for one of the sysadmins on pilot:
>
> I just sent an e-mail to the problem report form on pilot. On pressing submit 
> I got "you have been banned from posting"
>
> The original problem: I use alpine on pilot for mail.
>
> Just now I got a TLS error on attempting to send. The error message said that 
> this is normal (if it is, it hasn't happened before) that alpine was 
> misconfigured and to change the name of the mailserver to 
> "mail.trilug.org/notls". I changed the outgoing mailserver string from 
> "mail.trilug.org/ssl" to the above string. Then on sending e-mail I got 
> "invalid servername". I changed the name back (at least I thought I did) and 
> got the "invalid servername" error again (and not the invalid TLS error), so 
> maybe there's something wrong with the servername still.

I uploaded my old .pinerc file and am now getting the TLS error again

"
There was an SSL/TLS failure for the server

                                                            mail.trilug.org

The reason for the failure was

                                                        SSL negotiation failed

This is just an informational message. With the current setup, SSL/TLS will not 
work. If this error re-occurs every time you run Alpine, your current setup is 
not compatible with the configuration of your mail server. You may want to add 
the option

                                                                /notls

to the name of the mail server you are attempting to access. In other words, 
wherever you see the characters

                                                            mail.trilug.org

in your configuration, replace those characters with

                                                         mail.trilug.org/notls

Type RETURN to continue.
"

Now I just need the TLS error fixed.

Thanks

Joe
>
> Can you fix the TLS error and the servername error please?
>
> Thanks Joe
>
>

-- 
Joseph Mack NA3T EME(B,D), FM05lw North Carolina
jmack (at) austintek (dot) com - azimuthal equidistant
map generator at http://www.wm7d.net/azproj.shtml
Homepage http://www.austintek.com/ It's GNU/Linux!

From trilug at trilug.org  Sun Jun  5 08:23:41 2016
From: trilug at trilug.org (Aaron Schrab via TriLUG)
Date: Sun, 5 Jun 2016 08:23:41 -0400
Subject: [TriLUG] outgoing mail problem on pilot
In-Reply-To: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>
References: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>
Message-ID: <20160605122340.GG13062@pug>

At 02:28 +0000 05 Jun 2016, Joseph Mack NA3T via TriLUG <trilug at trilug.org> wrote:
>This is for one of the sysadmins on pilot:
>
>I just sent an e-mail to the problem report form on pilot. On pressing 
>submit I got "you have been banned from posting"

I'm hoping that this had the same root cause as the initial problem.  I 
doubt if you were actually banned.

>The original problem: I use alpine on pilot for mail.

That does sound like a pretty big problem. :)

>Just now I got a TLS error on attempting to send.

The mail server was configured with an unsupported selection of ciphers.  
This caused it to immediately hangup on connections to the smtps port, 
which is what alpine had been configured to use. For some reason 
connecting to one of the unencrypted ports and using STARTTLS to turn on 
encryption seemed to have been working. I've fixed the cipher selection, 
and verified that connections to the smtps port work again.

I've also changed the default smtp-server setting in alpine to:

mail.trilug.org/tls/user=${USER}

Switching from /ssl/ to /tls/ to switch from using the smtps port to the 
normal smtp port with STARTTLS, and removing the setting to disable 
certificate validation.

From trilug at trilug.org  Sun Jun  5 09:13:11 2016
From: trilug at trilug.org (Joseph Mack NA3T via TriLUG)
Date: Sun, 5 Jun 2016 13:13:11 +0000 (GMT)
Subject: [TriLUG] outgoing mail problem on pilot
In-Reply-To: <20160605122340.GG13062@pug>
References: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>
 <20160605122340.GG13062@pug>
Message-ID: <alpine.DEB.2.10.1606051245160.27339@www.wm7d.net>

On Sun, 5 Jun 2016, Aaron Schrab via TriLUG wrote:

Hi Aaron,

Thanks for the quick reply and the fix.

>> I just sent an e-mail to the problem report form on pilot. On pressing 
>> submit I got "you have been banned from posting"
>
> I'm hoping that this had the same root cause as the initial problem.  I 
> doubt if you were actually banned.

I was hoping the same.

>> The original problem: I use alpine on pilot for mail.
>
> That does sound like a pretty big problem. :)

:-)

I guess I should expect to be a target for that sort of ribbing

I started my sysadmin days in the era of 16kbaud modems. This was perfectly fine 
for editing files with vi, but if I had to mess with a program that had a gui 
and thought you were sitting at the machine's console I knew it would be 20mins 
before the graphics instructions would form the gui on my screen at home. As a 
result I only use tools that require low bandwdth to the remote machine, and use 
utilities whose files can be grep'ed etc. Pine is perfect for the job. From what 
I know mutt would be good too, but I already have something that works perfectly 
so I'm not going to fix it.

>> Just now I got a TLS error on attempting to send.
>
> The mail server was configured with an unsupported selection of ciphers.

THanks for handling it. It's working just fine now.
Joe


-- 
Joseph Mack NA3T EME(B,D), FM05lw North Carolina
jmack (at) austintek (dot) com - azimuthal equidistant
map generator at http://www.wm7d.net/azproj.shtml
Homepage http://www.austintek.com/ It's GNU/Linux!

From trilug at trilug.org  Sun Jun  5 13:42:56 2016
From: trilug at trilug.org (William Sutton via TriLUG)
Date: Sun, 5 Jun 2016 13:42:56 -0400 (EDT)
Subject: [TriLUG] outgoing mail problem on pilot
In-Reply-To: <alpine.DEB.2.10.1606051245160.27339@www.wm7d.net>
References: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>
 <20160605122340.GG13062@pug>
 <alpine.DEB.2.10.1606051245160.27339@www.wm7d.net>
Message-ID: <alpine.DEB.2.02.1606051342130.27744@pilot.trilug.org>

Another Alpine user here and I support Joseph 100%.

Besides which, my text email client won't catch any viruses :-)

William Sutton

On Sun, 5 Jun 2016, Joseph Mack NA3T via TriLUG wrote:

> On Sun, 5 Jun 2016, Aaron Schrab via TriLUG wrote:
>
> Hi Aaron,
>
> Thanks for the quick reply and the fix.
>
>>> I just sent an e-mail to the problem report form on pilot. On pressing 
>>> submit I got "you have been banned from posting"
>>
>> I'm hoping that this had the same root cause as the initial problem.  I 
>> doubt if you were actually banned.
>
> I was hoping the same.
>
>>> The original problem: I use alpine on pilot for mail.
>>
>> That does sound like a pretty big problem. :)
>
> :-)
>
> I guess I should expect to be a target for that sort of ribbing
>
> I started my sysadmin days in the era of 16kbaud modems. This was perfectly 
> fine 
> for editing files with vi, but if I had to mess with a program that had a gui 
> and thought you were sitting at the machine's console I knew it would be 
> 20mins 
> before the graphics instructions would form the gui on my screen at home. As 
> a 
> result I only use tools that require low bandwdth to the remote machine, and 
> use 
> utilities whose files can be grep'ed etc. Pine is perfect for the job. From 
> what 
> I know mutt would be good too, but I already have something that works 
> perfectly 
> so I'm not going to fix it.
>
>>> Just now I got a TLS error on attempting to send.
>>
>> The mail server was configured with an unsupported selection of ciphers.
>
> THanks for handling it. It's working just fine now.
> Joe
>
>
> -- 
> Joseph Mack NA3T EME(B,D), FM05lw North Carolina
> jmack (at) austintek (dot) com - azimuthal equidistant
> map generator at http://www.wm7d.net/azproj.shtml
> Homepage http://www.austintek.com/ It's GNU/Linux!
> -- 
> This message was sent to: William <william at trilug.org>
> 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/william%40trilug.org
> Welcome to TriLUG: http://trilug.org/welcome

From trilug at trilug.org  Sun Jun  5 13:52:42 2016
From: trilug at trilug.org (John Ostrander via TriLUG)
Date: Sun, 5 Jun 2016 13:52:42 -0400
Subject: [TriLUG] test
In-Reply-To: <CAPjrFiPN-6Zh7wzL4bPAeovBynNdmJrMiHLr7FcMjR9Va9e2JA@mail.gmail.com>
References: <op.yiihd02prns8nc@odin>
 <CACSroP3hJyJyj7CWjrxD-H1EnvotSgD_vPBB8w=3Yod+frLbqw@mail.gmail.com>
 <CACSroP08C97xWxd1rea8XCVknyCrHJwuKEFhB6oWJ91J_4+abw@mail.gmail.com>
 <743FC371-CE0A-4CD1-A0E4-51FA1829D7B9@gmail.com>
 <CAPjrFiPN-6Zh7wzL4bPAeovBynNdmJrMiHLr7FcMjR9Va9e2JA@mail.gmail.com>
Message-ID: <e46dd8bc-3455-35b5-9944-b368663b6cd8@crackroot.org>

I had this same issue a few weeks ago when I mailed out about the
CryptoParty. I believe that it was the MailMan greylist. It's likely
that his EMail threw up flags that it might be spam. The messages just
take a bit longer to get through the pipe because of this.

On 06/04/2016 08:18 PM, Wes Garrison via TriLUG wrote:
> Yeah, something was holding up Peter's email.  These were sent last night
> and didn't arrive until this afternoon.
> 
> _________________________________
> Wesley S. Garrison
> Network Engineer
> Xitech Communications, Inc.
> phone:  (919) 260-0803
> fax:       (919) 932-5051
> __________________________________
> "Lead us not into temptation, but deliver us from email."
> 
> On Sat, Jun 4, 2016 at 7:04 PM, Moose Barry via TriLUG <trilug at trilug.org>
> wrote:
> 
>> I got the tests. Not sure if you wanted responses,
>> Moose
>>
>> Sent from my PDA
>> "There is no wealth but life"
>> Live and love everyday my dear.
>>
>>> On Jun 4, 2016, at 4:26 PM, Jeremy Davis via TriLUG <trilug at trilug.org>
>> wrote:
>>>
>>> actually 4 I think
>>>
>>>> On Saturday, June 4, 2016, Jeremy Davis <jeremyhwllc at gmail.com> wrote:
>>>>
>>>> I got 3 of your tests from the TriLUG general discussion list
>>>>
>>>> Jeremy
>>>>
>>>> On Friday, June 3, 2016, Peter Neilson via TriLUG <trilug at trilug.org
>>>> <javascript:_e(%7B%7D,'cvml','trilug at trilug.org');>> wrote:
>>>>
>>>>> Did it go through this time?
>>>>> --
>>>>> This message was sent to: Jeremy Davis <jeremyhwllc 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/jeremyhwllc%40gmail.com
>>>>> Welcome to TriLUG: http://trilug.org/welcome
>>>>
>>>>
>>>>
>>>> --
>>>> Jeremy Davis
>>>> @jeremydavis0_0
>>>> www.linkedin.com/in/jeremydavisprofile/
>>>> www.trianglecareerdevelopment.com
>>>
>>> --
>>> Jeremy Davis
>>> @jeremydavis0_0
>>> www.linkedin.com/in/jeremydavisprofile/
>>> www.trianglecareerdevelopment.com
>>> --
>>> This message was sent to: Moustapha Barry <mooseeds 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/mooseeds%40gmail.com
>>> Welcome to TriLUG: http://trilug.org/welcome
>> --
>> This message was sent to: Wes <wes at xitechusa.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/wes%40xitechusa.com
>> Welcome to TriLUG: http://trilug.org/welcome
>>

-- 
John M. Ostrander
john at crackroot.org

"Man is the measure of all things: of things which are, that they are,
and of things which are not, that they are not." Protagoras

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://www.trilug.org/pipermail/trilug/attachments/20160605/95dd51dc/attachment.pgp>

From trilug at trilug.org  Sun Jun  5 15:08:40 2016
From: trilug at trilug.org (Peter Neilson via TriLUG)
Date: Sun, 05 Jun 2016 15:08:40 -0400
Subject: [TriLUG] test
In-Reply-To: <e46dd8bc-3455-35b5-9944-b368663b6cd8@crackroot.org>
References: <op.yiihd02prns8nc@odin>
 <CACSroP3hJyJyj7CWjrxD-H1EnvotSgD_vPBB8w=3Yod+frLbqw@mail.gmail.com>
 <CACSroP08C97xWxd1rea8XCVknyCrHJwuKEFhB6oWJ91J_4+abw@mail.gmail.com>
 <743FC371-CE0A-4CD1-A0E4-51FA1829D7B9@gmail.com>
 <CAPjrFiPN-6Zh7wzL4bPAeovBynNdmJrMiHLr7FcMjR9Va9e2JA@mail.gmail.com>
 <e46dd8bc-3455-35b5-9944-b368663b6cd8@crackroot.org>
Message-ID: <op.yill4qrzrns8nc@odin>

MailMan greylist? Tell me more. What on earth did I do (or fail to do)?

On Sun, 05 Jun 2016 13:52:42 -0400, John Ostrander via TriLUG  
<trilug at trilug.org> wrote:

> I had this same issue a few weeks ago when I mailed out about the
> CryptoParty. I believe that it was the MailMan greylist. It's likely
> that his EMail threw up flags that it might be spam. The messages just
> take a bit longer to get through the pipe because of this.
>
> On 06/04/2016 08:18 PM, Wes Garrison via TriLUG wrote:
>> Yeah, something was holding up Peter's email.  These were sent last  
>> night
>> and didn't arrive until this afternoon.
>>
>> _________________________________
>> Wesley S. Garrison
>> Network Engineer
>> Xitech Communications, Inc.
>> phone:  (919) 260-0803
>> fax:       (919) 932-5051
>> __________________________________
>> "Lead us not into temptation, but deliver us from email."
>>
>> On Sat, Jun 4, 2016 at 7:04 PM, Moose Barry via TriLUG  
>> <trilug at trilug.org>
>> wrote:
>>
>>> I got the tests. Not sure if you wanted responses,
>>> Moose
>>>
>>> Sent from my PDA
>>> "There is no wealth but life"
>>> Live and love everyday my dear.
>>>
>>>> On Jun 4, 2016, at 4:26 PM, Jeremy Davis via TriLUG  
>>>> <trilug at trilug.org>
>>> wrote:
>>>>
>>>> actually 4 I think
>>>>
>>>>> On Saturday, June 4, 2016, Jeremy Davis <jeremyhwllc at gmail.com>  
>>>>> wrote:
>>>>>
>>>>> I got 3 of your tests from the TriLUG general discussion list
>>>>>
>>>>> Jeremy
>>>>>
>>>>> On Friday, June 3, 2016, Peter Neilson via TriLUG <trilug at trilug.org
>>>>> <javascript:_e(%7B%7D,'cvml','trilug at trilug.org');>> wrote:
>>>>>
>>>>>> Did it go through this time?
>>>>>> --
>>>>>> This message was sent to: Jeremy Davis <jeremyhwllc 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/jeremyhwllc%40gmail.com
>>>>>> Welcome to TriLUG: http://trilug.org/welcome
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Jeremy Davis
>>>>> @jeremydavis0_0
>>>>> www.linkedin.com/in/jeremydavisprofile/
>>>>> www.trianglecareerdevelopment.com
>>>>
>>>> --
>>>> Jeremy Davis
>>>> @jeremydavis0_0
>>>> www.linkedin.com/in/jeremydavisprofile/
>>>> www.trianglecareerdevelopment.com
>>>> --
>>>> This message was sent to: Moustapha Barry <mooseeds 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/mooseeds%40gmail.com
>>>> Welcome to TriLUG: http://trilug.org/welcome
>>> --
>>> This message was sent to: Wes <wes at xitechusa.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/wes%40xitechusa.com
>>> Welcome to TriLUG: http://trilug.org/welcome
>>>

From trilug at trilug.org  Sun Jun  5 21:13:08 2016
From: trilug at trilug.org (Brian via TriLUG)
Date: Sun, 5 Jun 2016 21:13:08 -0400
Subject: [TriLUG] outgoing mail problem on pilot
In-Reply-To: <20160605122340.GG13062@pug>
References: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>
 <20160605122340.GG13062@pug>
Message-ID: <5754CE24.50907@cheetah.dynip.com>

On 06/05/2016 08:23 AM, Aaron Schrab via TriLUG wrote:
> The mail server was configured with an unsupported selection of ciphers.
> This caused it to immediately hangup on connections to the smtps port,

Ayup. I relay through pilot, and that's exactly what was happening to 
all my outbound mail.

 > I've fixed the cipher selection,
 > and verified that connections to the smtps port work again.

Thank you very much for fixing it!  Now I can send e-mail again!  Hooray!

-B



From trilug at trilug.org  Sun Jun  5 22:44:08 2016
From: trilug at trilug.org (Tom Eisenmenger via TriLUG)
Date: Mon, 6 Jun 2016 05:44:08 +0300
Subject: [TriLUG] that's so gooood
Message-ID: <00001117e5f2$bb7ea1e5$77da263f$@charter.net>

Spam content removed.


From trilug at trilug.org  Sun Jun  5 23:40:06 2016
From: trilug at trilug.org (Brian McCullough via TriLUG)
Date: Sun, 5 Jun 2016 23:40:06 -0400
Subject: [TriLUG] outgoing mail problem on pilot
In-Reply-To: <alpine.DEB.2.02.1606051342130.27744@pilot.trilug.org>
References: <alpine.DEB.2.10.1606050220001.31076@www.wm7d.net>
 <20160605122340.GG13062@pug>
 <alpine.DEB.2.10.1606051245160.27339@www.wm7d.net>
 <alpine.DEB.2.02.1606051342130.27744@pilot.trilug.org>
Message-ID: <20160606034005.GA25436@bdmcc-us.com>

On Sun, Jun 05, 2016 at 01:42:56PM -0400, Triangle Linux Users Group discussion list wrote:
> Another Alpine user here and I support Joseph 100%.
> 
> Besides which, my text email client won't catch any viruses :-)

My drug of choice has almost always been mutt, but same answer.


Brian