Deep dive into Kernel

/etc/inputrc set bell-style none

mysql> show status where `variable_name` = 'Threads_connected'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | Threads_connected | 4 | +-------------------+-------+ 1 row in set (0.00 sec)... or through the show processlist command:mysql> show processlist; +----+------+-----------------+--------+---------+------+-------+------------------+ | Id | User | H..

계정을 생성하고 모든 권한을 주고 싶을 때mysql> create user 'choonho'@'%' identified by 'choonho';Query OK, 0 rows affected (0.00 sec) mysql> grant all on *.* to 'choonho'@'%';Query OK, 0 rows affected (0.01 sec) mysql> flush privileges;Query OK, 0 rows affected (0.00 sec) read 권한만 주고 싶을 때create user 'telegraf'@'localhost' identified by 'telegraf_pw';GRANT SELECT, SHOW VIEW ON *.* TO 'telegraf'@'localhost'; bash에..

mysql> select * from ndbinfo.memoryusage;+---------+---------------------+---------+------------+-------------+-------------+| node_id | memory_type | used | used_pages | total | total_pages |+---------+---------------------+---------+------------+-------------+-------------+| 1 | Data memory | 7045120 | 215 | 25769803776 | 786432 || 1 | Index memory | 2957312 | 361 | 4295229440 | 524320 || 1 | ..

t2.micro at us-east-1[ec2-user@ip-172-16-0-190 ~]$ cat /proc/cpuinfoprocessor : 0vendor_id : GenuineIntelcpu family : 6model : 63model name : Intel(R) Xeon(R) CPU E5-2676 v3 @ 2.40GHzt2.name at us-east-1[ec2-user@ip-172-16-0-116 ~]$ cat /proc/cpuinfoprocessor : 0vendor_id : GenuineIntelcpu family : 6model : 63model name : Intel(R) Xeon(R) CPU E5-2676 v3 @ 2.40GHzt2.medium at us-east-1processor :..

자신의 계정에 root 권한을 주는 방법으로는 sudoer를 이용할 수 있다. /etc/sudoers.d 디렉토리 밑에 새로운 파일을 만든다.ㅇ 그룹으로 관리하고 싶을 경우, /etc/sudoers.d/my_company User_Alias DEV = sunshout,sunshout2 DEV ALL=(ALL) NOPASSWD: ALL

process 감시https://github.com/influxdata/telegraf/tree/master/plugins/inputs/procstat

네트워크 트래픽SELECT derivative(mean("bytes_recv"),1s) FROM "net" WHERE "interface" = 'eth0' AND $timeFilter GROUP BY time(10s), "host" 디스크 사용량SELECT mean("used_percent") FROM "disk" WHERE "device" = 'xvdb' AND $timeFilter GROUP BY time(10s), "host" Memory 사용량SELECT mean("used_percent") FROM "mem" WHERE $timeFilter GROUP BY time(10s), "host" CPU 사용량SELECT 100-mean("usage_idle") FROM "cpu" WHERE "cpu" ..

CentOS에서 보면 /etc/cron.daily/etc/cron.hourly/etc/cron.weekly/etc/cron.monthly 디렉토리가 존재한다. 해당 디렉토리에서 shell script을 넣어두면 해당 주기별로 실행한다. ex) /etc/cron.daily/delete_log #!/bin/bash find /var/log -mtime +3 -exec rm {} \;그러면 실제적으로 어느 시간에 해당 cron이 도는지는 anacrontab을 통해서 알수 있다./etc/anacrontab 을 보면# /etc/anacrontab: configuration file for anacron # See anacron(8) and anacrontab(5) for details. SHELL=/bin/shP..

aws --region us-west-1 ec2 describe-images --owners aws-marketplace --filters Name=product-code,Values=aw0evgkw8e5c1q413zgy5pjce [choonho.son@ip-172-31-11-240 devops]$ aws --region us-west-1 ec2 describe-images --owners aws-marketplace --filters Name=product-code,Values=aw0evgkw8e5c1q413zgy5pjce{ "Images": [ { "ProductCodes": [ { "ProductCodeId": "aw0evgkw8e5c1q413zgy5pjce", "ProductCodeType": "..