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
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
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
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. It speeds up things until the disks
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
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 or the configuration of MySQL is
sub-optimal.
In this case, the machine looks fine.
I can't comment on queries or
Hi Rainer,
You might get more improvement by optimizing your application and
queries than by tuning hardware or MySQL. :-)
About switching to InnoDB, are you doing lots of writes that are causing
locked tables? e.g. What's the ratio of Table_locks_immediate to
Table_locks_waited in SHOW STATUS?
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
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
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 the
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
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
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
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
31 matches
Mail list logo