#mysql
02 January 2008
Total 23 pages. You are browsing page 3/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
03:18 <****> whats iostat show?
03:19 <****> is that freebsd?
03:19 <****> must be huh
03:20 <****> I think its blocking on io
03:20 <****> yep
03:20 <****> 0 77 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 50 0 0 0 50
03:20 <****> 0 84 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 49 0 0 0 50
03:20 <****> 0 77 0.00 0 0.00 0.00 0 0.00 0.00 0 0.00 50 0 0 0 50
03:20 <****> 0 84 16.00 11 0.17 0.00 0 0.00 0.00 0 0.00 50 0 0 0 50
03:21 <****> well u320 hdd's / raid 10
03:21 <****> no usage on disks
03:21 <****> 6.2?
03:21 <****> yep
03:21 <****> I am fearing for my mysql installation right now :-)
03:22 <****> dmesg/console show anything unusual?
03:22 <****> nope
03:22 <****> nothing in messages
03:22 <****> etc
03:22 <****> are you using pthreads or the recommended libthr?
03:23 <****> Druid_: have yuo check the error log file?
03:23 <****> Druid_: try "show processlist"
03:23 <****> yeah, he said there was nothing there
03:23 <****> he already pasted the show processlist
03:24 <****> nothing in error log
03:24 <****> Druid_
03:24 <****> as soon as a query comes
03:24 <****> it hangs
03:24 <****> no matter what db
03:24 <****> table
03:24 <****> or user
03:25 <****> did a myisamcheck for tables etc
03:25 <****> that is probably from mytop instead of processlist, no state, hard to know what is foing on
03:25 <****> Druid_: is this the same instance that couldn't allocate 2MB of memory earlier?
03:25 <****> yeah
03:25 <****> I'd look elsewhere (not mysql)
03:26 <****> system seems ok
03:26 <****> hdd's healthy
03:26 <****> ..
03:26 <****> druid: what if you run a query that doesn't use any tables? SELECT 1+1 FROM DUAL
03:26 <****> ishiboo: that's not a valid MySQL query
03:26 <****> im guessing its an I/O issue though so I think that will return
03:26 <****> chadmaynard: why not?
03:26 <****> you don't need the from dual
03:27 <****> oh it does work though
03:27 <****> that IS a valid mysql statement
03:27 <****> i don't think it always will
03:27 <****> but you're right
03:27 <****> mysql doesn't need FROM DUAL
03:27 <****> you can run a select without a table.
03:27 <****> chadmaynard: check the documentation.
03:27 <****> ishiboo: no.
03:27 <****> what if you really have a table with the name dual
03:27 <****> http://pastebin.com/m64a29845
03:28 <****> Druid_: can you do "show processlist;" so that we can see the state of the query
03:28 <****> its an I/O issue
03:28 <****> thats why its sitting in kserel
03:29 <****> run out of disk space?
03:29 <****> it should throw an error then
03:29 <****> any chance there are errors in the mysql error log?
03:29 <****> he said no errors in the error log
03:29 <****> then again, if the disks full... :-)
03:29 <****> IIRC mysql warns you way before the disk fills though
03:30 <****> http://pastebin.com/m4a97040a
03:30 <****> well lets see df output
03:30 <****> disk full on 4.1 and newer can cause hangs
03:30 <****> also check dmesg
03:30 <****> I agree with chad, lets see disk usage.
03:30 <****> happy 2008 ebergen
03:31 <****> and vmstat output
03:31 <****> Filesystem Size Used Avail Capacity Mounted on
03:31 <****> /dev/da0s1a 38G 16G 19G 45% /
03:31 <****> opening table and waiting for table in the state
03:31 <****> http://pastebin.com/m14a4c635
03:32 <****> Druid_: how much memory does this system actually have? I'm still curious about malloc() saying it couldn't find any memory
03:33 <****> waaaaaait malloc() said it can't find memory?!
03:33 <****> 4 gb
03:33 <****> how much is mysqld currently using
03:33 <****> thats really weird
03:33 * thumbs blames chadmaynard
03:34 <****> hm
03:34 <****> well
03:34 <****> now
03:34 <****> haha i didn't do it this time
03:34 <****> mysql is
03:34 <****> PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND
03:34 <****> 16183 mysql 16 20 0 282M 38656K kserel 0 3:35 2.73% mysqld
03:34 <****> chadmaynard: it's a habit, I suppose.
03:34 <****> thumbs: I can't disagree
03:34 <****> druid: CPU usage is not an issue. back to the vm... you saw a malloc() that couldn't allocate?
03:34 <****> and queries working now again
03:34 <****> that is weird
03:34 <****> ishiboo now
03:34 <****> it works
03:34 <****> But of course it does
03:34 <****> without having me doing anything
03:35 <****> chadmaynard: Happy new year, by the way.
03:35 <****> Druid_: test all of your hardware
03:35 <****> thumbs: you too
03:35 <****> reboot + memtest86
03:35 <****> I've had a lot of issues with 6.2
Total 23 pages. You are browsing page 3/23.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last