Sudo stop mysql; sudo start.

Tarkowski: Examined rows – rows of table which columns are examined in where? Correct?

Bancourt: Stodghill: i don’t want to use raw devices, but I want to keep the 16k block size. i’m just not familiar enough with mdadm yet to know for sure how it will work in this case

Plank: Off to a bad start though, mkfs.ext4 says my alignment is off by 8k

Aegerter: Even if I tell gdisk to align at 128k

Stodghill: I doubt you’re going to see any notable difference attempting to change chunk sizes of your raid stripe. You aren’t going to be flushing just 1 innodb page at a time, so having a chunk size = 16kB won’t really matter much. If you’re concerned about performance differences at that level I would recommend using a hardware RAID controller first.

Eisentrout: Not an option in this case unfortunately

Robey: Stodghill: and it is chunk sizes 16k that I’m worried about

Heroth: Anyone know why we’d experience long semaphore waits 14000+ transactions that are typically microseconds stacking up to 15 seconds when InnoDB’s clearly not syncing or log flushing. the adaptive has index portion shows 330MB InnoDB checkpoint on a 1900MB InnoDB log file so less than the 75% threshold and 0 pending log/chkp writes.

Traugh: Does anyone know how to use the information_schema.tokudb_lock_waits table?

Traugh: I’m trying to eventually join it to information_schema.processlist so that I can identify which queries are being affected by locks, but my joins don’t seem to be correct:

Retherford: Does mysql validate utf-8 strings in queries, as in check if the byte stream is actually correct utf8?

Decoux: Retherford: why would it?

Decoux: Anyway, it’s pretty easy to test.

Malouff: Hoping someone can help me in the right direction on this issue: I am trying to see if there are any overlapping meetings. I am trying to check with my query if there are any meetings between 10:00 – 11:06

Traugh: Retherford: iirc, if you put a utf8-mb4 character into a utf8 field, it will truncate the string

Traugh: Retherford: at least sometimes :

Retherford: Guess ill just scrub all the input for invalid utf8, sounds like the correct thing to do anyway

Venezia: Vacho: where.and start between start time and end time OR end between start time and end time

Venezia: That won’t count long meetings

Decoux: What is an arad pilot, anyway?

Carcia: Venezia: I am all ears.

Venezia: Arada is a ship from escape velocity: override, an excellent late-90’s game. i signed up for something using this name after playing it.probably 15 years ago, and then just kept using it, as it’s a name that’s always available

Picketts: Venezia: I was just going to say, I can’t believe it wasn’t taken.but it makes sense now

Venezia: Start=end and end=start

Venezia: Where start_field=’end time’ and end_field=’start time’

Sayas: Venezia: I don’t think using = is correct

Liloia: A meeting can end and start at 11.00 without being double booked

Masser: SELECT * FROM dgs.meetings;select count* as aggregate from meetings where location_id = 3 and start ‘2015-10-05 12:00:00’ and end ‘2015-10-05 11:30:00’

Hambly: Select count* as aggregate from meetings where location_id = 3 and start ‘2015-10-05 12:00:00’ and end ‘2015-10-05 11:30:00’ **

Hjalmarson: I think this is correct.

Kirt: Hey I have a really weird issue

Didlake: I have mysql installed in a VM

Venezia: Well, it depends on if a meeting that ends at the start time of the other is considered overlapping

Nickolas: I cannot connect if I ‘sudo mysql -u root’

Skane: I *can* connect after I reboot the VM

Llarena: Obviously I already have a workaround but this seems pretty weird right?

Balo: I’ve restarted mysql multiple times

Oats: Sudo stop mysql; sudo start mysql