私のRaspberry PiはSDカードと継続的にインターフェースしています

私のRaspberry PiはSDカードと継続的にインターフェースしています

私のRaspberry PiにはArch ARMを搭載した128GBのSDカードがあり、

  • アパッチ
  • ネクストクラウド

インストールすると、SD カードとのインターフェイスが止まらなくなるようです。このプロセスが、ディスクにほとんどのデータを書き込むプロセスであることがiotopわかりました。mysql シェルで、次のことがわかりました。mysqld

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すでに/tmpRAM ディスク上にある場合 ( tmpfs)

その後、コマンドを継続的に実行すると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)

関連情報