Wittmer: Have no idea how to check that. And googling just results in older results that uses commands that no longer work
Hux: The only working one I can find, is SHOW ENGINE INNODB STATUS; which gives me nothing I can understand
Edgemon: All transactions listed with that command, are all “not started”, and all file i/o threads are waiting for completed aio requests. There’s no pending log writes or chkp writes
Rumery: Ether_Man, then it seems there are no long running transactions. so it is quite improbable that the space were taken just by undo logs unless you hit some kind of bug. – did you do any alter on some big table?
Monsees: I do not touch the db directly normally. I have not myself done any alters on anything, but I cannot garantee anything about what zarafa does to it
Rumery: Some update in last week etc?
Rumery: Alter often copies entire table, so takes quite a lot of temporary space for big tables, and without file per table that tmp space is inside ibdata – so it may get inflated at some point and it is not possible to simply reclaim that space to filesystem – but it will be reused by other growing tables and similar operations
Danesh: Well, I”ll convert it to myisam and check. Worst case, I’ll have to restore the backup which I took like 5 minutes ago
Arnott: Do i need stanzas in my.cnf or can i leave them away?
Waldroop: I mean: can i have k=v pairs without any grouping?
Feehly: They have to appear inside some sort of group, like mysql or mysqld or client
Hevesy: So it knows which program they apply to
Charbonneaux: Snoyes: “port” f.e. has the same value in client or mysqld, so can i just specify it as a global variable? i.e. above the first stanza?
Radaker: Deever: nope, have to do it twice.
Schoepfer: Is it necessary to set a database collation? which one would it be? utf8_general_ci? i am running drupal
Wieck: Twisme: it isn’t, if you don’t set server default collation is used
Mcrenolds: Deever: if you don’t, you get an error, “error: Found option without preceding group in config file”
Sottile: Decoux, snoyes: ok, thanks
Frech: Twisme: and it only matters for tables that are created after setting collation and don’t set collation themselves
Pusey: I would expect correct collation to be set by Drupal installation scripts
Kerans: So it is okay if it is set to that defalt? 😀
Nazario: I never had problems with ä, ö, ü and such
Souliere: I was just wondering before transferring my localhost to productivity
Bangs: It seems that setting utf8 at the beginning saves headaches later.
Dunkin: Latin1 is fine if you only have English text, but eventually somebody will come along and say, “hey, we’d like to support Japanese” and then you have a lot of work to do.
Whaler: I was talking to a ‘wannabe’ superior today, who thinks about IT as ‘one click to solve it all’ generation Y, he was talking about “integrating” several independent databases. into OUR current client database. the problem is that, we know that the systems are not heterogeneous and that is what I was trying to explaining to him. I said that I need do***entation on the subject, because it’s impossible to determine which how way the schemas are going to
Sommer: Receive the imported data. Any ideas of how to come out of the situation?
Aggas: Djzn: what’s his reason for wanting to integrate them?
Shkreli: And by independent databases, do you mean different schemata on one MySQL server, or several different MySQL servers?
Lyell: Or not even MySQL servers?
Kuritz: Snoyes, there are previdency benefitiaries clients scattered a couple of government institutions.
Yasurek: They operated on a third-party tool who uses SQL Server
Feighner: So the plan is to migrate from SQL Server to MySQL?
Dobosz: Yes, independente databases, as in different schemas or similar schemas and different databases
Bligen: The plan is basically to “import” some public servant registries into the “main” database which is ours maintained by a third party in cloud