使用php对网站CDN做基准测试
kevin.Zhu 发布于：2013-1-16 15:40 分类：Php 有 10 人浏览，获得评论 0 条
公司最近要使用CDN，为了能测试下在加入CDN后的效果，需要对网站做一个基准测试。以下是实现方式。
以下是对网站数据的采集，使用screen运行php index.php
index.php
<?php include(__DIR__.'/mysql.php'); include(__DIR__.'/config.php'); include(__DIR__.'/helper.php'); while(1) { $db = new Mysql(); $db->connect($config['db']); $create_time = strtotime(date('Y-m-d H:i',time())); //######################2M图片############################# //无CDN $start = get_microtime(); $status = curl('http://27.54.226.101:99/scenicInt/0/6/2/101062/101062.jpg'); $end = get_microtime(); $time = sprintf("%s",($end - $start)); if( !$status ) { $time = -1; } $db->ping($config['db']); $db->query("insert into benchmark(time,type,category,create_time) value($time,1,2,$create_time)"); //使用CDN $start = get_microtime(); $status = curl('http://image.yhiker.com/scenicInt/0/6/2/101062/101062.jpg'); $end = get_microtime(); $time = sprintf("%s",($end - $start)); if( !$status ) { $time = -1; } $db->ping($config['db']); $db->query("insert into benchmark(time,type,category,create_time) value($time,1,1,$create_time)"); //######################12M离线包############################# //无CDN $start = get_microtime(); $status = curl("http://27.54.226.101:99/0086/itinerary/01000000379-0.zip"); $end = get_microtime(); $time = sprintf("%s",($end - $start)); if( !$status ) { $time = -1; } $db->ping($config['db']); $db->query("insert into benchmark(time,type,category,create_time) value($time,2,2,$create_time)"); //使用CDN $start = get_microtime(); $status = curl("http://image.yhiker.com/0086/itinerary/01000000379-0.zip"); $end = get_microtime(); $time = sprintf("%s",($end - $start)); if( !$status ) { $time = -1; } $db->ping($config['db']); $db->query("insert into benchmark(time,type,category,create_time) value($time,2,1,$create_time)"); //######################API接口数据############################# //无CDN $start = get_microtime(); $status = curl('http://27.54.226.101:98/haiyouapi/services',array('command'=>8101,'platformType'=>'web','param'=>array('itineraryId'=>'01000000599'))); $end = get_microtime(); $time = sprintf("%s",($end - $start)); if( !$status ) { $time = -1; } $db->ping($config['db']); $db->query("insert into benchmark(time,type,category,create_time) value($time,3,2,$create_time)"); //使用CDN $start = get_microtime(); $status = curl('http://api.yhiker.com/haiyouapi/services',array('command'=>8101,'platformType'=>'web','param'=>array('itineraryId'=>'01000000599'))); $end = get_microtime(); $time = sprintf("%s",($end - $start)); if( !$status ) { $time = -1; } $db->ping($config['db']); $db->query("insert into benchmark(time,type,category,create_time) value($time,3,1,$create_time)"); unset($start); unset($status); unset($end); unset($time); unset($db); sleep(120); } ?>
config.php
<?php header('Content-type:text/html;charset=utf-8'); ini_set('date.timezone','Asia/Shanghai'); set_time_limit(0); error_reporting(E_ERROR); ini_set('memory_limit', '1024M'); $config['db'] = array ( 'host' => '192.168.1.188:3000', 'user' => 'xupeng', 'pass' => 'xupeng', 'db' => 'test', 'pconnect' => false, 'dbcharset' => 'utf8', );
helper.php
<?php function get_microtime() { list($usec, $sec) = explode(' ', microtime()); return ((float)$usec + (float)$sec); } function curl($url, $data = array(), $timeout = 20) { $ch = curl_init(); if (is_array($data) && $data) { $formdata = json_encode($data); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: application/json')); curl_setopt($ch, CURLOPT_POSTFIELDS, $formdata); } curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); curl_setopt($ch, CURLOPT_TIMEOUT, $timeout); $result = curl_exec($ch); $response = curl_getinfo( $ch ); curl_close($ch); if( $response['http_code'] == 200 ) { return true; } else { return false; } }
mysql.php
<?php class mysql { var $dbhost; //数据库地址 var $dbuser; //数据库用户名 var $dbpasswd; //数据库密码 var $dbpconnect=0; //数据库长连接 var $dbname; //数据库名称 var $dbchart; //数据库链接编码 var $dblink; //数据库连接对象 var $sql; //sql语句 var $res; //sql语句执行结果 var $errno; //错误信息 function connect($dbConfig) { $this->dbhost = $dbConfig['host']; $this->dbuser = $dbConfig['user']; $this->dbpasswd = $dbConfig['pass']; $this->dbpconnect = $dbConfig['pconnect']; $this->dbname = $dbConfig['db']; $this->dbchart = $dbConfig['dbcharset']; if($this->dbpconnect) { $this->dblink = mysql_pconnect($this->dbhost,$this->dbuser,$this->dbpasswd,1) or die('can not connect to mysql database!'); } else { $this->dblink = mysql_connect($this->dbhost,$this->dbuser,$this->dbpasswd,1) or die('can not connect to mysql database!'); } mysql_query('set names '.$this->dbchart, $this->dblink); mysql_select_db($this->dbname, $this->dblink); unset($dbConfig); } /** * 数据库执行语句 * * @return blooean * */ function query($sql, $die_msg = 1) { $this->sql = $sql; $result = @mysql_query($sql, $this->dblink); //可以用自定义错误信息的方法，就要压制本身的错误信息 if($result == true) { return $result; } else { //有错误发生 $this->errno = mysql_errno($this->dblink); if($this->errno >0) { if($die_msg == 1) { //强制报错并且die $this->msg($sql); } else { return $this->errno;//无强制报错，则返回错误代码 } } } } /** * 获得查询语句单条结果 * * @return array * */ function get_one($sql) { $this->sql = $sql; $this->res = $this->query($sql); return mysql_fetch_assoc($this->res); } /** * 获得查询语句多条结果 * * @return array * */ function get_all($sql,$filed=null) { $this->sql = $sql; $this->res = $this->query($sql); $arr = array(); while($row = mysql_fetch_assoc($this->res)) { if( $filed ) { $arr[] = $row[$filed]; } else { $arr[] = $row; } } return $arr; } /** * 取得结果数据 * * @param resource $query * * @return string * */ function result($query, $row) { $query = @mysql_result($query, $row); return $query; } function affected_rows() { return mysql_affected_rows($this->dblink); } /** * 获得刚插入数据的id * * @return int id * */ function insert_id() { return ($id = mysql_insert_id($this->dblink)) >= 0 ? $id : $this->result($this->query('SELECT last_insert_id()'), 0); } /** * 关闭数据库连接，当您使用持续连接时该功能失效 * * @return blooean * */ function close() { return mysql_close($this->dblink); } function ping($dbconfig) { if(!mysql_ping($this->dblink)) { $this->close(); $this->connect($dbconfig); } } /** * 显示自定义错误 * */ function msg($sql) { if($this->errno) { //可以根据错误ID，配置好一些友好的错误信息提示语句 $msgArr = array(); $msgArr['1062'] = "唯一性索引有重复值插入"; /*...更多错误代码根据实际业务再添加...*/ if($msgArr[$this->errno]) { $errMsg = $msgArr[$this->errno];//已定义的错误 }else{ $errMsg = mysql_error();//未定义的错误，由默认的错误信息决定 } echo "数据库操作错误\n"; echo "错误代码：".$this->errno."\n"; echo "SQL语句：".$sql."\n"; echo "错误信息：".$errMsg."\n"; echo date('Y-m-d H:i:s',time())."\n"; unset($msgArr); die; } } function __destruct() { $this->dbhost; $this->dbuser; $this->dbpasswd; $this->dbpconnect; $this->dbname; $this->dbchart; $this->dblink; $this->sql; $this->res; $this->errno; } }
以下是数据报表的展示：
<?php include(__DIR__.'/config.php'); include(__DIR__.'/mysql.php'); $db = new mysql(); $db->connect($config['db']); $result = $db->get_all("select * from benchmark where category = 2 order by create_time desc limit 90"); //echo count($result);exit; $ret = array(); $total = array(); foreach( array_reverse($result) as $v) { $time_db = strtotime(date('Y-m-d H:i',$v['create_time'])); $time = intval(($time_db+28800).'000'); $ret[$v['type']] .= '['.$time.','.$v['time'].'],'; $total[$v['type']][] = ( $v['time'] > 0 ) ? $v['time'] : 0; } $pic = '['.chop($ret[1],',').']'; $zip = '['.chop($ret[2],',').']'; $api = '['.chop($ret[3],',').']'; $pic_average = array_sum($total[1]) / count($total[1]); $zip_average = array_sum($total[2]) / count($total[2]); $api_average = array_sum($total[3]) / count($total[3]); //CDN $result_cdn = $db->get_all("select * from benchmark where category = 1 order by create_time desc limit 90"); $ret_cdn = array(); $total_cdn = array(); foreach( array_reverse($result_cdn) as $v) { $time_db = strtotime(date('Y-m-d H:i',$v['create_time'])); $time = intval(($time_db+28800).'000'); $ret_cdn[$v['type']] .= '['.$time.','.$v['time'].'],'; $total_cdn[$v['type']][] = ( $v['time'] > 0 ) ? $v['time'] : 0; } $pic_cdn = '['.chop($ret_cdn[1],',').']'; $zip_cdn = '['.chop($ret_cdn[2],',').']'; $api_cdn = '['.chop($ret_cdn[3],',').']'; $pic_average_cdn = array_sum($total_cdn[1]) / count($total_cdn[1]); $zip_average_cdn = array_sum($total_cdn[2]) / count($total_cdn[2]); $api_average_cdn = array_sum($total_cdn[3]) / count($total_cdn[3]); $all = $db->get_all("select sum(time) as sum,sum(item) as id from benchmark where time != -1 and category = 2 GROUP BY type"); $pic_all_average = $all[0]['sum'] / $all[0]['id']; $zip_all_average = $all[1]['sum'] / $all[1]['id']; $api_all_average = $all[2]['sum'] / $all[2]['id']; $all_cdn = $db->get_all("select sum(time) as sum,sum(item) as id from benchmark where time != -1 and category = 1 GROUP BY type"); $pic_all_average_cdn = $all_cdn[0]['sum'] / $all_cdn[0]['id']; $zip_all_average_cdn = $all_cdn[1]['sum'] / $all_cdn[1]['id']; $api_all_average_cdn = $all_cdn[2]['sum'] / $all_cdn[2]['id']; ?> <!DOCTYPE HTML> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>国内服务器基准测试</title> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script> <script type="text/javascript"> $(function () { $('#container_pic').highcharts({ chart: { type: 'areaspline' }, title: { text: '2M图片速度测试' }, //subtitle: { // text: '没有CDN加速国内访问速度' //}, xAxis: { type: 'datetime', labels: { formatter: function() { return Highcharts.dateFormat('%H:%M', this.value); } } }, yAxis: { title: { text: '访问速度' } }, tooltip: { shared: true, dateTimeLabelFormats:{ day: '%Y-%m-%d %H:%M' }, valueSuffix: 's' }, credits: { enabled: false }, plotOptions: { areaspline: { fillOpacity: 0.5 } }, series: [{ name: '无CDN加速', data: <?php echo $pic;?> },{ name: '有CDN加速', data: <?php echo $pic_cdn;?> }] }); $('#container_zip').highcharts({ chart: { type: 'areaspline' }, title: { text: '12M离线包速度测试' }, //subtitle: { // text: '没有CDN加速国内访问速度' //}, xAxis: { type: 'datetime', labels: { formatter: function() { return Highcharts.dateFormat('%H:%M', this.value); } } }, yAxis: { title: { text: '访问速度' } }, tooltip: { shared: true, dateTimeLabelFormats:{ day: '%Y-%m-%d %H:%M' }, valueSuffix: 's' }, credits: { enabled: false }, plotOptions: { areaspline: { fillOpacity: 0.5 } }, series: [{ name: '无CDN加速', data: <?php echo $zip;?> },{ name: '有CDN加速', data: <?php echo $zip_cdn;?> }] }); $('#container_api').highcharts({ chart: { type: 'areaspline' }, title: { text: 'API接口速度测试' }, //subtitle: { // text: '没有CDN加速国内访问速度' //}, xAxis: { type: 'datetime', labels: { formatter: function() { return Highcharts.dateFormat('%H:%M', this.value); } } }, yAxis: { title: { text: '访问速度' } }, tooltip: { shared: true, dateTimeLabelFormats:{ day: '%Y-%m-%d %H:%M' }, valueSuffix: 's' }, credits: { enabled: false }, plotOptions: { areaspline: { fillOpacity: 0.5 } }, series: [{ name: '无CDN加速', data: <?php echo $api;?> },{ name: '有CDN加速', data: <?php echo $api_cdn;?> }] }); }); </script> </head> <body> <div id="container_pic" style="min-width: 310px; height: 400px; margin: 0 auto"></div> <br /> <div id="container_zip" style="min-width: 310px; height: 400px; margin: 0 auto"></div> <br /> <div id="container_api" style="min-width: 310px; height: 400px; margin: 0 auto"></div> <br /> <hr> <h1 style="text-align:center">无CDN访问速度</h1> <hr> <div style="margin-top:20px;"> <h2>访问2M图片最近一小时内平均速度为：<?php echo $pic_average;?>s</h2> <h2>访问12M离线包最近一小时内平均速度为：<?php echo $zip_average;?>s</h2> <h2>访问api接口最近一小时内平均速度为：<?php echo $api_average;?>s</h2> </div> <div style="margin-top:30px;"> <h2>访问2M图片平均速度为：<?php echo $pic_all_average;?>s</h2> <h2>访问12M离线包平均速度为：<?php echo $zip_all_average;?>s</h2> <h2>访问api接口平均速度为：<?php echo $api_all_average;?>s</h2> </div> <hr> <h1 style="text-align:center">有CDN访问速度</h1> <hr> <div style="margin-top:20px;"> <h2>访问2M图片最近一小时内平均速度为：<?php echo $pic_average_cdn;?>s</h2> <h2>访问12M离线包最近一小时内平均速度为：<?php echo $zip_average_cdn;?>s</h2> <h2>访问api接口最近一小时内平均速度为：<?php echo $api_average_cdn;?>s</h2> </div> <div style="margin-top:30px;"> <h2>访问2M图片平均速度为：<?php echo $pic_all_average_cdn;?>s</h2> <h2>访问12M离线包平均速度为：<?php echo $zip_all_average_cdn;?>s</h2> <h2>访问api接口平均速度为：<?php echo $api_all_average_cdn;?>s</h2> </div> </body> <script src="js/highcharts.js"></script> <script src="js/modules/exporting.js"></script> </html>
数据库结构：
CREATE TABLE `benchmark` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `time` float NOT NULL, `type` tinyint(3) unsigned NOT NULL COMMENT '1：图片 2：zip 3：api', `category` tinyint(3) unsigned NOT NULL COMMENT '1:cdn 2:无cdn', `create_time` int(10) unsigned NOT NULL, `item` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=27202 DEFAULT CHARSET=utf8;