Mysql Meta Data

Posted on 2019-08-16 | In mysql

SCHEMATA

select 
# 库名
SCHEMA_NAME 
from SCHEMATA;

TABLES

select
       #库名　　表名 　行数　创建时间 修改时间 表注释
       TABLE_SCHEMA, TABLE_NAME, TABLE_ROWS, CREATE_TIME, UPDATE_TIME, TABLE_COMMENT
from TABLES
where TABLE_SCHEMA = 'mds-server';

COLUMNS

select
       #库名　表名　字段名  排序(seq) 默认值　 是否可为null
TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION , COLUMN_DEFAULT, IS_NULLABLE,
       #DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE , DATETIME_PRECISION,
       # 数据类型 是否主键(PRI), 注释
       COLUMN_TYPE, COLUMN_KEY, COLUMN_COMMENT
 from `COLUMNS` where TABLE_SCHEMA = 'mds-server';

STATISTICS表

index

1
2
3

select
TABLE_SCHEMA, TABLE_NAME, INDEX_SCHEMA, INDEX_NAME, COLUMN_NAME
 from STATISTICS where TABLE_SCHEMA = 'mds-server';

VIEWS

1	select * from VIEWS;

引用

Untitled

Posted on 2019-08-16

OrientDB Cookie

Posted on 2019-08-03 | In graphdb

Docker安装OrientDB

docker run -d --name orientdb \
    -p 2424:2424 -p 2480:2480 \
    -e ORIENTDB_ROOT_PASSWORD=root \
    orientdb:3.0.22-tp3

2424 port 应用连接, 2480 port web管理平台
orientdb链接密码为root
3.x 相比2.x 在java引用jar中有不同
orientdb:3.0.22-tp3 与 orientdb:3.0.22不同之处在于tp3添加了Gremlin支持
3.x在Redhat6.8版本启动可能会有问题

web管理平台

http://localhost:2480

通过orientdb console

# 进入orientdb容器
dexec orientdb
# 启动console
/orientdb/bin/console.sh

连接 orientdb

1	connect remote:127.0.0.1 root root

连接 orientdb 的test1库

1	connect remote:127.0.0.1/test1 root root

显示当前有多少图库

1	list database

创建图库

图库名为test1 帐号密码为root

1	create database remote:127.0.0.1/test1 root root

删除图库

1	drop database remote:127.0.0.1/test1 root root

导出图库

将test1导出在/tmp/bacup-test1.gz

1 2	connect remote:127.0.0.1/test1 root root export database /tmp/backup-test1

导入图库

将bacup-test1.gz导入

1 2	connect remote:127.0.0.1/test1 root root import database /tmp/backup-test1.gz --reserveClusterIDs=true

引用

OrientDB3手册

Debain Mirros

Posted on 2019-07-21 | Edited on 2019-08-03 | In debian

清华debian源

deb https://mirrors.tuna.tsinghua.edu.cn/debian/ stretch main non-free contrib
deb https://mirrors.tuna.tsinghua.edu.cn/debian/ stretch-updates main non-free contrib
deb https://mirrors.tuna.tsinghua.edu.cn/debian/ stretch-backports main non-free contrib
deb-src https://mirrors.tuna.tsinghua.edu.cn/debian/ stretch main non-free contrib
deb-src https://mirrors.tuna.tsinghua.edu.cn/debian/ stretch-updates main non-free contrib
deb-src https://mirrors.tuna.tsinghua.edu.cn/debian/ stretch-backports main non-free contrib
deb https://mirrors.tuna.tsinghua.edu.cn/debian-security/ stretch/updates main non-free contrib
deb-src https://mirrors.tuna.tsinghua.edu.cn/debian-security/ stretch/updates main non-free contrib

xface 自动登录

sudo vim /etc/lightdm/lightdm.conf
autologin-user=youname
autologin-user-timeout=0

#　查看ip

1	ip addr show

