Hi,
I'm having a strange problem with table locking. I have written a stored
procedure that only accesses a single table. Before executing the
procedure, I'm trying to lock the table in question for writing. The
LOCK TABLE command succeeds, but when I execute the stored procedure it
tells me
TECTED]
> Sent: Wednesday, December 01, 2004 11:22 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Table Locking Problem? Very Slow MyISAM DB - PLS HELP!
>
>
> >The reason I ask is because eight select statements should not bog down a
> >production serve
When the server begins to slow down, what does top reveal?
Andrew Nelson wrote:
The reason I ask is because eight select statements should not bog
down a production server. On the MySQL side, is anything being
written to the slow query log? On the application side is there any
virus scanning or
The reason I ask is because eight select statements should not bog down a
production server. On the MySQL side, is anything being written to the slow
query log? On the application side is there any virus scanning or similar
activity being performed? Does iostat show any heavy reading or writing
The reason I ask is because eight select statements should not bog down
a production server. On the MySQL side, is anything being written to the
slow query log? On the application side is there any virus scanning or
similar activity being performed? Does iostat show any heavy reading or
writing
Hi Victor,
How did you deduce that the database server is the bottleneck? Are all your
processes running on the same machine?
Because 'ps -aux' shows it running at 94% of the CPU and when I
stop/start the mysql server, it seems to be ok again for another
hour.
Any ideas?
Andrew Nelson wrote:
Hi
Hi,
I have a MySQL 3.23.55 server managing accounts on my exim mail server..
The table type on all tables MyISAM.. I have the MTA performing various
queries
for each incoming email - determining mail aliases, vacation messages and
filtering rules etc but they're all pretty much SELECT statements
How did you deduce that the database server is the bottleneck? Are all
your processes running on the same machine?
Andrew Nelson wrote:
Hi,
I have a MySQL 3.23.55 server managing accounts on my exim mail server..
The table type on all tables MyISAM.. I have the MTA performing
various queries
fo
I recently migrated a myisam database to a dual processor AMD Opteron
(see specs below) host and found that tables would sporadically lock and
not release and so all subsequent inserts would be blocked. In this
state, I was unable to nicely restart the server. It would simply give
up. Repairing
MezzIndex.ID, MezzIndex.Title
- Original Message -
From: "Andrius Armonas" <[EMAIL PROTECTED]>
To: "Johan Wahlström" <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 6:19 AM
Subject: Re: locking problem!
> if you're using write lock and do not unlock
I have problem with table lockings scince i upgraded the MySQL version, and i have
tried with
both RedHat 7.1 rpm version 2.23.36 and compile myself with 2.23.39. The result is the
same.
As can be seen in the "screenshot" below there is one process running, and a lot
sleeping. In
this example
- Original Message -
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 11:56 AM
Subject: Re: Strange locking problem disrupting operation
> > Then we encountered a strange behaivour:
>
> Now this is a surprise! It seems I have experienced something
> similar for a long ti
- Original Message -
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 11:56 AM
Subject: Re: Strange locking problem disrupting operation
> > Then we encountered a strange behaivour:
>
> Now this is a surprise! It seems I have experienced something
> similar for a long ti
Sie schrieben am Freitag, 13. Juli 2001, 11:51:37:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
> database,sql,query,table
> If you just reply to th
Hello everyone!
we recently upgraded from 2.23.27 to 2.23.39, and in the same time changed machine
from a p3-666, 512MB, ide to a dual p3 550, 896MB, scsi. The platform is Linux. As
expected
we got a enourmous increase in database speed. Then we encountered a strange behaivour:
Suddenly MySQL s
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
16 matches
Mail list logo
