How to optimize Mysql server performance?

David Makogon

Member
Joined
Apr 24, 2016
Messages
35
Points
0
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

Well-known member
Registered
Joined
May 3, 2016
Messages
1,622
Points
83
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

Member
Registered
Joined
Mar 10, 2016
Messages
17
Points
0
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
 

David Makogon

Member
Joined
Apr 24, 2016
Messages
35
Points
0
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?

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.

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?

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

Well-known member
Registered
Joined
Jun 26, 2016
Messages
543
Points
43
@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

Well-known member
Registered
Joined
Apr 3, 2015
Messages
1,027
Points
83
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!
 
Latest Threads
Replies
0
Views
35
Replies
0
Views
174
Replies
0
Views
79
Replies
0
Views
73
Recommended Threads
Replies
14
Views
7,133
  • Locked
2
Replies
32
Views
14,283
Replies
5
Views
4,560
Replies
1
Views
1,733
Similar Threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top