#mysql
03 November 2007
Total 17 pages. You are browsing page 5/17.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
07:55 <****> the top is mysql doing 40% user cpu time
07:55 <****> and the query is local
07:55 <****> well, sys cpu can be caused because of many issues
07:55 <****> like... even... fs fragmentation
07:55 <****> but of course, can be different everywhere
07:55 <****> you can try oprofiling the kernel ;-D
07:56 <****> oh god :P
07:56 <****> well, thats a thin line you have to cross to understand what is wrong
07:56 <****> instead of speculating :)
07:57 <****> though speculating is always more fun
07:57 <****> and easier
07:57 <****> mhm
07:57 * ToeBee blames dust on the CPU
07:57 <****> stand on the corner... me and yoko ono..
07:58 <****> yawn, I want this dump to be faster
07:58 <****> damn japanese
07:58 <****> what do the japanese have to do with dumping?
07:58 <****> wait... I might not want to know
07:59 <****> ToeBee: I'm assigning new db server for japanese content
07:59 <****> they got a bit of contention living on same box with french :)
07:59 <****> nobody stands french!
07:59 <****> heh well don't blame them for that
07:59 <****> indeed
08:00 <****> isnt there a way to use more than one cpu core per mysql query? its just a waste of resources :(
08:00 <****> run two queries :)
08:01 <****> actually, innodb has background threads
08:01 <****> which may utilize multiple cores %)
08:02 <****> but thats more for i/o parallelization
08:02 <****> kind of depressing having 3 cores sitting idle
08:02 <****> my personal belief is that if you manage to hit cpu resource limits, you're doing something wrong ;-)
08:02 <****> but this is strictly personal ;-D
08:03 <****> lol ... those tables are big
08:04 <****> define big :)
08:04 <****> yawn.
08:04 <****> 30M rows each, ~6GB
08:04 <****> ok, my 'cat blah.sql | mysql' is using 90% cpu ;-)
08:04 <****> is that all?
08:05 <****> I like small databases
08:05 * ToeBee adds 2 indexes
08:05 <****> this one is 20gb, it is small for me
08:05 <****> i like cheese
08:05 <****> it even got a tiny tiny server
08:05 <****> with just 4gb of ram
08:06 <****> oh, and 600GB of diskspace for this 20gb database :)
08:06 <****> nacho cheese
08:06 <****> doritos!
08:06 <****> I prefer swiss
08:06 <****> meh, stephen colbert's campaign has been shot down
08:06 * domas sad
08:06 <****> bye
08:06 <****> damn democrats
08:07 <****> damn nazis
08:07 <****> you can always have bigger if big is too small :P
08:09 <****> that's what she said
08:10 <****> did someone say Enzyte?
08:12 <****> anyone know if you can escape various single instances of , ' " whem using LOAD DATA on a unicode file. Everythign else seems to be working except for the few entries that have these characters
08:13 <****> there's a character set variable
08:13 <****> that load data uses
08:13 <****> set it to charset that is in your file :)
08:14 <****> ok, i set my table to the characterset of the file instead. so just do it in the load data
08:14 <****> thx
08:14 <****> LOAD DATA is the win
08:14 <****> yea, its awesome
08:15 <****> mysqldump should use load data
08:16 <****> lies.
08:17 <****> no
08:17 <****> lies.
08:17 <****> --extended-insert
08:18 <****> \o/
08:18 <****> 35761.24 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
08:18 <****> though I like multiple background i/o threads:
08:18 <****> I/O thread 10 state: waiting for i/o request (write thread) reads 0 writes 226673 requests 7096 io secs 6.220268 io msecs/request 0.876588 max_io_wait 21.213000
08:18 <****> I/O thread 11 state: waiting for i/o request (write thread) reads 0 writes 74597 requests 2147 io secs 2.414632 io msecs/request 1.124654 max_io_wait 5.925000
08:18 <****> I/O thread 12 state: waiting for i/o request (write thread) reads 0 writes 25693 requests 1160 io secs 1.114130 io msecs/request 0.960457 max_io_wait 23.746000
08:18 <****> ;-)
08:21 <****> wth where did those stats come from?
08:21 <****> innodb
08:21 * brown_cat waves
08:22 <****> show variables like 'version%';
08:22 <****> +--------------------+--------------------------------------+
08:22 <****> | Variable_name | Value |
08:22 <****> +--------------------+--------------------------------------+
08:22 <****> | version | 4.0.26-wikimedia-google-20071102-log |
08:22 <****> | version_comment | Super duper custom build |
08:22 <****> | version_compile_os | unknown-linux-gnu |
08:22 <****> +--------------------+--------------------------------------+
08:22 <****> \o/
08:23 <****>
08:23 <****> :p
08:23 <****> should I kick myself or what?
08:23 <****> yes!
08:23 <****> ok now?
08:23 <****> heh
08:24 <****> the irc gods are satisfied
08:25 <****> I can only concur
08:25 <****> yay
08:26 <****> http://apps.facebook.com/prezident
08:27 <****> I don't get facebook
08:27 <****> I find myself limited
08:27 <****> :(
Total 17 pages. You are browsing page 5/17.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last