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
in your db
- avoid taxonomy - it does evil hiearchical queries
et cetera ad nauseam :-)
On Wed, Apr 21, 2010 at 4:31 PM, shamu...@gmail.com shamu...@gmail.comwrote:
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
of the tables. Of course, if you want to throw more hardware at
the problem it might help in the short run but it might be masking the
original problem.
Regards,
Johan
-Original Message-
From: shamu...@gmail.com [mailto:shamu...@gmail.com]
Sent: 21 April 2010 15:31
To: mysql@lists.mysql.com
.
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
to avoid using Views or Taxonomy. 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
, Perrin Harkins per...@elem.com wrote:
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
Below is my MySQL Server's status and configuration. But I can not see
anything under /tmpfs/, it is showing empty to me.
here is the result of ls -al
drwxrwxrwx 2 mysql mysql60 Apr 7 17:43 tmpfs
Could anyone tell me how to check the status of temp files and temp tables
on disk?
Thanks.