, Perrin Harkins wrote:
> On Wed, Apr 21, 2010 at 11:14 AM, 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 i
d 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
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: Mor
nt obligatoire. Étant donné que les email
> peuvent facilement être sujets à la manipulation, nous ne pouvons accepter
> aucune responsabilité pour le contenu fourni.
>
>
>
>
>
>
> > Date: Wed, 21 Apr 2010 09:31:15 -0500
>
> > Subject: More CPU or More RAM?
>
ate
> index to any 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...@
module, especially on debug.
> That, too goes 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 wrote:
>
>> I have a 1.5G database which feeds a CMS web applica
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 Drive
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.
