Open streams: 0
Alarm status:
Active alarms: 265
Max used alarms: 279
Next alarm time: 28789
sh-3.2#
From:
mos [EMAIL PROTECTED]
To:
mysql@lists.mysql.com
Date:
26.06.2008 22:52
Subject:
Re: Performance problem with more than 500 concurrent queries
At 10:39 AM 6/26/2008, you
:
26.06.2008 22:52
Subject:
Re: Performance problem with more than 500 concurrent queries
At 10:39 AM 6/26/2008, you wrote:
Hello,
thanks for the answer.
Where is the error.log stored? I run the mysqladmin, it requires the
password and it exits immediately. But I cannot find any error.log
:
Re: Performance problem with more than 500 concurrent queries
Hi,
Could try your script with the key_buffer set to 0 ?
Regards,
Jocelyn Fournier
[EMAIL PROTECTED] a écrit :
Hello,
Thanks for you help. You can see the results in the .err file below.
I've
run it twice while the algorithm
do this
mysqladmin -uroot -p debug
and check the error.log, see if there are any locks on the tables.
On 6/26/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello guys,
I am new to this list and also kind of new to mysql too.
I have a multi-thread application written in Ruby. The
:30
Subject:
Re: Performance problem with more than 500 concurrent queries
do this
mysqladmin -uroot -p debug
and check the error.log, see if there are any locks on the tables.
On 6/26/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hello guys,
I am new to this list and also kind of new
Sorry about the long signature in the email. I forgot to remove it...
Guillermo
From:
[EMAIL PROTECTED]
To:
mysql@lists.mysql.com
Date:
26.06.2008 17:39
Subject:
Re: Performance problem with more than 500 concurrent queries
Hello,
thanks for the answer.
Where is the error.log stored? I
:39
Subject:
Re: Performance problem with more than 500 concurrent queries
Hello,
thanks for the answer.
Where is the error.log stored? I run the mysqladmin, it requires the
password and it exits immediately. But I cannot find any error.log.
Thanks,
Guillermo
---
Guillermo Acilu
At 10:39 AM 6/26/2008, you wrote:
Hello,
thanks for the answer.
Where is the error.log stored? I run the mysqladmin, it requires the
password and it exits immediately. But I cannot find any error.log.
Thanks,
Guillermo
Guillermo,
Look in the \MySQL\Data\*.err file.
Also I don't
17:34
CC: mysql@lists.mysql.com
Asunto: RE: Performance problem
On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda
[EMAIL PROTECTED] wrote:
im new on the performance tuning of this database (MySQL 5.0.45,
rpm-based installation), and i have one performance problem on our
new
I`ve resolved my problems without hardware manipulation.
Thanks to all.
-Mensaje original-
De: Francisco Rodrigo Cortinas Maseda
Enviado el: miércoles 16 de abril de 2008 18:57
Para: mysql@lists.mysql.com
Asunto: RV: Performance problem
Hi all,
im new on the performance tuning of
On Fri, 18 Apr 2008, Francisco Rodrigo Cortinas Maseda
[EMAIL PROTECTED] wrote:
im new on the performance tuning of this database (MySQL 5.0.45,
rpm-based installation), and i have one performance problem on our
new installation:
...
We are experiencing problems about the performance of
Gunnar,
You might do some more investigating on these to see if there is an
index you could use to speed these up, 15.8 million records might be a
full table scan, even if it's not - it's clearly a whole heck of a lot
of data and that's going to give you a huge performance hit. I'm not
Thank you Erik!
HDs are OK, a couple of GB free. Not that it's a lot, but I can't imagine
it being too low for MySQL..
I'm aware memory is a bit low, but RAMBUS chips are hard to come by. They
don't have them in stock anywhere anymore. Also they are quite expensive.
It's almost like you could've
Thank you Erik!
HDs are OK, a couple of GB free. Not that it's a lot, but I can't imagine
it being too low for MySQL..
I'm aware memory is a bit low, but RAMBUS chips are hard to come by. They
don't have them in stock anywhere anymore. Also they are quite expensive.
It's almost like you could've
At 6:47a -0500 on 08 Jan 2008, Gunnar R. wrote:
Concerning slow queries, it seems there's a couple of different queries
that's being logged.
I haven't tried it yet, but this recently went by on debaday.debian.net:
mytop: a top clone for MySQL
At 3:51p -0500 onGunnar R. wrote, On 01/08/2008 03:51 PM:
That tool tells me 100% of the data is read from memory, not a byte from
disk... would there still be any point in getting more memory?
Any suggestions to where to go from here?
I dunno. My hunch is that could do some query
Hi,
Thanks.
mysql show processlist;
++---+---+---+-+--+--+--+
| Id | User | Host | db| Command | Time
Hello,
Thanks. I read the document, but unfortunately it didn't tell me anything
new..
One of the things I am a bit confused about is:
top - 22:08:12 up 6 days, 7:23, 1 user, load average: 4.36, 3.30, 2.84
Tasks: 134 total, 1 running, 133 sleeping, 0 stopped, 0 zombie
Cpu0 : 61.3% us,
Gunnar,
us = user (things like MySQL/PHP/Apache)
sy = system (memory management / swap space / threading / kernel
processes and so on)
ni = nice (apps running only when nothing else needs the resource)
id = idle (extra cpu cycles being wasted)
wa = wait state (io wait for disk/network/memory)
Gunnar R. wrote:
I am thinking about buying a new dual core box (with IDE disks?), but
I have to make sure this really is a hardware issue before I spend
thousands of bucks.
I think you've got an application problem somewhere which you should
look into first. Hardware-wise I think you're
-Original Message-
From: Per Jessen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 02, 2008 7:51 AM
To: mysql@lists.mysql.com
Subject: Re: Performance problem - MySQL at 99.9% CPU
Gunnar R. wrote:
I am thinking about buying a new dual core box (with IDE disks?), but
I have
Hi,
If you can follow this document:
http://www.ufsdump.org/papers/uuasc-june-2006.pdf
You should be able to figure out what's happening.
Cheers,
Andrew
-Original Message-
From: Gunnar R. [mailto:[EMAIL PROTECTED]
Sent: Tue, 01 January 2008 23:31
To: mysql@lists.mysql.com
Subject:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I've learned a bit about the environment this server is running in. It's
VMware with root NFS and storage NFS mount points for MySQL. I've been
told the throughput over NFS for my Server is from 20 to 30 MB/s.
The server has 3GB ram. I'm not
Hi,
On Jan 1, 2008 6:31 PM, Gunnar R. [EMAIL PROTECTED] wrote:
Hello,
I am running a community site mainly based on phpBB. It has about 9.300
registered users, 650.000 posts and about 200.000 visitors/month (12 mill
hits). The SQL database is about 700MB.
It's all running on a couple of
Hi, please monitor what happened with mysql
show processlist
show innodb status
and also ps aux
because maybe some application makes your mysql busy
On Jan 2, 2008 7:31 AM, Gunnar R. [EMAIL PROTECTED] wrote:
Hello,
I am running a community site mainly based on phpBB. It has about 9.300
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
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
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;
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
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
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
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.
Server:
Jim Tyrrell wrote:
Everyone,
I finally feel let down by mysql after 5 years of
great use. I break most things in weeks so this is a
heck of a record. I am sure I am being a dummy on
this, but
am wondering if there is some setting somewhere to
help out a query like this.
Given a table like
What?
Please post in english.
Marco Baar wrote:
Hallo,
Ich benutze mysql seit 2 Jahren. Inzwischen haben sich 50MB Nutzdaten
angesammeln und hab ein Problem mit der Performance während der Abfrage
meiner Haupttabelle.
Die Tabelle hat ca 200.000 Datensätze und ich mache im verhältnis zu
Pereira [mailto:[EMAIL PROTECTED]
Sent: 29 September 2005 11:24
To: Marco Baar
Cc: mysql@lists.mysql.com
Subject: Re: Performance problem
What?
Please post in english.
Marco Baar wrote:
Hallo,
Ich benutze mysql seit 2 Jahren. Inzwischen haben sich 50MB Nutzdaten
angesammeln und hab
Hi Marco, all,
this list uses English - I will translate the main points only:
Marco Baar wrote:
Hallo,
Ich benutze mysql seit 2 Jahren. Inzwischen haben sich 50MB Nutzdaten
angesammeln und hab ein Problem mit der Performance während der Abfrage
meiner Haupttabelle.
| Using MySQL for 2 years
: Nuno Pereira [EMAIL PROTECTED]
An: Marco Baar [EMAIL PROTECTED]
Kopie: mysql@lists.mysql.com
Betreff: Re: Performance problem
Datum: Thu, 29 Sep 2005 11:24:00 +0100
What?
Please post in english.
Marco Baar wrote:
Hallo,
Ich benutze mysql seit 2 Jahren. Inzwischen haben sich 50MB Nutzdaten
I must assume you have all the proper indexes setup and your
configuration variables are fairly optimal.
First, I would run just the select part with an explain in front of it
to see what MySQL is trying to do. I've had MySQL run a query for an
inordinate amount of time on a fairly small data
Can you supply us with an example? Some explain plans to corroborate your
reported slowness.
-Original Message-
From: Andrey Chernyh
To: [EMAIL PROTECTED]
Sent: 3/9/04 3:35 AM
Subject: Performance problem with 4.0.18
Hello All!
After we converted our tables from MyISAM to InnoDB the
- Original Message -
From: Ronan Lucio [EMAIL PROTECTED]
Here it is a slowly query, it take about 15 seconds:
SELECT f.dtrelease AS fdtrelease, f.cod AS fcod, f.title AS title,
vf.price AS vfprice, vf.cod AS vfcod
FROM film AS f, rent_film AS r, film_format AS ff,
Mike,
Ronan,
You haven't given us much to go on.
I´m sorry.
Is this application running on a web server?
Yes, but in a diferent machine connecting via TCP/IP.
1) How many rows are your queries returning? (on average) and how long
does
it take?
Hmmm... Most of the queries are
Mike,
Ronan,
If your queries are only returning fewer than a hundred rows, and
if every join is indexed, I would have expected it to take only a second
or
two at most.
I´m sorry, but I´m not so good in SQL queries, rather joins.
If my queries are taking about 15 seconds instead of
Ronan,
If your queries are only returning fewer than a hundred rows, and
if every join is indexed, I would have expected it to take only a second or
two at most.
Have you put Explain in the front of the query to see if it is
using an index on all the joins?
Your ( (
At 02:33 PM 1/30/2004, you wrote:
Hi,
I´m having a serious performance problem with my MySQL.
The CPU is most of time with a load of 60%-95%.
I´m using MySQL-4.0.14 on a FreeBSD-5.1 box.
It´s a Celeron-2.0 Ghz - 512 Mb RAM - 40 Gb of Hard Disk.
I think the main problem the queries struct wrongly
Angela Olmeijer escribió:
Hi there!
I encountered a performance problem when I switched from a Win2000
machine to a WinXP machine to access MySQL via a MS Access (XP)
Front-end.
Simple queries take 20 times more time to appear on screen.
Here's a rundown of hard-/software.
Windows 2000
Peter Zuidema wrote:
Please help,
We have big performance problems.
This is the situation:
We haven an Windows NT server with a P355 processor and 256MB Ram. We have
installed version 3.49 of mysql
(we have also tried version 3.52).
When we do a select on a table which contains about
On Thu, 24 Oct 2002, Peter Zuidema wrote:
Please help,
We have big performance problems.
This is the situation:
We haven an Windows NT server with a P355 processor and 256MB Ram. We have
installed version 3.49 of mysql
(we have also tried version 3.52).
When we do a select on a table
a.RelatieID
1
-Original Message-
From: Thomas Spahni [mailto:tsp;lawbiz.ch]
Sent: donderdag 24 oktober 2002 17:44
To: Peter Zuidema
Cc: Mysql
Subject: Re: Performance problem
On Thu, 24 Oct 2002, Peter Zuidema wrote:
Please help,
We have big performance problems
Guilherme wrote:
I have 3 tables tableA, tableB and tableC and the fields tableA.id,
tableB.idA and tableC.idA.
I'm using this query (bellow) to call information from the database that has
in tableA but tableA.id is not found on tableB.idA and tableC.idA.
SELECT tableA.*
FROM tableA
Guilherme,
Thursday, July 25, 2002, 4:18:13 AM, you wrote:
G I have 3 tables tableA, tableB and tableC and the fields tableA.id,
G tableB.idA and tableC.idA.
G I'm using this query (bellow) to call information from the database that has
G in tableA but tableA.id is not found on tableB.idA and
PROTECTED]
Subject: Re: Performance Problem - LEFT JOIN
Guilherme wrote:
I have 3 tables tableA, tableB and tableC and the fields tableA.id,
tableB.idA and tableC.idA.
I'm using this query (bellow) to call information from the database that has
in tableA but tableA.id is not found on tableB.idA
51 matches
Mail list logo