dpicx06888 2019-05-27 17:53
浏览 164

为什么我的Laravel Memcache需要太长时间来检索数据?

I am making an simple larvel application to show memcached use. The Os i am using is ubuntu. The records in the database are 50k.

I successfully installed memcache and saved data in it but the problem is that when i am retrieving data from memcache its taking too long same as a retrival from database would. Kindly let me know what is the issue. I have installed memcache on windows as well but the issue is same on windows as well.

/**
 * Created by PhpStorm.
 * User: Delll
 * Date: 14-Sep-18
 * Time: 2:44 AM
 */

namespace App\Http\Controllers;

use App\User;
use Illuminate\Http\Request;

use App\Http\Requests;
use App\Http\Controllers\Controller;
use Illuminate\Support\Facades\Cache;
use Illuminate\Support\Facades\DB;

class User_controller extends Controller{


    public function index(){
        $memcache = 'Using memcache';

        $users = Cache::remember("key",6999,function(){
            return DB::table('users')->get();
        });
//        Cache::pull('key');

        $val= Cache::has('key');
        if($val !=null){
            echo "Found ".$val;
        }else{
            echo "Not Found ".$val;
        }

        return view('pages.home',compact('users','memcache'));
    }

    public function remove(){
        $value = Cache::pull('key');
        return $value;
    }


}

The result from memcache should be retrieved faster than database.

  • 写回答

1条回答 默认 最新

  • dongqiuwei8667 2019-05-27 18:27
    关注

    Performance issues with memcached are tough to debug (at least for me). I would suggest using the user space strace tool to get some insight into what exactly is causing the delay (read? write? something else?)

    here is an example of getting some info:

     strace -p {php_process_id} -k -r -t -i -T -q  -v -y -yy -C -d -o strace_output.log
    

    instead of php process id put there the root php-fpm process id and see what you get.

    评论

报告相同问题?

悬赏问题

  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)