Automatically use the memcache plugin on MySQL 5.6+: 1.5x - 2x faster queries

Created on 22 March 2014, almost 11 years ago

Updated 30 August 2024, 6 months ago

Mysql 5.6+ supports direct access to InnoDB directly without query parsing using memcached protocol, so access to cache blobs/config can get speed-up

More info and benchmarks here:

Also AWS RDS supports it

- Discover how to enable it for CI and which changes required
- Extend mysql driver with opt-in/out access to
- Measure

research, code, commit

✨ Feature request

Status

Closed: outdated

Version

11.0 🔥

Component

MySQL driver →

Last updated about 1 month ago

Created by

🇭🇺Hungary giorgio79

Live updates comments and jobs are added and updated live.

Performance
It affects performance. It is often combined with the Needs profiling tag.

Incomplete comments

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment 6 months ago →
🇳🇿New Zealand quietone
I am closing this as outdated because Drupal 10/11 does not support MySQL 5.6.
Status changed to Active 6 months ago6:34am 30 August 2024
Comment 6 months ago →
🇫🇷France andypost
The feature is evolved to https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html

So better title and update IS
Status changed to Closed: outdated 6 months ago8:08am 30 August 2024
Comment 6 months ago →
🇨🇦Canada gapple
From the 17.20 InnoDB memcached Plugin documentation page:

The InnoDB memcached plugin was removed in MySQL 8.3.0, and was deprecated in MySQL 8.0.22.

Production build 0.71.5 2024