Re: MYSQL CLIENT PROBLEM

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 <baron@xaprb.com> 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.
>
Received on Mon Oct 1 03:55:19 2007