Mysql InnoDB PHP result problem

[josys64]

i have a strange problem :
MySQL 4.0.21 innodb and php 4.3.9-1
all tables are in innodb type.

For a simple select statement sometimes i get result and sometimes
nothing (i.e mysql_num_rows( )>0 or mysql_num_rows( )==0). It's a random
behaviour.
If my table is MyISAM type no problem.

If someone have an idea ?

[Heikki Tuuri]

Re: Mysql InnoDB PHP result problem

Hi!

Could this:

http://dev.mysql.com/doc/mysql/en/innodb-consistent-read-example.html

explain it?

Regards,

Heikki

"josys64" <josys64@hotmai l.com> kirjoitti
viestissä:3682b efd.0502090704. 3f02b647@postin g.google.com...[color=blue]
>i have a strange problem :
> MySQL 4.0.21 innodb and php 4.3.9-1
> all tables are in innodb type.
>
> For a simple select statement sometimes i get result and sometimes
> nothing (i.e mysql_num_rows( )>0 or mysql_num_rows( )==0). It's a random
> behaviour.
> If my table is MyISAM type no problem.
>
> If someone have an idea ?[/color]