Re: Internals Of MySQL
Im running some benchmarking tests on mysql, postgres and interbase database servers. does anyone know the reasons why or know where i can find out some technical reasons why the mysql database server is particularly good in relation to the others or just by itself e.g. use of query optimisation or indexing etc. I'm only looking at creates, selects, inserts, update and delete statements. I've tried to look around for this on the net, but all i seem to get is a big arguement consisting of the features lacking in mysql that are in other databases e.g. ACID!! Without detailed knowledge, may I suggest that you have answered your own question. MySQL has dumped some of the more complex features offered by other databases in favour of oprimising for prformance. Some of the features arequired for ACID would probably slow it down considerably. Isn't it nice toi have the choice - if you really need ACID, there are other databeses which will offer it. If you don't, you can used MySQL and not be burdened with the cost of it. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Internals Of MySQL
[EMAIL PROTECTED] writes: Im running some benchmarking tests on mysql, postgres and interbase database servers. does anyone know the reasons why or know where i can find out some technical reasons why the mysql database server is particularly good in relation to the others or just by itself e.g. use of query optimisation or indexing etc. I'm only looking at creates, selects, inserts, update and delete statements. I've tried to look around for this on the net, but all i seem to get is a big arguement consisting of the features lacking in mysql that are in other databases e.g. ACID!! Without detailed knowledge, may I suggest that you have answered your own question. MySQL has dumped some of the more complex features offered by other databases in favour of oprimising for prformance. Some of the features arequired for ACID would probably slow it down considerably. Isn't it nice toi have the choice - if you really need ACID, there are other databeses which will offer it. If you don't, you can used MySQL and not be burdened with the cost of it. Alec Cawley Hi! Just to clear up the issue a bit. If you wish to have ACID level of security use MySQL with BDB or InnoDB tables. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Internals Of MySQL
Hi! The Zend article is somewhat outdated, because it says that MySQL does not support transactions. The benchmark the Zend article is referring to is the TPC-C benchmark and the AS3AP-IR-select benchmark financed by Great Bridge LLC, a company selling support for PostgreSQL. I have written TPC-C in apostrophes because the benchmark was not conducted according to the rules of TPC. They found out that PostgreSQL was performing as well as two commercial databases, but I believe the test was strictly disk-bound, and all sensibly written database servers would get the same results. In the AS3AP-IR-select test after some tuning MySQL was faster for fewer than 7 users, PostgreSQL for more than 7 users. I think this test is bound by the speed of the communication software between the client and the server, because fetching a single row took some 1000 microseconds, much more than is used internally inside the database server. On my website http://www.innodb.com I have posted two simple tests measuring the internal server CPU performance of PostgreSQL-7.1.1 and MySQL/InnoDB-3.23.39. In those tests MySQL/InnoDB is 4 - 11 times faster. But it is best to run your own tests. Regards, Heikki Tuuri Innobase Oy I'll have to pipe up and say that, empirically, mysql far outperforms postgres on a non-state-of-the-art server. I have seen 10 simultaneous connections to mysql and a system load of 0.1 versus 1 instance of postgres (postmaster) and a load of over 2 (and with 3 instances of postmaster a load of 8!)I know that hardware is cheap and obviously if I was running exclusively postgres I'd throw more ram and a faster CPU at it. Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org- Original Message - From: Leon Mergen [EMAIL PROTECTED]To: Dip [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]Sent: Saturday, June 09, 2001 3:24 PM Subject: Re: Internals Of MySQL I recently read an article at Zend.com, showing that Postgres had better performance than MySQL... Offcourse, this is a very bad thing to say inthe MySQL mailing list, and I'm not really sure about it either, since so many praise MySQL... http://zend.com/zend/art/databases.php _ Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. T: +31 31 735 03 03 F: +31 31 735 03 08 ICQ: 55677353 The information transmitted in this email is intended only for the person(s)or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this informationby persons or entities other than the intended recipient is prohibited. Ifyou received this email in error, please contact the sender and permanently delete the email from any computer. - Original Message - From: Dip [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 8:55 PM Subject: Internals Of MySQL Hi All, Im running some benchmarking tests on mysql, postgres and interbase database servers. does anyone know the reasons why or know where i can find out some technical reasons why the mysql database server is particularly good in relation to the others or just by itself e.g. use of query optimisation or indexing etc. I'm only looking at creates, selects, inserts, update and delete statements. I've tried to look around for this on the net, but all i seem to get is a big arguement consisting of the features lacking in mysql that are in other databases e.g. ACID!! Thanks, Dipesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Internals Of MySQL
I'll have to pipe up and say that, empirically, mysql far outperforms postgres on a non-state-of-the-art server. I have seen 10 simultaneous connections to mysql and a system load of 0.1 versus 1 instance of postgres (postmaster) and a load of over 2 (and with 3 instances of postmaster a load of 8!) I know that hardware is cheap and obviously if I was running exclusively postgres I'd throw more ram and a faster CPU at it. Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: Leon Mergen [EMAIL PROTECTED] To: Dip [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 3:24 PM Subject: Re: Internals Of MySQL I recently read an article at Zend.com, showing that Postgres had better performance than MySQL... Offcourse, this is a very bad thing to say in the MySQL mailing list, and I'm not really sure about it either, since so many praise MySQL... http://zend.com/zend/art/databases.php _ Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. T: +31 31 735 03 03 F: +31 31 735 03 08 ICQ: 55677353 The information transmitted in this email is intended only for the person(s)or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this email in error, please contact the sender and permanently delete the email from any computer. - Original Message - From: Dip [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, June 09, 2001 8:55 PM Subject: Internals Of MySQL Hi All, Im running some benchmarking tests on mysql, postgres and interbase database servers. does anyone know the reasons why or know where i can find out some technical reasons why the mysql database server is particularly good in relation to the others or just by itself e.g. use of query optimisation or indexing etc. I'm only looking at creates, selects, inserts, update and delete statements. I've tried to look around for this on the net, but all i seem to get is a big arguement consisting of the features lacking in mysql that are in other databases e.g. ACID!! Thanks, Dipesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php