| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> Alrighty.
<1> mindamp: then, read that and learn about how to design the table structure and relationships so queries are cleaner
<2> bah
<2> i know how to design a table...
<2> this is a one time operation on a legacy database
<2> i just need this one query to run once.... then i can revamp the database
<2> but we have a tradeshow in 3 days...
<3> Leithal: Doesn't seem like 5.0.x accepts that var
<2> so i don't have time for that now
<2> could you ***ist me in structuring this query?
<1> mindamp: The query is really rather simple. That's why I sent you to some docs. We already gave you the join condition which is the only tricky part
<2> but where do i put the join condition?
<3> default_storage_engine = InnoDB
<3> There we go
<1> mindamp: read the docs please. That's a very basic concept.
<4> setuid: it should
<4> or table_type
<2> bah
<2> that link has nothing about join conditions
<2> just joins
<1> !tell inviso about joins
<0> Alrighty.
<3> Leithal: Is converting from MyISAM as simple as doing a dump, changing the .sql dump file's default engine to InnODB and re-inserting?
<5> hello, guys!
<4> setuid: Yes
<2> What you can see from this is that an INNER JOIN produces a result set containing only rows that have a match, in both tables (t1 and t2), for the specified join condition(s).
<4> setuid: it can be as easy as creating the innodb table, and insert ... select
<2> does tell where or how to structure the condition
<2> er doesn't
<5> hey, a simple question... how do I truncate tablename_column only... in other words... how do I empy a single column in a lot of rows?
<6> setuid: or as simple as alter table... engine = innodb
<3> shabbs: That works too?
<3> shabbs: Runtime?
<4> setuid: however you should also consider the performance considerations in the change
<3> Leithal: As in?
<4> (the appropriate buffers etc.)
<2> argh
<1> mindamp: select stuff from table1 JOIN table2 on join_condition WHERE general_conditions
<3> Leithal: Any doco on that?
<4> innodb_buffer_pool_size for a start
<6> setuid: yes, it should change the type of the table
<4> !man innodb startup options
<0> (InnoDB Startup Options) : http://dev.mysql.com/doc/mysql/en/InnoDB_start.html
<3> innodb_buffer_pool_size = 8M
<3> Nees more?
<5> how can I empty a single column from a lot of rows?
<6> Renich: update yourtable set yourcolumn = '' (or NULL if you want NULL) WHERE clause
<1> Renich: update table set col=NULL where conditions_to_pick_the_rows
<5> thank you
<5> thought I was missing something in the truncate syntax
<4> setuid: if your tables are bigger than 8 Mb - yea it wouldn't hurt ;)
<3> Leithal: I need to import 340GiB of data into this db...
<3> So it'll take _forever_ if its not tuned right
<4> So yea you need more than 8Gb.
<3> 8Gb? I don't even have that much RAM! ;)
<4> I meant 8 Mb
<4> but anyway
<3> oh, whew! =)
<2> mysql_query("SELECT * FROM test_attendees INNER JOIN test_orders ON where test_orders.attendee_records LIKE
<2> CONCAT("%", test_attendees.ATTENDEE_ID, "%") test_attendees.ATTENDEE_ID = test_orders.attendee_records);
<4> awful lot of tuning to do ;)
<2> is that it?
<2> ON ...
<2> bah
<2> christ
<2> kill me now
<4> SELECT * FROM test_attendees INNER JOIN test_orders ON test_orders.attendee_records LIKE CONCAT("%", test_attendees.ATTENDEE_ID, "%")
<1> mindamp: please run your queries before posting them and at least make an attempt to understand the error :(
<4> S U F F E R
<2> har
<7> hello. is there a way of having "fool proof" sequences in mysql?
<1> chellste: fool proof? Does auto_increment not do what you need?
<2> mysql_query("SELECT * FROM test_attendees INNER JOIN test_orders ON test_orders.attendee_records LIKE
<2> CONCAT("%", test_attendees.ATTENDEE_ID, "%"));
<2> ?
<2> bah
<2> parse error
<1> mindamp: dude. Stop pasting stuff.
<2> bah
<1> mindamp: and you broke php. getting it working through the command line first
<2> argh
<2> could someone just help me with this one stupid query?
<7> inviso: not really. the auto_increment counter might be reset. for example when exporting data or optimizing the database.
<1> Leithal: You might appreciate this... :) http://thedailywtf.com/forums/60879/ShowPost.aspx
<4> har I read that yesterday
<4> I had to do a hack kinda like that lately
<3> Leithal: How do I "prune" the main InnoDB files? /var/lib/mysql/ibdata1 and such
<3> Does it just keep growing and growing, until I run out of disk?
<1> chellste: the auto_increment counter gets reset when optimizing the db? What do you mean by that?
<4> setuid: yes it will keep on growing, you have to "reorg" it to prune it
<2> could someone please help with this.
<4> dump/delete/load
<3> Leithal: How do you do th... oh
<4> mostly it will just use the internal space from deletes etc. too though
<2> this is all i have... http://pastebin.com/565542
<4> hmm perhaps not mostly, but you get the picture
<4> inviso: SELECT id, substring_index(substring(xml, locate('<title>', xml)+7),'</title>',1) FROM profile_graph;
<1> mindamp: very basic php parse errors. Try it from the mysql command line client as I suggested earlier.
<2> i revised the CONCAT statement... cause it was WRONG
<3> What is the real benefit of InnoDB vs. MyISAM?
<4> ^ my hack to get the title value from an column with xml in it ;p
<2> k
<1> Leithal: oh geez. Just shoot me now :)
<4> incidentally, the format above is pretty good for delimited strings too.. </hint>
<2> inviso... it seems to be taking a long time.. is that normal?
<2> i guess for that join condition it would be
<1> mindamp: yes. That join conditions smells of rotten eggs
<4> mwaahahaha
<2> actually... it seems to be hung
<4> I hope that wasn't some silly WoW reference
<1> Leithal: if you abandon me, at least give me the ban stick ;)
<4> heh I would if I could ;)
<1> nah, not Therion's fault. I'm *way ahead of him
<8> anyone know if the select distinct bug has been fixed yet?
<1> mutilator: bugs.mysql.com -> search -> Ta Da
<8> distinct/group
<9> Leithal: What'd I do now?
<4> WoW evilness
<9> Not my fault that Blizzard is so good at what they do
<1> Leithal - 0, Therion - 1, Blizzard - 50
<9> Now if they'd spend some of those hundreds of millions of dollars we've given them to engineer another solution than ****ing queues maybe I'll resubscribe
<2> inviso... this query hangs in command line... http://pastebin.com/565549
<7> inviso: - AUTO_INCREMENT is implemented as SELECT MAX(col) FROM table
<1> Leithal - 0, Therion - 15, Blizzard - $millions
<1> chellste: nope
<1> mindamp: it's still running
<2> oh
<2> how long should that take?
<7> so if I'm using the ID outside the db i can't trust that the id will point to the same record.
<1> mindamp: forever
<1> mindamp: depends on how much data you have, actually
<7> inviso: or has this been improved?
<2> hmmm is that CONCAT statement correst?
<1> chellste: yes, works fine
<2> for the |
Return to
#mysql
or
Go to some related
logs:
#xorg
#bash
#linux
#web
E: Couldn't find package automatix
#web
#fluxbox
gimp script-fu debian missing alpha to logo
ipw3945 ubuntu slow
#gaim
|
|