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.