Re: Including Mysql in the Main Distrubation
Drake Diedrich wrote: ... >/usr/doc/postgresql-doc/FAQ.gz >-- > 2.11) How do I tune the database engine for better performance? > > There are several things that can be done. You can disable fsync() by > starting the postmaster with a '-o -F' option. This will prevent > fsync()'s from flushing to disk after every transaction. > ... > There has been a lot of criticism of Postgres' speed. Perhaps the >fsync() warning should be made more prominent (in README.Debian, or even the >package description). Thank you for the suggestion. I have added a note to README.Debian. This will be in 6.3.2-10 (slink). -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 "Cease from anger, and forsake wrath; do not fret- it leads only to evil."Psalms 37:8 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
On Tue, Jun 16, 1998 at 11:03:22AM +0200, Michael Meskes wrote: > No DBMS syncy after each transaction. Most systems do it every 30 seconds. > Support for that will be added to Postgres later on. And with 80 TPS I think /usr/doc/postgresql-doc/FAQ.gz -- 2.11) How do I tune the database engine for better performance? There are several things that can be done. You can disable fsync() by starting the postmaster with a '-o -F' option. This will prevent fsync()'s from flushing to disk after every transaction. I haven't examined the code, but postgres was seeking all over the disk with fsync() on (the default), and only getting 4 transactions/sec inserting a row into a table (no indices or anything). Performance rose a factor of 20 after turning fsync()s off. msql and mysql don't appear to have full transaction support, so I didn't consider them "real" databases. They would be sufficient for the task I was performing (moving squid log entries into a database), but since postgres could be sped up I didn't see a need to learn another DB. There has been a lot of criticism of Postgres' speed. Perhaps the fsync() warning should be made more prominent (in README.Debian, or even the package description). -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
On Tue, 16 Jun 1998, Michael Meskes wrote: > Gergely Madarasz writes: > > I find it much faster, it uses less resources... of course it has less > > features too, but you dont always need subselects and transactions. > > It doesn't have transactions? Whew, I never expected that. You can lock the tables and then do some things, but without rollback. -- Madarasz Gergely [EMAIL PROTECTED] [EMAIL PROTECTED] It's practically impossible to look at a penguin and feel angry. Egy pingvinre gyakorlatilag lehetetlen haragosan nezni. HuLUG: http://www.cab.u-szeged.hu/local/linux/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
Drake Diedrich writes: >In some tests I ran, I found that postgres was only capable of 4 > transactions per second in the default configuration. The speed could be > increased to 80 transactions/sec if you were willing to turn off the > automatic disk syncing. It is not clear from the mysql documentation > whether it syncs the disk after each transaction, so mysql may only be > comparable to the unsync'd postgres speed. With an fsync after each > transaction, Postgres is limited by disk seek times. You might be able to > speed it up by putting each file in the database on separate (fast) disks. No DBMS syncy after each transaction. Most systems do it every 30 seconds. Support for that will be added to Postgres later on. And with 80 TPS I think Postgres is doing quite a job. I remember some co-workers timing Oracle on an SCO machine a while ago. With a huge database it wasn't able to do more than 50 TPS. Michael -- Dr. Michael Meskes, Project-Manager| topsystem Systemhaus GmbH [EMAIL PROTECTED]| Europark A2, Adenauerstr. 20 [EMAIL PROTECTED] | 52146 Wuerselen Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44 Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
Gergely Madarasz writes: > I find it much faster, it uses less resources... of course it has less > features too, but you dont always need subselects and transactions. It doesn't have transactions? Whew, I never expected that. Michael -- Dr. Michael Meskes, Project-Manager| topsystem Systemhaus GmbH [EMAIL PROTECTED]| Europark A2, Adenauerstr. 20 [EMAIL PROTECTED] | 52146 Wuerselen Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44 Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
Raul Miller writes: > I'm aware of two issues: > > (1) mysql is significantly faster Will comment on this one later. > (2) postgres forces you to abandon ansi sql for a number of things > where mysql allows you to use ansi sql. Which ansi sql feature is missing? Michael -- Dr. Michael Meskes, Project-Manager| topsystem Systemhaus GmbH [EMAIL PROTECTED]| Europark A2, Adenauerstr. 20 [EMAIL PROTECTED] | 52146 Wuerselen Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44 Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
> Meskes, Michael <[EMAIL PROTECTED]> wrote: > > Please tell me what exactly you like more about mysql in comparison to > > PostgreSQL which really is DFSG free. > On Sat, Jun 13, 1998 at 07:55:46PM -0500, Erv Walter wrote: > 1) Speed > 2) While neither completely implements SQL92 and newer standards, the > portion that mysql implements is more useful for my application than > the portion that PostgreSQL implements. > > Erv Walter In some tests I ran, I found that postgres was only capable of 4 transactions per second in the default configuration. The speed could be increased to 80 transactions/sec if you were willing to turn off the automatic disk syncing. It is not clear from the mysql documentation whether it syncs the disk after each transaction, so mysql may only be comparable to the unsync'd postgres speed. With an fsync after each transaction, Postgres is limited by disk seek times. You might be able to speed it up by putting each file in the database on separate (fast) disks. /etc/postgresql/postmaster.init --- PGFSYNC=no -- Dr. Drake Diedrich, Research Officer - Computing, (02)6279-8302 John Curtin School of Medical Research, Australian National University 0200 Replies to other than [EMAIL PROTECTED] will be routed off-planet -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
Meskes, Michael <[EMAIL PROTECTED]> wrote: > Please tell me what exactly you like more about mysql in comparison to > PostgreSQL which really is DFSG free. 1) Speed 2) While neither completely implements SQL92 and newer standards, the portion that mysql implements is more useful for my application than the portion that PostgreSQL implements. Erv Walter -- Graduate Student[EMAIL PROTECTED] Department of Chemistry [EMAIL PROTECTED] Univ of Wisconsin-Madison [EMAIL PROTECTED] With two ways to spell a word, the wrong one will be used -- tagline 1.00 by xopy -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
Martin Schulze wrote: > > On Sat, Jun 13, 1998 at 01:48:58AM -0400, Kevin Atkinson wrote: > > After carefully reading over the license of Mysql it seems like it could > > be included in the main > > distribution area. > > > > I am wondering exactly what parts are preventing it from being > > included. > > > > Is it that you must purchase it if you wish to develop commercial > > applications that require it? > > Please go back and reed the Mysql license and the Debian Free > Software Guidelines. > > >From the Mysql copyright: > > Copyright: > > MYSQL FREE PUBLIC LICENSE > (Version 4, March 5, 1995) > > 2. Restrictions. > > This license is subject to the following restrictions: > > (a) Distribution of the Program or any work based on the Program by a > commercial organization to any third party is prohibited if any payment is > made in connection with such distribution, whether directly (as in payment > for a copy of the Program) or indirectly (as in payment for some service > related to the Program, or payment for some product or service that > includes a copy of the Program "without charge"; these are only examples, > and not an exhaustive enumeration of prohibited activities). However, the > following methods of distribution involving payment shall not in and of > themselves be a violation of this restriction: > > (i) Posting the Program on a public access information storage > and retrieval service for which a fee is received for retrieving > information (such as an on-line service), provided that the fee is not > content-dependent (i.e., the fee would be the same for retrieving the > same volume of information consisting of random data). > > (ii) Distributing the Program on a CD-ROM, provided that the > files containing the Program are reproduced entirely and verbatim on such > CD-ROM, and provided further that all information on such CD-ROM be > redistributable for non-commercial purposes without charge. > > [..] > > (c) You must meet all of the following conditions with respect to the > distribution of any work based on the Program: > > [..] > > (ii) You must cause any work that you distribute or publish, that > in whole or in part contains or is derived from the Program or any part > thereof, to be licensed as a whole and at no charge to all third parties > under the terms of this License; > > [..] > > This fails #1 of the DFSG as written: > > 1. Free Redistribution >The license of a Debian component may not restrict any party from >selling or giving away the software as a component of an aggregate >software distribution containing programs from several different >sources. The license may not require a royalty or other fee for >such sale. > Thanks, sorry I wasted your time. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
RE: Including Mysql in the Main Distrubation
On Sat, 13 Jun 1998, Meskes, Michael wrote: > Please tell me what exactly you like more about mysql in comparison to > PostgreSQL which really is DFSG free. I find it much faster, it uses less resources... of course it has less features too, but you dont always need subselects and transactions. Greg -- Madarasz Gergely [EMAIL PROTECTED] [EMAIL PROTECTED] It's practically impossible to look at a penguin and feel angry. Egy pingvinre gyakorlatilag lehetetlen haragosan nezni. HuLUG: http://www.cab.u-szeged.hu/local/linux/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
RE: Including Mysql in the Main Distrubation
Please tell me what exactly you like more about mysql in comparison to PostgreSQL which really is DFSG free. Michael -- Dr. Michael Meskes, Projekt-Manager| topystem Systemhaus GmbH [EMAIL PROTECTED]| Europark A2, Adenauerstr. 20 [EMAIL PROTECTED] | 52146 Wuerselen Go SF49ers! Use Debian GNU/Linux! | Tel: (+49) 2405/4670-44 > -- > From: Kevin Atkinson[SMTP:[EMAIL PROTECTED] > Sent: Samstag, 13. Juni 1998 07:48 > To: debian-devel > Subject: Including Mysql in the Main Distrubation > > Truefully I think Mysql is the best free SQL Server available. > > Thanks. > > > -- > To UNSUBSCRIBE, email to [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact > [EMAIL PROTECTED] > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
On Sat, Jun 13, 1998 at 01:48:58AM -0400, Kevin Atkinson wrote: > After carefully reading over the license of Mysql it seems like it could > be included in the main > distribution area. > > I am wondering exactly what parts are preventing it from being > included. > > Is it that you must purchase it if you wish to develop commercial > applications that require it? Please go back and reed the Mysql license and the Debian Free Software Guidelines. >From the Mysql copyright: Copyright: MYSQL FREE PUBLIC LICENSE (Version 4, March 5, 1995) 2. Restrictions. This license is subject to the following restrictions: (a) Distribution of the Program or any work based on the Program by a commercial organization to any third party is prohibited if any payment is made in connection with such distribution, whether directly (as in payment for a copy of the Program) or indirectly (as in payment for some service related to the Program, or payment for some product or service that includes a copy of the Program "without charge"; these are only examples, and not an exhaustive enumeration of prohibited activities). However, the following methods of distribution involving payment shall not in and of themselves be a violation of this restriction: (i) Posting the Program on a public access information storage and retrieval service for which a fee is received for retrieving information (such as an on-line service), provided that the fee is not content-dependent (i.e., the fee would be the same for retrieving the same volume of information consisting of random data). (ii) Distributing the Program on a CD-ROM, provided that the files containing the Program are reproduced entirely and verbatim on such CD-ROM, and provided further that all information on such CD-ROM be redistributable for non-commercial purposes without charge. [..] (c) You must meet all of the following conditions with respect to the distribution of any work based on the Program: [..] (ii) You must cause any work that you distribute or publish, that in whole or in part contains or is derived from the Program or any part thereof, to be licensed as a whole and at no charge to all third parties under the terms of this License; [..] This fails #1 of the DFSG as written: 1. Free Redistribution The license of a Debian component may not restrict any party from selling or giving away the software as a component of an aggregate software distribution containing programs from several different sources. The license may not require a royalty or other fee for such sale. Regards, Joey -- / Martin Schulze * [EMAIL PROTECTED] * 26129 Oldenburg / / Experience is a useful thing. Unfortunately it is / / only acquired just after one could have used it. / -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
Re: Including Mysql in the Main Distrubation
On Sat, 13 Jun 1998, Kevin Atkinson wrote: > > Is it that you must purchase it if you wish to develop commercial > applications that require it? And that you cannot sell it. -- Madarasz Gergely [EMAIL PROTECTED] [EMAIL PROTECTED] It's practically impossible to look at a penguin and feel angry. Egy pingvinre gyakorlatilag lehetetlen haragosan nezni. HuLUG: http://www.cab.u-szeged.hu/local/linux/ -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
