RE: More CPU or More RAM?

2010-04-21 Thread Johan Gant
I guess this is a DB list, but I strongly disagree with Johan's suggestion 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 Apri

RE: More CPU or More RAM?

2010-04-21 Thread Johan Gant
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,

Re: MySQL being hacked with commands through URL

2009-11-18 Thread Johan Gant
With respect, denying all access to 'users' for anything except r...@localhost sounds like trying to cure dandruff by decapitation. Firstly your web app shouldn't be using root to access your data tables and secondly there's every chance his web server is seperate from his db server. You should hav

Re: locked file mysqld-nt.exe when re-installing mysql on windows server

2008-07-30 Thread Johan Gant
ces---> delete all mysql > entries. Do the same for controlset002 and controlset003 > > After above is done try to delete the file in C:\mysql\bin folder. > > regards > anandkl > > > On 7/30/08, Johan Gant <[EMAIL PROTECTED]> wrote: >> >> Hi >> I

locked file mysqld-nt.exe when re-installing mysql on windows server

2008-07-29 Thread Johan Gant
Hi I'm reinstalling an instance of MySQL 4.1 on a Windows Server 2003 machine, but I cannot delete the original installation folder or re-install into it due to the presence of the mysqld-nt.exe file in the C:\mysql\bin folder. I've killed all services relating to MySQL (or those that I can clearly

Re: WHERE .... IN

2008-07-24 Thread Johan Gant
ich may involve normalising your tables. Also, if this is a field of type int you may need to cast your data as varchar to perform wildcard searches. Regards Johan Gant 2008/7/23 Ali Deniz EREN <[EMAIL PROTECTED]>: > Hi all, > > I have a problem as below: > > A text field -Lets call i