tuneup_guide
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| tuneup_guide [2010/12/01 02:32] – k2patel | tuneup_guide [2020/08/10 02:35] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 4: | Line 4: | ||
| You need to run following command first. | You need to run following command first. | ||
| - | < | + | < |
| mysqlcheck -u root --auto-repair --check --optimize --all-databases -p | mysqlcheck -u root --auto-repair --check --optimize --all-databases -p | ||
| </ | </ | ||
| Line 40: | Line 40: | ||
| you can specify many parameter in index like - DESC ... etc. | you can specify many parameter in index like - DESC ... etc. | ||
| - | < | + | < |
| CREATE INDEX id_google ON google_searches(hits DESC); | CREATE INDEX id_google ON google_searches(hits DESC); | ||
| </ | </ | ||
tuneup_guide.1291170749.txt.gz · Last modified: 2020/08/10 02:29 (external edit)