←Prev date Next date→ Show only urls(Click on time to select a line by its url)
WhoWhatWhen
panamausjoined #tikiwiki [01:54]
.............................. (idle for 2h26mn)
zlinuxjoined #tikiwiki [04:20]
........ (idle for 38mn)
zlinux_joined #tikiwiki [04:58]
...................................... (idle for 3h5mn)
zlinuxjoined #tikiwiki [08:03]
........ (idle for 38mn)
joined #tikiwiki [08:41]
zlinux_joined #tikiwiki [08:43]
.... (idle for 15mn)
Tiki|botRecent Bug: - http://dev.tiki.org/item6447 [08:58]
.................. (idle for 1h27mn)
zlinuxjoined #tikiwiki [10:25]
.... (idle for 17mn)
amette_joined #tikiwiki [10:42]
..... (idle for 21mn)
tibojoined #tikiwiki
hi everyone
somebody can help me ?
with tracker 		[11:03]
Jyhem_joined #tikiwiki [11:17]
.............. (idle for 1h5mn)
robertokirjoined #tikiwiki [12:22]
redflojoined #tikiwiki [12:29]
RadoSMoin, how can I find out which mysql type I've selected at install time? [12:34]
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 [12:42]
........ (idle for 36mn)
RadoSamette_, 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?
relevant => stored
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:18]
Also, in the dump I see tiki_pages is innoDB, but other tables are not... so that selection just matter for that table? [13:28]
amette_left #tikiwiki
joined #tikiwiki 		[13:42]
chibaguyjoined #tikiwiki
polom 		[13:45]
amette_left #tikiwiki
joined #tikiwiki 		[13:58]
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?
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:03]
.... (idle for 16mn)
Jyhem_laptopjoined #tikiwiki [14:20]
zlinuxjoined #tikiwiki [14:31]
RadoSOk, that is/ would be good, so I don't have to correct it afterwards.
The Engine selection is stored in the dump, so it's restored 1:1. 		[14:36]
amette_exactly. You can also just edit the dump with an editor and change the engines to make them all the same. [14:37]
RadoSBut... 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:37]
RadoSLike full-text search. [14:38]
amette_pretty good question, I got no idea [14:38]
RadoSRadoS nods. [14:38]
amette_Also: I think full-text search is available in InnoDB nowadays, no!? [14:39]
RadoSI though ISAM was lacking it while innoDB had it all along?! :)
+t 		[14:39]
amette_oh, ok, hehe, not sure now *g* [14:39]
RadoSI think that was why I chose innoDB back then, because people were complaining search failed in the old mediawiki. [14:40]
amette_hmmmm.....
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:40]
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:47]
RadoSI trust the installer to do the "right thing".
I chose innoDB when I installed 1st time, so I stick with it. 		[14:54]
amette_Sounds good! *thumbsup* [14:55]
RadoSACID _might_ have been a reason, but I don't remember now anymore. ;) [14:55]
...... (idle for 26mn)
amette_left #tikiwiki
joined #tikiwiki
left #tikiwiki
joined #tikiwiki 		[15:21]
........ (idle for 35mn)
arildbjoined #tikiwiki [15:58]
............. (idle for 1h0mn)
Tiki|botRecent Bug: - http://dev.tiki.org/item6448 [16:58]
................ (idle for 1h18mn)
amette_left #tikiwiki [18:16]
joined #tikiwiki [18:24]
.... (idle for 15mn)
fabriciusjoined #tikiwiki [18:39]
Telesightjoined #tikiwiki [18:48]
................. (idle for 1h23mn)
Jyhem_laptopjoined #tikiwiki [20:11]
fabriciusjoined #tikiwiki [20:22]
←Prev date Next date→ Show only urls(Click on time to select a line by its url)