[ic] Time for new hardware?

[Stefan Hornburg (Racke)]

On 09/20/2016 03:12 PM, Grant wrote:
>>>>> I've been making a lot of optimizations lately and I think I'm to the
>>>>> point where my 4 cores just aren't able to keep up with demand during
>>>>> peak traffic hours each day.  Pages load quickly when I see fewer than
>>>>> 4 busy interchange processes in top but things slow down drastically
>>>>> after that.  Once I'm OK with the degree of optimization my ITL pages
>>>>> have undergone and I'm not IO-bound or memory-bound, is it time to
>>>>> throw CPU at the problem?
>>>>>
>>>>> I'm a little puzzled because I've seen my server perform much better
>>>>> under much greater loads in the past.  I thought my growing mysql
>>>>> tables could be the problem so I set up indexes and it has helped but
>>>>> my server still struggles under loads it used to handle without issue.
>>>>> I did notice that my tables are split about 50/50 between InnoDB and
>>>>> MyISAM and I'd like to make all of them InnoDB.
>>>>>
>>>>> - Grant
>>>>
>>>> Yeah, I would recommend to switch all them to InnoDB for consistency
>>>> and real transactions.
>>>>
>>>> You probably can find sufficient resources on MySQL optimization with
>>>> InnoDB if that is your bottleneck.
>>>
>>>
>>> Actually IO doesn't seem to be a bottleneck at this point.  It seems
>>> to be CPU as things slow down once I have 4 busy interchange processes
>>> on my quad-core CPU and iotop does not show much activity at that
>>> point.  Besides ITL optimization, is this a clear case of needing a
>>> faster CPU and more cores or is there anything else to consider first?
>>>
>>>
>>>> May I ask which webserver you are using?
>>>
>>>
>>> I'm using nginx reverse proxied to apache2.
>>
>> Did you consider to get rid of Apache?
> 
> 
> I'm certainly planning to do that but if I watch top it looks like my
> apache2 processes *barely* get above idle even when the web server is
> under heavy load.  The interchange processes get hammered.
> 

Which mode/settings do you use for the Interchange server? How
do you connect Nginx and Interchange?

Regards
	Racke


-- 
Ecommerce and Linux consulting + Perl and web application programming.
Debian and Sympa administration.