Re: Append function no longer works on a table

[John Sawyer]

Hi Javier

thanks for the speedy response.

There are no triggers that should be interfering with the table, which I created only last week. The table itself is very simple. It is an historic stock price table for approx 200 stocks with 6 columns, two of which are composite primary keys (date and stock_ticker). The daily price information extends back approx 25 years so the combined rows amount to around 750k so far. Each new stock repesents an append of approx 6k rows. Even when I do a test append of only one row, the function still gives me the timeout error message.


I have looked at the server file log in the MySQL workbench I can't see anything that means much to me beyond a couple of disabled messages (see below) which hopefully may mean more to you.

[note]Plugin ‘FEDERATED’ is disabled.
InnoDB: The InnoDB memory heap is disabled
InnoDB: Highest supported format is Barracuda

regards

John