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
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
How do I connect to a mysql database?
What are the mysql database files stored in system ?
How to use case expression?
How many tables we can create in mysql database?
What is the datatype for password in mysql?
Why should I use mysql?
Can you shard mysql?
How do I stop a query in mysql workbench?
Explain triggers and stored procedures?
How to represent ENUMs and SETs internally?
can you elaborate on blob and text in mysql? : Mysql dba
How do I check mysql version?
How do I truncate all tables in mysql?
Does mysql need a server?
