数据库|mysql教程
UDF,自动同步,memcached
数据库-mysql教程
html5博客源码,vscode选择,ubuntu 终端界面,tomcat mem,sqlite压缩上传,万网 java服务器,bootstrap 分享插件,电脑前端css框架,爬虫 起点,php去除数组空值,简单搜索seo,如何爬网站源码,网页qq表情包源码,zblog模板安装,aspcms 404页面,aspcms网站管理系统,易语言程序获取焦点lzw
接上篇:mysql使用mysql-udf-http效率测试笔记 ,这次不使用rest架构,而是使用:libmemcached和memcached_functions_mysql
c2c网站系统源码,vscode适应屏幕,ubuntu rdp,idea自带tomcat吗,sqlite 唯一索引,border网页设计,数据库master,免费建站服务器空间,ibook插件,去哪儿网前端框架,爬虫基础教程,php安装教程,seo发外链,springboot单例问题,aspcms内容调用去掉html标签,php网站链接加密,网页主页模板,微盟商城模板尺寸,magento 后台404,html 滑动切换页面,winform 客户关系管理系统 源码,mfc 程序皮肤lzw
源码程序定义,vscode改背景,安装ubuntu需要多少时间,tomcat高cpu,sqlite中导入txt,移动端自适应图片轮播插件,前端cep框架怎么设置,爬虫软件爬销售数据,linux下php的安装,seo兼容模式,手机网站分享,m3u8 网页播放代码,织梦首页模板路径修改,osg mfc 程序lzw
接上篇: ,这次不使用rest架构,而是使用:libmemcached和memcached_functions_mysql,测试版本是:
libmemcached-0.34.tar.gz和memcached_functions_mysql-0.9.tar.gz,其它版本配对都有问题,我安装测试过有问题的版本有:
代码如下:
memcached_functions_mysql-1.1在:
libmemcached-0.49\libmemcached-0.48\libmemcached-0.47\libmemcached-0.30\libmemcached-0.43\\libmemcached-0.42\
下安装有错误
memcached_functions_mysql-0.10在:
libmemcached-0.42\下安装有错误
memcached_functions_mysql-0.8在:
libmemcached-0.49\libmemcached-0.48\libmemcached-0.47\libmemcached-0.44\libmemcached-0.43\
\libmemcached-0.42\下安装有错误
MySQL测试版本:5.1.55,操作系统Centos5.4 64bit,内存2G
安装libmemcached-0.34和memcached_functions_mysql-0.9,
代码如下:
[root@sunss24 libmemcached-0.34]#./configure \
–with-memcached=/home/memcache/bin/memcached
[root@sunss24 libmemcached-0. 34]# make
[root@sunss24 libmemcached-0. 34]# make install
再运行一下memstat,算成功了
[root@sunss24 ~]# ln -s /usr/local/lib/libmemcached.so.3 /usr/lib/
[root@sunss24 ~]# cd memcached_functions_mysql-0.9
[root@sunss24 memcached_functions_mysql-0.9]# ./configure \
–with-mysql=/usr/local/mysql/bin/mysql_config \
–libdir=/usr/local/mysql/lib/
[root@sunss memcached_functions_mysql-0.9]# make && make install
安装完成后将UDFs加载到MySQL中:
代码如下:
mysql> show variables like “%plugin%”;
+—————+———————————–+
| Variable_name | Value |
+—————+———————————–+
| plugin_dir | /usr/local/mysql/lib/mysql/plugin |
+—————+———————————–+
1 row in set (0.00 sec)
[root@sunss ~]# find / -name “libmemcached_functions_mysql.so”
/usr/local/mysql/lib/libmemcached_functions_mysql.so
/root/memcached_functions_mysql-0.9/src/.libs/libmemcached_functions_mysql.so
You have new mail in /var/spool/mail/root
[root@sunss ~]# cp /usr/local/mysql/lib/libmemcached_functions_mysql.so /usr/local/mysql/lib/mysql/plugin/
[root@sunss ~]# cd memcached_functions_mysql-0.9/
[root@sunss ~]#cd sql/
mysql> source install_functions.sql;
查看各种版本:
代码如下:
mysql> select memc_udf_version();
+——————–+
| memc_udf_version() |
+——————–+
| 0.9 |
+——————–+
1 row in set (0.00 sec)
mysql> select memc_libmemcached_version();
+—————————–+
| memc_libmemcached_version() |
+—————————–+
| 0.34 |
+—————————–+
1 row in set (0.00 sec)
mysql>
遇到问题:
代码如下:
No package ‘libmemcached’ found
Consider adjusting the PKG_CONFIG_PATH environment variable if you
installed software in a non-standard prefix.
Alternatively, you may set the environment variables DEPS_CFLAGS
and DEPS_LIBS to avoid the need to call pkg-config.
See the pkg-config man page for more details.
解决办法:
[root@sunss24 memcached_functions_mysql-0.9]# whereis pkgconfig
[root@sunss24 memcached_functions_mysql-0.9]# export \
PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/usr/lib/pkgconfig
导出所有memcache内容:
使用:
效率测试:
插入:
代码如下:
<?php
include_once(“gettime.php”);
$btime = getmicrotime();
$i = 0;
$mem = new Memcache();
$mem->addServer(‘192.168.0.10’, 11212);
$local_db = mysql_connect(“192.168.0.208”, “sunss”, “123456”);
if(!$local_db)
{
die(‘Could not connect: ‘.mysql_error());
}
$local_db_sel = mysql_select_db(“test”, $local_db);
mysql_query(“set names utf8”, $local_db);
while ( $i < 1000) {
$re_sql = “insert into urls (id,url) values ($i, ‘’)”;
$res = mysql_query($re_sql, $local_db);
$i++;
}
mysql_close($local_db);
$etime = getmicrotime();
$runTime = round($etime – $btime, 4);
echo “runTime: “.$runTime.”\r\n”;
?>
1000条,插入时间:runTime: 1.4072
删除:
代码如下:
<?php
include_once(“gettime.php”);
$btime = getmicrotime();
$i = 0;
$mem = new Memcache();
$mem->addServer(‘192.168.0.10’, 11212);
$local_db = mysql_connect(“192.168.0.208”, “sunss”, “123456”);
if(!$local_db)
{
die(‘Could not connect: ‘.mysql_error());
}
$local_db_sel = mysql_select_db(“test”, $local_db);
mysql_query(“set names utf8”, $local_db);
while ( $i < 1000) {
//$re_sql = “insert into urls (id,url) values ($i, ‘’)”;
$re_sql = “delete from urls where id=”.$i;
//echo “re_sql_1: “.$re_sql.”\n”;
$res = mysql_query($re_sql, $local_db);
$i++;
}
mysql_close($local_db);
$etime = getmicrotime();
$runTime = round($etime – $btime, 4);
echo “runTime: “.$runTime.”\r\n”;
?>
删除1000条,运行时间:runTime: 1.5534
更新未作
结论:每秒query大概650条记录,比上次的mysql-udf-http快多了