VMCD.ORG » linux

Presto-engine Privileges Control – Architect

January 20, 2022 Architect, bigdata, linux, system No comments computer engine

We use presto as the main data query engine to provide data query services for business parties. In our architecture, presto as a core capability requires access to data query permission control, including permission control at the table and column levels. We designed The following scheme to achieve this requirement

[……]

Donkey System

January 18, 2018 Architect, Architecture, linux, MYSQL, software, system No comments

Donkey system is a fully automatic MySQL database change system.
It gives a great help both to the release of the business and the company’s automate[……]

[Reprint]Injection MySQL – Function

August 24, 2015 Internals, linux, MYSQL, rdbms No comments

Reprint a PDF for MySQL Injection Test

MySQL Error Based SQL Injection Using EXP[……]

linux tools part 9– Monitoring system performance

April 25, 2014 linux, system No comments

淘宝的开源监控工具 –同事推荐安装测下来非常不错可以配合zabbix进行数据的采集

link:http://tsar.taobao.org/

[mysql@mysqldb tmp]$ tsar 
 
Time           ---cpu-- ---mem-- ---tc[......]Read more

How to use Flash Cache on Redhat (not OEL)

August 26, 2013 Architect, hardware, linux, system No comments 11g new feature

By ask Surachart for help

Test: Flash Cache on 11gR2 + RHEL

A Flash Cache (11gR2) is supported by OEL or Solaris. If Want To use RHEL(Ex[……]

linux tools part 8– Monitoring Reads and Writes to a File and device

May 13, 2013 linux, system No comments linux tools

1.配合使用systemtap 监控系统对于文件的读写：

[root@db-42 systemtap]# uname -a
Linux db-42 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GN[......]Read more

linux tools part 7– Monitor socket activity

April 23, 2013 linux, system No comments linux tools

systemtap发行版本提供了socktop,用于监控socket套接字之间的通信,具体如下：

[root@db-42 ~]# socktop -h
USAGE: socktop [-d] [-i interval] [-N num] [-P protocol]... [-f family].[......]Read more

gdb 调试TPCC 一例

March 19, 2013 linux, system No comments trouble shooting

TPCC对mysql 5.5.27做一次性能测试时遭遇 Segmentation fault,gdb调试记录之:

[root@db-81 ~]# uname -a 
Linux db-81 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010[......]Read more

linux tools part 6– network Monitoring (2)

March 19, 2013 linux, system No comments linux tools

基于上次的nicstat linux还提供了nethogs,可以监控指定pid的具体流量,在这里可以下到源码.

获取过程：

open("/proc/$pid/fd")
open("/proc/net/tcp")
open("/proc[......]Read more

linux tools part 5– Trace network information

March 13, 2013 linux, system No comments linux tools

Nmap (“Network Mapper”) is an open source tool for network exploration and security auditing. It was designed to rapidly scan large networks, although[……]

Read more