Colker: I really have never seen MySQl just randomly shut down though. ever
Suran: Hello, is inner join without any constraint no on keyword is same as full join
Umfleet: Thank you, can you tell me what is the difference?
Bogany: Brittman: results show engine innodb statusG , as you said lots info : so yes innodb is running :
Brittman: _Zodiac: use it, first check innodb_log_file_size and innodb_buffer_pool_size
Kar: So if both tables are not empty are they equal?
Samlal: Brittman: checking buffer_pool_size with query as shown here http://dba.stackexchange.com/a/27341 outcome here was/is 1 so setting it to 1GB should be okay
Guethle: Brittman: checking innodb_log_file is done how?
Sharpton: Brittman im asking about normal join not cross join
Brittman: _Zodiac: if you convert existing myisam tables to innodb your calculation might change. do you run any other services here like mail or web?
Brittman: DaveBar: “inner join without any constraint no on keyword”
Zomora: DaveBar: Just to be clear, inner join requires an ON clause, even though MySQL allows it. It’s like a cross join. A full join is an outer join, not an inner join.
Howells: Brittman: yes a Forum which already uses Innodb and for mail it runs on same server but have no clue how to check that to be honest
Brittman: _Zodiac: normally you set buffer pool to ~70% of RAM available, you have to subtract what the web/mail services use from that
Brittman: _Zodiac: you don’t have existing myisam data? du -shc /var/lib/mysql/*/*MYID tail -1
Koehler: DaveBar: Also note that a full join without effcetive joincriteria ON 1 = 1, is just like an inner join with ON 1 = 1. Every row in t1 matches every row in t2 with no missing matches.
Yeeloy: Just upgraded wb and also using linux 14.04 but same issue
Blume: Brittman: result du -shc /var/lib/mysql/*/*MYID tail -1 = 95M
Menghini: It seems to be a known issue http://bugs.mysql.com/bug.php?id=74147
Rutten: DaveBar: Both strictly require an ON clause per the standard. You should always provide one.
Glimp: What happens if i add an auto-increment column to a populated table?
Scandurra: How can i know what versio nof libglib veresion ?
Yeary: Mices: You can try it.
Brittman: W00tner: dpkg -l grep -i glib
Aery: Ii libglib2.0-0:amd64 2.40.2-0ubuntu1 amd64 GLib library of C routines
Brittman: Mices: create table t2 like t1; insert into t2 select * from t1 limit 100;
Doolen: Mices: If you don’t understand the result / behavior, that’s a good time to ask. Use a test table.
Naderi: It’s been reported that downgrading libglib2.0.0 from 2.42.01 to 2.40.0 solves this problem.
Siregar: So my version is 2.0.0 it needs to be 2.42.41 ?
Brittman: W00tner: ask #ubuntu-server or #ubuntu for advice which may be a new lts
Turcios: Brittman: settings as show here should be okay? http://pastie.org/private/mgix0nlnfyljdgnmkq7gg
Belgrave: My data dir is set to /var/lib/mysql and my bin dir is /var/spool/mysqllogs. Why is Mysql writing to /tmp?
Parkin: Dovid: they’re temporary tables
Maraia: Brittman _Zodiac: normally you set buffer pool to ~70% of RAM available, we have vps with 6GB so I should set buffer pool to 4GB?
Ritari: Dovid: https://dev.mysql.com/doc/refman/5.0/en/temporary-files.html
Erceg: Brittman: how much data do you have?
Guzek: BlaDe: I get that. i am trying to figure out why it’s using /tmp and if I can change it? There is a lot of writing on alter table. OS is on spinners and /var/lib/mysql is a SSD