inson
-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 fro
---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
numbers? MySQL should be able to
ersions 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 table
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 h
.21 37.29
> 10:30:00 HK all 35.91 0.00 16.64 47.45
> 10:40:00 HK all 46.26 0.00 22.03 31.72
> 10:50:00 HK all 43.28 0.00 19.37 37.35
> 11:00:00 HK all 35.22 0.00 16.42 48.36
> 11:10:00 HK
piler :-)) -- except stat() 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:
&g
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.
ECTED]>
To: "Rainer Sip" <[EMAIL 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 c
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? I
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 i
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, provide
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 disk
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 haven
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 belie
"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
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 o
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 i
r a list of changes and fixes since 4.0.1 at
> http://www.mysql.com/doc/N/e/News-4.0.2.html
>
> Good Luck,
> Ken
> - Original Message -
> From: "Varshavchick Alexander" <[EMAIL PROTECTED]>
> To: "Ken Menzel" <[EMAIL PROTECTED]>
> Cc: &quo
ginal 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
&
From: Ken Menzel <[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_LI
> Date: Tue, 19 Feb 2002 13:22:04 -0000
> > From: Simon Green <[EMAIL PROTECTED]>
> > To: 'Varshavchick Alexander' <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
> > Subject: RE: Mysql performance question
> >
> > What disk drive have you got?
> &g
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
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 persona
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
-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 21 October 2001 23:52
To: Ronan Minogue
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL Performance Question
On Sun, Oct 21, 2001 at 08:41:45PM +0100, Ronan Minogue wrote:
> Dear Sir/Madam.
>
> I have written a Management Information Sy
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
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.
>
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 u
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
tabl
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 hav
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 know
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 a
32 matches
Mail list logo
