This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
tuneup_guide [2009/03/07 23:14] k2patel created |
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 34: | Line 34: | ||
why it is important, because more ram usage will cause swap during the request on server.\\ | 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. | when server start using swap it will make server d** slow. | ||
+ | |||
+ | ==== Create Indexes for query if it not exists on busy table ==== | ||
+ | |||
+ | Creating index will help you on sorting and searches which reduce time highly.\\ | ||
+ | you can specify many parameter in index like - DESC ... etc. | ||
+ | |||
+ | <code sql> | ||
+ | CREATE INDEX id_google ON google_searches(hits DESC); | ||
+ | </code> | ||
+ | |||
+ | 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. |