General guidance only. play.

Danfield: Jak2000: so, a difference of 2 between the function returns

Danfield: Select dayname’2015-08-22′, weekday’2015-08-22′, dayofweek’2015-08-22’G

Kappler: How about MySQLFabric WeightedRoundRobin works?

Bluhm: I try to set weight ,but it doesnt work

Freisner: Xecycle: See

Roof: Brittman: “To specify automatic properties, use the DEFAULT CURRENT_.” so without that it defaults to nothing. Anyway, “FROM mysql:5.6” fails running that script, complaining Field ‘TimeStamp’ doesn’t have a default value.

Gruell: Brittman: “FROM mysql:5.5” succeeded, however. So the behaviour is different in mysql 5.5 to 5.6, and mariadb goes with 5.5?

Sorkin: Http:// Somewhere along the lines I think I ruined this query. It’s supposed to select all rows between a unixtimestamp range, but then it’s also supposed to select the oldest from object_revisions for each selected name. I think I have an extra “= 1438401600 AND . 1441080000” where I souldn’t but which isn’t jumping out at me. :

Nab: Sadtaco: aside from the horrible structure – how is maxunixtime the oldest?

Lofton: Could probably make a better query that accomplishes the whole thing.

Galbiso: I think. I’m supposed to find maxunixtime that is less than the start date that I’m searching

Okinaka: I think I mispoke a little.

Truesdell: I need to find the newest result that is older than the start date of my search.

Huseby: And get the min from a range with . ORDER by time ASC LIMIT 1;

Murry: I mispoke when I said I needed to get the oldest from object_revisions.

Bresette: Select . where . range_lower_limit order by unixtime desc limit 1; then

Hambright: I need to select all rows from objects and object_revisions and then of those selected rows, I need the most recent row that is older than the search dates.

Yaccarino: Okay fair enough, but if I like “SELECT . WHERE unixtime = . unixtime . UNION SELECT . WHERE unixtime = . unixtime” how do I then get . where . range_lower_limit for the matched name fields in the previous selects?

Frezza: I think you can write some test cases and carefully constuct a query

Speights: No I mean. if I do a select union, is there a way to use those returned results for another query to union as well?

Jett: I need to SELECT . WHERE name, type IN selected rows . Is there a way to do that?

Steese: Without duplicating the whole query twice

Swed: 41s for “checking permissions” on a table drop big table

Dambach: Swed: What version of MySQL are you running

Swed: Dambach, mariadb 10.0

Swed: But found some info about similar case 4 years old, so seems it happens

Dambach: The older cases are due to invalidating pages in the buffer pool that belonged to the table, that is fixed in MariaDB 10.0

Gustis: Sadtaco: guess – anyway – i’m off

Dambach: I would be interested to see a stack trace on the thread doing the drop table or perf top -p $pidof mysqld output to see what’s consuming time on that DROP.

Brunsting: Swed: looks like there is other stuff in the checking permissions state that isn’t being desribed as such.

Nysether: I dont’ get the “,. ” part on line 9.

Becerra: Sadtaco: continue with IFt1.unixtime t2.unixtime, t1.type, t2.type . and same for each other result you want in the output

Swed: Dambach, sorry, I was wrong : it is 5.5.33a-MariaDB – our other system is 10.0 but not this one

Pogue: And line 12 – don’t jion on the unixtime

Saladin: Sadtaco: No, we will not spoonfeed you. We’ll give you pointers, man pages, general guidelines, even web pages that you *actually* have to read. But don’t expect use to spoonfeed you. You can allways employ a MySQL Consultant for that.

Lorenc: General guidance only. play with that and know what a select statement does