BlaDe: I get that. i am.

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?

Brittman: Http://

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?

Brittman: DaveBar:

Samlal: Brittman: checking buffer_pool_size with query as shown here 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

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?

Belgrave: My data dir is set to /var/lib/mysql and my bin dir is /var/spool/mysqllogs. Why is Mysql writing to /tmp?

Kjeldgaard: Http://

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:

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