Answer Posted / 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 |
Post New Answer View All Answers
How to delete a database from mysql server.
How do I create a mysql username and password?
What does mysql_fetch_assoc do?
What is required to create mysql database?
How many rows can mysql hold?
What is row?
What is delimiter in mysql trigger?
What are the applications required to support mysql?
What is mysqli_select_db?
How do I save in mysql?
What is mysql port?
How to create trigger in mysql phpmyadmin?
How do I start mysql in linux?
What is pdo in mysql?
How do I find users in mysql?
