#mysql
25 October 2007
Total 27 pages. You are browsing page 4/27.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
01:44 <****> so whats the command to tell mysql to cnnect to an ip instead of localhost
01:44 <****> mysql -h 192?
01:44 <****>
01:45 <****> ok thanks
01:49 <****> hi
01:49 <****> i have a problem
01:49 <****> hello
01:49 <****> dont we all?
01:49 <****> with this error
01:49 <****> http://pastebin.mysql-es.org/181
01:49 <****> this is the permisions for my raw device
01:49 <****> ls -l /dev/raw/raw1
01:49 <****> crw-rw---- 1 mysql disk 162, 1 Oct 24 17:45 /dev/raw/raw1
01:49 <****> and this one
01:49 <****> ls -l /dev/sdb1
01:49 <****> brw-rw---- 1 mysql disk 8, 17 Oct 24 12:43 /dev/sdb1
01:50 <****> i didnt even know mysql ran off raw devices
01:58 <****> h1pple: shouldn't that be rwxrw---- ?
02:00 <****> h1pp1e check /dev/raw/
02:01 <****> su - mysql -c "ls -l /dev/raw"
02:01 <****> Trengo, su - mysql -c "ls -l /dev/raw"
02:01 <****> total 0
02:01 <****> crw-rw---- 1 mysql disk 162, 1 Oct 24 17:45 raw1
02:01 <****> su - mysql -c "ls -la /dev/raw"
02:01 <****> mysql can see it
02:02 <****> Trengo, su - mysql -c "ls -la /dev/raw"
02:02 <****> total 0
02:02 <****> drwxr-xr-x 2 root root 60 Oct 24 17:45 .
02:02 <****> drwxr-xr-x 10 root root 5780 Oct 24 17:45 ..
02:02 <****> crw-rw---- 1 mysql disk 162, 1 Oct 24 17:45 raw1
02:03 <****> I have posted mysql query at http://pastebin.com/m22ddbac6 I have also posted the Explain resultset. Please guide me how to optimize the query as the query does not returns results to the end user but it gets hanged.
02:03 <****> id mysql?
02:04 <****> Trengo, the same error... :S
02:04 <****> id mysql ?
02:07 <****> Trengo, id ? what id ?
02:07 <****> h1pp1e run that, id mysql
02:07 <****> its probably mysql:mysql
02:08 <****> yes its mysql
02:09 <****> group mysql?
02:09 <****> yes
02:10 <****> Trengo, mysql:x:101:102:MySQL server:/var/lib/mysql:/bin/bash
02:10 <****> i've never tried raw devices, but why did you chown it to group disk?
02:11 <****> i have a script which makes a backup from my database (i could not use mysqldump). the syntax it creates is as follow: insert table values, then a line break, then what follows is (values_i), being i=1...n
02:11 <****> is there a limit for n? i mean, is there a limit on how many values combination i can insert by a insert command?
02:11 <****> guys, could someone please explain to me why, when I create a "created_at" column with the command created_at DATETIME NOT NULL it automatically gives it a default value of 0000-00-00 00:00:00 ?
02:12 <****> I don't really want a default value, because I want the application to set this. If a value isn't assigned by the app, then I want the db to give an error
02:13 <****> pulpfiction: there is a max_allowed_packet, which is somewhat configurable. See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
02:13 <****> i have to go to bed, see you all later
02:16 <****> ki77a77, ok, i'll take a look at what the default value is and configure my backup script to break the results into that number
02:16 <****> ki77a77, thanks
02:18 <****> hal11: I think you want to look at enabling strict mode on your server.
02:19 <****> hal11: or even 'traditional' mode
02:21 <****> ki77a77, I see. OK, thanks, I understand
02:23 <****> Can anyone help me optimize the query at http://pastebin.com/m22ddbac6 Which when I try to run in mysql 4.0 hangs itself and no output is derived?
02:26 <****> cstextiles: that's the select count distinct with the dozen left joins? lol, I'm not surprised. ;^)
02:27 <****> ki77a77: What are the other options availablefor quering?
02:28 <****> cstextiles: oh, that's far beyond my limited skill set. I'm sure someone else here can be a help though.
02:29 <****> cstextiles, the explain you posted seems kind of nonsensical . . . I don't know how you could possibly have "const row not found" in a table that was LEFT JOINed.
02:30 <****> But I'm not as MySQL-1337 as a lot of people here.
02:31 <****> cstextiles, why are you doing all the left joins anyway? Why don't you just do SELECT COUNT(DISTINCT programs.id) FROM programs;?
02:32 <****> Simetrical: Actually I am using Where clause after this query where the fields of other left joind are use and so I am using Left Join instead of plain count
02:32 <****> cstextiles, why didn't you post that as part of the query, then?
02:32 <****> cstextiles, the pastebin you linked to has no WHERE clause.
02:33 <****> Hello! How i can read an random row?
02:33 <****> select .... ORDER BY RAND()
02:33 <****> freebox: ^^
02:33 <****> freebox: sort by rand(), but it has performance issues.
02:33 <****> =)
02:33 <****> freebox, kind of a tricky subject. There are some tradeoffs to make. Google "MySQL random row" or somesuch, and you should find some decent summaries of available options.
02:33 <****> Simetrical: Yes but that depended on the user intraction as well as I thought that when without where clause it hangs itself then theres no need for inserting where clause
02:34 <****> ok
02:34 <****> cstextiles, what do you mean it hangs itself? You're executing the query on the command line?
02:34 <****> Simetrical: what happended to the_wench?
02:34 <****> ki77a77, died. Along with archivist, evidently.
02:35 <****> ki77a77, maybe a more regular idler would have more details. But now we have SQL instead.
02:35 <****> Simetrical: Remarkable how much you get to rely on a bot...
02:35 <****> I am a little worried about archivist.
02:36 <****> Simetrical: Yes No result is fetched when I try to use the above Query through PHP in a Web way. Also when I try to use this query on my local machine then mysqld consumes most of the resources about 97% and mysql Query browser literally hangs itself for about 5 minutes after which I have to use end Task
02:37 <****> cstextiles, are you sure you posted the correct EXPLAIN output? Try running EXPLAIN again on the exact query you posted, without WHERE, and post that if it's different.
02:37 <****> cstextiles, it doesn't look like the EXPLAIN you posted matches the query.
02:39 <****> Josh Beckett looks like he's throwing pitches with a bazooka - 97 mph
02:41 <****> I will need to put texts around 1000 chars. Is VARCHAR( 1000 ) the best way?
02:42 <****> freebox, you could also use TEXT.
02:42 <****> freebox, it doesn't take any more storage space.
02:42 <****> Or maybe I mean SMALLTEXT.
02:42 <****> Yes, I think that's what I mean.
02:42 <****> Simetrical: I ahve agai tried the same query and read the output from 30th line in http://pastebin.com/m1848a40a
02:43 <****> smalltext is the best way? is for an "luck of the day" site =)
02:43 <****> cstextiles, I don't understand how that EXPLAIN is possible, so I can't help you there. My general advice is try removing some of the joins until you see that it runs quickly. Or start with no joins and add them one by one, until it stops working.
02:44 <****> freebox: your mysql version is significant. See http://dev.mysql.com/doc/refman/5.0/en/char.html
02:44 <****> freebox, either way will work okay. VARCHAR(1000) will make sure no one puts in anything *more* than 1000 characters, which you might want. SMALLTEXT allows up to 65535 characters.
02:44 <****> Hmm, I don't know about versions, listen to him. :)
02:45 <****> freebox: varchar was limited to 255 < ver 5.0-ish
02:45 <****> hm
02:45 <****> good
02:46 <****> i'll use smalltext
02:47 <****> an off topic: What is the "American name" of that "luck cookies"?
02:47 <****> freebox: wtf?
02:48 <****> this one: http://img110.imageshack.us/img110/1189/biscoitocortesiaaul3.jpg
02:49 <****> thats chineses cookies :P
Total 27 pages. You are browsing page 4/27.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last