This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
tuneup_guide [2010/12/01 02:32] k2patel |
tuneup_guide [2010/12/01 02:36] k2patel |
||
---|---|---|---|
Line 4: | Line 4: | ||
You need to run following command first. | You need to run following command first. | ||
- | <code mysql> | + | <code sql> |
mysqlcheck -u root --auto-repair --check --optimize --all-databases -p | mysqlcheck -u root --auto-repair --check --optimize --all-databases -p | ||
</code> | </code> | ||
Line 40: | Line 40: | ||
you can specify many parameter in index like - DESC ... etc. | you can specify many parameter in index like - DESC ... etc. | ||
- | <code bash> | + | <code sql> |
CREATE INDEX id_google ON google_searches(hits DESC); | CREATE INDEX id_google ON google_searches(hits DESC); | ||
</code> | </code> |