- Original Message -
From: Supriya Shiyekar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 10:59 PM
Subject: MySql performance problem
Hi,
We are having strange performance problem with mysql on Solaris.Our
application makes JDBC calls to mysql
===
No System Faults found
==
Thanks for the help,
Supriya.
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
To: Supriya Shiyekar [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, August 28, 2002 7:02 AM
Subject: Re: MySql performance problem
- Original
, August 28, 2002 7:02 AM
Subject: Re: MySql performance problem
- Original Message -
From: Supriya Shiyekar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 10:59 PM
Subject: MySql performance problem
Hi,
We are having strange performance
Hi,
We are having strange performance problem with mysql on Solaris.Our
application makes JDBC calls to mysql database which resides locally on the
machine.
It takes 3 minutes to execute a piece of code(which involves select,
insert and update queries) on a Windows machine but an
Hello,
it´s me again. For the new readers: mysql 3.23.41, ~50q/s, load jumps to 200.
If have been experimenting with the slow log to find out about these slow
queries that are apparently locking too long. Much to my horror, I have
lots of queries of this type popping up:
# Time: 21
On Thu, Sep 06, 2001 at 05:26:53PM +0200, Henning Schroeder wrote:
Find all the queries that interact with this table. EXPLAIN them. Time them.
*all* of them? there are lots.
Well, perhaps not initially but you may want to have EXPLAINed a majority
of the queries that are issued against
On Thu, Sep 06, 2001 at 12:02:07AM +0200, Henning Schroeder wrote:
All the updates to the table are of the style described above (one to three
colums changed, row indexed by primary key). Well, with SELECTs it´s a
different story: many queries join in different ways to the table. FYI,
it´s
hi wesley and the gang,
thank you very much for your help so far. i optimized the indexes and added
another one i obviously forgot before, and the database is smoother now. a
bit at least, it now maxes out at 65q/s instead of 50...
At 13:12 06.09.01, you wrote:
idea? And how am I supposed
Henning Schroeder wrote:
i also tried logging the queries that appear often with copying to temp
table status and now have a nice set of them, though i don´t quite
understand *why* the are copying. below are two:
(the rows count is *way* to high, probably because the timestamps are
ancient
At 17:52 06.09.01, you wrote:
It is copying ALL of the results into the temp table. If you can (e.g.
you know you will
never want more than N records), add a LIMIT 0,N to the end of the SELECT
so that when you
have an old timestamp it will not hang the database.
as i use
select count (*)
Henning Schroeder wrote:
At 17:52 06.09.01, you wrote:
It is copying ALL of the results into the temp table. If you can (e.g.
you know you will
never want more than N records), add a LIMIT 0,N to the end of the SELECT
so that when you
have an old timestamp it will not hang the database.
The queries were...
select * from cookies left join users on cookies.uid=users.uid left join
sessions on users.uid=sessions.uid where
cookies.cookie=e3bd03382561eb3619b66fbea2af217d;
select * from cookies left join users on cookies.uid=users.uid left join
extended on
Hi!
I am trying to understand and fix a severe performance problem I am having
with MySQL for some weeks now, but to no avail. So I am coming here, hoping
you understand more than I do (which is not very hard to do :-)
Im am running mysql 3.23.41 (from the mysql-server-3.23.41-1 debian
: Henning Schroeder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 05, 2001 5:10 PM
Subject: MySQL Performance Problem
Hi!
I am trying to understand and fix a severe performance problem I am having
with MySQL for some weeks now, but to no avail. So I am coming here,
hoping
you
On Wed, Sep 05, 2001 at 11:10:49PM +0200, Henning Schroeder wrote:
Looking in the process table reveals (when the page is fast) lots of
sleeping processes, sometimes (when the page is slow -- 30sec to load a web
page) lots (20+) processes that are locked. Usually they are some SELECTs
and
Hi,
Looking in the process table reveals (when the page is fast) lots of
sleeping processes, sometimes (when the page is slow -- 30sec to load a
web
page) lots (20+) processes that are locked. Usually they are some SELECTs
and UPDATEswaiting for a single table that is the most update
16 matches
Mail list logo