tuneup_guide
Differences
This shows you the differences between two versions of the page.
|
tuneup_guide [2009/03/07 23:14] k2patel created |
tuneup_guide [2020/08/10 02:35] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ==== Mysql Has tuner ==== | ||
| - | If you see your mysql is slowing down or not performing good. | ||
| - | You need to run following command first. | ||
| - | |||
| - | <code mysql> | ||
| - | mysqlcheck -u root --auto-repair --check --optimize --all-databases -p | ||
| - | </code> | ||
| - | |||
| - | ==== Third Party tuner ==== | ||
| - | |||
| - | Still feel slowness. see below.\\ | ||
| - | First,\\ | ||
| - | You need to understand what tuner is all about and how to tuneup.\\ | ||
| - | for that purpose you can use one descriptive tuner you can grab it from following link.\\ | ||
| - | you can use fetch instead of wget. | ||
| - | |||
| - | <code bash> | ||
| - | wget http://www.day32.com/MySQL/tuning-primer.sh | ||
| - | </code> | ||
| - | |||
| - | Now run the script and read every things it print on screen step by step.\\ | ||
| - | There is nothing anybody can do if you don't judge. | ||
| - | |||
| - | After getting idea what is the tuner and how it works.\\ | ||
| - | get following tuner which is more frequently updated than above one. | ||
| - | |||
| - | <code bash> | ||
| - | wget http://mysqltuner.com/mysqltuner.pl | ||
| - | </code> | ||
| - | |||
| - | Now, most important part\\ | ||
| - | If you see any tuner saying you are assigning more ram, than reduce the ram by adjusting variable in my.cnf.\\ | ||
| - | why it is important, because more ram usage will cause swap during the request on server.\\ | ||
| - | when server start using swap it will make server d** slow. | ||
tuneup_guide.txt ยท Last modified: 2020/08/10 02:35 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
