DB I found my problem and why Mysql lock my table for a select. In
DB fact, mysql sometimes don't use the right index and so does a 'Table
DB sort' that lock my table. I modify the query to add USE INDEX
DB clause and now, all seems to work well ... I just need to test
DB during several days
DBI still have performance problem with my big MyISAM table.
DBIn fact, mysql keep locking my table, even for doing select :(
PDB That's how MyISAM works -- it uses table locks for everything.
PDB Given that fact, if it didn't lock the table for reading, that would
PDB allow other clients to
On Tue, Sep 24, 2002 at 10:36:31AM +0200, David Bordas wrote:
DBI still have performance problem with my big MyISAM table.
DBIn fact, mysql keep locking my table, even for doing select :(
PDB That's how MyISAM works -- it uses table locks for everything.
PDB Given that fact, if it didn't
Hi list,
I still have performance problem with my big MyISAM table.
In fact, mysql keep locking my table, even for doing select :(
I don't know why but it's very very annoying.
1% of my query are search ones.
Theses queries are slow, too slow.
So i'm thinking about splitting my table to lot of
At 9:35 +0200 9/23/02, David Bordas wrote:
Hi list,
I still have performance problem with my big MyISAM table.
In fact, mysql keep locking my table, even for doing select :(
That's how MyISAM works -- it uses table locks for everything.
Given that fact, if it didn't lock the table for reading,