[01:54] panamaus joined #tikiwiki [04:20] zlinux joined #tikiwiki [04:58] zlinux_ joined #tikiwiki [08:03] zlinux joined #tikiwiki [08:41] zlinux joined #tikiwiki [08:43] zlinux_ joined #tikiwiki [08:58] Tiki|bot Recent Bug: - http://dev.tiki.org/item6447 [10:25] zlinux joined #tikiwiki [10:42] amette_ joined #tikiwiki [11:03] tibo joined #tikiwiki [11:03] tibo hi everyone [11:03] tibo somebody can help me ? [11:04] tibo with tracker [11:17] Jyhem_ joined #tikiwiki [12:22] robertokir joined #tikiwiki [12:29] redflo joined #tikiwiki [12:34] RadoS Moin, how can I find out which mysql type I've selected at install time? [12:42] amette_ RadoS : https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html will tell you the engine used to create the table [13:18] RadoS amette_, thanks, but is the choice myISAM vs. innoDB relevant only there, or does tiki/php save it somewhere, too, so to know which features are available and which not? [13:18] RadoS relevant => stored [13:19] RadoS I installed an original tiki in innoDB, now for testing and trying out I chose myISAM, but used a backup-dump from the original install with innoDB. [13:28] RadoS Also, in the dump I see tiki_pages is innoDB, but other tables are not... so that selection just matter for that table? [13:42] amette_ left #tikiwiki [13:42] amette_ joined #tikiwiki [13:45] chibaguy joined #tikiwiki [13:46] chibaguy polom [13:58] amette_ left #tikiwiki [14:00] amette_ joined #tikiwiki [14:03] amette__ RadoS: it's only ever relevant at table creation time. One can create databases with mixed engine tables, no problem. Might it be that you used a dump from a Tiki created with InnoDB and then ran the upgrade with MyISAM, so that the new tables were created with MyISM? [14:04] amette__ afaik Tiki doesn't store the choice anywhere, it's just the selection in the installer to choose with which "Engine=" option the create table statements will be generated. (Haven't looked at that code for a long time any more.) [14:20] Jyhem_laptop joined #tikiwiki [14:31] zlinux joined #tikiwiki [14:36] RadoS Ok, that is/ would be good, so I don't have to correct it afterwards. [14:37] RadoS The Engine selection is stored in the dump, so it's restored 1:1. [14:37] amette_ exactly. You can also just edit the dump with an editor and change the engines to make them all the same. [14:37] RadoS But... apparently some feature depend on this, how does the code know what works & what not? [14:37] amette_ Which is not needed as you mentioned in your first sentence, but if you want to tune for a special case, it is good. [14:38] RadoS Like full-text search. [14:38] amette_ pretty good question, I got no idea [14:38] * RadoS nods. [14:39] amette_ Also: I think full-text search is available in InnoDB nowadays, no!? [14:39] RadoS I though ISAM was lacking it while innoDB had it all along?! :) [14:39] RadoS +t [14:39] amette_ oh, ok, hehe, not sure now *g* [14:40] RadoS I think that was why I chose innoDB back then, because people were complaining search failed in the old mediawiki. [14:40] amette_ hmmmm..... [14:42] amette_ Since MySQL 5.6 both support full-text search, didn't find yet which one didn't before, but I'm rather sure it was InnoDB... [14:47] amette_ Anyway... Reason for InnoDb has for years been: ACID-compliance. Which is not that critical in a web application like Tiki. Downside was no full-text search and maybe performance. Both are fixed nowadays afaik, so you should try InnoDB for all your tables, if you can. [14:54] RadoS I trust the installer to do the "right thing". [14:55] RadoS I chose innoDB when I installed 1st time, so I stick with it. [14:55] amette_ Sounds good! *thumbsup* [14:55] RadoS ACID _might_ have been a reason, but I don't remember now anymore. ;) [15:21] amette_ left #tikiwiki [15:21] amette_ joined #tikiwiki [15:23] amette_ left #tikiwiki [15:23] amette_ joined #tikiwiki [15:58] arildb joined #tikiwiki [16:58] Tiki|bot Recent Bug: - http://dev.tiki.org/item6448 [18:16] amette_ left #tikiwiki [18:24] amette_ joined #tikiwiki [18:39] fabricius joined #tikiwiki [18:48] Telesight joined #tikiwiki [20:11] Jyhem_laptop joined #tikiwiki [20:22] fabricius joined #tikiwiki