Re: memcached vs tuning MySql

Top Page
Attachments:
Message as email
+ (text/plain)
+ (text/html)
+ (text/plain)
Delete this message
Reply to this message
Author: Bryan O'Neal
Date:  
To: Main PLUG discussion list
Subject: Re: memcached vs tuning MySql
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.
On Dec 12, 2014 1:34 PM, "Sesso" <> wrote:

> 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 <>
> 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 -
> > To subscribe, unsubscribe, or to change your mail settings:
> > http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>
> ---------------------------------------------------
> PLUG-discuss mailing list -
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.phxlinux.org/mailman/listinfo/plug-discuss
>

---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss