Hi Baron, The answers are as below I have not upgraded the server. Done tuning on my.cnf on innodb parameters. No i have not change the storage engine from MYISAM to INNODB
Regards, Krishna On 9/28/07, Baron Schwartz <[EMAIL PROTECTED]> wrote: > > Krishna Chandra Prajapati wrote: > > Hi All, > > > > I am using mysql-client 5.0.15 on fedora system. Server is a Debian box > with > > mysql 5.0.32 > > After getting connected to the server(192.168.1.7) using the command > below > > mysql -h 192.168.1.7 -D dip -u dip -p > > > > When a record deleted from a table on server (192.168.1.7) Then that > changes > > are not reflected on the client session. If i log out and then reconnect > to > > server then the changes are reflected. Earlier it was working fine. > > This is not a bug in the client. It sounds like you are seeing the > effects of REPEATABLE READ transaction isolation level. Did you upgrade > the server or reconfigure it? Did you change your storage engine from > MyISAM to InnoDB? > > The next time this happens, try running COMMIT and then run the SELECT > again. Do you see the changed data? If so, it's the transaction > isolation level. >