hi,ive some two forum tables with abot 700Mb each one, and they was type
myisam. I was getting some lock problems and i decided to switch them to innodb,
but server load growed from 3 to 20. I followed your steps but i got not any
server load improvements.
should i back to myisam? or is
Cc: mysql@lists.mysql.com
Subject: Re: Server Load Question
Eric, I sent you a note about hardware this morning as well, but here's
a further thought -
Don't know if this is the case, but is this the exact same application
served to 100 different customers? And are Database-2 and Dat
Eric, I sent you a note about hardware this morning as well, but here's
a further thought -
Don't know if this is the case, but is this the exact same application
served to 100 different customers? And are Database-2 and Database-3
the same for every customer? Some kind of reference info per
ng
performance issues.
- Original Message -
From: "Robinson, Eric" <[EMAIL PROTECTED]>
To:
Sent: Monday, June 19, 2006 1:01 PM
Subject: Server Load Question
I asked this question previously but didn't get much response so I'll
try again.
Our server will be home
On Monday 19 June 2006 10:01 am, Robinson, Eric wrote:
> Q: In terms of performance, is it better for each customer to have its
> own instance of MySQL, each serving 3 databases, or is it better to have
> one instance of MySQL serving 300 databases?
>
> --Eric
Can you clarify a bit on instance? A
I asked this question previously but didn't get much response so I'll
try again.
Our server will be home to 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.
Each client has 3 databases.
Database-1: 500 tables. 13 t
On Fri, 25 Feb 2005, Chris Aitken (The Web Hub) wrote:
> Its highly possible as this is the first database ive had to use with a
> large number of records. I shall look into indexing part of databasing now.
> Any suggested places to start that explains it helpfully ?
One way to do it, would be t
At 05:59 AM 25/02/2005, Atle Veka wrote:
"packs it in"? Do you mean like you say that sendmail actually crashes
when load goes above 5? I would guess sendmail is rather throttling itself
and that you are seeing log messages about sendmail refusing connections.
Is this a correct assumption? Sendmail
arches of these
> records happening regularly.
>
> The problem ive come across, is my hosting providers box is setup so that
> if the server load gets to 5, sendmail packs it in.
"packs it in"? Do you mean like you say that sendmail actually crashes
when load goes above 5? I woul
hosting providers box is setup so that
if the server load gets to 5, sendmail packs it in.
When someone does a search of the records, mysql jumps up to 100% cpu usage
(which is fine) but the more searches that are being done (the website is
getting more users daily) the longer the cpu is at 100
Hi All,
I'm reading "High Performance MySQL". In my humble opinion is an very good
book.
Congratulations to the authors.
In the chapter "Load Balancing and High Availability" is cited the Tony
Bourke's book "Server Load Balancing".
Someone read it? is one
Hello !
I'm trying to figure how to get how many queries are done by each
DB/user and not for the whole MySQL server.
How to know how many queries are done each done for each DB ? MySQL Server
load is heavy and I need to know from which websites...
--
Cedric - mailto:[EMAIL PROTECTED]
(D
Dear All,
we have developed a web-based application for a client
and now in its testing phase by next week...
It uses Linux/PHP 4/MySQL 3.23
As the volume of user will be more, we are very much
concerned about the server efficiency and our
application efficiency/performance...
Following are the
hi
we have developed for a client and now its testing
phase by next week...
using Linux/PHP/MySQL 3.23
we need to test the database load...
like how efficienty query is executing...
how many inserts..updataes taking place...etc...
how much the data etc...
is there any tools available for this?
any
14 matches
Mail list logo
