On Dec 12, 2007 2:03 AM, Oded Arbel <[EMAIL PROTECTED]> wrote: > > On Tue, 2007-12-11 at 18:00 +0200, ik wrote: > > Hello List, > > > > I have a weird problem with the above server using MySQL (4.1): > > You need to provide more information about MySQL - what engine your > tables are using, any replication or clustering taking place, etc'.
The table that is effected is InnoDB. I do not use clustering at all, and it happens on every restart of the system. > > > 1. Some tables on specific database are loosing the Auto Inc pointer, > > making it start from 0 every time there is a restart to the server > > itself. > > Can't see any reason for this to happen unless something actually resets > it (it can be done). Are you using NDB on these tables by any chance ? I first noticed it, after the server was taken down after adding it some PCI hardware, but when I researched it before, I did found earlier indications to that issue. I did made then update on the auto inc field to make it indicate the right value. And no, I do not use NDB. > > > 2. It seems that the MySQL server have a big delay (of a minute and > > sometimes more) between the time I update/delete records using a > > program (written in Java 1.6 and mysql connector), until the change is > > actually taking place. > > As I mentioned earlier, this is due to transaction isolation between multiple > users on the same table - the records are updated immediately (or at least > as soon as they are committed) but the user doing the select only sees it > after its own transaction completes. The "problem" is, that the select arrived after I already closed the connection back to the connection pool of Java. And it is set to auto commit. Another issue, is that this happens only on specific machine and after a restart of the machine, while prior to that, things acted as expected, so there must be something that changed, but I cant put my finger on what was changed. > > -- > Oded Ido -- http://ik.homelinux.org/ ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
