#mysql
14 October 2007
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Sun Oct 14 00:00:16 2007
00:11 <****> vigilant, what is the query? does it return rows when you enter it directly into mysql ?
00:12 <****> siliconsurge, crossover cable shouldht work
00:12 <****> siliconsurge, crossover cable should work
00:13 <****> sorry fingers slipped, there
00:17 <****> hello, whats the mysql function to limit a string to x chars
00:17 <****> return first X chars `description` from blah
00:21 <****> ipodtouch, did you look at the string function section of the docs?
00:37 <****> I've seen professional web applications with field values containing a php array... this violates 1NF... is that okay to have such a design?
00:45 <****> gnari no
00:47 <****> intgr, hm, you mentioned the enum booleanish thingy, what is it? i just played with set type, which seems cool for this job. but im not sure if this is a wise solution :)
00:48 <****> !man string functions
00:48 <****> (String Functions) : http://dev.mysql.com/doc/mysql/en/string-functions.html
00:48 <****> for you, ipodtouch :)
00:55 <****> Any oracle users around?
00:58 <****> Hello
00:58 <****> I've got a quick question
00:58 <****> In my select statement, I've got a mathematical operation that basically multiplies a rate by a quantity.
00:59 <****> I'd like to SUM all the results of that operation. Can this be done?
00:59 <****> I tried SUM( project_task_hours.hours * project_task.rate )
01:00 <****> Is anyone here?
01:02 <****> Octopssy, oracle 6, yes :))
01:02 <****> Ah, figured it out :)
01:02 <****> SELECT employee.name,
01:02 <****> project_task_hours.hours,
01:02 <****> SUM(project_task_hours.hours*project_task.rate) AS income
01:02 <****> FROM project_task_hours INNER JOIN project_task ON project_task_hours.project_task_id = project_task.id
01:02 <****> INNER JOIN employee ON project_task.employee_id = employee.id
01:02 <****> GROUP BY employee.name
01:02 <****> woohoo :)
01:02 <****> congratulations :)
01:02 <****> lol, thank you.
01:03 <****> enum and set kills me, need more coffee
01:03 <****> oracle 6? welcome to 1990 :p
01:05 <****> hehe
01:07 <****> a friend of mine gave me an oracle 6 package in 199x, about 1 meter of Documentation and a few 5" disks :) quite a very nice lecture
01:12 <****> I don't remember which version of oracle I first used. It was either 5 or 6. That was too long ago.
01:13 <****> can annyone tell me why mysql keeps craching evry +-5hours? i have to repair/optimize/backup/restore to be able work correct for annother 5hours
01:14 <****> then its all over again (give or take fwew hours before it craches)
01:14 <****> ! pastebin
01:14 <****> oops
01:14 <****> sorry
01:14 <****> Djbaby: It's tough to tell with that level of detail.
01:15 <****> might have error somewhere
01:15 <****> just gives error that mysql has gone away
01:15 <****> check the mysql logs
01:15 <****> Djbaby: Check to see exactly what you're running as well.
01:16 <****> game server
01:16 <****> so theres lots of stress on it though
01:16 <****> and its also tables of game server that is freaking out
01:16 <****> the rest is fine
01:18 <****> and the logs say... ?
01:18 <****> Djbaby: That's not enough detail. Formulate a complete description of the problem and post it to a pastebin.
01:18 <****> no logs crap -.- seems its turned off by default
01:18 <****> wil going to turn them on
01:18 <****> Djbaby: It could help to read the documentation describing the proper way to report a MySQL bug. Much of the same detail is requierd.
01:18 <****> on next crach il be back :p
01:19 <****> yes but
01:19 <****> evrytime i whant to repair them
01:19 <****> i can show this
01:20 <****> account repair warning Number of rows changed from 0 to 17266
01:20 <****> i can hit rapair 100 times it wil still give me that
01:20 <****> repair*
01:20 <****> you like the word repair don't you :p
01:21 <****> :p
01:21 <****> annyway turned log on see what it wil say
01:22 <****> Djbaby: Have you tried duplicating the problem? Maybe you have a hardware problem.
01:22 <****> dublicating hum yes , its going on for like 2weeks or so
01:23 <****> I think he means on another physical machine
01:23 <****> Djbaby: That's not exactly what I mean. Does this happen on more than one system? That might tend to rule out a specific disk drive, for instance, that might be the root cause.
01:23 <****> that i cant test
01:24 <****> but it can be posble of disk falure i think, though however its not that old of hard disk right now (dedicated server)
01:24 <****> its only +-3months old hd
01:24 <****> if my hosting company gave me a new one that is -.-
01:24 <****> hello
01:24 <****> has anyone here used NDB ?
01:24 <****> Djbaby: New/unused drives have a non-0 failure rate.
01:25 <****> figures -.-
01:26 <****> Djbaby ask them
01:26 <****> annytings i can test to see if its hd related?
01:26 <****> im sure they have some sort of HW warranty with the manufacturer
01:26 <****> they'll replace the disk if needed
01:26 <****> Djbaby: you could check the SMART status
01:26 <****> Djbaby: You might have access disk drive diagnostics that will report current conditions.
01:27 <****> access to, that is.
01:27 <****> dmesg tells all
01:27 <****> smartmontools too
01:27 <****> Djbaby whats the engine? innodb? myisam?
01:27 <****> both
01:28 <****> though it innodb that is craching
01:29 <****> ok think it wil be hd
01:29 <****> http://pastebin.com/m1c4eb6f4
01:30 <****> hmm yeah that doesn't look good. Try "smartctl -a /dev/hda
01:30 <****> Xgc: very nice intuition
01:31 <****> is that a virtual server?
01:32 <****> no
01:32 <****> no floppy?
01:33 <****> dedicated server
01:33 <****> IDE disk?
01:33 <****> odd
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last