Differences

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

--- tuneup_guide [2009/03/07 23:14] – created 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.
-<code mysql>
+<code sql>
 mysqlcheck -u root --auto-repair --check --optimize --all-databases -p
 </code>
@@ Line 17: / Line 17: @@
 <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>
@@ Line 34: / Line 34: @@
 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.
+==== 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.