mysql-3.23.43 builds

mysql-3.23.43 builds

[Gerrit P. Haase]

[-- Attachment #1: Type: text/plain, Size: 2029 bytes --]

Hallo Cygwinners,

Create a group cyg_mysql and a user mysql with NT's user-management.
Add them in the right files (/etc/group & /etc/passwd), rename user
cyg_mysql to mysql, then build from the sources (patch is attached).

Put the attached patch and the source package ( http://www.mysql.com )
in your build tree (e.g. /src/database):

$ tar zxvf mysql-3.23.43.tar.gz

$ cd mysql-3.23.43

$ patch -p0 < ../mysql.patch
patching file `extra/resolveip.c'

NOTE: you may change '--prefix=/usr' to another location
      and add '-mpentiumpro' before '-felide-constructors'
      to CXXFLAGS.

$ CFLAGS="-O3" \
> CXX=gcc \
> CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
> ./configure \
> --prefix=/usr \
> --enable-assembler \
> --with-mysqld-ldflags=-all-static \
> --with-mysqld-user=mysql \
> --with-berkeley-db \
> --with-innodb \
> 2>&1 | tee log.configure

$ make 2>&1 | tee log.make

$ make test 2>&1 | tee log.test
       NOTE:
       there is a problem with communication through
       sockets here, see attached test.log for infos.
       This test fails!!!
       any socket specialists out there to give a
       hint? I have no idea.

$ make install 2>&1 | tee log.make

$ make init-db 2>&1 | tee log.init

$ cd /usr ; /usr/bin/safe_mysqld &

$ cd sql-bench
$ ./run-all-tests
Benchmark DBD suite: 2.14
Date of test:        2001-10-29  2:08:35
Running tests on:    CYGWIN_NT-4.0 1.3.3(0.46/3/2) i686
Arguments:
Comments:
Limits from:
Server version:      MySQL 3.23.43

alter-table:

(It is still running...)

NOTE:
These sql-bench-tests requires the Perl modules DBI & DBD::mysql
to be installed:

$ perl -MCPAN -eshell
cpan> install DBI
cpan> install DBD::mysql
cpan> quit


Ciao,

Gerrit P. Haase                          mailto:gp@familiehaase.de
-- 
=^..^=
mysql.patch
log.test
--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/


[-- Attachment #2: log.test --]
[-- Type: text/plain, Size: 1533 bytes --]

cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
011029  3:03:35  Warning: Got signal 14 from thread 1
011029  3:03:35  ../sql/mysqld: Shutdown Complete

Installing Slave Databases
011029  3:03:37  Warning: Got signal 14 from thread 1
011029  3:03:37  ../sql/mysqld: Shutdown Complete

Starting MySQL daemon
Loading Standard Test Databases
Starting Tests

 TEST                         USER   SYSTEM  ELAPSED        RESULT
------------------------------------------------------------------------
alias                         ....     ....     ....       [ fail ]

/stuff/database/mysql-3.23.43/client/mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/stuff/database/mysql-3.23.43/mysql-test/var/tmp/mysql-master.so' (111) Command exited with non-zero status 1 real 12.85 user 0.03 sys 0.05 
Aborting. To continue, re-run with '--force'.

Ending Tests
Shutting-down MySQL daemon

\a/stuff/database/mysql-3.23.43/client/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/stuff/database/mysql-3.23.43/mysql-test/var/tmp/mysql-master.so' (111)'
Check that mysqld is running and that the socket: '/stuff/database/mysql-3.23.43/mysql-test/var/tmp/mysql-master.sock' exists!
Master shutdown finished
Warning;  Aborted waiting on pid file: '/stuff/database/mysql-3.23.43/mysql-test/var/run/mysqld-slave.pid' after 10 seconds
Slave shutdown finished
make: *** [test] Error 1

[-- Attachment #3: mysql.patch --]
[-- Type: text/x-diff, Size: 438 bytes --]

--- extra/resolveip.c.orig	Sun Oct 28 21:43:03 2001
+++ extra/resolveip.c	Sun Oct 28 21:42:41 2001
@@ -31,7 +31,7 @@
 #include <my_sys.h>
 #include <getopt.h>
 
-#if !defined(_AIX) && !defined(HAVE_UNIXWARE7_THREADS) && !defined(HAVE_UNIXWARE7_POSIX) && !defined(h_errno)
+#if !defined(_AIX) && !defined(HAVE_UNIXWARE7_THREADS) && !defined(HAVE_UNIXWARE7_POSIX) && !defined(h_errno) && !defined(__CYGWIN__)
 extern int h_errno;
 #endif
 

Re: mysql-3.23.43 builds

[Stipe Tolj]

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #1: Type: text/plain, Size: 1090 bytes --]

> Create a group cyg_mysql and a user mysql with NT's user-management.
> Add them in the right files (/etc/group & /etc/passwd), rename user
> cyg_mysql to mysql, then build from the sources (patch is attached).
> 
> Put the attached patch and the source package ( http://www.mysql.com )
> in your build tree (e.g. /src/database):

congratulations to the successfull build.

What cygwin version did you use? MySQL depends on pthread support?!

If this works I will package it to the CAMP distribution, ASAP.

Stipe

tolj@wapme-systems.de
-------------------------------------------------------------------
Wapme Systems AG

Münsterstr. 248
40470 Düsseldorf

Tel: +49-211-74845-0
Fax: +49-211-74845-299

E-Mail: info@wapme-systems.de
Internet: http://www.wapme-systems.de
-------------------------------------------------------------------
wapme.net - wherever you are

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mysql-3.23.43 builds

[Gerrit P. Haase]

Hallo Stipe,

Am 2001-10-29 um 02:37 schriebst du:

>> Create a group cyg_mysql and a user mysql with NT's user-management.
>> Add them in the right files (/etc/group & /etc/passwd), rename user
>> cyg_mysql to mysql, then build from the sources (patch is attached).
>> 
>> Put the attached patch and the source package ( http://www.mysql.com )
>> in your build tree (e.g. /src/database):

> congratulations to the successfull build.

Thanks.

> What cygwin version did you use? MySQL depends on pthread support?!

$ uname -a
CYGWIN_NT-4.0 LORELEY 1.3.3(0.46/3/2) 2001-09-12 23:54 i686 unknown

> If this works I will package it to the CAMP distribution, ASAP.

$ ./run-all-tests
Benchmark DBD suite: 2.14
Date of test:        2001-10-29  2:08:35
Running tests on:    CYGWIN_NT-4.0 1.3.3(0.46/3/2) i686
Arguments:
Comments:
Limits from:
Server version:      MySQL 3.23.43

alter-table: Total time: 3845 wallclock secs ( 0.88 usr  0.41 sys +  0.00 cusr  0.00 csys =  1.29 CPU)
ATIS: Total time: 105 wallclock secs (24.71 usr  7.18 sys +  0.00 cusr  0.00 csys = 31.89 CPU)
big-tables: Total time: 102 wallclock secs (21.40 usr 13.00 sys +  0.00 cusr  0.00 csys = 34.40 CPU)
connect: Total time: 678 wallclock secs (121.17 usr 74.33 sys +  0.00 cusr  0.00 csys = 195.50 CPU)
create: Total time: 3590 wallclock secs (36.92 usr 13.15 sys +  0.00 cusr  0.00 csys = 50.07 CPU)
insert: Total time: 6090 wallclock secs (1831.24 usr 557.79 sys +  0.00 cusr  0.00 csys = 2389.04 CPU)
select: Estimated total time: 2165 wallclock secs (184.04 usr 49.31 sys +  0.00 cusr  0.00  csys = 233.36 CPU)
wisconsin: Total time: 43 wallclock secs (11.31 usr  5.12 sys +  0.00 cusr  0.00 csys = 16.42 CPU)

All 8 test executed successfully
Tests with estimated time have a + at end of line

Totals per operation:
Operation             seconds     usr     sys     cpu   tests
alter_table_add                     2232.00    0.47    0.14    0.61     992
alter_table_drop                    1555.00    0.30    0.16    0.46     496
connect                              150.00   23.93   19.95   43.88   10000
connect+select_1_row                 180.00   27.78   21.41   49.19   10000
connect+select_simple                167.00   26.61   20.48   47.09   10000
count                                 43.00    0.24    0.04    0.28     100
count_distinct                        66.00    1.19    0.33    1.52    1000
count_distinct_2                      64.00    1.47    0.41    1.88    1000
count_distinct_big                   262.00   18.54    5.47   24.00     120
count_distinct_group                 142.00    3.42    0.95    4.37    1000
count_distinct_group_on_key           64.00    1.37    0.37    1.74    1000
count_distinct_group_on_key_parts    142.00    3.69    1.10    4.79    1000
count_distinct_key_prefix             57.00    1.07    0.26    1.33    1000
count_group_on_key_parts              59.00    2.99    0.84    3.84    1000
count_on_key                         657.00   46.33   11.40   57.73   50100 +
create+drop                          201.00   10.34    3.62   13.97   10000
create_MANY_tables                   821.00    7.10    1.86    8.96   10000
create_index                          31.00    0.00    0.00    0.00       8
create_key+drop                      210.00   10.68    3.68   14.35   10000
create_table                           0.00    0.02    0.02    0.04      31
delete_all                            16.00    0.00    0.00    0.00      12
delete_all_many_keys                 116.00    0.04    0.02    0.06       1
delete_big                             0.00    0.01    0.00    0.01       1
delete_big_many_keys                 116.00    0.04    0.02    0.06     128
delete_key                            12.00    2.29    1.40    3.70   10000
drop_index                            25.00    0.01    0.00    0.01       8
drop_table                             0.00    0.02    0.01    0.03      28
drop_table_when_MANY_tables          794.00    4.57    1.87    6.44   10000
insert                               407.00   86.09   47.66  133.77  350768
insert_duplicates                     95.00   22.45   12.43   34.88  100000
insert_key                           492.00   53.07   21.88   74.95  100000
insert_many_fields                    30.00    1.76    0.57    2.33    2000
insert_select_1_key                    9.00    0.00    0.00    0.00       1
insert_select_2_keys                  16.00    0.00    0.00    0.00       1
min_max                               27.00    0.10    0.01    0.11      60
min_max_on_key                       327.00   67.27   17.51   84.78   85000
multiple_value_insert                  7.00    0.99    0.02    1.01  100000
order_by_big                         135.00   54.02   16.85   70.87      10
order_by_big_key                      95.00   55.96   16.12   72.08      10
order_by_big_key2                     90.00   54.12   16.31   70.43      10
order_by_big_key_desc                 97.00   54.76   16.98   71.74      10
order_by_big_key_diff                125.00   53.84   16.38   70.22      10
order_by_big_key_prefix               91.00   53.37   16.86   70.23      10
order_by_key2_diff                    12.00    5.19    1.40    6.59     500
order_by_key_prefix                    6.00    2.77    0.73    3.50     500
order_by_range                        12.00    3.01    0.96    3.98     500
outer_join                            81.00    0.02    0.01    0.03      10
outer_join_found                      79.00    0.01    0.00    0.01      10
outer_join_not_found                  46.00    0.00    0.00    0.00     500
outer_join_on_key                     52.00    0.02    0.00    0.02      10
select_1_row                          10.00    1.94    1.44    3.38   10000
select_2_rows                         15.00    2.79    1.74    4.54   10000
select_big                            92.00   54.23   16.49   70.72      80
select_big_str                       138.00   34.13    6.70   40.83   10000
select_column+column                  12.00    2.50    1.51    4.02   10000
select_diff_key                      188.00    0.75    0.16    0.91     500
select_distinct                       22.00    4.46    1.11    5.57     800
select_group                          84.00    4.62    0.93    5.55    2911
select_group_when_MANY_tables       1564.00    4.24    2.11    6.35   10000
select_join                            5.00    1.23    0.37    1.60     100
select_key                           446.00  184.02   46.49  230.51  200000
select_key2                          441.00  191.93   48.38  240.31  200000
select_key2_return_key               419.00  170.11   46.60  216.70  200000
select_key2_return_prim              429.00  185.10   46.31  231.40  200000
select_key_prefix                    485.00  191.38   48.72  240.09  200000
select_key_prefix_join                29.00   10.21    2.98   13.19     100
select_key_return_key                434.00  181.32   43.44  224.76  200000
select_many_fields                    72.00   19.62   12.43   32.05    2000
select_query_cache                   138.00   11.49    2.64   14.13   10000
select_query_cache2                  139.00   13.46    3.26   16.72   10000
select_range                         210.00   20.49    6.39   26.88     410
select_range_key2                     49.00   17.11    3.89   21.01   25010
select_range_prefix                   50.00   16.76    4.81   21.58   25010
select_simple                          6.00    1.47    1.08    2.55   10000
select_simple_join                     5.00    1.79    0.40    2.19     500
update_big                            30.00    0.00    0.01    0.01      10
update_of_key                         72.00   14.70    7.81   22.51   50000
update_of_key_big                     33.00    0.24    0.05    0.29     501
update_of_primary_key_many_keys       43.00    0.09    0.09    0.18     256
update_with_key                      342.00   75.04   42.25  117.29  300000
update_with_key_prefix                98.00   22.83   12.57   35.40  100000
wisc_benchmark                         9.00    3.83    1.07    4.91     114
TOTALS                              16622.00 2207.22  712.72 2920.00 2667247 +

Now I'm building mysql-4.0.0 with shared libs;)

Ciao,

Gerrit P. Haase                            mailto:gp@familiehaase.de
-- 
=^..^=


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mysql-3.23.43 builds

[Robert Collins]

How does it handle dropped connections/ clients that crash without
signing off? These are the things listed as needing attention in the
manual for win32 - and when I read them I figured cygwin might do
better, but haven't had a chance to follow up..

Rob


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

Re: mysql-3.23.43 builds

[Gerrit P. Haase]

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #1: Type: text/plain, Size: 905 bytes --]

Hallo Robert,

2001-10-29 14:17:53, du schriebst:

> How does it handle dropped connections/ clients that crash without
> signing off? These are the things listed as needing attention in the
> manual for win32 - and when I read them I figured cygwin might do
> better, but haven't had a chance to follow up..

I've done no more testing so far, but this would be a good point to
start with.  Thanks,

Gerrit
-- 
convey Information Systems GmbH                 http://www.convey.de/
                                                Vitalisstraße 326-328
Gerrit P. Haase                                 D-50933 Köln
gerrit.haase@convey.de                          Fon: ++49 221 6903922


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/