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

[Marcin Derlukiewicz]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140831/f1584ab5/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/f1584ab5/attachment-0001.png>