Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - hugaagogo

Pages: [1]
1
- 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--------------------

2
MySQL / Re: cron.daily - mysql restart every night (How to stop ?)
« on: January 20, 2021, 05:25:55 PM »
any idea?

3
MySQL / cron.daily - mysql restart every night (How to stop ?)
« on: January 10, 2021, 11:48:21 AM »
- 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


-------------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--------------------

4
How to / Re: How do I get rid of Netdata?
« on: April 25, 2019, 10:19:19 AM »
i dont want to share all my website secrets/stats and informations to netdata inc. stop selling our datas! stop installing 3party spywares to our servers !

i dont have time to delete/change your spyware-centoswebpanel right now.

stop automatically installing spywares on every night update, this is 3. times.
i'm uninstalling it for the third time, and you re automatically install and start it again at every night !!!

5
How to / Re: How do I get rid of Netdata?
« on: April 14, 2019, 09:54:10 AM »
- do you sell our datas or other things to netdata, why you automatically install this shit to my server?

- after this, how can i be sure you dont install any other applications to my server (botnet? cyrpto miners?)

I do not trust you and cwp anymore, i sure that i will delete cwp from my server.


Pages: [1]