Transaction end well but not refresh data

hi!

I have a database with INNODB tables.

My program have five clients and when, to the end of the day, they do a b=
ig
transaction, the result not is show, but the transaction end correctly.

It work fine to the begin of the day, but, the same transaction, when the=

database has been working all the day, don?t show the correct data and th=
e
database do not return any error.

database: 4.0.23
tables: InnoDB
ODBC: the last
programs: Visual Basic

Server is not dedicated, but have low use.
I have incremented the buffer pool size and mem pool size but is the same=
..

Some idea?

Homerman



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Transaction end well but not refresh data

Try "FLUSH TABLES"


On Thu, 3 Mar 2005 21:10:24 +0100, homerman@ono.com wrote:
> hi!
>
> I have a database with INNODB tables.
>
> My program have five clients and when, to the end of the day, they do a big
> transaction, the result not is show, but the transaction end correctly.
>
> It work fine to the begin of the day, but, the same transaction, when the
> database has been working all the day, don?t show the correct data and the
> database do not return any error.
>
> database: 4.0.23
> tables: InnoDB
> ODBC: the last
> programs: Visual Basic
>
> Server is not dedicated, but have low use.
> I have incremented the buffer pool size and mem pool size but is the same.
>
> Some idea?
>
> Homerman
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=mauriciocperez@gmail.com
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org