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 http://dev.mysql.com/doc/refman/5.6/en/timestamp-initialization.html
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://pastebin.com/CE2jgVfb 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 – http://pastie.org/10428167 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