Mysql optimization

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I have table with 7 millions of records , i want to know if some one
can help top optimize the select requests, i created the necessary
indexex but some specific requests still slow.


Re: Mysql optimization

Quoted text here. Click to load it

You can't optimize a table without knowing its structure and without
knowing the specific queries that you're having problems with.

Include that info with your question.

Try using EXPLAIN SELECT ... to see if it's actually using the
indexes you created.

                        Gordon L. Burditt

Re: Mysql optimization

He want the answers like  +Ram , +HD.....

Quoted text here. Click to load it

Site Timeline