How to optimize Mysql server performance?

David Makogon · Jun 14, 2016

I am trying to test a small VPS for one of my sites, but sometimes mysql server databases are error due to web traffic or queries. Are there any way(s) to optimize Mysql server performance?

VirtuBox · Jun 14, 2016

Yes you should check what is your version of mysql, as the last (5.6) have really better performance.
And to fix it you should edit the /etc/my.cnf file to accept more queries.

But if you really want performance, you can delete mysql and use mariadb instead. Really faster than mysql.

praveenk · Jun 22, 2016

David Makogon said:
I am trying to test a small VPS for one of my sites, but sometimes mysql server databases are error due to web traffic or queries. Are there any way(s) to optimize Mysql server performance?

Simply try mysqltuner.pl on your VPS and make the necessary changes in the my.cnf file, for more information you can refer POST

Luxin Host · Jun 26, 2016

There are two ways of doing this, firstly is the way that @VirtuBox explained it.
and secondly make sure to always keep your databases tidy and as light as possible.

David Makogon · Jun 26, 2016

VirtuBox said:
Yes you should check what is your version of mysql, as the last (5.6) have really better performance.
And to fix it you should edit the /etc/my.cnf file to accept more queries.

Please elaborate this.

what codes do I need to add to increase mysql performance?

VirtuBox said:
But if you really want performance, you can delete mysql and use mariadb instead. Really faster than mysql.

How to switch to mariadb, I heard more times about this but how to enable it on my blog sites?

I am using mysql databases.

praveenk said:
Simply try mysqltuner.pl on your VPS and make the necessary changes in the my.cnf file, for more information you can refer POST

Did you or anyone here use mysqltuner.pl to optimize mysql databases?

Luxin Host said:
and secondly make sure to always keep your databases tidy and as light as possible.

It's hard to keep databases tidy because I used to add content and images to my blog sites regularly so its increased quickly time by time.

Luxin Host · Jun 26, 2016

@David Makogon
Are you familiar with database maintenance?
If yes the you should start to implement it.
if no, its ideal to start learning about it as it will help you a great deal as your website grows.

I suggest deleting revisions and unnecessary plugins if you use wordpress or other CMS.

What is your blog ran on?

RDO Servers · Jun 26, 2016

MariaDB is a "drop in replacement" for MySQL which means you will not need to make any changes to your databases or queries.

Check your memory usage. Running out of available RAM can cause problems for MySQL!

How to optimize Mysql server performance?

David Makogon

Member

VirtuBox

Well-known member

praveenk

Member

Luxin Host

Well-known member

David Makogon

Member

Luxin Host

Well-known member

RDO Servers

Well-known member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud