Reply to thread

Message

i have switch to InnoDB in Workbench directly !
For that
Open Workbench
Left Menu (select Edit tables)
Open mptvdb scheme
Right click on one table
select "Alter Table"
Switch Myisiam -> InnoDB
Select "Apply" & Close Tables
Make this for all tables (one by one)
Row_format : Dynamic (not changed)
Character_set : UTF8 default (not changed)
No error message in Workbench

For test : i have scanned DVB-S (2500 channel), i think configuration.exe freeze less compared to 5.1+Mysiam (my HTPC is really slow)
but many channel have 10000 as channel Number.

<blockquote data-quote="azzuro" data-source="post: 969809" data-attributes="member: 50482">i have switch to InnoDB in Workbench directly !For that<ul>
<li data-xf-list-type="ul">Open Workbench</li>
<li data-xf-list-type="ul">Left Menu (select Edit tables)</li>
<li data-xf-list-type="ul">Open mptvdb scheme</li>
<li data-xf-list-type="ul">Right click on one table</li>
<li data-xf-list-type="ul">select &quot;Alter Table&quot;</li>
<li data-xf-list-type="ul">Switch Myisiam -&gt; InnoDB</li>
<li data-xf-list-type="ul">Select &quot;Apply&quot; &amp; Close Tables</li>
<li data-xf-list-type="ul">Make this for all tables (one by one)</li>
</ul>Row_format : Dynamic (not changed)Character_set : UTF8 default (not changed)No error message in Workbench&nbsp;For test : i have scanned DVB-S (2500 channel), i think configuration.exe freeze less compared to 5.1+Mysiam (my HTPC is really slow)but many channel have 10000 as channel Number.</blockquote>

[QUOTE="azzuro, post: 969809, member: 50482"] i have switch to InnoDB in Workbench directly ! For that [LIST] [*]Open Workbench [*]Left Menu (select Edit tables) [*]Open mptvdb scheme [*]Right click on one table [*]select "Alter Table" [*]Switch Myisiam -> InnoDB [*]Select "Apply" & Close Tables [*]Make this for all tables (one by one) [/LIST] Row_format : Dynamic (not changed) Character_set : UTF8 default (not changed) No error message in Workbench For test : i have scanned DVB-S (2500 channel), i think configuration.exe freeze less compared to 5.1+Mysiam (my HTPC is really slow) but many channel have 10000 as channel Number. [/QUOTE]