Compiling mySQL

Guy Harper guy at gtv8.demon.co.uk
Tue Sep 19 08:14:04 BST 2000


Hello all.

I'm having some difficulty in compiling mySQL-3.22.32. The make process seems to be getting lost somewhere... it'sconstantly reading/writing to disk, and has continued to do so for up to 18 hours, without any sign of conclusion.

I have tried this both with an X session running and without.

Below is a typical output from top during compilation:


last pid: 50952;  load averages:  0.39,  0.35,  0.46  up 2+22:08:06    22:18:43
40 processes:  1 running, 39 sleeping

Mem: 35M Active, 1068K Inact, 20M Wired, 3260K Cache, 6847K Buf, 404K Free
Swap: 282M Total, 184M Used, 98M Free, 65% Inuse


  PID USERNAME PRI NICE  SIZE    RES STATE    TIME   WCPU    CPU COMMAND
50869 guy        2   0 28300K  9836K select   1:12  4.64%  4.64% XF86_SVGA
50553 root     -22   0   154M 30800K swread  22:58  0.93%  0.93% cc1plus
50932 guy        3   0  1860K   416K ttyin    0:17  0.60%  0.54% top
  171 root       2   0   872K    64K select   0:28  0.00%  0.00% moused
50899 guy        2   0 22160K  2276K select   0:19  0.00%  0.00% communicator-4
  136 root       2   0  1420K   112K select   0:15  0.00%  0.00% sendmail
50877 guy       10   0  1748K   464K nanslp   0:12  0.00%  0.00% wminet
  110 root       2   0   904K    68K select   0:12  0.00%  0.00% syslogd
  133 root      10   0   948K    56K nanslp   0:07  0.00%  0.00% cron

This is several hours since invoking make, the process priority is -22, so I guess the system has given up? As you can see, the processor is not heavily loaded. The process cc1plus, occasionally changes STATE from swread to RUN.

According to wmtop, <pagedaemon> is very busy, but top doesn't show this....

When initially invoking make, I get the following output from top:

st pid: 51172;  load averages:  0.85,  0.28,  0.22    up 2+23:33:15  23:43:52
45 processes:  4 running, 41 sleeping
CPU states: 86.0% user,  0.0% nice, 10.9% system,  0.4% interrupt,  2.7% idle
Mem: 33M Active, 3636K Inact, 20M Wired, 2532K Cache, 6834K Buf, 404K Free
Swap: 282M Total, 34M Used, 248M Free, 11% Inuse, 104K In, 640K Out

  PID USERNAME PRI NICE  SIZE    RES STATE    TIME   WCPU    CPU COMMAND
51171 root      58   0 42220K 31772K RUN      0:36 69.22% 65.23% cc1plus


Here, the process cc1plus appears to be doing something useful... shortly thereafter (around half an hour), cc1plus falls to around 2 percent, and disk activity continues with renewed vigor!!

The output to the teminal running make, stops here:
....
Making all in share
c++ -DMYSQL_SERVER                      -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql-3.22.32\"" -DDATADIR="\"/usr/local/mysql-3.22.32/var\""                       -DSHAREDIR="\"/usr/local/mysql-3.22.32/share/mysql\""                  -DHAVE_CONFIG_H -I./../include                  -I./../regex                   -I. -I../include -I.. -I.    -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DDBUG_OFF   -fno-implicit-templates -DMYSQLD_NET_RETRY_COUNT=1000000  -c sql_yacc.cc



The system is a P200MMX, with 64MB RAM, and ~300MB swap space, of which 50% is in use (without an X server running). I have succesfully compiled mySQL-3.22.27 in the past on this system, and whilst I recall it taking some time (maybe an hour or so), I can't see why it should be taking so long.

Any assistance would be much appreciated.... :)


Thanks,

Guy





More information about the Ukfreebsd mailing list