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: http://pastie.org/10408563
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: http://pastie.org/10408760 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