[ic] Time for new hardware?

Grant emailgrant at gmail.com
Tue Sep 20 12:20:15 UTC 2016


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

- Grant



More information about the interchange-users mailing list