Jump to content
scott001

Scheduled maintenance issue / no statistics recording

Recommended Posts

Last night I did some work on my server and had to restart mysql several times. I don't believe that any changes I made would break the maintenance cronjob--I checked and it is running on schedule, but no stats are being recorded. 

I suspect that the cache is somehow corrupted because I may have restarted mysql during a maintenance run. Is there a way for me to flush the cache in case this is the cause? Any ideas about how to get this fixed? Thank you in advance!

 

 

Just in case the performance changes I made last night to my.cnf could somehow affect this, here is what I did:

  • changed thread_cache_size from 128 to 256

Since I upgraded to MariaDB a couple of months ago I read that these are important for speed, so I added them to the my.cnf:

  • host_cache_size=256 (default is 128)
  • aria_pagecache_buffer_size=256M (default is 128)

Share this post


Link to post
Share on other sites

Here is what I found. My cronjob, which worked fine for years like this:

0 * * * * php -f /home/site/public_html/revivieadserver/maintenance/maintenance.php >/dev/null 2>&1

suddenly, at least to me anyway, needed to be like this:

0 * * * * php -f /home/site/public_html/revivieadserver/maintenance/maintenance.php localhost >/dev/null 2>&1

The mysql restarts may have been just a coincidence, and my server auto-updated and installed a new version of cpanel or something else, but something changes and now I must include "localhost" in the cronjob.

I hope this helps someone else!

Share this post


Link to post
Share on other sites
On 5/22/2018 at 7:38 PM, scott001 said:

Here is what I found. My cronjob, which worked fine for years like this:

0 * * * * php -f /home/site/public_html/revivieadserver/maintenance/maintenance.php >/dev/null 2>&1

suddenly, at least to me anyway, needed to be like this:

0 * * * * php -f /home/site/public_html/revivieadserver/maintenance/maintenance.php localhost >/dev/null 2>&1

The mysql restarts may have been just a coincidence, and my server auto-updated and installed a new version of cpanel or something else, but something changes and now I must include "localhost" in the cronjob.

I hope this helps someone else!

Hello, i have problem with statistics too, and i want to ask you - is the cronjob really help you in this situation, and what version of MariaDB you are using?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...