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

Sun Aug 31 08:18:47 GMT 2014

Thank you for the insights.

MyISAM does not provide relational keys (not sure about recent
enhancements).
Although we don't rely on it completely we will move towards it going
forward.

Regards,
Prasad

*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 Sun, Aug 31, 2014 at 11:42 AM, Marcin Derlukiewicz <
marcin.derlukiewicz at netinteractive.pl> wrote:

> It all depends. When you need to select lot of sorted records myisam is
> still faster coz inno uses gen_clust_index for sorting.
>
> The other thing is that innodb always needs tunning. You cat work on
> default settings with myisam, but innodb always require you to tune
> settings.
>
> third thing is fulltext. If you need fulltext on inno you need mysql
> 5.6.4+ and it's not available on some hostings ( and some people still
> thinks that there is no full text in inno so they keep myisam :P )
>
>
> 2014-08-30 16:44 GMT+02:00 Prasad <prasad at vtiger.com>:
>
>>  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/
>>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
>
> --
>
>
> Marcin Derlukiewicz
>
> Programista
>
> kom: +48 604 956 498
>
> e-mail: marcin.derlukiewicz at netinteractive.pl
>
> http://netinteractive.pl
>
> http://www.facebook.com/netinteractivepl
>
>
> Adres:
>
> City Gate
>
> ul. Ogrodowa 58, 00-876 Warszawa
>
> NIP: 9521925604 REGON: 142403831
>
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140831/974b52ca/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/20140831/974b52ca/attachment-0001.png>