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
On 04/21/2010 02:21 PM, Tom Worster wrote:
I'd go with the 4G 4-core server. If you're running apache and a sensible
OS, the extra cores can be helpful. So, unless you know you have a need for
very large key buffers, 4G should leave the OS plenty for FS cache.
Not that I actually have a
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
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
Hi,
Have you looked at tuning Drupal first? What processes are slowing your server
down and are there any other applications sharing the machine that might be
contributing to the problem? Assuming you haven't got any wacky contrib modules
have you considered improving your application caching,
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
It seems all Johans are interested on this topic. :D
Thank Johan.
My web server (apache 2) is on the same server. And it looks good to me.
I have no custom module. The most often used modules are CCK, Views and
WebForm. OK my server does send out some mails every day, about 10K.
I tried to
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
Thanks Martin,
This is my current configuration.
mysql SHOW VARIABLES LIKE 'have_query_cache';
+--+---+
| Variable_name| Value |
+--+---+
| have_query_cache | YES |
+--+---+
1 row in set (0.00 sec)
mysql SHOW VARIABLES LIKE
. 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
14 matches
Mail list logo