前幾天在245配置的主機上測試yzmcms百萬內容下的負載情況，本來想今天在測試下開啟緩存功能之后的負載情況，結果發現整理桌面的時候不小心把之前測試用的數據備份給刪除了，無奈了。
之前的數據是袁老大給弄的，這也不好意思在麻煩他了啊。
有沒有大佬供一個快速生成百萬測試內容得腳本啊
非常感謝。
@andywenming 報錯了
/**將下面函數放入application/api/controller/index.class.php 里面，前臺訪問 xxx.com/api/index/test * 百萬數據插入數據庫 (分五次，一次插入20萬) $catid - 欄目id, */ public function test() { /* * 連接數據庫 */ $dsn = 'mysql:host=127.0.0.1;dbname=yzmcms;'; $user = 'root'; $password = 'root'; $dbh = new PDO($dsn, $user, $password); // $db = D('article'); $title = "演示文章標題"; $seo_title = "演示文章SEO標題 - "; $content = "演示文章內容詳情內容"; $catid = 3; $username = "yzmcms"; $userid = 1; $inputtime = SYS_TIME; $updatetime = SYS_TIME; $dbh->exec( "set global max_allowed_packet = 2*1024*1024*1024" ); $time_start = microtime(true); $sql = "INSERT INTO `yzm_article` ( `title`, `seo_title`, `content`, `catid`, `username`, `userid`,`updatetime`,`inputtime`) VALUES ('$title','$seo_title','$content','$catid','$username','$userid','$updatetime','$inputtime')"; for($i=0; $i<=200000; $i++){ // 一次插入20萬，執行5次即可 $title = "演示文章標題{$i}"; $updatetime = SYS_TIME+($i*60); $inputtime = SYS_TIME+($i*60); $sql .=",('$title','$seo_title','$content','$catid','$username','$userid','$updatetime','$inputtime')"; } $id = $dbh->exec($sql); $time_end = microtime(true); $time = $time_end - $time_start; echo "完成時間: {$time} s " . PHP_EOL; }
這家伙很懶，什么都沒寫呢~
Powered By YzmCMS內容管理系統 2014-2025 加入官方QQ群：633258511 成年人的世界里哪有容易二字
/**將下面函數放入application/api/controller/index.class.php 里面，前臺訪問 xxx.com/api/index/test * 百萬數據插入數據庫 (分五次，一次插入20萬) $catid - 欄目id, */ public function test() { /* * 連接數據庫 */ $dsn = 'mysql:host=127.0.0.1;dbname=yzmcms;'; $user = 'root'; $password = 'root'; $dbh = new PDO($dsn, $user, $password); // $db = D('article'); $title = "演示文章標題"; $seo_title = "演示文章SEO標題 - "; $content = "演示文章內容詳情內容"; $catid = 3; $username = "yzmcms"; $userid = 1; $inputtime = SYS_TIME; $updatetime = SYS_TIME; $dbh->exec( "set global max_allowed_packet = 2*1024*1024*1024" ); $time_start = microtime(true); $sql = "INSERT INTO `yzm_article` ( `title`, `seo_title`, `content`, `catid`, `username`, `userid`,`updatetime`,`inputtime`) VALUES ('$title','$seo_title','$content','$catid','$username','$userid','$updatetime','$inputtime')"; for($i=0; $i<=200000; $i++){ // 一次插入20萬，執行5次即可 $title = "演示文章標題{$i}"; $updatetime = SYS_TIME+($i*60); $inputtime = SYS_TIME+($i*60); $sql .=",('$title','$seo_title','$content','$catid','$username','$userid','$updatetime','$inputtime')"; } $id = $dbh->exec($sql); $time_end = microtime(true); $time = $time_end - $time_start; echo "完成時間: {$time} s " . PHP_EOL; }