Re: Append function no longer works on a table
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
Subject
Views
Written By
Posted
2576
July 18, 2013 04:49AM
1185
July 18, 2013 09:48AM
Re: Append function no longer works on a table
1234
July 18, 2013 04:04PM
1228
July 22, 2013 03:53PM
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.