Common knowledge and commands for server management

MySQL server:

Service httpd Start

Service httpd Stop

Modify the directory where MySQL data files are located in/etc/my.conf:

Datadir=/assets/mysql

Effective after restarting MySQL server

Note The permissions issue may occur during the modification of the DataDir restart service above: Because MYSQLD is running as a MySQL user, and datadir may not belong to a MySQL user, the solution:

innodb:the error means mysqld does not has the access rights toinnodb:the directory. Innodb:file name. /'open'. Innodb:cannot continue operation. 071027 : £º  mysqld endedchown -R mysql.mysql/assets/mysql

Data disk mount and expansion:

Https://help.aliyun.com/document_detail/25452.html?spm=5176.doc25445.6.173.XKkyJu

Check the CPU-intensive process details under Linux:

1. Top-c detect the corresponding command and PID,

2. Cd/prox/pid

3. Ls-l, the display of CWD and EXE can be seen in particular which command started this CPU-intensive task!

Common knowledge and commands for server management