>-Original Message-
>From: OKAN ARI [mailto:okan...@aribem.com]
>Sent: Monday, July 06, 2009 10:54 AM
>To: mysql@lists.mysql.com
>Subject: Dramatic performance problem
>
>Hi to every body, I am newbie for mysql lists. I have a mysql server
>with 2GB of ram and C
Hi to every body, I am newbie for mysql lists. I have a mysql server with 2GB
of ram and Core2Duo cpu. Until today mysql server had very acceptable
performance results. But today, server is very slow. No db change, no php code
change. But I can't find the reason of this slowness.
I am using MYS
ubject:
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
>
]>
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 wrote:
Hello,
thanks for the answer.
Where is the error.log stored? I run the mysqladmin, it requires the
password and it exits immediately.
Open files:20
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 querie
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
D]
> 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 run the mysqladmin, it requires the
> password
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
;
Cc:
mysql@lists.mysql.com
Date:
26.06.2008 16: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:
>
> He
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
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 application is
reading one table that has two columns (Father, Children). As you might
suspect, this is a tree. The fields are foreign keys to a second table,
but the sec
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 probl
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 abo
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
Hi all,
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:
- The radius servers (that are written on perl) we have are writing the auth
and acct log to one mysql database. The conn we have is
> It's possibly a DNS problem (reverse DNS exactly).
You know, I'm feeling a bit stupid here... That was indeed the problem,
as the new server hadn't been moved on DNS yet.
I put the IP address into the windows hosts file on the DB server, and
the problem cleared up immediately.
Thanks!
-Doug
It's possibly a DNS problem (reverse DNS exactly).
Best regards.
OK folks, I'm kind of stumped; looking into things a bit more, but
thought I'd hit the list and see if anyone had any suggestions for a
rock to look under, in case I'm missing it...
DB Server: Windows 2003, 8-way CPU, lots of RAM, MySQL 4.1.22-nt binary
from MySQL
Current Production web server: Li
On ons, januar 2, 2008, 13:07, Andrew Braithwaite wrote:
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, 0
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 optimizat
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
http://debaday.debian.net/2007/12/26/mytop-a-top-
4464 S 99.9 30.8 4200:25 mysqld
>>
>> How come the CPUs can have idle time even though mysqld is running at
>> 99.9%, AND there's a processor queue (4.36)?
>>
>> Cheers,
>>
>> Gunnar R.
>>
>> On ons, januar 2, 2008, 13:07, Andrew Braithwaite
4464 S 99.9 30.8 4200:25 mysqld
>>
>> How come the CPUs can have idle time even though mysqld is running at
>> 99.9%, AND there's a processor queue (4.36)?
>>
>> Cheers,
>>
>> Gunnar R.
>>
>> On ons, januar 2, 2008, 13:07, Andrew Braithwaite
mailto:[EMAIL PROTECTED]
Sent: Tue, 01 January 2008 23:31
To: mysql@lists.mysql.com
Subject: Performance problem - MySQL at 99.9% CPU
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&qu
ilto:[EMAIL PROTECTED]
> Sent: Tue, 01 January 2008 23:31
> To: mysql@lists.mysql.com
> Subject: Performance problem - MySQL at 99.9% CPU
>
> 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 v
Hi,
Thanks.
mysql> show processlist;
++---+---+---+-+--+--+--+
| Id | User | Host | db| Command | Time
-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 s
bject: Performance problem - MySQL at 99.9% CPU
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 years old
-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 h
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 d
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
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 co
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 years old Dell box with two P4 Xeon 1.7Ghz
CPUs, 1GB of RAMBUS memory
Hi,
I'm using phorum [1] and made some custom queries against their
database. My query looks like this:
SELECT
message_id, subject, datestamp, forum_id, thread
FROM
phorum_messages
WHERE
forum_id IN (1, 2, 3, 4) AND parent_id = 0 AND
thread != 0 AND status = 2 AND closed = 0
ORDER BY
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 ta
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
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
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 thi
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 this:
FeatureID is an au
Marco Baar wrote:
of cause your right.
hello
dear Nuno Pereira,
I use mysql since 2 years and collected about 50 MB user data. I ve got a
performance problem during selecting the main table. The table has about
200.000 rows and I make a simple select. I only select over 4 attributes
with
ySQL for 2 years now, having accumulated 50 MB of data,
| got a performance problem while querying my "main table".
Die Tabelle hat ca 200.000 Datensätze und ich mache im verhältnis zu anderen
Abfragen doch ein eher simplen select.
| Table has about 200,000 rows of data, "select&qu
: Nuno 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 mys
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 ander
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 anderen
Abfragen doch ein eher simplen select.
Ich selekt
Hello.
Sometimes, after an upgrade it is necessary to rebuild indexes
in the tables (I'm not sure if it always produces an error if
you haven't done it). In general - usual recommendations for
optimizing queries work in your case. Use the slow query log
to find slow queries. Check if indexes
Hi,
I host a big french website including forum (phpbb), search engine (mnogo),
album (smartor), blogs... around 780Mo in MySQL
Everything work fine with my old configuration :
- One SQL/mail server bi-Xeon, 2.6Ghz, 3Go :
FC4, MySQL 4.0, Postfix-Mysql, Courier-imap Mysql
- One front serve
I would increase your myisam_sort_buffer_size considerably just for
this operation. You've got your key_buffer set high, but your sort
buffer is comparatively low for creating a big index.
One way you can tell how far along the index is, is to look at how
quickly the index file is growing and
Hi.
I need to index about 300 million 20-byte records, but it takes
forever (it isn't finished yet, after almost 24 hours, so I don't have
actual numbers).
I'm using RHEL, kernel 2.6.9, Mysql 4.1.11, MyISAM table, on a dual
Xeon with 4GB RAM and IDE disks. I'm using the following values from
/my
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 s
I have been trying to run an fairly large INSERT into an
empty table joining two other tables now for several weeks and have not been
able to get the query to run to completion even when sub-seting the data into smaller
ranges.
I have tried this at MySQL releases 4.1.8a and 4.1.10a wit
Mysql 4.1.3
Windows XP SP1
All tables are InnoDB
The query (1):
select Product.id, LongAnswer.value, count(*)
from LongAnswer
inner join Answer on LongAnswer.answer=Answer.id
inner join QuestionDefinition on Answer.question=QuestionDefinition.id
inner join Survey on Answer.survey = Survey.id
inner
How fast is this query?
SELECT id
FROM msg_body
WHERE MATCH(body) AGAINST( 'WORD')
If it's fast , you may have to re-state your query so that you are not FT
searching and joining tables in the same statement. The optimizer can only
use 1 index at a time from any table. We may be running into a
Hi Fredrik,
a LEFT JOIN could be faster (I'm not sure, try it). And you don't have a
fulltext index on msg_header.list.
What about this?
SELECTmsg_header.bodyid, msg_header.id, msg_header.subject,
msg_header.mfrom, msg_header.date, msg_header.list
FROM msg_header
LEFT JOIN msg
Hi all,
I'm running a small mail archive and have a little problem with the
fulltext search performance.
I really appreciate any tips/design suggestions (even if it dont have to
do with the search problem ;) ).
Database schema:
mysql> describe msg_header;
+-+--+--+-+-
VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
I've made some experiments and can
VP> Can you supply us with an example? Some explain plans to corroborate your
VP> reported slowness.
Of course.
Here is the query.
It is big and ugly, I'm curently working on system optimization. But
why the same query is good at one machine and bad at another?
SELECT ...
FROM positionReports p
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
Hello All!
After we converted our tables from MyISAM to InnoDB the database
became very slow!
The same database on another machine on MySQL 3.23.58 works very good.
The machines are identical, my.cnf files are the same.
What can be the reason of such slow performance?
Thank you!
Best regards, An
gt; From: Chris Nolan [mailto:[EMAIL PROTECTED]
> Sent: 12 February 2004 17:28
> To: Michael McTernan
> Cc: Mysql; Benoit St-Jean
> Subject: Re: InnoDb Table Performance problem
>
>
> Michael McTernan wrote:
>
> >Hi there,
> >
> >
> >
> >&
o complete. Using the FORCE INDEX(date) predicate,
the query time drops to about 2 seconds.
Thanks,
Mike
You're welcome! I hope that this helps you out!
Regards,
Chris
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: 12 February 2004 12:23
To: Michael McTernan
partitioning
between the tables on disk.
I'm guessing that the real problem here is that some of my queries are
secretly doing table scans when they shouldn't, and that is causing a huge
slowdown, although I might split the BLOB column into a different table such
that table scans don
Original Message-
> From: Benoit St-Jean [mailto:[EMAIL PROTECTED]
> Sent: 12 February 2004 14:04
> To: Michael McTernan
> Cc: Mysql
> Subject: Re: InnoDb Table Performance problem
>
>
> Michael McTernan wrote:
>
> >Hi,
> >
> >
> >
> >
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know problem... The table
handler (for InnoDB) has to do a table scan to count all rows... This
particular case is optimized with MyISAM ...
Sure. But why is the tablescan ~100 times faster for the table without the
BLO
Sent: 11 February 2004 22:47
To: Michael McTernan
Cc: Mysql
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB,
gt; To: Michael McTernan
> Cc: Mysql
> Subject: Re: InnoDb Table Performance problem
>
>
> Michael McTernan wrote:
>
> >Hi there,
> >
> >I'm making something similar to a file revision control system, and using
> >MySQL on Linux as the database to drive
Michael McTernan wrote:
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well, with the exception of one table
that is always very slow.
This table holds
Hi there,
I'm making something similar to a file revision control system, and using
MySQL on Linux as the database to drive it. Almost all my tables are
InnoDB, and generally it is going very well, with the exception of one table
that is always very slow.
This table holds the files within the da
Dear Sirs and Ladies,
i'm on the way to create some big indexes on a huge MyISAM-table(13G),
using the 'ALTER TABLE ADD INDEX ..., ADD INDEX ..., ...' -Statement.
After mysql copied all data to the temporary #-Tables it slowes down very
much.
A top shows my that it mostly runs in 'D' (uninterrupt
- 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
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
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 l
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 "( ( T
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
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 build,
but at this time I need
I have found that by dumping with --extended-insert, the subsequent import
is MUCH faster. Of course it only issues 450 odd queries for the data set
instead of ~200k...
-mike
[EMAIL PROTECTED]
12/23/03 05:02 PM
To
[EMAIL PROTECTED]
cc
Subject
Strange performance problem importing
I am using 3.23.58 (server and client) on FreeBSD 5.2-RC1 and all of what
I am about to describe is being performed locally.
When importing dumped data (with something like mysql dbname <
dbname.dump) the import is being performed at ~60 queries a second. This
is MUCH slower than when I was run
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
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
Windows XP
PIV processo
Hello,
we're trying to do a BOOLEAN full text search over a table with about
200.000 entrys and 650MB of data (full text index is about half the size
of the data, the average row length is about 3,2kB) on the System stated
below. A sample statement we're trying to run is:
SELECT
id, title
FR
Hello Heikki,
Thanks for your response. Hmmm... When I run 'show processlist', I get something
like the following:
++--++--+-+-+---+--+
| Id | User | Host | db | Command
nal Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 10:48 PM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
> Hello Heikki,
>
> > why you do not look with SHOW INNODB STATUS if there are dang
Hello Heikki,
> why you do not look with SHOW INNODB STATUS if there are dangling
> transactions which could still see the delete-marked rows? Purge cannot
> remove them then.
This is what I see:
mysql> show table status like 'sccchangelog';
+--++++---
ECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 03, 2003 12:10 AM
Subject: Re: Unexpected empty table performance problem with MySQL and
InnoDB
> Hi,
>
> I wanted to post a follow-up question to the inquiry below. I've done some
more research since my last post and now
Hi,
I wanted to post a follow-up question to the inquiry below. I've done some more
research since my last post and now think that the performance problem is related to
something other than uncommitted transactions. More specifically, I think the culprit
is the lack of timely synchroniz
ersnaam 26
a.UserCreated 1
aty eq_ref PRIMARY PRIMARY 8
a.AfspraakTypeID1
r eq_ref PRIMARY PRIMARY 8 a.RelatieID
1
-Original Message-
From: Thomas Spahni [mailto:tsp@;lawb
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 t
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 contai
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 10.000 records, we have
for ab
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
e
Cc: [EMAIL 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
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
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
1 - 100 of 118 matches
Mail list logo
