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

2015-08-06

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

SSDB

Views: 103868 | 27 Comments

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

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

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

Posted by ideawu at 2015-08-06 13:03:36 Tags: iphp, phpssdbadmin

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

qiujiafu 2017-11-06 at 10:51:34
请作者帮忙分析一下，
我们正准备在这个月把REDIS集群全部下线来着，
这一出故障感觉好虚，，， Reply
qiujiafu 2017-11-14 at 11:24:37
@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
ideawu 2017-11-06 at 11:07:22

@qiujiafu: 不要紧张，你遇到的问题文档中都有提到解决方案。 Reply

qiujiafu 2017-11-06 at 13:53:13

@ideawu: 另外，进程限制是：
ulimit -n
655360 Reply

ideawu 2017-11-06 at 14:17:18

@qiujiafu: 建议加入官方QQ群: 170983373 Reply

qiujiafu 2017-11-06 at 12:14:18

@ideawu:
我查了下系统配置，
cat /proc/sys/fs/file-nr
9200 0 6815744
680万了，这个还可以再增加吗？
另外日志里面从17：55开始出现server.cpp(343): fd: 306256, proc error, delete link；
会不会是因为这个error导致文件数不断增长？ Reply

ideawu 2017-11-06 at 14:13:55

@qiujiafu: 你 grep 一下日志，在出错的时候并发连接数是多少？关键字是 "links"。 Reply

qiujiafu 2017-11-06 at 14:30:32

@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

ideawu 2017-11-06 at 14:36:09

@qiujiafu: 很显然，你的客户端程序bug，导致用完了服务器进程的fd资源。
qiujiafu 2017-11-06 at 10:48:55

然后在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

ideawu 2017-11-06 at 11:06:52

@qiujiafu: 你好，too many open files 问题可参见文档解决：http://ssdb.io/docs/zh_cn/config.html Reply
qiujiafu 2017-11-06 at 10:45:18

昨晚我们有一台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
qiujiafu 2017-10-23 at 10:14:59

作者大神，我再咨询一个问题：
我的服务器是2台：20核、256G、8T配置，分别运行了两个SSDB实例（主主），cache_size设置为50000，预计存储十亿左右的KV数据，之前在REDIS集群中大概使用了100G左右的内存。
我想问下，SSDB有没有命令可以查询到已使用的内存是多少，如果不够准备把cache_size再增加一些，万一没有命中缓存的话查询性能应该会差很多吧？
另外，如果方便的话，能不能介绍一下SSDB的缓存机制是什么样的？
非常感谢！ Reply
qiujiafu 2017-10-10 at 16:55:11

作者你好，有个问题咨询一下，请问SSDB单个实例的连接数有没有上限，最多可以同时保持多少个链接？ Reply

ideawu 2017-10-10 at 19:22:39

@qiujiafu: 经测试，保持10万个连接时仍然工作良好。此时，基于无必要进行下去的考虑主动停止测试。 Reply

qiujiafu 2017-10-11 at 11:06:24

@ideawu: 另外还有一个问题再咨询一下：我们项目每天有10亿的单KEY查询操作，日志级别设置为debug相当于要记录10亿条本地日志，IO负载应该会比较高，会不会对SSDB性能产生影响，是否需要修改日志级别？ Reply

ideawu 2017-10-11 at 14:16:32

@qiujiafu: 你可以把日志级别改为 info. Reply

qiujiafu 2017-10-11 at 10:42:26

@ideawu: 谢谢，十万个完全够用了，况且实际场景不可能单实例十万连接，这样的架构肯定有问题 Reply
playlong 2017-05-09 at 12:54:42

改密码后登录提示：
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
guess 2017-04-17 at 21:15:24

你好，请问一下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

ideawu 2017-04-18 at 11:22:26

@guess: 没有冲突，放心。 Reply
小罗布 2017-03-02 at 15:29:31

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

ideawu 2017-03-02 at 20:14:11

@小罗布: 应该是 nginx 配置不对. Reply
alao 2016-12-09 at 13:41:34

新版本支持管理多实例了吧？ Reply
248251678 2015-11-26 at 19:31:48

ssdb 如何实现搜索功能？ Reply