Hello.
Not enough information to make a suggestion. You have a very
old version. Upgrade it.
Jeff Schwartz <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 12 lines --]
>
> I'm running MySQL 4.0.14 and it's locking tables for everything including
> counti
I'm running MySQL 4.0.14 and it's locking tables for everything including
counting records and select statements. I don't use any lock statements.
Has anyone else encountered this? Any suggestions?
Thanks,
Jeff
__
Do You Yahoo!?
Tired of spam
Am I missing a configuration setting somewhere?
I have been working on a MySQL Max (3.23.52-max-nt) database running on W2K
Server.
I am using a MySQL client remotely over a VPN but unfortunately the client's
internet connection is severely overloaded and the connection dies on
occasion.
When th
>Description:
When running a select that will take a long time due to the "order by" at the
end mysql still keeps the table locked during the ordering.
After it gets the result set is should unlock the table during the ordering
phase
>How-To-Repeat:
Iss
Sorry I confused read lock with locks that prevent other threads to read.
This is what I meant :
I have web sites where there are periodic inserts (& deletes ) of many
new records generated by crawlers.
In order to reduce the # of queries I do compound operations like
INSERT VALUES(a),(b),(c
I have web sites where there are periodic inserts (& deletes ) of many
new records generated by crawlers.
In order to reduce the # of queries I do compound operations like
INSERT VALUES(a),(b),(c), and DELETE FROM table WHERE record_id IN
($LONG_ID_LIST).
At the same as these operations are
> (begins: http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/Mar.2000/1029.html )
By chance, this points me to an archive of this list. I already
looked for a hint at the trailer and on the website, but, as I
didn't find any, assumed that there wasn't any. Wouldn't it be
helpful to add links at bot
We are currently working with a table containing ~650MB of data in
700,000 rows. In attempting to select from this, we would typically find
long holdups with process states listed as creating temporary tables.
By using SQL_SMALL_RESULT we were able to greatly reduce the time taken
for select oper
roblem orrigonates).
>
>good luck,
>
>cheers,
>
>noel
>
>On Monday, July 09, 2001 6:59 PM, Patrick Premartin [SMTP:[EMAIL PROTECTED]]
>wrote:
>> >> I use Delphi 5 and MyODBC to access a MySQL database.
>> >>
>> >> In my program, I've
ss a MySQL database.
> >>
> >> In my program, I've sometimes a tables locked and I don't understand
why
> >! I am the only user on this database and I change records correctly (as
I
> >do it for other programs on other databases).
> >>
> >>
>> I use Delphi 5 and MyODBC to access a MySQL database.
>>
>> In my program, I've sometimes a tables locked and I don't understand why
>! I am the only user on this database and I change records correctly (as I
>do it for other programs on other databases).
>
Patrick Prémartin wrote:
> I use Delphi 5 and MyODBC to access a MySQL database.
>
> In my program, I've sometimes a tables locked and I don't understand why ! I am the
>only user on this database and I change records correctly (as I do it for other
>programs on ot
Hi
I use Delphi 5 and MyODBC to access a MySQL database.
In my program, I've sometimes a tables locked and I don't understand why ! I am the
only user on this database and I change records correctly (as I do it for other
programs on other databases).
Does somebody have this problem
13 matches
Mail list logo