Typo3 upgrade and InnoDB

View: New views
4 Messages — Rating Filter:   Alert me  

Typo3 upgrade and InnoDB

by Pero Matic :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi. I tried upgrading Typo3 but all ALTER queries with InnoDB in them were
not executed (compare script never ends) because my hosting provider doesn't
support InnoDB. Now, my question is: will typo3 still function correctly? As
i understood InnoDB is used by indexed search engine but it can also use
MyIsam tables as well - is this correct? Thx!

Regards.


_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: Typo3 upgrade and InnoDB

by Ernesto Baschny [cron IT] :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Pero Matic schrieb:
> Hi. I tried upgrading Typo3 but all ALTER queries with InnoDB in them were
> not executed (compare script never ends) because my hosting provider doesn't
> support InnoDB. Now, my question is: will typo3 still function correctly? As
> i understood InnoDB is used by indexed search engine but it can also use
> MyIsam tables as well - is this correct? Thx!

It works, of course. The queries should "end". The conversion can take a
lot of time, especially if your cache tables and index tables are
"full". Try to clean them up before running the COMPARE and see if they
are not indeed converted to InnoDB.

If the hosting environment indeed does not support InnoDB, the
conversion simply won't be made (but it should not take forever, this
error should make it run "fast"). The COMPARE tool will then always
prompt for this ALTER TABLE statement, but you can ignore that: it will
work as before, only with the same problem you faced (or not) before,
that of whole-table locking (while records are being inserted, noone can
fetch or update it). Might not be a problem for your.

Cheers,
Ernesto
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: Typo3 upgrade and InnoDB

by Dan Osipov :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

It will work, however some tables give optimal performance when they're
InnoDB tables - like the cache tables. You may have some performance
issues if using MyISAM for those tables.

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Pero Matic wrote:
> Hi. I tried upgrading Typo3 but all ALTER queries with InnoDB in them were
> not executed (compare script never ends) because my hosting provider doesn't
> support InnoDB. Now, my question is: will typo3 still function correctly? As
> i understood InnoDB is used by indexed search engine but it can also use
> MyIsam tables as well - is this correct? Thx!
>
> Regards.
>
>
_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english

Re: Typo3 upgrade and InnoDB

by Pero Matic :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


"Dan Osipov" <dosipov@...> wrote in message
news:mailman.1.1257515830.29529.typo3-english@......
> It will work, however some tables give optimal performance when they're
> InnoDB tables - like the cache tables. You may have some performance
> issues if using MyISAM for those tables.

Thank you Ernesto and Dan. Regards.


_______________________________________________
TYPO3-english mailing list
TYPO3-english@...
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english