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 do I know if mysql is installed on windows?
How do I disconnect mysql workbench?
How would you get the current date in mysql?
What is blob and clob?
How to include numeric values in sql statements?
What is an example of a delimiter?
What are the advantages of myisam over innodb?
Write a query to create a database and a table?
What is flush privileges in mysql?
Which storage engine is best in mysql?
Why to use char instead of varchar in the database?
What are the types of database engines available in mysql?
How do I download a mysql community server?
what is the procedure to configure the application of mysql?
How many mysql connections can handle?
