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
> application makes JDBC calls to mys
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
I can't help you with your problem, because I have almost the same thing
happening to my server every 2-3 days. It is exactly as you described
Please someone offer us suggestions??
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: "He
14 matches
Mail list logo
