Memcached is one of the technologies that holds the modern Internet together, but do you know what it actually does? Brian Aker has certainly earned the title of Memcached guru, and below he offers a peek under the hood. He'll also provide a deeper dive into Memcached in a tutorial at the upcoming 2011 MySQL Conference.
What problem is Memcached meant to solve?
Brian Aker: In an operation like a database or an application …
[Read more]“The least expensive query is the query you never run.”
Data access is expensive for your application. It often requires
CPU, network and disk access, all of which can take a lot of
time. Using less computing resources, particularly in the cloud,
results in decreased overall operational costs, so caches provide
real value by avoiding using those resources. You need an
efficient and reliable cache in order to achieve the desired
result. Your end users also care about response times because
this affects their work productivity or their enjoyment of your
service. This post describes some of the most common cache
methods for MySQL.
Popular cache methods
The MySQL query cache
When the query cache is enabled, MySQL examines each query to see if the contents have been stored in the query cache. If the results have been cached they are used instead of actually running the query.. This improves the response time …
[Read more]Given the popular response from my first lesson in improving scalability where I detailed simple ways to eliminate unnecessary SQL, let me share another common bottleneck with MySQL scalability that can be instantly overcome.
Analyzing the writes that occur on a system can expose obvious potential bottlenecks. The MySQL Binary Log is a wealth of information that can be mined. Simple DML Counts per table can be achieved by a single line command.
Let’s look at the following example output of a production system:
mysqlbinlog /path/to/mysql-bin.000999 | \ grep -i -e "^update" -e "^insert" -e "^delete" -e "^replace" -e "^alter" | \ cut -c1-100 | tr '[A-Z]' '[a-z]' | \ sed -e "s/\t/ /g;s/\`//g;s/(.*$//;s/ set …[Read more]
I just released Memcached Functions for MySQL, version 1.1. I'm very happy with this release since it has a new get_cas() and get_cas_by_key() function as well as my own shiny new string functions! See Blue Gecko's blog for details: http://www.bluegecko.net/mysql/memcached-functions-for-mysql-1-1-released/
I’m pleased to announce the release of Memcached Functions for MySQL, version 1.1. It’s been a while since the 1.0 release, and I’ll use writing a book and having a baby as an excuse, but nevertheless, this release has several changes and new features:
mysql> select memc_servers_set('localhost:11211');
+-------------------------------------+
| memc_servers_set('localhost:11211') |
+-------------------------------------+
| 0 |
+-------------------------------------+
1 row in set (0.00 sec) …[Read more]
Check out this SlideShare Presentation:
Plugin Memcached%20 Study
View more presentations from Liu
Lizhi.
Check out this SlideShare Presentation: MySQL and memcached GuideView more documents from webhostingguy.
I use a MacBook Pro for my day-to-day operations here at CB1, INC. I’m a huge believer that a development environment should mimic the production environment, so I find myself running a couple virtual machines in VMware Fusion.
The following guide is a reference for myself as well as possibly a helpful resource for setting up your own Linux development environment. Here’s an checklist of the tasks to perform and software to install:
Patents! Patents! Patents! Canonical’s perfect 10. And more.
Follow 451 CAOS Links live @caostheory on Twitter and
Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have
to.”
# Google responded to Oracle’s claims that its Android OS infringes copyrights and patents related to Java.
# Matt Asay evaluated the various patent claims against Android and its related devices.
# Microsoft licensed smartphone patents from ACCESS Co and a subsidiary of Acacia Research.
# Glyn Moody …
[Read more]This miniconf aims to cover many of the current methods of data storage and retrieval and attempt to bring order to the universe. We’re aiming to cover what various systems do, what the latest developments are and what you should use for various applications.
We aim for talks from developers of and developers using the software in question.
Aiming for some combination of: PostgreSQL, Drizzle, MySQL, XFS, ext[34], Swift (open source cloud storage, part of OpenStack), memcached, TokyoCabinet, TDB/CTDB, CouchDB, MongoDB, Cassandra, HBase….. and more!