Rechercher dans le manuel MySQL
15.19.6 Writing Applications for the InnoDB memcached Plugin
[+/-]
- 15.19.6.1 Adapting an Existing MySQL Schema for the InnoDB memcached Plugin
- 15.19.6.2 Adapting a memcached Application for the InnoDB memcached Plugin
- 15.19.6.3 Tuning InnoDB memcached Plugin Performance
- 15.19.6.4 Controlling Transactional Behavior of the InnoDB memcached Plugin
- 15.19.6.5 Adapting DML Statements to memcached Operations
- 15.19.6.6 Performing DML and DDL Statements on the Underlying InnoDB Table
Typically, writing an application for the
InnoDB
memcached plugin
involves some degree of rewriting or adapting existing code that
uses MySQL or the memcached API.
With the
daemon_memcached
plugin, instead of many traditional memcached servers running on low-powered machines, you have the same number of memcached servers as MySQL servers, running on relatively high-powered machines with substantial disk storage and memory. You might reuse some existing code that works with the memcached API, but adaptation is likely required due to the different server configuration.The data stored through the
daemon_memcached
plugin goes intoVARCHAR
,TEXT
, orBLOB
columns, and must be converted to do numeric operations. You can perform the conversion on the application side, or by using theCAST()
function in queries.Coming from a database background, you might be used to general-purpose SQL tables with many columns. The tables accessed by memcached code likely have only a few or even a single column holding data values.
You might adapt parts of your application that perform single-row queries, inserts, updates, or deletes, to improve performance in critical sections of code. Both queries (read) and DML (write) operations can be substantially faster when performed through the
InnoDB
memcached interface. The performance improvement for writes is typically greater than the performance improvement for reads, so you might focus on adapting code that performs logging or records interactive choices on a website.
The following sections explore these points in more detail.
Traduction non disponible
Le manuel MySQL n'est pas encore traduit en français sur l'infobrol. Seule la version anglaise est disponible pour l'instant.
Document créé le 26/06/2006, dernière modification le 26/10/2018
Source du document imprimé : https://www.gaudry.be/mysql-rf-innodb-memcached-developing.html
L'infobrol est un site personnel dont le contenu n'engage que moi. Le texte est mis à disposition sous licence CreativeCommons(BY-NC-SA). Plus d'info sur les conditions d'utilisation et sur l'auteur.
Références
Ces références et liens indiquent des documents consultés lors de la rédaction de cette page, ou qui peuvent apporter un complément d'information, mais les auteurs de ces sources ne peuvent être tenus responsables du contenu de cette page.
L'auteur de ce site est seul responsable de la manière dont sont présentés ici les différents concepts, et des libertés qui sont prises avec les ouvrages de référence. N'oubliez pas que vous devez croiser les informations de sources multiples afin de diminuer les risques d'erreurs.