MySQL optimized settings for 4GB Linode

msamavi,

We're going to need to know a little more than "MySQL, Drupal, 4GB Linode".

• How many sites?

• How much traffic?

• Are all the sites completely dynamic?

• How much content is database driven?

• Will you have forums?

• How often will you be adding new content to your sites?

Those are just a few question, but others could have many more. Please give us as much information as possible about your sites.

Remember: Make it as easy as possible for us to help you.

Thanks Main Street James,

• 10 sites

• around 800 GB monthly

• Yes, all dynamic

• 90% content database driven

• Forums not yet, but 1 online shop (Ubercart) and starting blogs

• new contents added daily

And is the database on the 4G alone (recommended) or is some memory/CPU consuming web server there as well? If so how much memory is the web server consuming?

I'd put the web server on its own machine. Makes it easier to scale/replace web servers and database independently.

Yes, on the same machine.

Any comment, please?

msamavi,

You've supplied some information but you haven't told us anything you've already done to optimize MySQL.

You also haven't told us that you're actually having a performance problem. Dealing with hypotheticals makes it almost impossible for us to offer any specific help.

Remember: Make it as easy as possible for us to help you.

With at least 24 hours since your last MySQL config change or restart:

wget mysqltuner.pl
perl mysqltuner.pl

Research and understand every suggestion it makes before implementing it, because sometimes it's wrong.