Please wait while we load your page...

PasswordSentry

Latest Version [8.00202205221] Last Updated [May-22-2022]

Webmaster Tutorials

Definition [mySQL Maintenance]

Protect Your Website Today
Home




mySQL Maintenance



It is highly recommended you perform regular mySQL maintenance. You can do this by executing the following commands via SSH:

mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize


Repairing and optimizing mySQL databases goes a long ways to keep mySQL operating efficiently, and reducing the chances of mySQL crashing: which necessitates restarting the mySQL server (/etc/init.d/mysqld restart). Ideally you would create a cron job to automatically perfrom these actions at set times. For example, daily.

Random Security Blog Articles



PasswordSentry :: Security Blog Articleby Renee Dudley and Daniel Golden ProPublica is a Pulitzer Prize-winning investigative newsroom. Sign up for The Big Story newsletter to receive stories like this one in your inbox. Series: The Extortion Economy U.S. Companies and Ransomware On Jan. … Read More
PasswordSentry :: Security Blog ArticlePhishing. What is it? And how to protect yourself from it. Let’s say you get an email from your bank. You’ve gotten email from your bank before, but this one stands out from the others. It says “Changes were made … Read More
PasswordSentry :: Security Blog ArticleWill justices seek to hold social media firms to account for the postings of terrorists? AP Photo/Patrick Semansky Michael W. Carroll, American University “These are not, like, the nine greatest experts on the internet,” noted Justice Elena Kagan – … Read More