JFL> Can i get more speed by disabling InnoDB tables, if I'm only using
JFL> MyISAM and HEAP tables?
JFL> Any warnings about this?
If your server is need more resources ( memory , etc... ), Yes.
The InnoDB only uses processor if the tables typped "InnoDB" are used , but the
memory is allocated.
to disable the InnoDB only put this line:
skip-innodb
in your my.cnf on [mysqld] section.
but, only disable InnoDb not get more speed in your application ,
check the variables:
key_buffer
join_buffer
sort_buffer
This variables are very important in case of MyISAM tables.
no warnings
bye,
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--
$ look into "my eyes"
look: cannot open my eyes
-------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
---------------------------------------------------------------------
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
