Re: MySql performance problem

2002-08-28 Thread Mark Matthews
- 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

Re: MySql performance problem

2002-08-28 Thread Supriya Shiyekar
=== 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

Re: MySql performance problem

2002-08-28 Thread Supriya Shiyekar
, 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

MySql performance problem

2002-08-27 Thread Supriya Shiyekar
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

Mysql Performance Problem with updates, bug?

2001-09-11 Thread Henning Schroeder
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

Re: MySQL Performance Problem

2001-09-10 Thread Wesley Darlington
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

Re: MySQL Performance Problem

2001-09-06 Thread Wesley Darlington
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

Re: MySQL Performance Problem

2001-09-06 Thread Henning Schroeder
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

Re: MySQL Performance Problem

2001-09-06 Thread Adams, Bill TQO
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

Re: MySQL Performance Problem

2001-09-06 Thread Henning Schroeder
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 (*)

Re: MySQL Performance Problem

2001-09-06 Thread Adams, Bill TQO
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.

Re: MySQL Performance Problem

2001-09-06 Thread Kyle Hayes
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

MySQL Performance Problem

2001-09-05 Thread Henning Schroeder
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

Re: MySQL Performance Problem

2001-09-05 Thread Ryan Shrout
: 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

Re: MySQL Performance Problem

2001-09-05 Thread Wesley Darlington
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

Re: MySQL Performance Problem

2001-09-05 Thread Henning Schroeder
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