Author Topic: anacron - cron.daily - mysql restart every night (How to stop ?)  (Read 2053 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
- I want to stop cron.daily - "mysql restart" command but i dont know how.
(help appreciated. thank you.)

Why ?
i need minimum 2 day uptime for analize mysql conf

https://i.postimg.cc/mDRydFxg/screenshot-274.png

also(more importantly) sometimes these restarts cause 5++ minutes mysql downtime

https://i.postimg.cc/GppcvXtL/screenshot-273.png



https://i.postimg.cc/cLYN93cD/screenshot-277.png


------------sample-logs--------------------
email
Quote
Anacron job 'cron.daily' on sitename123.com


messages logs
Quote
Jan 10 03:30:01 servername123 systemd: Stopping MariaDB 10.2.36 database server...
Jan 10 03:30:03 servername123 systemd: Stopped MariaDB 10.2.36 database server.
Jan 10 03:30:04 servername123 systemd: Starting MariaDB 10.2.36 database server...
Jan 10 03:30:05 servername123 mysqld: 2021-01-10  3:30:05 140584771946688 [Note] /usr/sbin/mysqld (mysqld 10.2.36-MariaDB-log) starting as process 18309 ...
Jan 10 03:30:05 servername123 systemd: Started MariaDB 10.2.36 database server.
Jan 10 03:30:05 servername123 systemd: Stopping MariaDB 10.2.36 database server...
Jan 10 03:30:07 servername123 systemd: Stopped MariaDB 10.2.36 database server.
Jan 10 03:30:08 servername123 systemd: Starting MariaDB 10.2.36 database server...
Jan 10 03:30:08 servername123 mysqld: 2021-01-10  3:30:08 139859181062336 [Note] /usr/sbin/mysqld (mysqld 10.2.36-MariaDB-log) starting as process 18482 ...
Jan 10 03:30:08 servername123 systemd: Started MariaDB 10.2.36 database server.


cron logs
Quote
Jan  9 03:27:01 servername123 anacron[22631]: Job `cron.daily' started
Jan  9 03:27:01 servername123 run-parts(/etc/cron.daily)[29233]: starting certwatch
Jan  9 03:27:01 servername123 run-parts(/etc/cron.daily)[29240]: finished certwatch
Jan  9 03:27:01 servername123 run-parts(/etc/cron.daily)[29233]: starting cwp
Jan  9 03:27:22 servername123 run-parts(/etc/cron.daily)[30011]: finished cwp
Jan  9 03:27:22 servername123 run-parts(/etc/cron.daily)[29233]: starting cwp_acme.sh
Jan  9 03:27:22 servername123 run-parts(/etc/cron.daily)[30083]: finished cwp_acme.sh
Jan  9 03:27:22 servername123 run-parts(/etc/cron.daily)[29233]: starting cwp_bandwidth
Jan  9 03:27:23 servername123 run-parts(/etc/cron.daily)[30105]: finished cwp_bandwidth
Jan  9 03:27:23 servername123 run-parts(/etc/cron.daily)[29233]: starting logrotate
Jan  9 03:27:23 servername123 run-parts(/etc/cron.daily)[30112]: finished logrotate
Jan  9 03:27:23 servername123 run-parts(/etc/cron.daily)[29233]: starting man-db.cron
Jan  9 03:27:23 servername123 run-parts(/etc/cron.daily)[30126]: finished man-db.cron
Jan  9 03:27:23 servername123 anacron[22631]: Job `cron.daily' terminated (produced output)
Jan  9 03:27:23 servername123 anacron[22631]: Normal exit (1 job run)
Jan  9 03:28:01 servername123 crond[536]: (root) RELOAD (/var/spool/cron/root)
Jan  9 03:30:01 servername123 CROND[30791]: (root) CMD (/usr/local/bin/svcMonitor)
Jan  9 03:30:01 servername123 CROND[30792]: (root) CMD (/usr/local/bin/svcMonitor-systemd)
Jan  9 03:30:01 servername123 CROND[30799]: (root) CMD (/usr/lib64/sa/sa1 1 1)
Jan  9 03:40:01 servername123 CROND[1167]: (root) CMD (/usr/lib64/sa/sa1 1 1)
Jan  9 03:45:01 servername123 CROND[2379]: (root) CMD (/usr/local/bin/svcMonitor)
Jan  9 03:45:01 servername123 CROND[2380]: (root) CMD (/usr/local/bin/svcMonitor-systemd)



mysql logs
Quote
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Uses event mutexes
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Compressed tables use zlib 1.2.7
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Using Linux native AIO
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Number of pools: 1
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Initializing buffer pool, total size = 40M, instances = 1, chunk size = 40M
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Completed initialization of buffer pool
2021-01-10  3:30:05 140584151996160 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Highest supported file format is Barracuda.
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-01-10  3:30:05 140584771946688 [Note] InnoDB: 5.7.32 started; log sequence number 12347021
2021-01-10  3:30:05 140583850985216 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-01-10  3:30:05 140583850985216 [Note] InnoDB: Buffer pool(s) load completed at 210110  3:30:05
2021-01-10  3:30:05 140584771946688 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-10  3:30:05 140584771946688 [Note] Server socket created on IP: '::'.
2021-01-10  3:30:05 140584771946688 [Note] Reading of all Master_info entries succeeded
2021-01-10  3:30:05 140584771946688 [Note] Added new Master_info '' to hash table
2021-01-10  3:30:05 140584771946688 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.2.36-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
2021-01-10  3:30:05 140584349431552 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2021-01-10  3:30:05 140584349431552 [Note] Event Scheduler: Purging the queue. 0 events
2021-01-10  3:30:05 140584101639936 [Note] InnoDB: FTS optimize thread exiting.
2021-01-10  3:30:05 140584349431552 [Note] InnoDB: Starting shutdown...
2021-01-10  3:30:05 140583850985216 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2021-01-10  3:30:05 140583850985216 [Note] InnoDB: Buffer pool(s) dump completed at 210110  3:30:05
2021-01-10  3:30:07 140584349431552 [Note] InnoDB: Shutdown completed; log sequence number 12347040
2021-01-10  3:30:07 140584349431552 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-10  3:30:07 140584349431552 [Note] /usr/sbin/mysqld: Shutdown complete

-------------logs--------------------