Optimize MySQL - MySQLTuner

immu

New member
Joined
Jul 6, 2012
Messages
5
Points
0
Hiya guys, if any of you own a dedicated server and want to reduce the MySQL load hopefully I can help. Before doing the following steps it is advised to have had the MySQL service running for at least 24 hours, preferred 48 hours +

CentOS:

Download MySQLTuner:


PHP:
wget http://mysqltuner.com/mysqltuner.pl
Make executable:


PHP:
chmod 755 mysqltuner.pl
Run MySQLTuner:

PHP:
./mysqltuner.pl
Then the output will display what you need to do/can do to increase performance. Most of the configuration will lay in the following file:


PHP:
/etc/my.cnf
If you don't understand what it is telling you ask me here
 

James159

New member
Joined
Aug 31, 2012
Messages
56
Points
0
I think this is really good information regarding MySQL which definitely useful for all Oracle developers.
 

LeetHost

New member
Joined
Aug 5, 2013
Messages
30
Points
0
Thanks alot! very helpful topic for those who wish to optimize
 
Older threads
Replies
11
Views
7,297
Replies
23
Views
10,184
Replies
6
Views
3,653
Replies
2
Views
1,775
Newer threads
Replies
1
Views
3,087
Replies
19
Views
8,252
Replies
0
Views
2,780
Replies
6
Views
4,300
Recommended threads

Referral contests

Referral link for :

Sponsors

Latest Blog ArticlesMost Viewed Threads

Popular tags

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