Re: mysql/postgresql port of the server ?

Hello,

Friday, March 21, 2003, 12:42:21 PM, Jesus Climent wrote:

> Here at es.freedb.org we need a database backend of the server cddbd since it
> is eating our resources:

>   PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND  
> 22105 cddb      15   0 87304  85M   280 S    54.7 16.8 222:45 cddbd

> And the load jumped up to 50+ this morning.

Are you running cddbd from inetd? The daemon-mode is known to be
problematic in some cases. If it's running from inetd, this is
probably the update of the fuzzy matching hash index, which is done
once per day - especially on systems using ext2 that's a bit
problematic, since ext2 isn't suited very well for being misused as a
database. On our master-server we're using ReiserFS.

> Is there anything like that out there?

Unfortunately there's nothing like that out there, which has all the
required features. :(

> If not, we might be forced to stop our mirror due to major system resources
> consumption. Or then we have to wait until we can migrate to XFS or similar.

That'd be unfortunate. If you think that's the only option at the
moment, please let me know, so we can give users a warning, before you
finally take it down.
  
Best regards, Joerg