For those of you who run mysql, there’s an issue that you have to look at. Like file systems, database tables get fragmented over time. There’s a simple fix for it, but you will need to execute one command to do it.
Of course, you will need to have root access to your Mysql server, but it will significantly speed up your mysql database.
Simply, one command issued as the following:
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
I would really appreciate that if this made a difference or you find this helpful that you donate. I’m really trying to support my family and while I have >1000 visitors a day (unique), I haven’t seen a donation in a while. It’d be nice to see that someone appreciates what I’m doing.
This should make a difference on all mysql databases that have been running for a while. As for WordPress users, it makes a huge difference.
3 thoughts on “Increasing Mysql performance significantly”
Pretty nice poste. Je simply suis tomb� par hasard votre sur blog et wanted � mention que je have really enjoyed surfing autour votre weblog des postes. Dans n’importe quel case I fera(sera) souscrivent(adh�rent) on your rss l’alimentation et I’m esp�rant vous �crivez again very bient�t!
Great poste. I �tait v�rifiant constantly ce weblog et I’m inspired! Very useful information specially final part 🙂 je maintain tel information un lot. I �tait seeking ce certain information pour un very lengthy le temps. Thanks et best de chance.
Hello Blogger! I found your blog using Google and as a Search engine opmiitzer I have a tip for you that I think you will find very useful. There’s a WordPress addon that automatically does SEO for your site for higher rankings, it’s a 1-click install that’s not expensive at all. It will help you make more money from your website and drive more daily traffic to your pages. Click my username to check it out. Thanks for reading.