#mysql
11 November 2007
Total 18 pages. You are browsing page 4/18.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
02:21 <****> You specifically would want to review the "Data type" chapter
02:23 <****> !man data type
02:23 <****> (Column Types) : http://dev.mysql.com/doc/mysql/en/data-types.html
02:28 <****> anyone know how I can backup a mysql database without being root?
02:28 <****> _Lemon_: Thanks!
02:43 <****> What format was the video you created last time?
02:43 <****> er, wrong window, ignore that
02:45 <****> HI, I have a application that make some queries into a db every 10 seconds. I have it running now like for 4 days and it is using 959mb of the ram
02:45 <****> is there a way to prevent that the queries stay on the ram
02:45 <****> or to flush them every certain time
02:48 <****> your application is taking 959 mb?
02:53 <****> Golumn: if it your application that is taking up the memory then its your own fault :p
02:53 <****> Golumn: are you closing result sets after you're done with them?
02:59 <****> ToeBee, I think that is the problem, I don't close the result sets
03:00 <****> Golumn: look at your language's API and see how to do that
03:00 <****> thanks
03:03 <****> when writing mysql applications, do you want to limit the number of queries you submit to the database, or do you want to limit the complexity of the queries?
03:05 <****> tetsu, primarily the latter. The former is good too.
03:05 <****> that's completely not an answer.
03:05 <****> : )
03:05 <****> tetsu, "complexity" of course doesn't necessarily mean how long it is, but how time-consuming and inefficient it is for the engine to execute.
03:05 <****> yeah
03:05 <****> like if you have your data normalized
03:06 <****> so you're JOINing tables together frequently
03:06 <****> if the database is designed correctly then you can still do "complex" queries in very short amounts of time
03:06 <****> but say you have a user table and only use the user name once
03:06 <****> tetsu, joins aren't a big problem per se. Inability to use indexes for things like retrieval and sorting is a bigger problem.
03:07 <****> would it be better to select the name so it's in every result related to the name, just so you only have one query
03:07 <****> or have two queries, selecting the name once
03:07 <****> and only joining maybe 3 tables
03:07 <****> tetsu, give example queries? Not sure what you're saying.
03:07 <****> I don't think there is one answer to this question
03:08 <****> hi - i have a sql dump with the date being in the 'mm/dd/yyyy' format (since it didnt' come from mysql) how do i import it into mysql correctly?
03:08 <****> Washington, District of Columbia (USNS) - Gathered on the steps of the
03:08 <****> Justice Department, gay niggers worldwide announced their most ambitious ploy
03:08 <****> for political power to date, a boycott of all foods that make semen taste
03:08 <****> awful. GNAA president timecop led the rally with a pink megaphone, shouting
03:08 <****> over the noise of riot cops assembling in case the peaceful assembly turned
03:08 <****> violent.
03:08 <****> it depends on the data, the design and what you are doing with it
03:08 <****> !ops
03:08 <****> ToeBee: talking to me
03:08 <****> (Does anyone actually listen to !ops, anywhere, or is it some random meme that people always helplessly try?)
03:08 <****> "My friends," he lisped at the top of his lungs. "As America's - no, the
03:08 <****> world's - foremost consumers of sperm and without a doubt its greatest enjoyers
03:08 <****> and advocates, we plead - no, we demand - that these prostate poisons be
03:08 <****> eliminated from the modern diet." Around him, a surging throng of foamy
03:08 <****> ?
03:08 <****> devotees showed their approval with a shower of bodily fluids.
03:08 <****> um....
03:08 <****> ferric: no. tetsu :)
03:08 <****> oh great
03:09 <****> According to timecop, numerous studies prove that gay volunteers not only
03:09 <****> found that tobacco left a lingering moldy taste in semen, but that such
03:09 <****> commonplace items as coffee and multivitamin pills could make semen taste muddy
03:09 <****> and like insecticide, respectively. "These are intolerant, I mean, intolerable
03:09 <****> substances," timecop spluttered.
03:09 <****> not again :/
03:09 <****> HorehoundCandy: stuf plz. kthxbye
03:09 <****> that's pretty awesome.
03:09 <****> GNAA member DiKKy, on loan from NATO class dunce Norway, as if on cue dumped
03:09 <****> a 55 gallon drum of whipped semen into the Justice Department's Martin Luther
03:09 <****> King, Jr. meditative koi pond. As carp drowned in the sticky mucosal fluid,
03:09 <****> DiKKy took the microphone from a timecop overcome by emotion at the sacrifice
03:09 <****> of so much precious gay nigger seed. "Gummy bears make it taste like rubber
03:09 <****> cement - no, that's not a pun.
03:09 <****> I wish I could spam channels.
03:09 <****> ah ok
03:09 <****> errr
03:09 <****> Hey, how do you do that?
03:09 <****> it must take an awful lot of technique
03:09 <****> And salmon, of course," said DiKKy, "which makes
03:09 <****> it taste oily. Oh, and here's a big no-no: asparagus. Yucky.
03:10 <****> http://TrollingForWorldPeace.on.nimp.org/ We are good trolls with a noble mission, to bring about world peace!!!!! Check out our website....we are 600 members strong and bombarding chats and forums across the web. This mysql chat is being shown live on our website. GNAA 4EVER
03:10 <****> HorehoundCandy: stop spamming please
03:10 <****> DFTT.
03:11 <****> salle: That website you gave for the sqlcourse is excellent thank you very much!
03:11 <****> damn. looks like most of the ops are not here right now :/
03:11 <****> free reign
03:11 <****> ToeBee, certainly, you should be promoted.
03:11 <****> Back at the rally, timecop sniffed in response. "Like his ugly fat bitch of
03:11 <****> a wife will ever give him this kind of head," he said, demonstrating on Morgan
03:11 <****> Freeman, who happened to be passing on his way to testify before a Senate
03:11 <****> committee on racial discrimination in the color of fingernail clippers. "Desist
03:11 <****> -- cease, I say!" began Freeman, but then, in his characteristic basso
03:11 <****> profundo, began moaning rhythmically to the motion of gay nigger tongues.
03:11 <****> hmmm
03:11 <****> yay!
03:11 <****> sweet
03:11 <****> k-line FTW
03:12 <****> damn that Erik
03:12 <****> he obviously didn't want to stay on freenode :)
03:12 <****> :)
03:12 <****> lol
03:12 <****> well that i dont get
03:12 <****> anyway
03:13 <****> Simetrical, would I rather use SELECT name, product, order_date FROM users JOIN products JOIN orders when I only use the name once in my application, or would I rather use SELECT name FROM users ...., then SELECT product, order_date after
03:14 <****> i mean its a bad example but the question is there
03:14 <****> like some people use SELECT * as their queries
03:14 <****> tetsu, either one works, do whichever is convenient. Both should be about equally fast.
Total 18 pages. You are browsing page 4/18.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last