| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> This seems worse but it was mostly middle TN
<1> is there a way to limit the execution time for a particular query
<2> Therion, Don't you live in middle TN?
<0> will_: Yes
<3> lorfds: you can just kill the process
<4> never mind... I think I can do what I want with a hackish use of FIELD()
<1> jivedue -- yes, but i want this to be automatic
<1> i need time to figure out why it is bugged, and in the meantime it is stalling out my app
<1> i can kill it, but at the moment i am doing it manually
<2> Just write perfect queries the first time.
<1> i didnt write the query
<2> Maybe you should.
<1> it is part of a wiki app
<3> lorfds: put it on a cron job
<1> im going to
<1> but i dont have time to fix it at the moment
<0> lol
<3> Therion: you live anywhere close to springfield?
<0> I live in Clarksville
<2> What did I do?
<0> ie: I am 40 miles from SPringfield
<0> pretty much due west of it
<3> My dad, 2 sisters, and a brother live there.
<3> ahhh, I see it now
<0> Storms might have missed Springfield..they kind of forked
<0> south of there is getting chewed up though
<1> jivedue - can cron recognize a process in mysql and kill it when it exceeds its execution time?
<5> which is faster *like* or *fulltext*
<5> and by how much
<0> themoleste: Depends on the search
<0> lorfds: You can fairly easily script something to periodically check the processlist for long-running queries and terminate them.
<5> well what would make either faster
<3> lorfds: well just write a simple question to view the processlist and kill anything that takes long, and run it as a cron job
<0> themoleste: Lots of RAM.
<0> themoleste: Not doing dumb things.
<5> i got lots of ram
<5> so with lots of ram, which is faster
<1> Therion -- check as in every 1 second? -- or would this slow the server down
<0> themoleste: Then a biggish key_buffer_size and avoiding doing crazy things are your tips
<0> lorfds: Whatever period you need
<0> themoleste: THe original answer remains: it depends on the search.
<0> themoleste: And to some extent on the data distribution, size of data, etc etc etc
<5> well i said *search*
<0> Yeah but that means about nothing
<0> LIKE can do things fulltext cannot
<0> Without a specific example of what you would want to do, who knows
<6> how's it going will, will_?
<0> Life ****s for will
<0> because he does not have my manlove to sustain him
<6> :)
<6> why?
<5> well when i LIKE search* or =search i get like <1 - 2s when i *like* it is between 30-60secs
<3> that's so wrong
<3> Therion: isn't that illegal in TN?
<0> themoleste: Do you mean LIKE '%thing%'?
<5> err, ya... just a reflex using *s
<0> themoleste: If so: 1) That is a dumb thing to do 2) Fulltext cannot do it anyway 3) It's going to do a full index or table scan and it's going to ****, period
<6> Therion, that's funny... i've been givin him some manlove too
<0> But if that's what you have to do, you're stuck with LIKE
<0> Give more RAM, try preloading your indexes
<0> or find a better thing to do to your data ;)
<5> i use %like% as a failsafe... when = and like% dont match
<0> M3: That's why he doesn't have mine. Cheatin' hussy. :(
<6> :)
<0> themoleste: Yeah, but, it's a resource-intensive full index scan (***uming you have an index on the column)
<6> Therion, hussy? husband
<0> themoleste: No real way to improve the performance of that
<0> M3: What!!!
<3> themoleste: what is this for searching for in what again?
<5> so... i just have to buy a faster box? nothing else will help/
<0> M3: Now I know why you won't come see me :(
<0> themoleste: For that kind of thing? Pretty much
<3> careful, don't want to get picked up by a torndao..
<0> themoleste: It's not something that can get much more optimized than it is
<6> i just met u Therion
<0> themoleste: Having an index on the column will help... having key buffer large enough to cache the index in RAM will help...
<0> Jivedue: lol
<6> Therion, remember i'm the one who stole your man
<0> M3: You remember it, when you wake up in the night to find the knives bearing down on you
<0> hehe
<5> therion ... i have a key buffer large enough, and there is an index on the search column, but not on the order column
<6> easy Therion
<5> does key make sort faster?
<6> lemme enjoy my vacation
<5> or just the search
<0> themoleste: You're also probably incurring some filesorting... but basically LIKE '%token%' ****s, no matter what you do with it, if you have a non-trivial amount of data
<0> It's just not something that can be much more optimized than it already is
<6> nice nick Jivedue
<6> do u live in Vancouver too?
<3> Edmonton, AB
<3> and what do you mean "nice nick"?
<6> nice
<6> God's country
<5> well what about this... the system is smp ... but when mysql is raping at 99% ... it only uses one processor
<5> any way to make a single query, use multiple procs?
<7> is an odd name for a town in albania though :S
<8> Does anyone know how to fix this error? "Client does not support authentication protocol requested by server" I'm using the C API library and header files that came with the MySQL 5.0.19 installation and I am connection to a local MySQL 5.0.19 database.
<7> any idea why they called it edmonton ?
<3> yah, it's not easy being albertan.. all that oil money being poured into our economy.. those government checks to it's residents *sigh*
<6> i meant Jivedue is nice nick name
<6> but i read it as Jivedude
<6> :)
<6> sorry dude
<3> haha, noe one's ever said that to me before, but a lot of people read it as "Jivedude"
<5> ya sorry due err dude
<5> :)
<9> How could I delete all the rows in a table but the ones returned by SELECT * FROM table ORDER BY id DESC LIMIT 10;
<5> so... any way to make mysql work better with single query smp?
<6> i like themaximus too
<3> I like thenorris
<6> there's a hair salon called the Maximus in vancouver on Davie Street (the Gay street)
<10> colloid: Same way as with 25 :)
<6> Jivedue, thenorris or theChuck
<3> are you a follower?
<9> mendel: in one query... I needs to be at rigger
<6> follower of who Jivedue ?
<3> of the great chuck norris
<11> The one who does not sleep, but waits
<6> no
<6> not really
<6> is that whay he does sjrussel ?
<6> what's that TV series he plays in?
<3> Walker Texas Ranger
<6> right, thanks
<6> i like bruce lee better
<6> that guy was _fast_
<12> heh my friend spent the day with chuck norris about a month ago
<3> hansbrix: haha, how'd be get so blessed?
<12> she's a teacher at a school in portland
<12> he was there to give presentations to the cl***es there
<3> haha, what did he present on?
<12> she's a floater there, fills in cl***es
<12> so she had the time to entertain him between presentations
<12> i dont know actually, i think it was something anti-drug
<12> i'll ask her
<12> i see chuck norris 3 hours a day
<12> its just on exercise informercials
<12> so its not quite as personal i guess
<12> she said it was funny though cuz like none of the kids knew who he was
<12> it was a middle school
<3> that's probably the only reason he did it
<9> anyone know how to go about my problem?
<13> ask chuck norris
<13> he can solve anything
<12> Colloid: can you relate it to a chuck norris analogy?
<3> hansbrix: hahaha
Return to
#mysql
or
Go to some related
logs:
priority queue in php
gentoo init.d script eggdrop
XtermSplit
circular dependency. exiting
magical_trevsky
#mysql
#perl
#gaim
Atlantis IRC sakkath
kditty
|
|