Media change: please insert the disc labeled

sudo sed -i ‘/cdrom/d’ /etc/apt/sources.list
grep -v ‘#’ /etc/apt/sources.list

Ngrok Cookie

Posted on 2019-07-17 | In ngrok

TODO:

从零教你搭建ngrok服务，解决外网调试本地站点
https://morongs.github.io/2016/12/28/dajian-ngrok/

CentOS7搭建ngrok服务器
https://www.xncoding.com/2017/12/29/web/ngrok.html

ngrok 服务端安装
https://www.jianshu.com/p/d1cdfab9f571

Python Cookie

Posted on 2019-07-16 | Edited on 2019-08-03 | In python

python中调用shell

1 2	import os os.system('ls -hl')

ubuntu cookie

Posted on 2019-07-16 | In ubuntu

安装simple-chinese

1	sudo apt install language-pack-zh-hans-base/bionic-updates language-pack-zh-hans/bionic-updates

aria2-cookie

Posted on 2019-07-16 | Edited on 2019-07-17 | In aria2

Install Aria2

1	sudo apt install aria2

Usage in command

通过http下载文件

1	$ aria2c http://example.org/mylinux.iso

Download from 2 sources:

1	$ aria2c http://a/f.iso ftp://b/f.iso

Download using 2 connections per host:

1	$ aria2c -x2 http://a/f.iso

下载BT种子及文件本体

1	$ aria2c http://example.org/mylinux.torrent

下载过程ctrl+c 取消下载，再次下载时会继续下载　

BitTorrent Magnet URI:

1	$ aria2c 'magnet:?xt=urn:btih:248D0A1CD08284299DE78D5C1ED359BB46717D8C'

Metalink:

1	$ aria2c http://example.org/mylinux.metalink

从文本中下载很多url

1	$ aria2c -i uris.txt

aria2 后台启动信息

https://github.com/binux/yaaw

TODO: https://github.com/binux/yaaw

Usage
Run aria2 with RPC enabled
aria2c –enable-rpc –rpc-listen-all=true –rpc-allow-origin-all with ‘JSON-RPC PATH’ like http://hostname:port/jsonrpc

Recommend: Set –rpc-secret= if you are using aria2 1.18.4(or higher) with ‘JSON-RPC PATH’ like http://token:secret@hostname:port/jsonrpc

Set –rpc-user= –rpc-passwd= if you are using aria2 1.15.2(or higher) with ‘JSON-RPC PATH’ like http://username:passwd@hostname:port/jsonrpc

Visit index.html.

Change “JSON-RPC Path” setting if “Internal server error” occurred.

All your settings on web is temporary. Settings will be lost after aria2 restarted.
Tasks(including which is not finished) will be lost after aria2 restarted. Using –save-session=SOME/WHERE and reload with –continue=true –input-file=SOME/WHERE to continue.
Using $HOME/.aria2/aria2.conf to save your options.
For more infomations about aria2, visit Aria2 Manual
YAAW also support websocket! Set JSON-RPC PATH with ws://hostname:port/jsonrpc.
Pre-spicify or save JSON-PRC PATH as bookmark with http://binux.github.io/yaaw/demo/#path=http://hostname:port/jsonrpc

/Applications/Aria2GUI.app/Contents/Resources/aria2c –dir=/Users/hualong/Downloads –conf-path=/Applications/Aria2GUI.app/Contents/Resources/aria2.conf –input-file=/Applications/Aria2GUI.app/Contents/Resources/aria2.session –save-session=/Applications/Aria2GUI.app/Contents/Resources/aria2.session –max-concurrent-downloads=10 –max-connection-per-server=16 –min-split-size=1024K –split=16 –max-overall-download-limit=0K –max-overall-upload-limit=0K –max-download-limit=0K –max-upload-limit=0K –continue=true –auto-file-renaming=true –allow-overwrite=true –disk-cache=0M –max-tries=0 –retry-wait=5 -D

