| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> if you're going to do any selects, making the PK something that is organized for your primary select would be a *very good* thing
<0> as opposed to a random rowID
<1> when using UNION, how the heck am I getting different results for LIMIT 0,10 then LIMIT 10,10 (i.e. two seperate queries, I'm paging) than with LIMIT 0,20 ?
<2> which would not be a good thing
<0> Davey|Work, consistently?
<1> sjrussel, yes
<1> sjrussel, the difference I see, is that the first SELECT of the UNION doesn't return any results on the second page
<0> oh, in a UNION?
<1> yes
<3> are you sure that the LIMIT is being applied to the overall query and not the second query only?
<1> yup
<4> is there anything I can tweak to make a 3 table left join (with and OR clause run faster?)
<3> what is the query exactly?
<5> I'll certainly be doing selects where the primary key is in the WHERE clause. Is this what you mean by "organized for your primary select?"
<0> kindof
<4> Busy in here today
<1> you had to ask... hehe
<0> if you did selects by categoryID, for example, putting categoryID in the PK would be really good
<1> http://hashphp.org/pastebin?pid=6472 - you probably would prefer some formatting, right?
<0> rows near each other in the PK are near each other on disk
<0> so much faster to read
<4> my "explain" is http://rafb.net/paste/results/O3IUVu37.html
<1> http://hashphp.org/pastebin?pid=6473 - there formatting
<5> sjrussell: It sounds like you're talking about a composite key
<5> A PK made of multiple columns?
<0> could be
<0> in that case
<0> Davey|Work, that is the ugliest thing I've seen in a long time
<1> sjrussel, why thank you :)
<1> I'm proud of it! :D
<3> put paratheses around the queries, so you get (select...) UNION (select....) ORDER BY ... LIMIT
<0> does changing the values of constant columns in UNION work now?
<5> I've got two columns I'd like to index. One has is the PK and the other has no unique constraint, I just want to index on it. Both bigints
<0> 997, 998, etc
<0> that didn' youse to work
<1> HarrisonF, that's going to be a little hard
<3> whys that?
<1> HarrisonF, because I don't feel like hacking the generation code to add it, but I will if there isn't any other way
<2> heh, sjrussel: shows what I know, i was like wtf is 997 ?
<3> trying doing it manually to see if it helps first
<0> apparently, it's 'sort_col' ;)
<1> good idea :)
<2> so noob question: SELECT DISTINCT c . * , 997 AS sort_col
<3> and it is easy to add to auto-code generators, you just have it do ") union distinct (" and then ( and ) ;)
<2> what exactly is it doing ?
<2> just returning the value 997 for a colum called sort_col ?
<0> you'll get all the rows, then... 997
<0> yeah
<0> nice for reformatting data & such
<0> but ... it used to be that the UNION threw away the values after the first time
<2> how is it "reformatting" anything ?
<1> HarrisonF, OK, that does work, but *why* ? :)
<2> ahh
<6> pixie magic
<6> s/pixie/pudding
<1> enygma, do you have like a trigger on my nick? you follow me all over the place :P
<2> dust mites inside your server
<1> and you only speak when I do :P
<6> moi? never!
<2> restraining order time
<0> Davey|Work, perhaps you only read when talking?
<7> are those dust mites user friendly?
<2> i want to switch roles with my cat
<6> user roles or real life roles?
<6> because im not sure I want a cat in here
<0> top/bottom
<2> life roles.. he sleeps all day
<2> lol
<2> not top/bottom
<2> never needing to hunt for food
<6> kinky
<6> Davey likes side/side
<2> i'm just not that well endowed
<8> Should I be using version 4.1 or 5 when trying to use authentication with apache2.2?
<8> I'm also running FreeBSD 6.0
<2> it doesn't matter ?
<2> the mod_auth_db should work with whatever
<8> Okay, cool. I just saw that there was a special mod_auth_mysql41_ap2-1.00 for version 4.1 and didn't know whether I could use the regular mod_auth_mysql-2.20_7 or not
<0> DaveyWork: I (guess) that mysql retrieves the rows for the separate queries in parallel on separate threads
<0> and that () sequentializes them
<0> are there fewer than 20 rows the first query?
<2> BODMAS!
<2> but for sql
<9> hi, folks, I've got a problem even starting mysqld. I get the following error just running "mysqld_safe&" (this is what's in the error log) http://jtest.umecit.maine.edu/mysqerr.txt
<9> running this on slackware 10.2. total mysql noob.
<2> ineffable: did the server crash recently ?
<0> and .. that depending on the limit, mysql doesn't have to parse the second query ( limit < rows in table one, can just fetch fromt the first query??)
<9> alphablue, the previous time I tried it it gave the same error and crashed. that's why it says it didn't shut down properly
<9> this is all brand new installations, too
<2> checked your permissions ?
<9> running it as root
<2> did you run mysql_install_db ?
<2> i think slackware puts the db files in /usr/local/var/mysql ?
<9> I did run mysql_install_db
<0> BODMAS?
<2> and are the files owned by mysql:mysql ?
<9> one sec, I'll check
<2> sjrussel: old math trick i learnt in 4th grade.. order of operations acronym
<2> i forgot BO, but it's like division multiplication, addition , subtraction
<2> i think the B is for brackets, which are called parentheses in this country
<9> alphablue, everything in /usr/local/mysql is owned by root
<2> change it to mysql:mysql
<9> should I then regenerate the db, too?
<2> no
<9> okay
<2> if you've already done it, it's fine, mysql usually drops to mysql:mysql once it's started
<2> not sure what the username/group combo is for slack tho
<9> same error
<9> maybe I need to change more permissions
<8> sjrussel: PEMDAS :)
<2> chown -R ?
<2> pemdas ?
<9> alphablue, of cousre
<0> same thing
<8> Parenthases, Exponents, Multiplication, Division, Addition, Subtraction
<2> ahh
<2> but we were tuahgt division first.. wierd
<2> or i'm not remembering it right
<0> they're parallel
<0> same with add/subtract
<8> It doesn't matter which to use first
<8> Damnit sjrussel
<8> You keep writing faster
<8> :P
<2> ahh, no wonder i didn't take math as a major
<0> it's really PE(M|D)(A|S)
<9> alphablue, looks like I just needed to change some more permissions elsewhere, because it's no longer crashing immediately. Thanks!
<3> Davey|Work: order of operations, without the parathesis, it applys the LIMIT to the last query
<2> i remember when i first came here, and said left bracket my teacher is like.. no you don't use brackets for this..
<10> hey all. has anyone encountered an issue where the first access using jdbc results in java.sql.SQLException: Access denied for user ''@'localhost' (using p***word: NO); but all subsequent accesses work fine?
<11> hi Therion
<12> HELLO AGENT SMITH
<10> it's just the first access that comes back with that exception.
<11> heh
<2> rajesh: sounds like your code problem
<2> not mysql
<10> alphablue: yeah, it does, i agree.
<2> as if the first time your code is not aware of the proper connect string
<10> but was wondering if anyone faced it, and hence has an idea why.
<2> without learning java, and then looking at your code.. no :)
<10> yea, i checked that, but obviously i'm missing something more.
<10> cool.
<10> well, thanks anyway.
<10> ltr.
<2> paste your code, we can look
<2> bye ?
<10> alphablue: heh, it's a heck of a lot of code (it's not just a simple 4 lines to connect and exec)
<10> :)
Return to
#mysql
or
Go to some related
logs:
fc5 +screensaver config
centos raid tools
#web
linux sg setgroup
kenel panic not syncing vfs unable to mount root fs
#perl
#mysql
maddash irc
gentoo font deuglification
mysql mythconverg utf8
|
|