MYSQL教程mysql下mysql-udf-http效率测试小记

概述介绍《MYSQL教程mysql下mysql-udf-http效率测试小记》开发教程，希望对您有用。

《MysqL教程MysqL下MysqL-udf-http效率测试小记》要点：
本文介绍了MysqL教程MysqL下MysqL-udf-http效率测试小记，希望对您有用。如果有疑问，可以联系我们。

看到张宴的博客上关于"http/rest客户端的文章",怎样安装啥的直接都跳过,下面直接进入测试阶段,测试环境：虚拟机
代码如下:
[root@localhost ~]# uname -a
linux sunss 2.6.18-128.el5 #1 SMP Wed Jan 21 10:44:23 EST 2009 i686 i686 i386 GNU/linux

内存和交换分区：
代码如下:
[root@localhost ~]# free -m
total used free shared buffers cached
Mem: 376 363 13 0 23 105
-/+ buffers/cache: 233 142
Swap: 1023 133 890
MysqL：
[root@localhost ~]# MysqL -u root -p
Enter password:
Welcome to the MysqL monitor. Commands end with ; or \g.
Your MysqL connection ID is 57
Server version: 5.1.26-rc-log Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
MysqL>

使用的表结构：
代码如下:
DROP table IF EXISTS `mytable`;
CREATE table `mytable` (
`ID` int(10) NOT NulL auto_INCREMENT,
`addtime` int(10) NOT NulL,
`Title` varchar(255) NOT NulL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAulT CHARSET=utf8;

PHP *** 作MysqL的程序：
代码如下:
<?PHP
$type = $_GET['type'];
print_r($_GET);
include_once("gettime.PHP");
$btime = getmicrotime();
$loop_cnt= 1000; //循环次数
$db_host = '127.0.0.1'; //
$db_user = 'sunss'; //
$db_pass = '123456'; //
$db_name = 'test'; //
$db_link = MysqL_connect($db_host,$db_user,$db_pass) or dIE("Connected Failed: ".MysqL_error()."\n");
MysqL_query('set names utf8');
MysqL_db_query($db_name,$db_link);
if ("put" == $type) {//修改
$i = 1;
while ($i <= $loop_cnt) {
$Title = "jkjkjkjkjkjkjkjkjkjkjkjkjk";
$tt = time();
$sql = "update mytable set addtime=".$tt.",Title='".$Title."' where ID='".$i."'";
$res = MysqL_query($sql);
if (FALSE == $res) {
echo "update Failed!\n";
}
$i++;
}
} else if ("delete" == $type) { //删除
$i = 1;
while ($i <= $loop_cnt) {
$sql = "delete from mytable where ID='".$i."'";
echo "delete sql: ".$sql."<br>";
$res = MysqL_query($sql);
if (FALSE == $res) {
echo "delete Failed!\n";
}
$i++;
}

} else if ("post" == $type) { //添加
$i = 0;
while ($i < $loop_cnt) {
$Title = "hahahahahahahahahahahahahahahahahaha";
$tt = time();
$sql = "insert into mytable(addtime,Title) values($tt,'".$Title."')";
//print "sql: ".$sql."<br>";
$res = MysqL_query($sql);
if (FALSE == $res) {
echo "insert Failed!\n";
}
$i++;
}
}
MysqL_close();
$etime = getmicrotime();
$runTime = round($etime - $btime,4);
echo "runTime: ".$runTime."\r\n<br>";
?>

单独执行PHP连接MysqL,单条连接添加1000条记录必要：0.9s左右
PHP *** 作memcache的程序：
代码如下:
<?PHP
include_once("gettime.PHP");
$btime = getmicrotime();
//杩
$mem_host = "192.168.0.134";
$mem_port = "11311";
$timeout = 3600;
$i = 0;
$cnt = 1000;
while ($i < $cnt) {
$mem = new Memcache;
$mem->connect($mem_host,$mem_port) or dIE("Could not connect!");
$ret = $mem->set($i,"11111111111",$timeout);
if (false == $ret) {
file_put_contents("insert_Failed.log","post Failed!\n",file_APPEND);
}
$mem->close();
$i++;
}

//抽
$etime = getmicrotime();
$runTime = round($etime - $btime,4);
echo "runTime: ".$runTime."\r\n<br>";
?>

单条连接添加1000条记录,必要0.8s左右,
创建触发器：
代码如下:
DEliMITER $$
DROP TRIGGER /*!50032 IF EXISTS */ `test`.`mytable_insert`$$
CREATE
/*!50017 defineR = 'root'@'localhost' */
TRIGGER `mytable_insert` AFTER INSERT ON `mytable`
FOR EACH ROW BEGIN
SET @tt_resu = (SELECT http_put(CONCAT('http://192.168.0.134/mem_ss.PHP?type=post&ID=',NEW.ID,"&data=",NEW.addtime),11));
END;
$$

为触发器写个PHP更新memcache,代码如下：
代码如下:
<?PHP
$ID = $_GET['ID'];
$type = $_GET['type'];
$Json_data = $_GET['data'];
var_dump($_GET);
//杩
$mem_host = "192.168.0.134";
$mem_port = "11211";
$timeout = 3600;
$mem = new Memcache;
$mem->connect($mem_host,$mem_port) or dIE("Could not connect!");
if ("get" == $type ) {
$val = $mem->get($ID);
echo $val;
//$arr = JsonDecode($val,'utf-8');
//print_r($arr);
} else if ("put" == $type) {
$ret = $mem->replace($ID,$Json_data,$timeout);
if (false == $ret) {
file_put_contents("replace_Failed.log","replace Failed!\n",file_APPEND);
}
} else if ("delete" == $type) {
$ret = $mem->delete($ID);
if (false == $ret) {
file_put_contents("delete_Failed.log","delete Failed!\n",file_APPEND);
}
} else if ("post" == $type) {
$ret = $mem->set($ID,$timeout);
if (false == $ret) {
file_put_contents("post_Failed.log",file_APPEND);
}
}
$mem->close();
?>

使用PHP触发MysqL添加1000条记录,同时触发器触动PHP更新memcache,使用时间9s左右,
因为每次都关闭链接memcache,看是不是关闭链接导致慢,又写了一个程序：
代码如下:
<?PHP
include_once("gettime.PHP");
$btime = getmicrotime();
//连接
$mem_host = "192.168.0.134";
$mem_port = "11311";
$timeout = 3600;
$i = 0;
$cnt = 1000;
while ($i < $cnt) {
$mem = new Memcache;
$mem->connect($mem_host,3600);
if (false == $ret) {
file_put_contents("insert_Failed.log",file_APPEND);
}
$mem->close();
$i++;
}
//关闭连接
$etime = getmicrotime();
$runTime = round($etime - $btime,4);
echo "runTime: ".$runTime."\r\n<br>";
?>

耗时0.9s左右,比一个连接慢不了多少.
为了定位是触发器慢还是http_put慢,创建一个临时表
tmp_mytable,表结构如下：
代码如下:
CREATE table `mytable` (
`ID` int(10) NOT NulL auto_INCREMENT,
`Title` varchar(255) NOT NulL
) ENGINE=MyISAM DEFAulT CHARSET=utf8;

再次修改触发器,如下：
代码如下:
DEliMITER $$
DROP TRIGGER /*!50032 IF EXISTS */ `test`.`mytable_insert`$$
CREATE
/*!50017 defineR = 'root'@'localhost' */
TRIGGER `mytable_insert` AFTER INSERT ON `mytable`
FOR EACH ROW BEGIN
insert into tmp_mytable values(NEW.ID,NEW.addtime,NEW.Title);
END;
$$

再次用PHP向MysqL中添加1000条记录,消耗时间0.7s左右,证明效率消耗在http_put,也便是MysqL-udf-http慢.
不知道我的测试有错没?还请正在使用MysqL-udf-http的高手,或者对MysqL-udf-http有研究的高手指教.

欢迎参与《MysqL教程MysqL下MysqL-udf-http效率测试小记》讨论，分享您的想法，内存溢出PHP学院为您提供专业教程。

总结

以上是内存溢出为你收集整理的MYSQL教程mysql下mysql-udf-http效率测试小记全部内容，希望文章能够帮你解决MYSQL教程mysql下mysql-udf-http效率测试小记所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。