Re: MYSQL CLIENT PROBLEM

[Krishna Chandra Prajapati]

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.

Re: MYSQL CLIENT PROBLEM

[Baron Schwartz]

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.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MYSQL CLIENT PROBLEM

[Krishna Chandra Prajapati]

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 case happens many time.
Is there is any bug in mysql-client 5.0.15

Thanks,
Krishna

MySql client problem

[linux]

Dear Sir,

I have a Red-hat Linux6.2 . And i have installed MySql -3.23.32 server. It installed 
successfully. now when go to install MySql-3.23.32.rpm it doesn`t install, same for 
MySql-devel-2.32.32 it also doesn`t install.
And also tell em how to Uninstalled .rpm.

Pls reply me asap.

Regards,
Linus.