Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is field in mysql?
Is mysql a nosql database?
How to enter boolean values in sql statements?
What is difference between oracle sql and mysql?
Write a program using the select statement, while loop.
What is the return type of mysqli_query?
What is mysql vs sql?
How to enable or disable a row of a table using MySQL in struts?
Do while loop in mysql procedure?
How many rows we can insert in a mysql table?
How do I backup mysql database on linux?
How do I select a database in mysql?
What is row level locking in mysql?
What, if a table has one column defined as TIMESTAMP?
What is database clustering in mysql?
