MySQL Forums
Forum List  »  PHP

Re: Time-out problem
Posted by: Rick James
Date: June 06, 2014 09:15AM

Vinoth, please start a new thread. And please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
How much RAM do you have?

There are _many_ reasons why your SQL code might timeout; the performance forum is littered with hundreds of examples. Yours may not fit any of them, so let's look at your specifics.

Options: ReplyQuote


Subject
Written By
Posted
April 23, 2014 08:04AM
April 23, 2014 09:57AM
April 23, 2014 10:27AM
April 25, 2014 02:26PM
April 28, 2014 11:49AM
April 30, 2014 11:15AM
April 30, 2014 11:32AM
April 30, 2014 11:47AM
May 01, 2014 08:00AM
April 30, 2014 01:12PM
May 02, 2014 10:40AM
June 06, 2014 05:13AM
Re: Time-out problem
June 06, 2014 09:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.