MySQL Optimization and Scheduled Maintenance

Once in a while it is worth to take care of your database and verify it can provide the needed resources for your system.
After all, most of the data may be store in it...


Some Tasks I would Recommend You to Do
Please notice that this work may not be done manually, but can be automated. If you do so, you may be contribute it back to the community at your favorite open source project:

1. Run MySQLTuner and look for issues.
2. Take care of fragmented tables:
1. You can find them using SHOW TABLE STATUS WHERE Data_free > 0\G and take care of them using OPTIMIZE TABLE table_name; 
2. Or you can use mysqlfragfinder script for that.
3. Verify RAM, disk and CPU utilization
4. Check the slow log query

Keep Performing

Moshe Kaplan

What is the Best File System for MySQL?

Well the answer it depends.
Not sure? take a look at this Q&A at ServerFault

Keep Performing,
Moshe Kaplan

Good News from Amazon AWS for SEO and Newsletter Marketers

Amazon AWS latest announcement of Multiple IP Addresses for Amazon EC2 Instances support is a great news for SEO and Newsletter markers.

Why these are Good News?
Both SEO and Newsletter marketers require large number of dedicated IP addresses:

1. Google tend to associate websites that are using the same IP address. Therefore, if a single site uses unethical SEO methods, you may want to avoid a ranking damage to other sites. Another reason is that linking methods are considered more effective if they come from external sites.
2.  Major email suppliers around the world (Google's Gmail, Yahoo!, Yandex and Microsoft Hotmail) limit the number of emails per minute they accept from a single IP. Multiple IP addresses can help newsletter service providers better utilize their existing instances.

Bottom Line

Online services are getting better every time. It's time to utilize them!

Keep Performing,

Moshe Kaplan