On 7/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt r
On 7/6/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
How does the cpu power influence the speed of a query?
Sort is a cpu intensive process.
*Check if you are suffering from locks on the tables you look up.*
Also, was the table in the system where the queries are running faster
rebuilt r
Hello,
Explain where the Statement is very fast:
*** 1. row ***
table: Stuecke
type: ALL
possible_keys: PRIMARY,St_Autor
key: NULL
key_len: NULL
ref: NULL
rows: 694
Extra: Using where; Usin
Hi,
Run explain plan on both the machines and post the same.
~Alex
On 7/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldu
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
Please, mount your disks using "forcedirectio".
Regards,
Juan
On 7/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
I've a performance problem with our database:
Some select statements take about 20 seconds.
The same statements on an equal testmachine take less than 1 second.
Serve
does your test machine have the same data as your problem database.
Can you also please show the explain plan from both the machines.
On 7/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
I've a performance problem with our database:
Some select statements take about 20 seconds.
The
Hello,
I've a performance problem with our database:
Some select statements take about 20 seconds.
The same statements on an equal testmachine take less than 1 second.
Server: CPU: 2 x 440 MHz sparcv9
RAM: 2GB
(top: Memory: 2048M real, 931M free, 732M swap in use, 2839M swap fre
