IRC Logs

Network: freenode Channel: #mysql

	Enter your search terms Submit search form
	Web www.irclog.org

[05:04]<dugsggvzyg2><? endif; ?> is much clearer than <? } ?>
[05:05]<eyzau>oh.. wait.. nevermind.. i thought we were talking about ?:..
[05:05]<eyzau>yeah rarely used :)
[05:05]<dugsggvzyg2>naw, trinary is tried and true :)
[05:06]<eyzau>yeah i agree, i thought you were talking about the trinary operator at first
[05:06]<eyzau>rather ternary
[05:07]<sgjzu>Thanks, Duesentrieb.
[05:12]<veueq9>Can I create a mysql function that will return a resultset?
[05:16]<srmnm>if I want to load a file with the LOAD FILE command into a table, how does MYSQL where to put what information?>
[05:18]<srmnm>Anyone?>
[05:18]<srmnm>if I want to load a file with the LOAD FILE command into a table, how does MYSQL where to put what information?>
[05:19]<ggrvgyc>truz24, you around?
[05:20]<veueq9>yeah
[05:20]<ggrvgyc>truz24, you use Insight?
[05:20]<veueq9>I would like to do something like select field from table where field is in (GetValuesForThisType(field2));
[05:20]<veueq9>yeah
[05:20]<ggrvgyc>truz24: are you finding it sucking badly right now?
[05:20]<veueq9>yeah
[05:21]<ggrvgyc>truz24: ok, just wanted to be sure I wasn't alone :)
[05:21]<veueq9>they changed shit all over
[05:21]<veueq9>new up range
[05:21]<veueq9>up=ip
[05:21]<ggrvgyc>truz24: yeah
[05:21]<ggrvgyc>truz24: it's all slow and shit now, too :(
[05:21]<ggrvgyc>truz24: for me, anyway
[05:21]<ggrvgyc>truz24: only three of us on with the new ip range now, just thought I'd see if anyone else was having problems
[05:42]<duzznz>hola
[05:57]<zzzjgczdf2nff>zircu: thanks again. I took some of what I learned there, and did a test of my own! I feel much better now.
[05:58]<zzzjgczdf2nff>I entered 756,539 rows of random lorem ipsum, with 2891 lines being the most 'lines' for any c_id
[06:00]<zzzjgczdf2nff>SELECT `code` FROM `code` WHERE `c_id`=XXX ORDER BY `line` takes about .07-.08 seconds when they return more than 2000 rows
[06:01]<zzzjgczdf2nff>SELECT `c_id`, `line`, `code` FROM `code` WHERE `code` LIKE '%facilisi%' ORDER BY `c_id`,`line` takes about 4-4.5 seconds, when it returns 68,000+ records
[06:02]<zzzjgczdf2nff>and in reality, I would only be getting UNIQUE(`c_id`) on that...which would drop it down to where it wouldn't pull more than a few thousand...which I would STILL paginate to 20-100 per page
[06:04]<zzzjgczdf2nff>and all that is on a VMWare machine set to use only 256M ram...
[06:24]<eyzau>AaronCampbell: that looks good, did you look at what the EXPLAIN results showed on those two queries?
[06:24]<zzzjgczdf2nff>zircu: not sure what you mean exactly
[06:25]<eyzau>AaronCampbell: if you do a explain select code from code where .... it will show what mysql has to do to get the results
[06:29]<zzzjgczdf2nff>shouldn't SELECT DISTINCT(`col`),`other_col` FROM `table` ORDER BY `col`,`other_col` only return one record for each thing in `col`?
[06:29]<eyzau>no
[06:30]<eyzau>i've never used distinct on a specific column like that but, i would assume select distinct col, other_col
[06:30]<zzzjgczdf2nff>got it
[06:31]<zzzjgczdf2nff>My explain results: http://hashmysql.org/paste/viewentry.php?id=1832
[06:33]<vxzggjmd>AaronCampbell: just curious, why would you name a column in a table the same name as the table?
[06:39]<f-fnfj>Hello... I'm getting this error: #1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 36
[06:39]<f-fnfj>but doesn't seem nothing wrong with this line
[06:39]<f-fnfj>can anyone help me?
[06:40]<eyzau>AaronCampbell: notice thye 'type' column and the 'rows' column.. this is a good tool to get an idea on how fast things will work
[06:41]<zzzjgczdf2nff>threnody: not really sure...this is like a test table to make sure the capacities can be handled before I make the layout
[06:41]<eyzau>F-Lelo: i would guess you have a problem with the line just before that one
[06:41]<eyzau>F-Lelo: pastebin your table definition
[06:41]<f-fnfj>"pastebin"?
[06:42]<f-fnfj>can I paste on your pvt?
[06:42]<eyzau>F-Lelo: http://pastebin.com/
[06:42]<f-fnfj>ah, cool
[06:42]<f-fnfj>just a min
[06:42]<eyzau>i would ignore the private message and besides, more eyes are better than one
[06:43]<zzzjgczdf2nff>zircu: I see the "rows" part...I assume that's how many rows it actually has to check?
[06:43]<f-fnfj>zircu: I sent you the pastebin link by notice
[06:43]<zzzjgczdf2nff>in the first, it has to check all 1.5 million, and in the second it only looks at only 2537
[06:44]<eyzau>AaronCampbell: yeah the lower the better, and on joins it becomes very important that all but one have a 1 in the column
[06:45]<zzzjgczdf2nff>the "type" I don't understand...what is "all" vs "ref" ?
[06:45]<eyzau>i wont get notices, just paste the link here
[06:45]<f-fnfj>ok
[06:45]<f-fnfj>http://pastebin.com/pastebin.php?dl=714747
[06:46]<eyzau>AaronCampbell: all == bad, if it isn't all it shows how mysql will use the index, and in your case it uses the index refrenced from the const value of 314
[06:46]<eyzau>all is a table scan
[06:46]<f-fnfj>zircu: if you want, I can paste a bigger piece
[06:50]<eyzau>F-Lelo: what version of mysql is this?
[06:50]<f-fnfj>I'm not sure, it's from my webhosting
[06:51]<f-fnfj>zircu: http://pastebin.com/pastebin.php?dl=714756
[06:51]<f-fnfj>maybe this is better..
[06:52]<veueq9>is there a function to split a delimited string?
[06:56]<f-fnfj>zircu? :)
[06:56]<eyzau>F-Lelo: wow your impatient... i'm getting there
[06:56]<eyzau>truz24: split it into what?
[06:56]<f-fnfj>zircu: I'm not, it's just that I was wondering if you were on it.. sorry :)
[06:56]<veueq9>to be used in an "In" statement
[06:57]<veueq9>from GROUP_CONCAT
[06:58]<eyzau>F-Lelo: Well i get an error on line 2
[06:59]<eyzau>oh wait.. stupid copy paste issue
[06:59]<f-fnfj>hmmm
[06:59]<f-fnfj>hehehe ok
[07:00]<eyzau>F-Lelo: it works just fine, i'm guessing you have a real old version of mysql.. remove all that stuff after )
[07:00]<eyzau>the ENGINE.... stuff
[07:00]<f-fnfj>cool, man
[07:00]<f-fnfj>I'll test it
[07:00]<f-fnfj>thanks a lot :)
[07:01]<f-fnfj>I'll be back at you to tell you how it goes
[07:02]<eyzau>truz24: so you want to group_concat but then submit that to an 'IN' statement?
[07:02]<veueq9>zircu, i'm trying to simplify my problem, because as it is now, it doesn't make sense to do that.
[07:03]<f-fnfj>zircu: #1064 - You have an error in your SQL syntax near 'INSERT INTO `phpbb_auth_access` VALUES (5, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1' at line 42
[07:03]<f-fnfj>hehehehhe
[07:03]<f-fnfj>pastebin, here I go...
[07:05]<f-fnfj>zircu: http://pastebin.com/pastebin.php?dl=714772
[07:07]<eyzau>F-Lelo: put the ; back on the stuff you removed
[07:07]<f-fnfj>ok
[07:07]<eyzau>truz24: do you have an example of what you are trying to do? i can't comprehend it right now
[07:08]<f-fnfj>hehehe I'm so noob :)
[07:09]<veueq9>Well, I have a table that contains data about a sale, and the sale type. The saletype can have 1,2,3...n products attached to it. I then have another table that represents each of those products being "processed" Do you follow me so far?
[07:11]<eyzau>F-Lelo: well i did tell you to get rid of everything after )
[07:11]<f-fnfj>yeah, zircu hehehe

Back to #mysql
Or go to some related logs:
#debian
#php
#gentoo
#gentoo
#gentoo