PROTECTED]
Sent: Saturday, June 17, 2006 12:14 PM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Performance Question
So, you're looking at 150-300 databases and ~31-62k tables based on your
numbers? MySQL should be able to handle that, as should your OS, but the
most important part IMO
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Monday, June 19, 2006 6:35 AM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Performance Question
One reason you might be seeing a higher number of writes than reads is
if MySQL is able to answer queries from
So, you're looking at 150-300 databases and ~31-62k tables based on your
numbers? MySQL should be able to handle that, as should your OS, but the
most important part IMO is how your clients will be using their
data(bases). What sort of queries, how many, etc. Will it be possible for
one client to
of the application.)
--Eric
-Original Message-
From: Atle Veka [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 17, 2006 12:14 PM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
Subject: Re: MySQL Performance Question
So, you're looking at 150-300 databases and ~31-62k tables based on your
Our server will be home to 50-100 separate clients. Each client will
have their own set of databases that will be accessed by 10-60 users at
each client's site.
In terms of performance, is it better to have 1 instance of MySQL
servicing multiple databases, or multiple instances of MySQL each
PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 3:11 AM
Subject: Re: Mysql Performance Question
You need to figure out what's slowing down your application. It could be
expensive queries which in turn could be caused by missing indexes. It
could
be that the machine is too
At 12:32 PM 10/21/2003, you wrote:
Thanks a lot guys.
Haydies:
Just out of wondering, are you using PHP and if so do you use
mysql_pconnect
rather then mysql_connect because that would really speed things up.
I tired pconnect before but it didn't help but using up all the available
memory.
() or whatever to check
the mtime.
Matt
- Original Message -
From: mos
Sent: Wednesday, October 22, 2003 1:44 PM
Subject: Re: Mysql Performance Question
At 12:32 PM 10/21/2003, you wrote:
Thanks a lot guys.
Haydies:
Just out of wondering, are you using PHP and if so do you use
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there are 450
concurrent uers hanging on the site. Mytop showed that the queries per second maxed at
500. I believe this could be higher, provided that I have it running on a
On Tuesday, October 21, 2003, at 12:48 PM, Rainer Sip wrote:
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when
there are 450 concurrent uers hanging on the site. Mytop showed that
the queries per second maxed at 500. I
On Wed, 22 Oct 2003 00:48:29 +0800, Rainer Sip [EMAIL PROTECTED] wrote:
In the mid run I'm planning to mirgrate to innodb for higher concurrency (I'm currently using myisam). However, I'm seeking suggestions in fine tuning the parameters.
I know you want to tune the parameters, but if you
:48 PM
Subject: Mysql Performance Question
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there are
450 concurrent uers hanging on the site. Mytop showed that the queries per
second maxed at 500. I believe this could be higher
Rainer Sip wrote:
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there are 450
concurrent uers hanging on the site. Mytop showed that the queries per second maxed
at 500. I believe this could be higher, provided
PROTECTED]
Sent: Tuesday, October 21, 2003 9:48 AM
Subject: Mysql Performance Question
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when there
are 450 concurrent uers hanging on the site. Mytop showed that the
queries per second
Subject: Mysql Performance Question
I'm running a community site (Xoops) on Mysql 4.0.14.
I found that the speed of my site is slow during peak hours, when
there
are 450 concurrent uers hanging on the site. Mytop showed that the
queries per second maxed at 500. I believe this could be higher
PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 22, 2003 3:11 AM
Subject: Re: Mysql Performance Question
You need to figure out what's slowing down your application. It could be
expensive queries which in turn could be caused by missing indexes. It
could
be that the machine is too slow
Keith C. Ivey [EMAIL PROTECTED] wrote:
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline
burst, with a wd 512MB HD and I want to store George Bush in our MySQL
database.
As far as table definitions are concerned, should I use a BLOB or
should I store him on disk and make
Hi,
Can anyone help?
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline burst,
with a wd 512MB HD and I want to store George Bush in our MySQL database.
As far as table definitions are concerned, should I use a BLOB or should I
store him on disk and make a reference to the
On 9 Jul 2003 at 23:14, Andrew Braithwaite wrote:
I'm running a server with a Pentium 133 w/32meg ram, 512 pipeline
burst, with a wd 512MB HD and I want to store George Bush in our MySQL
database.
As far as table definitions are concerned, should I use a BLOB or
should I store him on
,
Ken
- Original 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
Good Morning Alexander!
Looks like you have tuned your system pretty well.
They are slightly less than 25716, is there any way to check if this
upper
limit becoming reached sometimes?
sysctl kern.openfiles will tell you how many are open now but there is
no way to know if the upper limit is
Hi people,
May be anybody can advice from the personal experience tweeking which
options both in the mysql configuration and server hardware can help in
increasing mysql performance speed? As it is now, mysql is configured to
occupy about 600M RAM, and queries per second avg goes up to about
What disk drive have you got?
We have found that this can help.
Simon
-Original Message-
From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 13:14
To: [EMAIL PROTECTED]
Subject: Mysql performance question
Hi people,
May be anybody can advice from
question
What disk drive have you got?
We have found that this can help.
Simon
-Original Message-
From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 13:14
To: [EMAIL PROTECTED]
Subject: Mysql performance question
Hi people,
May be anybody can
: Mysql performance question
What disk drive have you got?
We have found that this can help.
Simon
-Original Message-
From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2002 13:14
To: [EMAIL PROTECTED]
Subject: Mysql performance question
Hi people
[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
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
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
37 matches
Mail list logo