[Vtigercrm-developers] MyISAM or InnoDB - what is the preferred database engine of vtiger 6.1?

[Prasad]

InnoDB is preferable. Please the default engine type to the same.

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I* Facebook
<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall> *I* Blog
<https://blogs.vtiger.com/>* I* Wiki
<http://wiki.vtiger.com/index.php/Main_Page> *I *Forums
<https://discussions.vtiger.com>*I* Website <https://www.vtiger.com/>


On Sat, Aug 30, 2014 at 4:18 PM, Holbok István <holbok at gmail.com> wrote:

>  Dear vtiger Team,
>
> One of my vtiger 6.1.0 EA instance has a totally different MySQL database
> structure then others.
> If I knew well, the preferred database engine of vtiger 6.1 is *InnoDB *due
> to using foreign_keys.
> In a my XAMPP / *MySQL 5.5* instance all table was InnoDB.
> In an other XAMPP instance with *MySQL 5.6* all table was InnoDB as well.
>
> I have just checked an other instance LINUX (CentOS, C-panel, MySQL 5.6.17)
> The MySQL basic setup (in my.cnf file) was the same as in the Windows
> /XAMPP MySQl 5.6 -> the default database engine was InnoDB (this is the 5.6
> default).
> But the vtiger instance has InnoDB engine in only ~20% of table, all other
> table engines is MyISAM.
>
> It indicates there is some *uncertainty *and the SQL table install
> depended in this case from some environment variables.
>
> The file .../schema/DatabaseSchema.xml  defines InnoDB engine for all
> tables.
> The function *initialize()* in .../modules/Install/models/InitSchema.php
> uses it: $adb->createTables("schema/DatabaseSchema.xml");
> But in this case the result failed as it shown here (under the
> screenshoot, printable part of phpmyadmin output):
>
>
>
>
>  Tábla Sorok Típus Méret Megjegyzések  com_vtiger_workflows 23 MyISAM 10.7
> KB   Létrehozva: 2014. Aug 28. 18:45  Utolsó frissítés: 2014. Aug 28.
> 19:22    com_vtiger_workflows_seq 1 MyISAM 1 KB   Létrehozva: 2014. Aug
> 28. 18:45  Utolsó frissítés: 2014. Aug 28. 18:46
> com_vtiger_workflowtasks 22 MyISAM 21.9 KB   Létrehozva: 2014. Aug 28.
> 18:45  Utolsó frissítés: 2014. Aug 28. 19:22
> com_vtiger_workflowtasks_entitymethod 10 MyISAM 4.1 KB   Létrehozva: 2014.
> Aug 28. 18:45  Utolsó frissítés: 2014. Aug 28. 18:46
> com_vtiger_workflowtasks_entitymethod_seq 1 MyISAM 1 KB   Létrehozva: 2014.
> Aug 28. 18:45  Utolsó frissítés: 2014. Aug 28. 18:46
> com_vtiger_workflowtasks_seq 1 MyISAM 1 KB   Létrehozva: 2014. Aug 28.
> 18:45  Utolsó frissítés: 2014. Aug 28. 18:46
> com_vtiger_workflowtask_queue 0 MyISAM 1 KB   Létrehozva: 2014. Aug 28.
> 18:46  Utolsó frissítés: 2014. Aug 28. 18:46
> com_vtiger_workflowtemplates 0 MyISAM 1 KB   Létrehozva: 2014. Aug 28.
> 18:45  Utolsó frissítés: 2014. Aug 28. 18:45
> com_vtiger_workflow_activatedonce 0 MyISAM 1 KB   Létrehozva: 2014. Aug
> 28. 18:45  Utolsó frissítés: 2014. Aug 28. 18:45
> com_vtiger_workflow_tasktypes 7 MyISAM 2.5 KB   Létrehozva: 2014. Aug 28.
> 18:45  Utolsó frissítés: 2014. Aug 28. 18:45    etc.etc.
>
>
> How to handle it?
>
> Kindest regards:
> István
>
> --
> üdvözlettel:
>
> *Holbok István*
>
> +3670-342-0900
> *e-mail:* holbok at gmail.com
> *SkyPe:* holboki
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140830/90db6e4b/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: innodb.png
Type: image/png
Size: 323233 bytes
Desc: not available
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140830/90db6e4b/attachment-0001.png>