<html><head></head><body>I will take care of that after the Perl Dancer conference<br>
<br>
Regards Racke<br><br><div class="gmail_quote">On 20 September 2016 17:03:48 CEST, Grant <emailgrant@gmail.com> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre class="k9mail"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #fcaf3e; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #e9b96e; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"> I've been making a lot of optimizations
lately and I think I'm to the<br /> point where my 4 cores just aren't able to keep up with demand during<br /> peak traffic hours each day. Pages load quickly when I see fewer than<br /> 4 busy interchange processes in top but things slow down drastically<br /> after that. Once I'm OK with the degree of optimization my ITL pages<br /> have undergone and I'm not IO-bound or memory-bound, is it time to<br /> throw CPU at the problem?<br /><br /> I'm a little puzzled because I've seen my server perform much better<br /> under much greater loads in the past. I thought my growing mysql<br /> tables could be the problem so I set up indexes and it has helped but<br /> my server still struggles under loads it used to handle without issue.<br /> I did notice that my tables are split about 50/50 between InnoDB and<br /> MyISAM and I'd like to make all of them InnoDB.<br /><br /> - Grant<br /></blockquote><br /> Yeah, I would recommend to switch all them to InnoDB for consistency<br /> and
real transactions.<br /><br /> You probably can find sufficient resources on MySQL optimization with<br /> InnoDB if that is your bottleneck.<br /></blockquote><br /><br /> Actually IO doesn't seem to be a bottleneck at this point. It seems<br /> to be CPU as things slow down once I have 4 busy interchange processes<br /> on my quad-core CPU and iotop does not show much activity at that<br /> point. Besides ITL optimization, is this a clear case of needing a<br /> faster CPU and more cores or is there anything else to consider first?<br /><br /><br /><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"> May I ask which webserver you are using?<br /></blockquote><br /><br /> I'm using nginx reverse proxied to apache2.<br /></blockquote><br /> Did you consider to get rid of Apache?<br /></blockquote><br /><br /> I'm certainly planning to do that but if I watch top it looks like my<br /> apache2 processes *barely* get
above idle even when the web server is<br /> under heavy load. The interchange processes get hammered.</blockquote><br /><br /> Which mode/settings do you use for the Interchange server? How<br /> do you connect Nginx and Interchange?<br /></blockquote><br /><br /> Here are my active traffic settings from interchange.cfg:<br /><br /> PreFork Yes<br /> StartServers 12<br /> MaxServers 0<br /> MaxRequestsPerChild 100<br /> HouseKeeping 2<br /> PIDcheck 3600<br /> ChildLife 3600<br /><br /> apache2 listens on a particular port and nginx sends page requests to<br /> apache2 over that port via the proxy_pass directive. apache2 then<br /> hands off to interchange via Interchange::Link.<br /></blockquote><br /> We are using Nginx + FastCGI to connect to Interchange in most of our<br /> installations now.<br /></blockquote><br /><br />That's where I want to end up. Is there good info online on how to<br
/>connect nginx and IC directly?<br /><br />- Grant<br /><br /><hr /><br />interchange-users mailing list<br />interchange-users@icdevgroup.org<br /><a href="http://www.icdevgroup.org/mailman/listinfo/interchange-users">http://www.icdevgroup.org/mailman/listinfo/interchange-users</a><br /><br /></pre></blockquote></div></body></html>