aria2c –enable-rpc –rpc-listen-all=true –rpc-allow-origin-all

WebUI-Aria2

install webui-aria2

webui-aria2: Web browser interface for aria2 (2012 GSOC project)

#TODO 安装 webui https://github.com/ziahamza/webui-aria2

#　插件

brew search Aria2GUI
brew cask install maria
YAAW for Chrome

引用

graphql cookie book

Posted on 2019-07-15 | In graphql

##　SpringBoot两个graphql-spring-boot-starter

分别由两个团队开发

com.graphql-java　Maven版本 website
com.graphql-java-kickstart Maven 版本 website

graphql-java-kickstart包含的组建

//需要kotliin支持
kotlin.version = '1.3.41'

//kickstart graphql
implementation 'com.graphql-java-kickstart:graphql-spring-boot-starter:5.10.0'
implementation 'com.graphql-java-kickstart:graphiql-spring-boot-starter:5.10.0'
implementation 'com.graphql-java-kickstart:graphql-java-tools:5.6.1'
implementation 'com.graphql-java-kickstart:voyager-spring-boot-starter:5.10.0'
implementation 'com.graphql-java-kickstart:altair-spring-boot-starter:5.10.0'

code

https://github.com/jiahualong/java-example/tree/master/spring-graphql

引用

Dell P2415Q 使用 MacBookPro 2015 使用4k@60Hz刷新率

Posted on 2019-07-08 | In mac

环境

电脑

MacBook Pro (Retina, 15-inch, Mid 2015)
2.5 GHz Intel Core i7
16 GB 1600 MHz DDR3
AMD Radeon R9 M370X 2 GB
Intel Iris Pro 1536 MB

MacBookPro2015的雷电口可以支持4k@60Hz, 这里要注意的是 HDMI口不支持4k@60hz,需要使用雷电/miniDP转DP的线。
miniDP与雷电口兼容。

显示器

Dell P2415Q

Dell P2415Q显示器最高支持3840x2160@60Hz(4k@60hz)。

这里需要注意的是需要关闭MST: Dell显示器 - 设置 - 菜单 - 显示 - MST - 关。

MST选项的含义:

确认的DisplayPort(DP)配置的显示屏。
如果您的系统支持DP版本1.2,显示器可以显示的分辨率3840x2160@60Hz。 显示multi-stream传输(MST)应设置为"Off",这是默认状态。
MST关闭:(dp1.2模式的单个显示器设置)默认模式:4k*2K60Hz禁用MST功能。
MST主要:MST(dp1.2模式的菊花链式安装)功能已启用的主显示器菊花链式安装中。 预期的解决方案是4k*2K30Hz的MST(DP)已启用。
MST二级:(dp1.1的菊花链式和单个显示屏设置)MST功能被禁用的第二个显示器菊花链式安装中预期的解决方案是4k*2K30Hz的MST(DP)已禁用。
如果计算机支持DP版本1.1,显示器将无法实现3840x2160@60Hz。 它将支持较低60Hz的分辨率(如2560 x 1440或设为1920x1080。
通过显示器的屏上显示菜单(OSD)(屏上显示(OSD),请更改选项从MST"关闭"MST"二级"(要更改显示器的设置从DP1.2至1.1)。 Through the Monitor’s On-Screen Display menu (OSD), change the option from MST “OFF” to MST “Secondary” (You are changing the monitor’s setting from DP 1.2 to 1.1).
可能需要重新启动计算机显示器设置激活。

来自如何解决在DP/Mini DP无视频/解析错误问题与Dell P2715q/ p 2415 q平板显示器

线材

联基minidp转dp 1.4版

官方标注支持: 1080p:60Hz-480Hz; 2K:60Hz-240Hz; 4K:60Hz-144Hz; 8K:60Hz

系统

macOS Mojave 10.14.5

软件

EasyRes 1.1.1

方便设置分辨率