On Wed, Apr 21, 2010 at 4:52 PM, shamu...@gmail.com shamu...@gmail.comwrote:
replacement etc, but that costs me too much if I can use hardware to solve
the same problem. and Yes I know I will run to same problem again when the
It may be that you can't actually solve it with more hardware. The
. I really just wanted to be the first to
answer the original question.
Actually, Perrin already answered the question :)
And now for my 2c. All other things being equal, I would opt for a more
ram over a faster CPU. The extra ram can be used to reduce the load on
the CPU through judicious
Also, have some munin plugins. There are the ones I add to the ones in a
standard munin distribution, and give plenty of info.
Only the mysql_ one is actually mine, I got the rest off muninexchange.
Guess I should incorporate their functionality into mine sometime.
A good look at the data that
I have a 1.5G database which feeds a CMS web application (Drupal).
Right now I am hosting it with a 1.5G RAM VPS and I feel it is too slow. IO
and CPU are high. So I am planning to upgrade it to a dedicated serer.
Here are two choice of my server:
1. Intel Pentium G6950 (Dual Core), 2xSATA
Switch CMSes, you'll be better off. I have the pain of running Drupal, too.
Your DB host is probably good enough, unless you're doing insane amounts of
page views. What you need is Drupal optimisations. Here's just a few:
- drupal keeps both it's sessions and cache in the DB. Change to memcache
: shamu...@gmail.com [mailto:shamu...@gmail.com]
Sent: 21 April 2010 15:31
To: mysql@lists.mysql.com
Subject: More CPU or More RAM?
I have a 1.5G database which feeds a CMS web application (Drupal).
Right now I am hosting it with a 1.5G RAM VPS and I feel it is too slow. IO
and CPU are high. So I
Thanks Johan,
Unfortunately I run into all 4 issues you have mentioned. And the views is
my huge part of my site.
I got about 50k-60k page view per day, about 40k nodes. It is really a pain
to make drupal run fast. I feel drupal query the db tooo much.
I understand I can get some
Subject: More CPU or More RAM?
I have a 1.5G database which feeds a CMS web application (Drupal).
Right now I am hosting it with a 1.5G RAM VPS and I feel it is too slow. IO
and CPU are high. So I am planning to upgrade it to a dedicated serer.
Here are two choice of my server:
1. Intel
April 2010 15:44
To: shamu...@gmail.com
Cc: mysql@lists.mysql.com
Subject: Re: More CPU or More RAM?
Switch CMSes, you'll be better off. I have the pain of running Drupal, too.
Your DB host is probably good enough, unless you're doing insane amounts of
page views. What you need is Drupal
.
Date: Wed, 21 Apr 2010 09:31:15 -0500
Subject: More CPU or More RAM?
From: shamu...@gmail.com
To: mysql@lists.mysql.com
I have a 1.5G database which feeds a CMS web application (Drupal).
Right now I am hosting it with a 1.5G RAM VPS and I feel it is too slow.
IO
and CPU
. The advantages far outweigh the
disadvantages in most cases.
-Original Message-
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: 21 April 2010 15:44
To: shamu...@gmail.com
Cc: mysql@lists.mysql.com
Subject: Re: More CPU or More RAM?
Switch CMSes
: More CPU or More RAM?
Switch CMSes, you'll be better off. I have the pain of running Drupal, too.
Your DB host is probably good enough, unless you're doing insane amounts of
page views. What you need is Drupal optimisations. Here's just a few:
- drupal keeps both it's sessions and cache
On Wed, Apr 21, 2010 at 11:14 AM, shamu...@gmail.com shamu...@gmail.com wrote:
This is my current my.cnf setttings. Could anyone take a quick peek and tell
me if I set anything awfully wrong?
If your tables are MyISAM (not InnoDB), then 128MB is much too small
for your key_buffer. You should
Thanks Perrin,
My web server is on the same box as the database server.
I tried to use a mysql tuning-primer.sh to evaluate my server. and the
result for key_buffer is
KEY BUFFER
Current MyISAM index space = 181 M
Current key_buffer_size = 128 M
Key cache miss rate is 1 : 12507
Key buffer free
Meersman
Sent: 21 April 2010 15:44
To: shamu...@gmail.com
Cc: mysql@lists.mysql.com
Subject: Re: More CPU or More RAM?
Switch CMSes, you'll be better off. I have the pain of running Drupal, too.
Your DB host is probably good enough, unless you're doing insane amounts of
page views. What you
15 matches
Mail list logo