Optimize MySQL - MySQLTuner

immu

New member
Registered
Joined
Jul 6, 2012
Messages
2
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

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

LeetHost

New member
Registered
Joined
Aug 5, 2013
Messages
13
Points
0
Thanks alot! very helpful topic for those who wish to optimize
 
Older Threads
Replies
29
Views
10,665
Replies
8
Views
4,078
Replies
2
Views
3,428
Replies
18
Views
7,905
Newer Threads
Replies
2
Views
3,097
Replies
6
Views
4,570
  • Locked
Replies
5
Views
4,661
  • Locked
Replies
11
Views
4,948
Replies
2
Views
3,378
Latest Threads
Replies
3
Views
55
Replies
2
Views
96
Replies
12
Views
349
Recommended 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