#mysql
16 October 2007
Total 19 pages. You are browsing page 2/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
02:08 <****> Hi, I am wondering what I get if i configure mysql with --with-bench.
02:09 <****> actually, fulketerraun: DATE_FORMAT(STR_TO_DATE('2007.10.12','%y.%m.%d')),GET_FORMAT(DATE,'EUR'))
02:09 <****> wasn't usa format
02:09 <****> pthomas: benchmarking features? ;)
02:10 <****> dkr: Alright, I figured thats what it was.
02:19 <****> okay to ask SQL questions here or is this for mysql dev?
02:19 <****> mfisch: pure rethorical questions are ok.
02:20 <****> well I discovered a few things today
02:20 <****> first, I probably need full outer join and second, I dont think mysql offers it
02:21 <****> I think there's a way to fake it though
02:23 <****> mfisch: why would you need a full outer join?
02:24 <****> thumbs: let me preface this by stating that I'm a C/ASM coder who helps out with some PHP/Mysql work for a volunteer group
02:24 <****> thumbs: so please dont consdier me "informed" ;)
02:24 <****> thumbs: I need to get the FirstName, LastName, and PersonID from 8 tables where PersonID is not unique across tables, but names are
02:25 <****> but if for example Fred Smith is not in table 4, I was table4.person_id to show "NULL"
02:25 <****> mfisch: a left join would work well enough in that case.
02:25 <****> Would it?
02:26 <****> I think it wouldn't.
02:26 <****> The question is why your schema is so strange to begin with.
02:26 <****> my output should be "Fred, Smith, 4, 29, NULL, NULL, 19 ...." Where all those numbers are the various personIDs
02:26 <****> Simetrical: The original coder left, I volunteered to hold this DB together until we could redesign
02:27 <****> Are JOINs and UNIONs fairly expensive ops in terms of time and cpu cycles?
02:27 <****> So for each name in *any* table, you want a list of the IDs that name has in each table?
02:27 <****> Simetrical: exactly!
02:27 <****> mfisch, depends. :)
02:27 <****> Yes, I see that you want something like a full outer join. Hmm.
02:28 <****> Simetrical: just email me the patch later today ;)
02:28 <****> . . . ?
02:28 <****> Simetrical: when you code up the F O J code for me ;)
02:29 <****> Is this a query that needs to be run routinely, or only once? About how large are the tables?
02:29 <****> And you want all the results, or there will be a LIMIT clause?
02:29 <****> Simetrical: well, let's say it's run once or twice a day, tables vary from 50 rows to 300 rows each
02:30 <****> Simetrical: all results
02:30 <****> Ah, that's no problem at all. The size is tiny, so performance is no real issue.
02:30 <****> You could try just UNIONing them.
02:30 <****> Simetrical: that's what is done now
02:30 <****> Is it not working well?
02:31 <****> Simetrical: so I find every person in every table, but I can't tell that Fred Smith is in Table C and Table B, but not Table E
02:31 <****> Oh, that's easy enough to fix.
02:31 <****> Simetrical: maybe I can select first_name, last_name, TableC.personID, TableB.personId, etc?
02:31 <****> SELECT firstName, lastName, personID, 1 AS tablenum FROM table1 UNION SELECT firstName, lastName, personID, 2 AS tablenum FROM table2 UNION ...
02:32 <****> mfisch, you need a join condition for that, which as you observed would require a full outer join.
02:32 <****> that design looks hellish.
02:32 <****> thumbs: it wasn't well thought out, thats for suer
02:32 <****> thumbs, he's one of those poor souls with an inherited schema.
02:32 <****> Simetrical: and no real DB training besides that basic college class
02:33 <****> Well, if you ask in here we can help you with that. \o/
02:33 <****> Simetrical: let me try your method and get back to you in a bit (need to eat dinner now)
02:35 <****> dear folks, is there a rational reason for which mysql would eat up 500 megs of ram while i got just 1 db that is 140 megs in size?
02:36 <****> robboplus, because you set its configuration options to consume more memory than you need it to?
02:36 <****> hm. in fact i relaxed my mysql alot
02:37 <****> had no idea how BIG it may grow in mem...
02:41 * Simetrical frowns: post table corrupt, "Found 1800622 keys of 1800621"
02:42 <****> Anyone know what tends to cause that sort of thing?
02:42 <****> Should I just give up and convert to InnoDB for that table?
02:51 <****> hey
02:51 <****> Simetrical: awesome, that works
02:52 <****> Simetrical: that ",1", ",2" magic solved it
02:52 <****> why i cant get working select * from quotes_main,vote ORDER by vote.place limit 0,2; as it should
02:57 <****> What's a decent way to find out how many, say, fridays occurred between two datetime values?
03:07 <****> C API (Ruby actually): what is the maximum size of a statement (insert) submitted through the API?
03:08 <****> So far my documentation searches have not found this information....
03:14 <****> if I create a table in mysql is it possible I may have to do something to make the 'creation' visible?
03:14 <****> Maybe apply changes, or something? what is that called... when you make things 'stick'.
03:14 <****> commit?
03:15 <****> yes! commit!
03:15 <****> but iirc DDL operations auto-commit
03:15 <****> How do I make that happen?
03:15 <****> I thought so as well.
03:15 <****> also, are you using innodb or myisam?
03:16 <****> At this point it didn't matter. commit; didn't help my problem. :(
03:16 <****> well innodb is the only storage engine that even supports transactions
03:17 <****> Currently having this problem but it doesn't have to do with mysql: http://gallery.menalto.com/node/69425
03:23 <****> ToeBee: (and ndb) ;-)
03:25 <****> ?
03:44 <****> Vi?i vraga su sedam binjisah,
03:44 <****> su dva maca a su dvije krune,
03:44 <****> praunuka Turkova s Koranom!
03:44 <****> Za njim jata prokletoga kota,
03:44 <****> da opuste zemlju svukoliku
03:44 <****> ka skakavac sto polja opusti!
03:44 <****> Francuskoga da ne bi brijega,
03:44 <****> aravijsko more sve potopi!
03:44 <****> San pakleni okruni Osmana,
03:44 <****> darova mu lunu ka jabuku.
03:44 <****> Zloga gosta Evropi Orkana!
03:44 <****> Vizantija sada nije drugo
03:44 <****> no prcija mlade Teodore;
03:44 <****> zvijezda je crne sudbe nad njom.
03:44 <****> Paleolog poziva Murata
03:44 <****> da zakopa Grke sa Srbima.
03:44 <****> Same to you.
03:44 <****> Svoju misli Brankovic s Gertukom.
03:44 <****> Muhamede, to je za Gertuku!
03:44 <****> Sjem Azije, ?e im je gnjijezdo,
03:44 <****> vrazje pleme pozoba narode -
03:44 <****> dan i narod, kako cuku tica:
03:44 <****> Murat Srpsku, a Bajazit Bosnu,
03:44 <****> Murat Epir, a Muhamed Grcku,
03:44 <****> Is it Slavic Poetry Day?
Total 19 pages. You are browsing page 2/19.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last