Re: Merits of using MySQL (Was: Looping tcprules issue solved)
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
Re: Merits of using MySQL (Was: Looping tcprules issue solved)
On Wed, Aug 23, 2000 at 02:27:59PM -0500, 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. Because databases are cool. Everything should be run off a database. Ben -- Ben Beuchler [EMAIL PROTECTED] MAILER-DAEMON (612) 321-9290 x101 Bitstream Underground www.bitstream.net
Re: Merits of using MySQL (Was: Looping tcprules issue solved)
Database good, napster bad! -- Chris "$something_witty" Fankhauser Bitstream Underground On Wed, 23 Aug 2000, Ben Beuchler wrote: On Wed, Aug 23, 2000 at 02:27:59PM -0500, 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. Because databases are cool. Everything should be run off a database. Ben -- Ben Beuchler [EMAIL PROTECTED] MAILER-DAEMON (612) 321-9290 x101 Bitstream Underground www.bitstream.net
Re: Merits of using MySQL (Was: Looping tcprules issue solved)
I don't see the need either. I have several thousand users among 400 domains, running off a 1/2 GB PII, with no problems whatsoever. I rarely see a load average higher than .7. In addition, the server mirror's itself 3 times a day to another server that can be configured on the fly to take over, if necessary. Qmail is way cool... Dan Ben Beuchler wrote: On Wed, Aug 23, 2000 at 02:27:59PM -0500, 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. Because databases are cool. Everything should be run off a database. Ben -- Ben Beuchler [EMAIL PROTECTED] MAILER-DAEMON (612) 321-9290 x101 Bitstream Underground www.bitstream.net -- Whatever hits the fan will not be evenly distributed. == Daniel E. JacksonSchlumberger GeoQuest/System Engineer [EMAIL PROTECTED] Voice: (713) 513-2170 ==