#mysql
02 October 2007
Total 26 pages. You are browsing page 1/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Tue Oct 02 00:00:43 2007
00:04 <****> hi
00:06 <****> are you able to pass something like (('key','data'),('key2','data'),('etc','etc')) into a stored procedure later to be used in a INSERT INTO tbl (col1,col2) VALUES () statement?
00:06 <****> (a, b) VALUES (1,2), (3,4), (5,6);
00:07 <****> ANSWER NOT FAST ENOUGH
00:07 <****> i bj on that
00:08 <****> i mean
00:08 <****> kb
00:08 <****> ooooh
00:15 <****> is there a maximum size that innodb_buffer_pool can go? I'm using a 64-bit binary and it won't go any higher than 16Gig
00:18 <****> helloooooooooooooooooooooooo room!
00:19 <****> Hi. Where would I look for string-manipulation functions? ideally I'd like regex substitution --
00:20 <****> mysql can do regex matching, but that's about it. There is a replace() text function.
00:20 <****> aha.
00:20 * dash looks it up
00:20 <****> anyone here deal with more than 16G memory for innodb pool?
00:20 <****> dash: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
00:21 <****> does anyone know if it is possible to restore from a specific time period using a differential backup?
00:22 <****> ki77a77: looks like this'll do the the trick, thanks :)
00:23 <****> dash: happy to help.
00:24 <****> chadmaynard: What do you mean by "XY problem"?
00:25 <****> Is that a reference to male DNA?
00:25 <****> no
00:25 <****> gfhghgfhfg: no.
00:25 <****> the_wench: xy problem?
00:26 <****> !tell gfhghgfhfg about xy problem
00:26 <****> gfhghgfhfg
00:26 <****> !tell gfhghgfhfg about xy
00:26 <****> gfhghgfhfg The X-Y problem is when you want to do X, but you don't know how. You think you can hack X if you can just do Y, but you don't know how to do Y either. You ask (us) for help with Y. We think Y is a strange problem to want to solve... So just ask us about X.
00:26 <****> !wench learn xy problem is The X-Y problem is when you want to do X, but you don't know how. You think you can hack X if you can just do Y, but you don't know how to do Y either. You ask (us) for help with Y. We think Y is a strange problem to want to solve... So just ask us about X.
00:26 <****> I have learnt xy problem is The X-Y problem is when you want to do X, but you don't know how. You think you can hack X if you can just do Y, but you don't know how to do Y either. You ask (us) for help with Y. We think Y is a strange problem to want to solve... So just ask us about X.
00:27 <****> lol
00:27 <****> lol
00:28 <****> olo
00:30 <****> ki77a77: why did you /version me?
00:31 <****> because I chose to.
00:31 <****> stop that.
00:32 <****> I appreciate your input, and will waste no time putting it into effect.
00:32 <****> Is there a way to do a date difference (like DATEDIFF()) but with avoiding some dates (e.g. avois weekEnd, 2007-04-05 ...) ?
00:33 <****> hehe
00:33 <****> failed turing test? ;)
00:33 <****> what an ass
00:34 <****> progzy: eh not using just the standard date functions. You'd have to figure out how many you wanted to skip and subtract...
00:35 * chadmaynard will be nice
00:36 <****> chadmaynard: thanks. I try to put that inside a where condition but can not see how to proceed .. It may be impossible in one query ?
00:36 <****> progzy: you just want to skip weekends?
00:37 <****> and some dates in a table
00:37 <****> progzy: you can select count(0) of the dates between start and end date and subtract
00:37 <****> that'd be easy in one query
00:42 <****> I can not see the query ... :\
00:43 <****> progzy: I assume you are given a start and end date?
00:43 <****> yes
00:43 <****>x_days
00:44 <****> and you want to subtract from the datediff right
00:44 <****> ?
00:44 <****> x_days is a php var/constant
00:44 <****> ok
00:45 <****> But I need to consider Hollydays (I have a table for them) and Week Ends
00:45 <****> when substracting
00:47 <****> progzy: can you think of any way to determine the dates of weekends?
00:48 <****> you can either use date functions or insert them into your table
00:48 <****> Maybe with a php code
00:48 <****> or yes inset them in the table
00:48 <****> well you could use php
00:49 <****> What if I have all dates in one table ?
00:49 <****> what about it?
00:49 <****> There is a way to avoid them ?
00:50 <****> what do you mean?
00:50 <****> I don't understand how I could count the days betweens 2 dates avoiding dates in the "date table"
00:51 <****> You talked about a "SELECT COUNT" ...
00:52 <****> yes you select count where datecol between start and end;
00:54 <****> are you only wanting one datediff?
00:54 <****> or many?
00:54 <****>x_days ...
00:55 <****> I just need to count correctly
00:55 <****> considering WE and hollydays
00:56 <****> So "one date diff " would be the answer
00:56 <****> to your question
00:56 <****> x
00:58 <****> select count would count hollydays and week ends ...
00:58 <****> I see ...
00:58 <****> right
00:58 <****> Is it possible to throttle connections?
00:59 <****> total days minus days off = work days
00:59 <****> brilliant!
00:59 <****> err queries
00:59 <****> JymmmEMC: per user?
00:59 <****> JymmmEMC: yeah, by limiting max number of threads. :)
00:59 <****> chadmaynard: possibley
01:00 <****> dkr: That's a hard limit and when hit, just cuts em off completely... I don't want to put them into DT's
01:00 <****> nod, was just joking. I do it with my application code and advisory locking
01:01 <****> mysql sometimes causes too much load, when i TOP it, how to control it?
01:01 <****> Well, on a virtual host, the idiots will download anything.... just look at phpmybb
01:01 <****> But I don't think there a simple way to count week ends between 2 dates ...
01:02 <****> Moreover some dates to avoid are annualy (flag for it in the hollydays table)
01:02 <****> progzy: there is code to calculate day of week
01:02 <****> If you just cut em off, then the phone goes off the hook "OMG MY SITE IS DOWN AND I"M LOOSING BILLIONS OF DOLLARS"
01:02 <****> but you could just populate the days off table with all weekend dates in addition to holidays
01:03 <****> or add another table with Week ends yes ...
01:03 <****> ew
Total 26 pages. You are browsing page 1/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last