How can you do the fine tunning?

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

More MySQL Interview Questions

What are the common mysql functions?

0 Answers  


What is mysql url?

0 Answers  


How will show all records containing the name "sonia" and the phone number '9876543210'

0 Answers  


How can I change database in mysql?

0 Answers  


What is the difference between timestamp and datetime in mysql?

0 Answers  






How to rename an existing column in a table?

0 Answers  


What is pdo mysql?

0 Answers  


Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

0 Answers  


What are the mysql database files stored in system ?

0 Answers  


Have you ever used MySQL Administrator and MySQL Query Browser? Describe the tasks you accomplished with these tools?

1 Answers   TCS,


What is ISAM?

0 Answers  


What are date and time functions in mysql?

0 Answers  


Categories