2015-08-06

phpssdbadmin – SSDB 数据库图形界面管理工具升级

Views: 101102 | 27 Comments

SSDB 数据库图形界面管理工具 phpssdbadmin 发布了新版本 0.0.2, 请大家务必升级. 这个版本增加了管理后台登录时的图片验证码, 提高安全性.

phpssdbadmin 是 SSDB 数据库的 Web 管理工具, 思路来源于 phpmyadmin. phpssdbadmin 使用了简洁的 iphp 框架.

项目地址: https://github.com/ssdb/phpssdbadmin

Related posts:

  1. SSDB 数据库的图形化界面管理工具 – phpssdbadmin
  2. 开源的 PHP 轻量级框架 iphp
  3. SSDB 已经迁移到 github
  4. SSDB 采用里程碑式版本发布机制
Posted by ideawu at 2015-08-06 13:03:36 Tags: ,

27 Responses to "phpssdbadmin – SSDB 数据库图形界面管理工具升级"

  • 请作者帮忙分析一下,
    我们正准备在这个月把REDIS集群全部下线来着,
    这一出故障感觉好虚,,, Reply
    @qiujiafu:


    private function _msectime() {
    list($tmp1, $tmp2) = explode(' ', microtime());
    return (float) sprintf('%.0f', (floatval($tmp1) + floatval($tmp2)) * 1000);
    }

    public function test() {
    ini_set('display_errors', true);
    error_reporting(E_ALL);

    $ff = '/nfsc/xxxxxxxxxxxxxxx/20171114/aaa.log';
    $this->load->library('ci_single_redis', array('type' => 'tag139'), 'ssdbtag139');
    $ssdb_tag = $this->ssdbtag139->getRedis();
    $handle = @fopen($ff, 'r');
    if ($handle) {
    while (!feof($handle)) {
    $item = @fgets($handle); //按行读取
    if (empty($item)) {
    continue;
    }
    $arr_info = explode('|', $item);
    if(empty($arr_info[3])){
    continue;
    }
    $did = $arr_info[3];
    $key = 'u:' . $did;
    $start = $this->_msectime();
    $tags = $ssdb_tag->get($key);
    $end = $this->_msectime();
    $t = $end - $start;
    $msg = date('Y-m-d H:i:s') . '|' . $did . '|' . $t ;
    file_put_contents("/tmp/test_ssdb.log", $msg . "\n", FILE_APPEND);
    }
    }
    }
    Reply
    @qiujiafu: 不要紧张,你遇到的问题文档中都有提到解决方案。 Reply
    @ideawu: 另外,进程限制是:
    ulimit -n
    655360 Reply
    @qiujiafu: 建议加入官方QQ群: 170983373 Reply
    @ideawu:
    我查了下系统配置,
    cat /proc/sys/fs/file-nr
    9200 0 6815744
    680万了,这个还可以再增加吗?
    另外日志里面从17:55开始出现server.cpp(343): fd: 306256, proc error, delete link;
    会不会是因为这个error导致文件数不断增长? Reply
    @qiujiafu: 你 grep 一下日志,在出错的时候并发连接数是多少?关键字是 "links"。 Reply
    @ideawu:
    结果如下,只保留了关键字:
    17:47:35.130 XXX, links: 977
    17:52:35.130 XXX, links: 202822
    17:57:35.130 XXX, links: 423542
    18:02:35.132 XXX, links: 458610
    18:07:35.130 XXX, links: 401924
    18:12:35.230 XXX, links: 196361
    18:17:35.230 XXX, links: 666
    18:22:35.230 XXX, links: 938
    18:27:35.230 XXX, links: 824
    18:32:35.230 XXX, links: 785
    18:37:35.230 XXX, links: 900
    18:42:35.230 XXX, links: 952
    18:47:35.230 XXX, links: 1000
    18:52:35.230 XXX, links: 1070
    18:57:35.230 XXX, links: 1054
    19:02:35.230 XXX, links: 1067
    19:07:35.230 XXX, links: 995
    19:12:35.230 XXX, links: 963
    19:17:35.230 XXX, links: 1020
    19:22:35.230 XXX, links: 1041
    19:27:35.230 XXX, links: 1004
    19:32:35.230 XXX, links: 999
    19:37:35.230 XXX, links: 976
    19:42:35.230 XXX, links: 203529
    19:47:35.230 XXX, links: 228848
    19:52:35.230 XXX, links: 929
    19:57:35.230 XXX, links: 746
    20:02:35.230 XXX, links: 709
    20:07:35.230 XXX, links: 739
    20:12:35.230 XXX, links: 790
    20:17:35.230 XXX, links: 859
    20:22:35.230 XXX, links: 906
    20:27:35.230 XXX, links: 1002
    20:32:35.230 XXX, links: 1088
    20:37:35.230 XXX, links: 1193
    20:42:35.230 XXX, links: 397098
    20:47:35.230 XXX, links: 514409
    20:52:35.230 XXX, links: 418925
    20:57:35.230 XXX, links: 471739
    21:02:35.330 XXX, links: 527540
    21:07:35.330 XXX, links: 646633
    21:12:35.430 XXX, links: 646680
    21:17:36.530 XXX, links: 634745
    21:22:54.930 XXX, links: 655336 Reply
    @qiujiafu: 很显然,你的客户端程序bug,导致用完了服务器进程的fd资源。
  • 然后在21:00的时候,出现了如下错误:
    2017-11-05 21:07:06.090 [INFO ] server.cpp(343): fd: 306251, proc error, delete link
    2017-11-05 21:07:06.091 [INFO ] server.cpp(343): fd: 306256, proc error, delete link
    2017-11-05 21:07:06.265 [ERROR] server.cpp(309): accept failed! Too many open files
    2017-11-05 21:07:06.265 [ERROR] t_kv.cpp(166): get error: IO error: ./var/data/150977.ldb: Too many open files
    2017-11-05 21:07:06.265 [ERROR] server.cpp(309): accept failed! Too many open files
    2017-11-05 21:07:06.265 [ERROR] t_kv.cpp(166): get error: IO error: ./var/data/150232.ldb: Too many open files Reply
    @qiujiafu: 你好,too many open files 问题可参见文档解决:http://ssdb.io/docs/zh_cn/config.html Reply
  • 昨晚我们有一台SSDB服务器出了故障,CPU使用率涨到了100%;
    查看日志:
    2017-11-05 17:55:54.928 [INFO ] binlog.cpp(385): clean 10028 logs[2671023693 ~ 2671033720], 20000000 left, max: 2691033720
    2017-11-05 17:55:57.272 [INFO ] slave.cpp(316): sync_count: 103589001, last_seq: 2691034453, seq: 2691034454
    2017-11-05 17:56:00.290 [INFO ] slave.cpp(316): sync_count: 103590001, last_seq: 2691035453, seq: 2691035454
    2017-11-05 17:56:03.304 [INFO ] slave.cpp(316): sync_count: 103591001, last_seq: 2691036453, seq: 2691036454
    2017-11-05 17:56:05.421 [INFO ] slave.cpp(316): sync_count: 103592001, last_seq: 2691037453, seq: 2691037454
    2017-11-05 17:56:08.436 [INFO ] slave.cpp(316): sync_count: 103593001, last_seq: 2691038453, seq: 2691038454
    2017-11-05 17:56:11.628 [INFO ] slave.cpp(316): sync_count: 103594001, last_seq: 2691039453, seq: 2691039454
    2017-11-05 17:56:14.646 [INFO ] slave.cpp(316): sync_count: 103595001, last_seq: 2691040453, seq: 2691040454
    2017-11-05 17:56:17.306 [INFO ] server.cpp(343): fd: 220635, proc error, delete link
    2017-11-05 17:56:17.307 [INFO ] server.cpp(343): fd: 197437, proc error, delete link
    2017-11-05 17:56:17.364 [INFO ] server.cpp(343): fd: 95405, proc error, delete link
    2017-11-05 17:56:17.364 [INFO ] server.cpp(343): fd: 269424, proc error, delete link
    2017-11-05 17:56:17.365 [INFO ] server.cpp(343): fd: 295076, proc error, delete link Reply
  • 作者大神,我再咨询一个问题:
    我的服务器是2台:20核、256G、8T配置,分别运行了两个SSDB实例(主主),cache_size设置为50000,预计存储十亿左右的KV数据,之前在REDIS集群中大概使用了100G左右的内存。
    我想问下,SSDB有没有命令可以查询到已使用的内存是多少,如果不够准备把cache_size再增加一些,万一没有命中缓存的话查询性能应该会差很多吧?
    另外,如果方便的话,能不能介绍一下SSDB的缓存机制是什么样的?
    非常感谢! Reply
  • 作者你好,有个问题咨询一下,请问SSDB单个实例的连接数有没有上限,最多可以同时保持多少个链接? Reply
    @qiujiafu: 经测试,保持10万个连接时仍然工作良好。此时,基于无必要进行下去的考虑主动停止测试。 Reply
    @ideawu: 另外还有一个问题再咨询一下:我们项目每天有10亿的单KEY查询操作,日志级别设置为debug相当于要记录10亿条本地日志,IO负载应该会比较高,会不会对SSDB性能产生影响,是否需要修改日志级别? Reply
    @qiujiafu: 你可以把日志级别改为 info. Reply
    @ideawu: 谢谢,十万个完全够用了,况且实际场景不可能单实例十万连接,这样的架构肯定有问题 Reply
  • 改密码后登录提示:
    get_encrypt_keys failed

    D:\tools\UPUPW_NP5.2\htdocs\phpssdbadmin\app\classes\SafeUtil.php:74 _throw()
    D:\tools\UPUPW_NP5.2\htdocs\phpssdbadmin\app\controllers\login.php:24 create_encrypt_info()
    D:\tools\UPUPW_NP5.2\htdocs\phpssdbadmin\iphp\framework\App.php:166 index()
    D:\tools\UPUPW_NP5.2\htdocs\phpssdbadmin\iphp\framework\App.php:153 execute()
    D:\tools\UPUPW_NP5.2\htdocs\phpssdbadmin\iphp\framework\App.php:80 _run()
    D:\tools\UPUPW_NP5.2\htdocs\phpssdbadmin\index.php:9 run()

    不改密码可以进登录界面 但又提示密码强度不够

    是哪操作没对? Reply
  • 你好,请问一下ssdb和caffe冲突吗?我是小白,caffe的安装要安装levedb: https://www.hongweipeng.com/index.php/archives/459/
    里面的: yum install atlas-devel protobuf-devel leveldb-devel snappy-devel opencv-devel boost-devel hdf5-devel gflags-devel glog-devel lmdb-devel
    请问我安装了ssdb后能运行这串代码吗?谢谢 Reply
    @guess: 没有冲突,放心。 Reply
  • win+nginx+php环境下
    No route for css/bootstrap.min.css!

    E:\wnmp\www\phpssdbadmin\iphp\framework\App.php:158 route()
    E:\wnmp\www\phpssdbadmin\iphp\framework\App.php:153 execute()
    E:\wnmp\www\phpssdbadmin\iphp\framework\App.php:80 _run()
    E:\wnmp\www\phpssdbadmin\index.php:9 run()
    Copyright©2014-2016 ideawu. All rights reserved. 5.02 ms

    样式文件 js文件无法加载 Reply
    @小罗布: 应该是 nginx 配置不对. Reply
  • 新版本支持管理多实例了吧? Reply
  • ssdb 如何实现搜索功能? Reply

« [1][2] » 1/2

Leave a Comment