cdb will perform much faster than mysql on lookups. On additions or
modifications, it gets significantly slower as the number of users
go above 10,000.
>From what I can see, the benifits of mysql are:
1) Other programs who talk mysql can interact with the mail user tables
2) Inserts and modifications are significantly faster for large sites
3) Authentication services can be distributed across machines without
the need for NFS. (Kind of a moot point tho, since the user
directories
would need to be available via NFS)
If you read dan bernstiens page on cdb code, it gives stats on how
fast it can perform read operations. Very efficent ;]
Ken Jones
Ryan Hayle wrote:
>
> On that note--what is the real benefit of using MySQL? I'm running it now,
> and things are working fine, but I'm afraid of the load problem you
> described before... Does MySQL offer a significant performance gain? I
> doubt we'll -ever- have over 1000 users (we don't even have 100 now), and so
> it's not that important. I used to be running exim on a 486 with gnu-pop3d
> and it worked quite well, no performance issues whatsoever.
>
> Thoughts? Ideas? Suggestions?
>
> Thanks,
> Ryan Hayle
>
> -----Original Message-----
> From: Jeff Garvas [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 23 August, 2000 10:45
> To: [EMAIL PROTECTED]
> Subject: Looping tcprules issue "solved"
>
> I converted my entire MySQL "small" system back to cdb format last night.
>
> I had to recompile vpopmail and qmailadmin, but my load average on my
> system is back to an amazing 0.00 and everything is working fine.
>
> Is anyone aware of a bug in the MySQL workings of either qmailadmin,
> vpopmail or something else which was causing this?
>
> I would at some time like to convert back to a MySQL based system if the
> problem is solved.
>
> -Jeff
