DELETE FROM `still_youtube_podp_user` WHERE `date`+23328000 < UNIX_TIMESTAMP();
# hdparm -t /dev/vda2
/dev/vda2:
Timing buffered disk reads: 272 MB in 3.01 seconds = 90.29 MB/sec
# hdparm -t /dev/vda1
/dev/vda1:
Timing buffered disk reads: 256 MB in 2.42 seconds = 105.91 MB/sec
# iostat -x /dev/vda2
Linux 03/13/2020 _x86_64_ (8 CPU)
avg-cpu: %user %nice %system %iowait %steal %idle
4.38 0.03 1.81 0.78 2.28 90.71
Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util
vda2 0.01 50.30 4.22 44.36 88.74 1030.77 46.09 0.74 15.31 8.38 15.97 1.44 6.98
# iostat -x /dev/vda1
Linux 03/13/2020 _x86_64_ (8 CPU)
avg-cpu: %user %nice %system %iowait %steal %idle
4.38 0.03 1.81 0.78 2.28 90.71
Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util
vda1 0.00 0.00 0.00 0.00 0.07 0.00 248.88 0.00 2.29 2.29 0.00 1.19 0.00
app:
build:
context: .
dockerfile: docker/node/DockerfileFROM node:11
WORKDIR /src
COPY ./src/package*.json ./
RUN npm install mysql
COPY ./src /src
CMD ["node", "index.js"]