Re: MAX vs plain vanilla mysql
Petre, - Original Message - From: Petre Agenbag [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 9:01 AM Subject: Re: MAX vs plain vanilla mysql Thanks, So, just to be 100% sure, the BEST to do is to install max, as I can't see any reason why NOT to...? No performance issues when used as a plain vanilla model, no stability and no security issues either, only down side to it is that it is a tad bit larger ? no MyISAM bugs which would have been special to the -Max version have been reported, as far as I know. The security is the same in both versions because the MyISAM source code is the same. PS, Oh, and why do I always get a returned mail when posting to this list, yet my message still seems to reach it? Me too :). Looks like we almost always have some glitch in the mail server of some recipient of the mailing list, or in the mail server itself. I have notified the MySQL web team about this bug. Thanks Petre Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com Paul DuBois wrote: At 19:31 +0200 7/2/02, Petre Agenbag wrote: Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of tables in one db? Sorry if I'm asking stupid questions, just want to know what is possible and what not, was thinking the other day if it wouldn't be etter if one had different types of tables in one relation db ; myisam types for the normal static data, and innodb or bdb tables for the tables that need to commit/rollback. Yes, yes, yes, and yes. :-) - 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: MAX vs plain vanilla mysql
Petre, Monday, July 01, 2002, 9:26:49 AM, you wrote: PA Probably a stupid question, but which is best to have on ones server, PA the old mysql, or max. I.O.W, if you install MAX and never use innodb PA or berkeley tables, will it be equivalent to a normal mysql installation PA wrt performance and stability? PA I'm asking from an ISP's point of view, if that makes any difference ( PA obviously if from developer it will depend on the needs of the app..) MySQL-Max binary is larger. It takes a lot more memory and it is useless without usage of InnoDB and/or BDB. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: MAX vs plain vanilla mysql
Hi! I have to correct: if you put [mysqld] skip-innodb skip-bdb to your my.cnf, then -Max uses only about 1.5 MB more memory than plain MySQL, because of a larger executable. MyISAM tables in -Max are as reliable as in plain MySQL. It is the same source code. Best regards, Heikki Innobase Oy ... Petre, Monday, July 01, 2002, 9:26:49 AM, you wrote: PA Probably a stupid question, but which is best to have on ones server, PA the old mysql, or max. I.O.W, if you install MAX and never use innodb PA or berkeley tables, will it be equivalent to a normal mysql installation PA wrt performance and stability? PA I'm asking from an ISP's point of view, if that makes any difference ( PA obviously if from developer it will depend on the needs of the app..) MySQL-Max binary is larger. It takes a lot more memory and it is useless without usage of InnoDB and/or BDB. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: MAX vs plain vanilla mysql
Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of tables in one db? Sorry if I'm asking stupid questions, just want to know what is possible and what not, was thinking the other day if it wouldn't be etter if one had different types of tables in one relation db ; myisam types for the normal static data, and innodb or bdb tables for the tables that need to commit/rollback. Heikki Tuuri wrote: Hi! I have to correct: if you put [mysqld] skip-innodb skip-bdb to your my.cnf, then -Max uses only about 1.5 MB more memory than plain MySQL, because of a larger executable. MyISAM tables in -Max are as reliable as in plain MySQL. It is the same source code. Best regards, Heikki Innobase Oy ... Petre, Monday, July 01, 2002, 9:26:49 AM, you wrote: PA Probably a stupid question, but which is best to have on ones server, PA the old mysql, or max. I.O.W, if you install MAX and never use innodb PA or berkeley tables, will it be equivalent to a normal mysql installation PA wrt performance and stability? PA I'm asking from an ISP's point of view, if that makes any difference ( PA obviously if from developer it will depend on the needs of the app..) MySQL-Max binary is larger. It takes a lot more memory and it is useless without usage of InnoDB and/or BDB. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - 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: MAX vs plain vanilla mysql
At 19:31 +0200 7/2/02, Petre Agenbag wrote: Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of tables in one db? Sorry if I'm asking stupid questions, just want to know what is possible and what not, was thinking the other day if it wouldn't be etter if one had different types of tables in one relation db ; myisam types for the normal static data, and innodb or bdb tables for the tables that need to commit/rollback. Yes, yes, yes, and yes. :-) - 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: MAX vs plain vanilla mysql
Thanks, So, just to be 100% sure, the BEST to do is to install max, as I can't see any reason why NOT to...? No performance issues when used as a plain vanilla model, no stability and no security issues either, only down side to it is that it is a tad bit larger ? PS, Oh, and why do I always get a returned mail when posting to this list, yet my message still seems to reach it? Thanks Petre Paul DuBois wrote: At 19:31 +0200 7/2/02, Petre Agenbag wrote: Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of tables in one db? Sorry if I'm asking stupid questions, just want to know what is possible and what not, was thinking the other day if it wouldn't be etter if one had different types of tables in one relation db ; myisam types for the normal static data, and innodb or bdb tables for the tables that need to commit/rollback. Yes, yes, yes, and yes. :-) - 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