Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [memcached]

memcached is a high-performance, distributed memory caching system typically used to increase web application performance by calls to the database.

Originally developed by Brad Fitzpatrick in 2003, memcached allows you to make better use of your server's memory. With memcached, all your servers are looking into the same virtual pool of memory. This means that a given data item is always stored and always retrieved from the same location in your web cluster.

Typical users run memcached to make a website faster, by reducing calls to the database for oft-requested data. While many users have memcached running alongside a webserver process, some have also implemented it on dedicated machines solely intended to be memcached servers.

http://memcached.org/about

15 questions
4
votes
3 answers

Memcached plugin on MariaDB?

I'd like to try new NoSQL feature in MySQL 5.6 but I am using MariaDB 10.0.2 on Debian 6 and don't fancy coming back to MySQL. I'm wondering whether the memcached plugin has been added to MariaDB? And if not whether one can still use it as an…
alfish
  • 3,004
  • 7
  • 21
  • 18
4
votes
1 answer

Why is the Innodb Memcached plugin being deprecated in MySQL 8.0.22?

I originally used "the handlersocket" plugin for NoSQL access to InnoDB tables, then it eventually couldn't be built on newer versions so I migrated to the "Memcached" plugin which was being baked in by Oracle and seemed like a good long term…
oucil
  • 506
  • 2
  • 7
  • 19
2
votes
1 answer

How does a memcached bucket behave when fully loaded?

What is the default ttl of a key in memcached bucket? Also, what happens when a bucket is full? I created a 256MB RAM Bucket and tried to overload it by sending infinite set queries till error is thrown. But to my surprise, it keep accepting inputs,…
dragosrsupercool
  • 365
  • 2
  • 6
  • 15
2
votes
2 answers

Can anyone offer an opinion on handlersocket vs memcached performance in MySQL 5.6

I must say I was a little mis(un)-informed about the MySQL Memcached plugin which offers the same NoSQL like access to InnoDB tables as HandlerSocket, I had only had experience with entirely standalone memcached servers in cacheing scenarios. We're…
oucil
  • 506
  • 2
  • 7
  • 19
2
votes
0 answers

Caching impression counts to avoid mysql inserts

We currently get a lot of mySQL inserts/updates on duplicate daily (millions) and we're looking at speeding up the application by using some form of counter with memcached and then clearing it on intervals with a cron. Is this possible? What happens…
Kyle R
1
vote
1 answer

optimizing MySQL for traffic analytics system

background : I've developed a URL shortener system like Bitly with same features , so the system also tracks clickers info and represent as graphs to the person who has shorten the link as analytics data. currently I'm using MySQL and have a table…
Aliweb
  • 146
  • 5
1
vote
0 answers

Caching impression counts to avoid mysql inserts

We currently get a LOT of mySQL inserts/updates on duplicate daily (millions) and we're looking at speeding up the application by using some form of counter with memcached and then clearing it on intervals with a cron. Is this possible? What happens…
user48887
  • 11
  • 1
0
votes
1 answer

Memcache implementation

I have a Wordpress site that uses WP Super Cache plugin in order to make my blog posts and pages stay as HTML so that less PHP/MySQL code is executed. However, there's a featured box that can't get cached. So, I configured it manually to bypass…
bazaglia
  • 267
  • 2
  • 3
  • 6
0
votes
1 answer

MySQL causing major I/O Slowdown

I have a mysql server (version 5.1) running Roundcube Webmail client. We have a few hundred users on it during the day. My hypervisor, Virtuozzo, they have been working with us on this all day and found that the container itself is generating an…
Gordon Snappleweed
  • 11
  • 1
0
votes
1 answer

Adding Memcached plugin to Mysql Cluster Fails to start

I was able to setup a new mysql cluster, with total 6 VMs. New requirement is to add memcache plugin to mysql cluster, memcache failing to start with this error message WARNING -- Failed to allocate nodeid for API at 192.168.1.100. Returned error:…
bobby
  • 1
  • 2
0
votes
1 answer

How to cache select with variables? (MySQL)

Context: I have complicated very often executed query: CREATE OR REPLACE VIEW ordered_words AS SELECT word.id FROM category JOIN frequency ON category.id = frequency.category_id JOIN word ON frequency.word_id = word.id JOIN language ON…
Daniel
  • 209
  • 1
  • 3
  • 10
0
votes
1 answer

Is there possible chache query or save it in memory in MySql? Mayby Should I use something other?

I have complicated query (some joins and ordering), that I want to execute very often. Results of query can change very rarely. Query gets words form given language and category sorted by frequency, so it have two parameters - language and…
Daniel
  • 209
  • 1
  • 3
  • 10
0
votes
1 answer

updating single row in MYSQL

We have a situation where we need to update on a single row several thousands time a second and this requirement lasts continuously for 5 hours every day due to the nature of the business. Design cannot be changed so we are looking for solutions.…
roger moore
  • 367
  • 3
  • 18
-1
votes
1 answer

2 tables in mysql database overloading cpu even after optimize

thanks for reading this question i hope someone can give some insight into some steps. Here is my steps report. I added memcached instead of mysql cache. optimize the 2 tables from buddypress that where making the mysql overload. But still the…
EVX
  • 101
  • 2
-1
votes
1 answer

Query mysql database through memcache

I have been trying to use memcache with MySQL 5.6 but I can not figure out how to do this. I have add an entry into innodb_memcache.containers so I can query the database through memcache. What I would usually do with memcache is get the value for…
Lawrence Cooke
  • 193
  • 2
  • 10