On Thu, Aug 5, 2010 at 8:35 AM, Nunzio Daveri wrote:
>
> The server in this case is a stand alone with nothing more then CentOS and
> MySQL
> 5.1.44 on it. The drives are sas 10K rpm drives. The problem I see is that
> when you stress test the server (typically by running loads of reports -
> s
On 8/5/2010 9:35 AM, Nunzio Daveri wrote:
So when I do top-c before I run the reports,
it says mysql is using 2GB, then I run the stress test (several reports) and it
hits 12GB then I stop the stress and even 30 mins later the server says there is
only 800mb of ram free???
That's normal Linux
Any kind of optimization you need works.
I would use a explain sql statements istead to import without indexes, that
will shed more light...
Even if u optimize the report, if you have concurrent access demanding a
bunch load of data you will other operations get stuck... for that is a good
reason
code and re-architecting the db ;-)
Again...
Thanks for all of your feedback Gurus :-)
Nunzio
From: Steven Staples
To: Nunzio Daveri ; mysql@lists.mysql.com
Sent: Thu, August 5, 2010 7:23:19 AM
Subject: RE: Moving from one MySQL server to three MySQL serv
cause of the problem, before
adding to it.
Steven Staples
> -Original Message-
> From: Nunzio Daveri [mailto:nunziodav...@yahoo.com]
> Sent: August 4, 2010 2:40 PM
> To: mysql@lists.mysql.com
> Subject: Moving from one MySQL server to three MySQL servers?
>
> Hel
Hi Nunzio, all!
I cannot give specific hints, not being a MySQL tuning expert, but I
repeat my general question:
Nunzio Daveri schrieb:
> Hello Gurus :-) I was running a simple load generator against our 16GB Dual
> Quad core server and it pretty much came down to it's knees within two hours
My experience with replication:
Most of the times, is good enough, fast enough... I have just reworked some
part of an application to split the reporting module from all other modules.
We are still using php 4.3 with pear::db module (what? legacy software is
hard to kill! we are trying!, Honest!
>
> 1. Setup a single master and 2 slaves. The question is how to tell the web
> servers to get all the read data from the slaves and to only write to the
> master?
>
Replication is not an answer to all performance problems. Although updates
on the slave are more optimized than if you ran the upd
On Wed, August 4, 2010 11:40, Nunzio Daveri wrote:
> Hello Gurus :-)� I was running a simple load generator against our 16GB
> Dual
> Quad core server and it pretty much came down to it's knees within two
> hours of
> running tests.� The customer DOES NOT WANT to change any code, they just
> want t
On 8/4/2010 12:40 PM, Nunzio Daveri wrote:
it pretty much came down to it's knees within two hours of
running tests.
Can you clarify what happened in those 2 hours, exactly?
If you mean it took 2 hours of running a single test for performance to
collapse, I'm not sure this means anything. 2
Hello Gurus :-) I was running a simple load generator against our 16GB Dual
Quad core server and it pretty much came down to it's knees within two hours of
running tests. The customer DOES NOT WANT to change any code, they just want
to
throw hardware at it since it took them a year to create
11 matches
Mail list logo