Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- install of v5, table types, features
November 18, 2005, 10:35 pm
rate this thread
installed the beta v5.0.4 on my development machine, But, as I started
to develop and then backup data, I noticed that my tables are all using
the storage engine: InnoDB.
Can someone jog my memory and tell me what options cause that to be the
I'm on the fence, b/w choosing MyISAM and InnoDB
- I don't think I'll be using any transactions or foreign keys, in my
- Re: Performance: With a max of 50 users, I don't think this app will
need stress testing and I don't expect performance to degrade with
Since I'm using InnoDB, why is there nothing in the Directory set up
specifically for InnoDB ?
Does that only get used when you start defining foreign keys ?
I'm looking for clarification, advice on a few issues:
Table Locking : the manual's use of the word "thread" made in unclear,
what this does ??
autocommit : ?set to 1 for all non-InnoDB engines ?
Also, whats the best way to convert these tables, if I decide which is
I notice, that it can be done using, "Alter Table" command.
Suggestions and advice, most welcome. TIA for your replys while I
stew on this.
Re: install of v5, table types, features
the 5.0 full release is out... upgrade!
all tables are by default created as InnoDB instead of MyISAM in MySQL 5.0
unless specified after installation
depends what you're doing.... no transactions (are you really sure? never
more than one table is updated at a time?) then go MyISAM
InnoDB stores data completely differently than MyISAM. It's in the
ibdata.0 file or something. No directories are made.
table locking prevents alterations to a table while an update is going on
(i think). InnoDB tables can do row-level locking, but MyISAM tables can
only lock the entire table.
that means that your 'inserts' and 'updates' happen right away, no
transaction type of action
most of these questions can be answered with a MySQL book or at the very
least some googling
- » [ANNOUNCE] Mogwai ER-Designer 0.9.7 and FormMaker 0.6 available
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum