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
-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 Core2Duo cpu. Until today mysql
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
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
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
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
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
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
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:
-Original Message-
From: Gunnar R. [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
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). The SQL database is about 700MB.
It's all running
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). The SQL database is about 700MB.
It's all running
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
@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). The SQL database is about 700MB.
It's all running on a couple
@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). The SQL database is about 700MB.
It's all running on a couple of years old
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
: 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 Dell box with two P4
-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
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,
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
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
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
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
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
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
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
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
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
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
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 command is rather
| simple.
Ich
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
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
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
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
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
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
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
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
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
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
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,
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
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
: 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, and generally it is going very well, with the exception
of one
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, and generally it is going very well
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
PROTECTED]
Sent: 12 February 2004 14:04
To: Michael McTernan
Cc: Mysql
Subject: Re: InnoDb Table Performance problem
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
.
Thanks,
Mike
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: 12 February 2004 12:23
To: Michael McTernan
Cc: Benoit St-Jean; Mysql
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know
: InnoDb Table Performance problem
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
Subject: Re: InnoDb Table Performance problem
Michael McTernan wrote:
Hi there,
I would try to sum it up like this:
1. Discs work best when used as purely sequential devices.
2. Inserting those BLOBs takes up space somewhere. Strictly speaking, on
the disc they may very well be in between
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'
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
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
- 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 ( (
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
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
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
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
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 processor
PIV
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
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
Hello Heikki,
Thanks for your response. Hmmm... When I run 'show processlist', I get something
like the following:
++--++--+-+-+---+--+
| Id | User | Host | db | Command
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';
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 dangling
transactions which
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 synchronization
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 think that the performance problem
is related to something other than
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
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
- 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
===
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
, 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
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
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
1 - 100 of 117 matches
Mail list logo
