用mysql触发器自动更新memcache-mysql教程-PHP中文网

首页

数据库

mysql教程

用mysql触发器自动更新memcache

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:03 PM

memcachemysql更新自动触发器

mysql 5.1支持触发器以及自定义函数接口(UDF)的特性，如果配合libmemcache以及Memcached Functions for MySQL，就能够实现 memcache 的自动更新。简单记录一下安装测试步骤。安装步骤安装memcached,这个步骤很简单，随处可见安装mysql server 5.1RC，安装

mysql 5.1支持触发器以及自定义函数接口(UDF)的特性，如果配合libmemcache以及Memcached Functions for MySQL，就能够实现memcache的自动更新。简单记录一下安装测试步骤。

安装步骤

安装memcached,这个步骤很简单，随处可见
安装mysql server 5.1RC，安装办法也很大众，不废话了

编译libmemcached，解压后安装即可

<code><span>./</span><span>configure</span><span>;</span><span> make</span><span>;</span><span> make install</span></code>

编译Memcached Functions for MySQL，在http://download.tangent.org/找一个最新的版本下载就是，

<code><span>.</span><span>/configure --with-mysql=/</span><span>usr</span><span>/</span><span>local</span><span>/</span><span>mysql</span><span>/</span><span>bin</span><span>/</span><span>mysql_config </span><span>--</span><span>libdir</span><span>=</span><span>/usr/</span><span>local</span><span>/</span><span>mysql</span><span>/</span><span>lib</span><span>/</span><span>mysql</span><span>/</span><span>
make
make install</span></code>

接下来有两个办法让Memcached Functions for MySQL在mysql中生效
- 在mysql的shell中执行memcached_functions_mysql源码目录下的sql/install_functions.sql，这会把memcache function作为UDF加入mysql
- 运行memcached_functions_mysql源码目录下的utils/install.pl，这是一个perl脚本，作用同上一条

测试memcache function

以下测试脚本摘自memcached_functions_mysql的源码目录，有兴趣可以试试

<code><span>drop table </span><span>if</span><span> exists urls</span><span>;</span><span>
create table urls </span><span>(</span><span>
  id </span><span>int</span><span>(</span><span>3</span><span>)</span><span>not</span><span>null</span><span>,</span><span>
  url varchar</span><span>(</span><span>64</span><span>)</span><span>not</span><span>null</span><span>default</span><span>''</span><span>,</span><span>
  primary key </span><span>(</span><span>id</span><span>)</span><span>);</span><span>select</span><span> memc_servers_set</span><span>(</span><span>'localhost:11211'</span><span>);</span><span>select</span><span> memc_set</span><span>(</span><span>'urls:sequence'</span><span>,</span><span>0</span><span>);</span><span>

DELIMITER </span><span>|</span><span>

DROP TRIGGER IF EXISTS url_mem_insert</span><span>;</span><span>
CREATE TRIGGER url_mem_insert
BEFORE INSERT ON urls
FOR EACH ROW </span><span>BEGIN</span><span>
    SET NEW</span><span>.</span><span>id</span><span>=</span><span> memc_increment</span><span>(</span><span>'urls:sequence'</span><span>);</span><span>
    SET </span><span>@mm</span><span>=</span><span> memc_set</span><span>(</span><span>concat</span><span>(</span><span>'urls:'</span><span>,</span><span>NEW</span><span>.</span><span>id</span><span>),</span><span> NEW</span><span>.</span><span>url</span><span>);</span><span>END</span><span>|</span><span>

DELIMITER </span><span>;</span><span>

insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>'http://google.com'</span><span>);</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>'http://www.ooso.net/index.php'</span><span>);</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>'http://www.ooso.net/'</span><span>);</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>'http://slashdot.org'</span><span>);</span><span>
insert </span><span>into</span><span> urls </span><span>(</span><span>url</span><span>)</span><span> values </span><span>(</span><span>'http://mysql.com'</span><span>);</span><span>select</span><span>*</span><span>from</span><span> urls</span><span>;</span><span>select</span><span> memc_get</span><span>(</span><span>'urls:1'</span><span>);</span><span>select</span><span> memc_get</span><span>(</span><span>'urls:2'</span><span>);</span><span>select</span><span> memc_get</span><span>(</span><span>'urls:3'</span><span>);</span><span>select</span><span> memc_get</span><span>(</span><span>'urls:4'</span><span>);</span><span>select</span><span> memc_get</span><span>(</span><span>'urls:5'</span><span>);</span></code>

作者: Volcano 发表于July 9, 2008 at 2:41 pm

版权信息: 和作者信息及此声明

永久链接 - http://www.ooso.net/archives/436

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

如何在MySQL中删除或修改现有视图？May 16, 2025 am 12:11 AM

todropaviewInmySQL，使用“ dropviewifexistsview_name;” andTomodifyAview，使用“ createOrreplaceViewViewViewview_nameAsSelect ...”。whendroppingaview，asew dectivectenciesanduse和showcreateateviewViewview_name;“ tounderStanditSsstructure.whenModifying

MySQL视图：我可以使用哪些设计模式？May 16, 2025 am 12:10 AM

mySqlViewScaneFectectialized unizedesignpatternslikeadapter，Decorator，Factory，andObserver.1）adapterPatternadaptSdataForomDifferentTablesIntoAunifiendView.2）decoratorPatternenhancateDataWithCalcalcualdCalcalculenfields.3）fieldfields.3）

在MySQL中使用视图的优点是什么？May 16, 2025 am 12:09 AM

查看InMysqlareBeneForsImplifyingComplexqueries，增强安全性，确保dataConsistency，andOptimizingPerformance.1）他们simimplifycomplexqueriesbleiesbyEncapsbyEnculatingThemintoreusableviews.2）viewsEnenenhancesecuritybyControllityByControllingDataAcces.3）

如何在MySQL中创建一个简单的视图？May 16, 2025 am 12:08 AM

toCreateAsimpleViewInmySQL，USEthecReateaTeviewStatement.1）defitEtheetEtheTeViewWithCreatEaTeviewView_nameas.2）指定usethectstatementTorivedesireddata.3）usethectStatementTorivedesireddata.3）usetheviewlikeatlikeatlikeatlikeatlikeatlikeatable.views.viewssimplplifefifydataaccessandenenanceberity but consisterfort，butconserfort，consoncontorfinft

MySQL创建用户语句：示例和常见错误May 16, 2025 am 12:04 AM

1）foralocaluser：createUser'localuser'@'@'localhost'Indidendify'securepassword'; 2）foraremoteuser：creationuser's creationuser'Remoteer'Remoteer'Remoteer'Remoteer'Remoteer'Remoteer'Remoteer'Remoteer'Rocaluser'@'localhost'Indidendify'seceledify'Securepassword'; 2）

在MySQL中使用视图的局限性是什么？May 14, 2025 am 12:10 AM

mysqlviewshavelimitations：1）他们不使用Supportallsqloperations，限制DatamanipulationThroughViewSwithJoinSorsubqueries.2）他们canimpactperformance，尤其是withcomplexcomplexclexeriesorlargedatasets.3）

确保您的MySQL数据库：添加用户并授予特权May 14, 2025 am 12:09 AM

porthusermanagementInmysqliscialforenhancingsEcurityAndsingsmenting效率databaseoperation.1）usecReateusertoAddusers，指定connectionsourcewith@'localhost'or@'％'。

哪些因素会影响我可以在MySQL中使用的触发器数量？May 14, 2025 am 12:08 AM

mysqldoes notimposeahardlimitontriggers，butacticalfactorsdeterminetheireffactective：1）serverConfiguration impactactStriggerGermanagement; 2）复杂的TriggerSincreaseSySystemsystem load; 3）largertablesslowtriggerperfermance; 4）highConconcConcrencerCancancancancanceTigrignecentign; 5）; 5）

See all articles