MySQL Forums
Forum List  »  PHP

MyISAM & InnoDB buffering
Posted by: Alan Cameron
Date: October 29, 2016 02:09PM

I am starting to learn about MySQL and have come across a problem which has me puzzled.
I am trying to insert a record into a table using PHP PDO and keep getting a duplicate index violation. I think this is because after the first attempt when successful the index entries are being buffered in storage and even if I manually delete the record entered they are there when I try again.
I am trying to read the MySQL Reference manual for my version 5.7.11 but it is difficult know where to look for confirmation of my diagnosis.

If I am correct then the tests that I am doing are not representative of a condition which might occur in a reality.

I would like confirmation that my diagnosis is correct.

If this I the case is there a way to flush the buffers between my tests?
Applies to MyISAM and InnoDB

Options: ReplyQuote


Subject
Written By
Posted
MyISAM & InnoDB buffering
October 29, 2016 02:09PM
October 29, 2016 08:40PM
October 30, 2016 05:21PM
November 01, 2016 01:10PM


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.