> Simon, > > Memory usage: > total used free shared buffers cached > Mem: 1009 995 14 0 11 168 > -/+ buffers/cache: 815 194 > Swap: 517 294 223
1) It's a good idea to have at least as much swap space than real memory. I suggest to increase swap to 1-2G in your case. (of course this won't make your db faster). 2) Without analyzing your memory situation in detail, it seems that you already use too much which leads to 294M of swap being used. If some of the 294M is related to MaxDB, it's very clear that it may slow down things. I think reducing cache_size may help a bit then. Simon > > I changed the maxcpu parameter to 1. Lets see what happens. > Thank you very much for the help. > > Best regards > > On 7/12/06, Simon Matter <[EMAIL PROTECTED]> wrote: >> >> >> MAXCPU is already with value 2. >> >> cat /proc/cpuinfo | grep "processor" | wc -l returns 2 processors. >> >> You get 2 processors but you also get that with 1 CPU and HT enabled. If >> you have only 1 single core CPU, set MAYCPU to 1, really. >> >> BTW, how is your real memory usage? It looks a bit high for me >> considering >> you "only" have 1Gb RAM. >> >> Simon >> > > > > -- > Daniel Castro > Website: http://danielti.no-ip.info:2139 > MSN: [EMAIL PROTECTED] > Skype: danielti2005 > ICQ : 316727989 > Jabber: danielti > Linux User: 387864 > AOL User: Danielti2005 > Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]