Jul 20 06:09:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 05:39:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 05:17:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( cd / & run-parts -report /etc/cron.hourly) Jul 20 05:09:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 04:39:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 04:17:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( cd / & run-parts -report /etc/cron.hourly) Jul 20 04:09:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 03:39:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 03:31:26 ITMI-PHSE-MYSQL systemd: Finished Ubuntu Advantage APT and MOTD Messages. Jul 20 03:31:26 ITMI-PHSE-MYSQL systemd: rvice: Succeeded. Jul 20 03:31:24 ITMI-PHSE-MYSQL systemd: Starting Ubuntu Advantage APT and MOTD Messages. Jul 20 03:17:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( cd / & run-parts -report /etc/cron.hourly) Jul 20 03:10:01 ITMI-PHSE-MYSQL CRON: (root) CMD (test -e /run/systemd/system || SERVICE_MODE=1 /sbin/e2scrub_all -A -r) Jul 20 03:09:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 02:39:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 02:17:02 ITMI-PHSE-MYSQL CRON: (root) CMD ( cd / & run-parts -report /etc/cron.hourly) Jul 20 02:09:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 01:39:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 01:38:46 ITMI-PHSE-MYSQL systemd: rvice: Succeeded. Jul 20 01:17:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( cd / & run-parts -report /etc/cron.hourly) Jul 20 01:09:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 00:39:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 00:17:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( cd / & run-parts -report /etc/cron.hourly) Jul 20 00:09:01 ITMI-PHSE-MYSQL CRON: (root) CMD ( & if then /usr/lib/php/sessionclean fi) Jul 20 00:08:35 ITMI-PHSE-MYSQL snapd: autorefresh.go:513: auto-refresh: all snaps are up-to-date How can I optimize this? I would like it to use as much memory as possible but I don't want it to crash for an alter table.ĮDIT - log files: Jul 20 00:08:35 ITMI-PHSE-MYSQL snapd: storehelpers.go:551: cannot refresh: snap has no updates available: "core", "core18", "core20", "lxd" Probably it did not have enough memory for the alter table? I have run an alter table on a table with 3.5 million rows and that's when it crashed. I thought probably is normal because of innodb_dedicated_server. For example, just a moment ago I checked my free memory with free -m and it was 130. The problem is this every now and then (once in a day or every 2 days) mysql crashes saying "out of memory". The server is a vmware VM configured with 10GB RAM, 8 CPU (2 core, 4 sockets). It's a dedicated server so I have my.cnf set up as this: innodb_dedicated_server = 1 On it I have installed just mysql version 8.0.25-0ubuntu0.20.04.1 I have an ubuntu server version 20.04.2 LTS.
0 Comments
Leave a Reply. |