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 the use of mysql workbench?
List data types in mysql? Explain
What are enums used for in mysql?
Does mysql support sequence?
What is the current root password of mysql?
Explain csv tables.
what is the procedure to configure the application of mysql?
What is mysqli_connect_error ()?
How to make a column bigger and delete unique from table.
What is row level locking in mysql?
What is mysql used for?
What is the difference between timestamp and datetime in mysql?
What does blob mean in mysql?
Is mysqli faster than mysql?
What is mysqlcheck do?
