Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

2005-01-17 Thread Heikki Tuuri
t; Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Lähetetty: Monday, January 17, 2005 11:11 AM Aihe: Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections Thank you all for the hints. What will be then the best solution to always get the latest data?

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

2005-01-15 Thread Heikki Tuuri
://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: "Jose Antonio" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, January 15, 2005 1:34 AM Subject: Re: MySQL 4.1.8 & InnoDB: data

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

2005-01-14 Thread Jose Antonio
I'm doing the Commit so probably is the extra settings in the SQL. Could you please elaborate a bit more on that? Thank you in advance, Jose. Jeff Mathis escribió: simple answer is transactions. until you issue a commit, or otherwise specify extra settings in your SQL syntax, other connections d

Re: MySQL 4.1.8 & InnoDB: data unavailability among different connections

2005-01-14 Thread Jeff Mathis
simple answer is transactions. until you issue a commit, or otherwise specify extra settings in your SQL syntax, other connections do not see your data. Jose Antonio wrote: Hi! I am experiencing something weird using MySQL 4.1.8 with InnoDB tables. I have an application, let's call it A, that is

MySQL 4.1.8 & InnoDB: data unavailability among different connections

2005-01-14 Thread Jose Antonio
Hi! I am experiencing something weird using MySQL 4.1.8 with InnoDB tables. I have an application, let's call it A, that is monitoring the data that is available in the database. The data is inserted in the database by a different application, let's call it B. The problem is the following: A star