내 Raspberry Pi에는 Arch ARM이 포함된 128GB SD 카드가 있고
- 아파치
- 넥스트클라우드
그것에 설치되었으며 SD 카드와 논스톱 인터페이스를 하는 것처럼 보입니다. 나는 이것이 대부분의 데이터를 디스크에 쓰는 프로세스인 것 같다는 것을 iotop알게 되었습니다 . mysqldmysql 쉘에서 다음을 발견했습니다.
show processlist;
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------+----------+
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 1846 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 |
| 1852 | oc_stdcerr13 | localhost | nextcloud | Sleep | 0 | | NULL | 0.000 |
| 1853 | oc_stdcerr13 | localhost | nextcloud | Sleep | 0 | | NULL | 0.000 |
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------+----------+
8 rows in set (0.001 sec)
SD 카드를 어떻게 쉬게 할 수 있나요? 이미 램디스크에 있습니다( /var/log) ./tmptmpfs
그런 다음 계속해서 명령을 실행했을 때 show processlist다음도 보았습니다.
show processlist;
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 2061 | oc_stdcerr13 | localhost | nextcloud | Query | 0 | Init | SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `name`, `mimetype | 0.000 |
| 2062 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 |
| 2063 | oc_stdcerr13 | localhost | nextcloud | Sleep | 0 | | NULL | 0.000 |
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
8 rows in set (0.001 sec)
MariaDB [(none)]> show processlist;
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
| 1 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
| 2 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
| 5 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
| 2061 | oc_stdcerr13 | localhost | nextcloud | Query | 0 | Init | UPDATE `oc_filecache` SET `size` = '-1' WHERE (`fileid` = 15955) AND ((`size` <> '-1') OR (`size` IS | 0.000 |
| 2062 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 |
| 2063 | oc_stdcerr13 | localhost | nextcloud | Sleep | 0 | | NULL | 0.000 |
+------+--------------+-----------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
8 rows in set (0.001 sec)