Home   About   Contact   Log in

Archive for August 19th, 2002

*yawn*

August 19th, 2002 | No Comments | Filed in Technology

This is taking forever…

Quote: top 
 20:13:11 up 13 days,  2:04,  1 user,  load average: 2.48, 2.51, 2.52
59 processes: 57 sleeping, 2 running, 0 zombie, 0 stopped
CPU states:   2.7% user,   0.9% system,   0.0% nice,  96.4% idle
Mem:     30464K total,    29656K used,      808K free,    14424K buffers
Swap:    60476K total,    10500K used,    49976K free,     6452K cached

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
14063 mysql     20 -10  2868 1636  1372 R <  88.5  5.3 304:57 mysqld

This machine is:

Quote: processor 
processor	: 0
vendor_id	: GenuineIntel
cpu family	: 5
model		: 2
model name	: Pentium 75 - 200
stepping	: 12
cpu MHz		: 133.638
fdiv_bug	: no
hlt_bug		: no
f00f_bug	: yes
coma_bug	: no
fpu		: yes
fpu_exception	: yes
cpuid level	: 1
wp		: yes
flags		: fpu vme de pse tsc msr mce cx8
bogomips	: 266.24
Visit my other sites: Photo Gallery | Insane in the Membrane | Main website
Rate this:
0.0

The world’s slowest MySQL machine

August 19th, 2002 | No Comments | Filed in Technology

I’ve got MySQL running on an internal webserver. It’s a P133 machine with 32MB of ram and 3GB of disk space.

I just asked it to run about 120,000 queries and dump the results in a file. The file grew to seven meg, and it took about four hours to run.

I’m now pushing the results back into the database and it’s been going 15 minutes.

More database thrashing is to follow shortly, assuming I’ve not just put mess into the db and wasted half the day :)

Waiting for my Nuon and to hear about the interview I went to. Waiting sucks… going slightly mad waiting now :?

Visit my other sites: Photo Gallery | Insane in the Membrane | Main website
Rate this:
0.0
Photoblogs