Linux - Create a service for the new instance - using systemd

How to create a service for the new instance - using systems?

In this example: MySQL service.

1. Create “.service” file
Save in “/lib/systemd/system/” or “/etc/systemd/system”

touch mysql_3307.service
vi mysql_3307.service
 

[Unit]
Description=MySQL 3307 service
After=network.target
 
[Service]
Type=simple
Restart=always
User=mysql
Group=mysql
ExecStart=/etc/mysql/sudo mysqld --defaults-file=/etc/mysql/second_server.cnf
TimeoutSec=600
RuntimeDirectory=mysqld
RuntimeDirectoryMode=755
LimitNOFILE=5000
 
[Install]
WantedBy=multi-user.target

2. Start the service
Sudo systemctl start mysql_3307


3. Checking
systemctl status mysql_3307
 journalctl -xe


* Stop the service (if required)
systemctl stop mysql_3307

Linux: show enviroment parameter

Show environment parameter <PARAM_NAME> on Linux:

echo $<PARAM_NAME>

example: echo $PATH 

Stop running command in linux

1. find the PID of the command:
ps -aux | grep -i <PART_OF_THE_COMMAND>

• the second column is the PID

2. kill the command:
kill -TERM <PID>

AIX - CPU, memory and IO (disks space) commands

CPU usage for each process:
topas –P

CPU details:
mpstat

Memory details:
vmstat
svmon

Disk IO details:
iostat
topas -D