tuneup_guide
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| tuneup_guide [2009/08/05 02:07] – 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 17: | Line 17: | ||
| <code bash> | <code bash> | ||
| - | wget http://www.day32.com/MySQL/ | + | wget http://bazaar.launchpad.net/%7Ematt-day32/ |
| </ | </ | ||
| 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.1249438049.txt.gz · Last modified: 2020/08/10 02:29 (external edit)