Deep dive into Kernel

mysql> show variables like "%version%"; +-------------------------+--------------------------------------+ | Variable_name | Value | +-------------------------+--------------------------------------+ | innodb_version | 5.6.31 | | ndb_version | 459788 | | ndb_version_string | ndb-7.4.12 | | ndbinfo_version | 459788 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.6.31-ndb-7...

apt-get install gpm

In CentOS,update at /etc/sysconfig/network http://serverfault.com/questions/567249/centos-multiple-nics-routing-issue

/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