Tune mysql. unless you are using memcache to cache complex query results the mysql will usually be more efficient. However memcache avoids authentication, query parsing, etc. This leads to increased time as well. In which case, if you are ok with that, just make memcache calls directly to innodb.
buffer pool should normally be 90% of available ram. This is where mysql caches reads and writes.
I would say tune mysql and then use xcache instead of memcached. This is the route that I prefer to go. Since you already have memcached working, use it.
Jason
> On Dec 12, 2014, at 1:04 PM, Keith Smith <techlists@phpcoderusa.com> wrote:
>
>
> Hi,
>
> I'm working on a dual quad server with 16GB RAM. Free says it is using about 10GB.
>
> It serves several websites, the main one is a very active Drupal website. As you know Drupal is a resource hog. This one is even more so since there is tons of modules adding to the mix.
>
> I am told I should tune MySql instead of using memcache.
>
> The default max_allowed_packet is 1M. Druapl requires 16M I set it at 32M. I page load is much faster and this is with memcache loaded and configured. Memcache is currently configured to 64M of RAM for caching. Seems very small.
>
> Drupal uses innoDB and I am reading that increasing the innodb_buffer_pool_size will lead to a bust in performance. I assume this will reduce IO and the server load should go down.
>
> There is 4GB of free RAM and the server has not used any swap since it was rebooted last night. The innodb_buffer_pool_size default value is 128MB. Since I do not know what to expect I am thinking of setting it to 1GB and see what happens and work up from there.
>
> Any feedback is much appreciated!!
>
> Keith
>
> --
> Keith Smith
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss