tuneup_guide
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
tuneup_guide [2009/05/29 21:43] k2patel |
tuneup_guide [2020/08/10 02:35] (current) |
||
|---|---|---|---|
| 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 17: | Line 17: | ||
| <code bash> | <code bash> | ||
| - | wget http://www.day32.com/MySQL/tuning-primer.sh | + | wget http://bazaar.launchpad.net/%7Ematt-day32/mysql-tuning-primer/trunk/download/head%3A/tuningprimer.sh-20080620031244-qhr6av9fsnf6vswg-1/tuning-primer.sh |
| </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 mysql> | + | <code sql> |
| CREATE INDEX id_google ON google_searches(hits DESC); | CREATE INDEX id_google ON google_searches(hits DESC); | ||
| </code> | </code> | ||
| Line 46: | Line 46: | ||
| i have seen get load reduced on whole server in 2.x after applying just index. | i have seen get load reduced on whole server in 2.x after applying just index. | ||
| + | ==== Install memcached if your Application support memcache ==== | ||
| + | |||
| + | Installing memcached help on some similar query to the mysql and reduce load. | ||
tuneup_guide.1243633416.txt.gz ยท Last modified: 2020/08/10 02:29 (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
