Debian DokuWiki

User Tools

Site Tools

Trace: • phpshell_scanner • upgrade_using_ius • scripts • bash
tuneup_guide

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
tuneup_guide [2009/05/29 21:43] – k2pateltuneup_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.
  
-<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)