How can you do the fine tunning?

Question Posted / prasadhari_m@yahoo.com

3 Answers
4896 Views
ACC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can you do the fine tunning?..

Answer / subeeshbabu v

Fine tuning is mostly done for the SELECT statements.
Use the Keyword EXPLAIN in front Of your SELECT Statement.

eg: EXPLAIN SELECT t1.id, t2.id FROM table1 AS t1 INNER JOIN
TABLE2 AS t2 ON .....;
The result will be like this
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
| id | select_type | table | type | possible_keys |
key | key_len | ref | rows | Extra |
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
| 1 | SIMPLE | table1 | ref | t1 |
t1 | 4 | const | 2 | Using where |
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
1 row in set (0.00 sec)

if the "ref" column value is found to be ALL, then the two
tables must be joined properly. if the "Extra" gives values
like
Using temporary; Using filesort then the columns in the
JOIN conditions and WHERE clause must be indexed properly.
By doing this we can make our queries executing faster.

Is This Answer Correct ?

2 Yes

0 No

How can you do the fine tunning?..

Answer / salil

Other than using Explain to improve the sql by adding index.
we can also do some server side change to help improve MySQL
query performance.
You can enable slow_query_log to find out queries taking
long time and uses explain on those to fix it.

Add query_cache_size = 16M
This will cache the query result and return data fast on the
next request for the same query.

set key_buffers.

Is This Answer Correct ?

1 Yes

0 No

How can you do the fine tunning?..

Answer / shankri

If ur Television was not working means we have to do the
fine tuning.
Step 1:Take the Remote
Step2:Go the menu Control OR Program
Step3: In Menu Control Or program u will see fine Tunning
Step4:Change the status of the arrow in fine tunning
Step5:if the Television still not working means
Step6: Take ur Television and go to beach. Jump into the sea
along with ur Television

Is This Answer Correct ?

1 Yes

4 No

Post New Answer