List:General Discussion« Previous MessageNext Message »
From:Petre Agenbag Date:July 2 2002 5:31pm
Subject:Re: MAX vs plain vanilla mysql
View as plain text  
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
> / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
>/_/  /_/\_, /___/\___\_\___/   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 <mysql-thread113588@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-internet=boesmanland.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


Thread
MAX vs plain vanilla mysqlPetre Agenbag1 Jul
  • Re: MAX vs plain vanilla mysqlEgor Egorov2 Jul
Re: MAX vs plain vanilla mysqlHeikki Tuuri2 Jul
  • Re: MAX vs plain vanilla mysqlPetre Agenbag2 Jul
    • Re: MAX vs plain vanilla mysqlPaul DuBois2 Jul
  • Re: MAX vs plain vanilla mysqlPetre Agenbag3 Jul
Re: MAX vs plain vanilla mysqlHeikki Tuuri3 Jul