Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
On Tue, 19 Feb 2002, Simon Green wrote:
Date: Tue, 19 Feb 2002 13:22:04 -
From: Simon Green [EMAIL PROTECTED]
To: 'Varshavchick Alexander' [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Mysql performance
and see if you can spot
anything in the manual page for each of the variables.
Best of Luck,
Ken
- Original Message -
From: Varshavchick Alexander [EMAIL PROTECTED]
To: Simon Green [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 19, 2002 8:30 AM
Subject: RE: Mysql performance
[EMAIL PROTECTED]
To: Varshavchick Alexander [EMAIL PROTECTED],
Simon Green [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Mysql performance question
Hi Simon,
A couple of things, unless you have compiled WITH_LINUX_THREADS
from the /usr/ports/databases then adding more processors
Message -
From: Varshavchick Alexander [EMAIL PROTECTED]
To: Ken Menzel [EMAIL PROTECTED]
Cc: Simon Green [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 19, 2002 11:31 AM
Subject: Re: Mysql performance question
Thanks a lot for the advices. The value for table_cache is 8572, and
I'm
Jatin Nansi wrote:
I have 2 servers 1 running redhat 7.2 and the other running suse 7.3.
the hardware config is :
RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz).
Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM).
Now i expect to see the suse server go faster than RH,
Particularly given MySQL AB's comments in 2.2.2 Operating Systems Supported by MySQL.
=dn
Jatin Nansi wrote:
I have 2 servers 1 running redhat 7.2 and the other running suse 7.3.
the hardware config is :
RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz).
Suse 7.3: Low end server
: Saturday, January 19, 2002 7:19 AM
To: [EMAIL PROTECTED]
Subject: Suse V/S Redhat - mysql performance difference.
Hi list,
I have 2 servers 1 running redhat 7.2 and the other running suse 7.3.
the hardware config is :
RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz).
Suse 7.3: Low end server
Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: lundi 21 janvier 2002 15:39
To: [EMAIL PROTECTED]
Subject: Re: Suse V/S Redhat - mysql performance difference.
Particularly given MySQL AB's comments in 2.2.2 Operating Systems
Supported by MySQL.
=dn
Jatin Nansi wrote:
I have 2
Jatin Nansi [EMAIL PROTECTED] writes:
Hi list,
I have 2 servers 1 running redhat 7.2 and the other running suse 7.3.
the hardware config is :
RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz).
Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM).
Now i expect to
Robert Cross [EMAIL PROTECTED] writes:
2. Check what else the Suse system has installed and is running in the
background. I've migrated my two systems,
(Athlon-based 'base' station and PII/266 laptop) to Suse 7.3 from RH7.0,
and there appears to be way more background
systems running on
Hi list,
I have 2 servers 1 running redhat 7.2 and the other running suse 7.3.
the hardware config is :
RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz).
Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM).
Now i expect to see the suse server go faster than RH, but i am
Hello, list!
Has anyone made a test to find out under which OS MySQL performs best given
the same hardware? How much is the difference? I am a new user and I have to
choose a system. I am looking at Linux, Solaris or Win on x86.
Thanks,
Ales.
you should not have problems.
Simon
-Original Message-
From: Ales Vaupotic [mailto:[EMAIL PROTECTED]]
Sent: 23 November 2001 12:22
To: MySQL list
Subject: MySQL performance on different OS-es
Hello, list!
Has anyone made a test to find out under which OS MySQL performs best given
the same
On Mon, Oct 22, 2001 at 08:02:49AM +0100, Ronan Minogue wrote:
Jeremy,
Firstly thank you for the reply.
On the MySql web site there are benchmark response times provided
for the execution of queries on NT 4. e.g. reading 2,000,000 rows
by index requiring 367 seconds.
Are you aware of
Dear Sir/Madam.
I have written a Management Information System that has a MySQL db running
on a Linux server.
There is quite a small number of tables.
However these tables are growing quickly and the queries executed will
require LEFT OUTER JOIN between tables.
Example:
A sample query over 4
On Sun, Oct 21, 2001 at 08:41:45PM +0100, Ronan Minogue wrote:
Dear Sir/Madam.
I have written a Management Information System that has a MySQL db
running on a Linux server. There is quite a small number of tables.
However these tables are growing quickly and the queries executed
will
Hello:
I want to setup a machine with 3000 databases, each database will have
41 tables. Does MySQL support this configuration? What machine do you think
will support this configuration? The purpose is to create a website with
PHP+MySQL, is this possible?
Best Regards.
On Fri, 2001-10-05 at 09:52, José León Serna wrote:
Hello:
I want to setup a machine with 3000 databases, each database will have
41 tables. Does MySQL support this configuration? What machine do you think
will support this configuration? The purpose is to create a website with
Tonu Samuel writes:
I want to setup a machine with 3000 databases, each database will have
41 tables.
This should be no problem for MySQL. Everything is depending how to you
use MySQL.
It seems to be pretty popular to have a large number of databases,
but I guess it's mostly due to
On Fri, 2001-10-05 at 12:13, Carl Troein wrote:
It seems to be pretty popular to have a large number of databases,
but I guess it's mostly due to having a large number of users.
In pthe project I'm working on now we have 3 databases, 2 of which
are mysql and test. However, some of our tables
BTW, this is unique in MySQL - you can have tables mixed to be
transactional (InnoDB) and nontransactional (MyISAM) and use them mixed
in same query. All other SQL-s (as much I know) have transactions on
Oracle's Global Temporary Tables don't write to redo or rollback, and
on normal tables
On Fri, 2001-10-05 at 17:06, David Turner wrote:
BTW, this is unique in MySQL - you can have tables mixed to be
transactional (InnoDB) and nontransactional (MyISAM) and use them mixed
in same query. All other SQL-s (as much I know) have transactions on
Oracle's Global Temporary Tables
No problem, MYSQL is great and I know far less about it than I do
Oracle.
Dave
On Fri, Oct 05, 2001 at 06:08:07PM +0200, Tonu Samuel wrote:
On Fri, 2001-10-05 at 17:06, David Turner wrote:
BTW, this is unique in MySQL - you can have tables mixed to be
transactional (InnoDB) and
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
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
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
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
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
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 (*)
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.
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
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
: 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
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
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
On Fri, Jul 13, 2001 at 09:40:55AM -0200, Mario Witte wrote:
I'm searching for a tool which will provide statistics about the
usage of a mysql-server like avg queries/minute, cpu load etc.
Other folks have made good suggestions.
If you want something quick and interactive, mytop may give you
Hello,
I'm searching for a tool which will provide statistics about the usage of a
mysql-server like avg queries/minute, cpu load etc.
I've tried mysqler and liked it, but couldn't get it to start as a daemon.
Are there any similar tools out there?
Thanks in Advance,
--
Mario Witte [EMAIL
On Friday 13 July 2001 13:40, Mario Witte wrote:
Hello,
I'm searching for a tool which will provide statistics about the usage of a
mysql-server like avg queries/minute, cpu load etc.
I've tried mysqler and liked it, but couldn't get it to start as a daemon.
Are there any similar tools out
Mario Witte wrote:
Hello,
I'm searching for a tool which will provide statistics about the usage of a
mysql-server like avg queries/minute, cpu load etc.
I've tried mysqler and liked it, but couldn't get it to start as a daemon.
Are there any similar tools out there?
Thanks in
Cricket looks great, I think I'll have to try it ASAP.
For the moment I just found a utility called mrtg-mysql which puts
mysql-stats into mrtg. Statistics aren't very extensive but enough for the
moment.
--
Mario Witte [EMAIL PROTECTED]
On 2001.07.13 07:19:08 -0200 Van wrote:
Mario Witte
Van writes:
Mario Witte wrote:
Hello,
I'm searching for a tool which will provide statistics about the usage of a
mysql-server like avg queries/minute, cpu load etc.
I've tried mysqler and liked it, but couldn't get it to start as a daemon.
Are there any similar tools out there?
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 13, 2001 10:05 AM
Subject: Re: Mysql performance monitoring?
Cricket looks great, I think I'll have to try it ASAP.
For the moment I just found a utility called mrtg-mysql which puts
mysql-stats into mrtg. Statistics aren't very
Joshua,
Comparing Oracle vs. MySQL myisam tables, MySQL will
save disk space, and provide you with much faster
queries, but you have to be aware of the table
locking issues if you are doing
updates/inserts/deletes mixed with reads.
MySql documentation says that mysql enforces
table level
VVM Ravikumar Sarma Chengalvala wrote:
MySql documentation says that mysql enforces
table level locking if no explicit locking is there.If
I am using non transaction sensitive tables can I go
ahead without providing any explicit locking?I am
using myISAM.
Yes. This is how I use MySQL
VVM Ravikumar Sarma Chengalvala wrote:
Joshua,
Comparing Oracle vs. MySQL myisam tables, MySQL will
save disk space, and provide you with much faster
queries, but you have to be aware of the table
locking issues if you are doing
updates/inserts/deletes mixed with reads.
MySql
I would like to know the limitations of Mysql with extremely large tables. I
need to store 20+ million records. Each record would contain only 4-6 fields
and would not be longer than 128 bytes of information. The records could be
divided among several tables, but at what size is the performance
Shane Anderson wrote:
I would like to know the limitations of Mysql with extremely large tables. I
need to store 20+ million records. Each record would contain only 4-6 fields
and would not be longer than 128 bytes of information. The records could be
divided among several tables, but at
limitation about space and speed according to DBMS featuring. since MySQL
still have not full SQL 92 feature (transaction, sub select... I think)
make it eat a fewer space than other DBMS (oracle or informix) and it can
speed up because it did not need to handle more condition. I did not
I'm currently running MySQL with tables that contain ~10 million rows.
Each row has 50 columns and the table has 27 indexes. The data size of
what you're describing doesn't seem so big. There are some arithmatics
in the MySQL manual on how much disk space is used per row.
If the tables you
Hi,
I'm currently writing my final year thesis and i'm in need for some
information on the efficiency of MySQL. If anyone knows a good site, book,
paper etc ... pls let me know. I'm wondering how many request MySQL server
can resolve per second and that kind of things.
Thanks in advance,
Raf
Raf Geusens [EMAIL PROTECTED] wrote:
I'm currently writing my final year thesis and i'm in need for some
information on the efficiency of MySQL. If anyone knows a good site, book,
paper etc ... pls let me know. I'm wondering how many request MySQL server
can resolve per second and that kind
Hi all,
Im new to MySQL. I have the following questions that I hope someone can
clarify for me:
(1) I have learned from this list and other users group list that
MySQL is very fast on performance.
How do they measure this performance? Is it the execution time on
the command?
PROTECTED]
From: Michael Zornek [EMAIL PROTECTED]
Date: Fri, 12 Jan 2001 21:00:03 -0500
To: [EMAIL PROTECTED]
Subject: mySQL performance
Ok, I'm starting to design a PHP/mySQL web site that will house about 6-8
tables, lot of relation stuff, very dynamic output to the web visitors. My
worry
"Patrick FICHE" [EMAIL PROTECTED] writes:
I just wanted to know if my assertions are rigth and what are the common way
to solve this type of problems ?
Store your results into a temporary table?
--
Dave Hodgkinson, http://www.hodgkinson.org
Editor-in-chief, The
201 - 254 of 254 matches
Mail list logo
