View All Products
Compute
Storage
Databases
Networking
Developer Tools
Delivery
Security
Services
Industries
Pricing
Community
Engage With Us
Community ▶ Questions ▶ mysql and basic system health "Do only what Matters&quo
Log in to Ask a Question

mysql and basic system health "Do only what Matters&quo

general

I have a pretty stable LAMP install that I built from scratch here on Linode, and it's working for the most part 99.9% of the time. I'm not a linux expert by any means. However, what are some easy simple things to keep it running at peak performance. I have 26 virtual domains, and get around 1000 hits a day.

I know yum update for system updates..

what about mysql ?

I found this http://khaidoan.wikidot.com/mysql-table-maintenance but it says, "Do Only What Matters" so is "OPTIMIZE TABLE" not something that should be ran monthly?

Thanks,

2 Replies

Run this script and follow its advice: http://mysqltuner.pl/

That, and switching to InnoDB if possible, are probably the only things that actually matter in a small MySQL installation.

@hybinet:

Run this script and follow its advice: http://mysqltuner.pl/

That, and switching to InnoDB if possible, are probably the only things that actually matter in a small MySQL installation.

Yes great thank you.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Log in to Reply
Community Code of Conduct