User Tools

Site Tools


tuneup_guide

Differences

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

Link to this comparison view

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>​
tuneup_guide.txt ยท Last modified: 2020/08/10 02:35 (external edit)