1 SBus 25 3 SUNW,fas/sd (block)
> >
> > 1 SBus 2513 SUNW,socal/sf (scsi-3)
> > 501-3060
> >
> >No failures found in System
> >===
> >
> >No System Faults found
> >==
> &
r 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
> - Or
- 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
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 ho
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 Lock_tim
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
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
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
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:
> 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
> an
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
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,
> i
Henning Schroeder wrote:
> idea? And how am I supposed to find the slow queries?
Use EXPLAIN SELECT ...
http://www.mysql.com/doc/E/X/EXPLAIN.html
Also, if you run 'mysqladmin processlist' if you see a 'copying into temp table' that
lasts a
while (e.g run mysqladmin multiple times and see if it
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
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
> a
From: "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 no
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
packag
17 matches
Mail list logo