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 a tinyint in mysql?
How to include numeric values in sql statements?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
What do we use to remove duplicate records while fetching a data in mysql ?
Is oracle mysql free?
Can we store files in mysql?
How to include character strings in sql statements?
What is current version of mysql?
How to create a test table in your mysql server?
How to check if value already exists in mysql database in php?
How do I restore a database in mysql workbench?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
How to write date and time literals?
How can I see mysql database?
How do you create a primary key?
