MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries.You can check the same tips from here.Here is very useful tips for all mysql DBA's,Developers these tips are noted from MySQL Camp 2006 suggested by mysql community experts.Kaj (Most Excellent Obvious Facilitator) Index stuff. Ronald Don't Index Everything Use benchmarking Minimize traffic by fetching only what you need. Paging/chunked data retrieval to limit Don't use SELECT * Be wary of lots of small quick queries if a longer query can be more efficient Use EXPLAIN to profile the query execution plan Use Slow Query Log (always have it on!) Don't use DISTINCT when you have or could use GROUP BY Use proper data partitions...
