A list for people who work on the MySQL code

Roberto@dellapasqua.com | 17 Jun 2002 23:18

object pool benchmark over 100mbit lan

Hello!

To be fair with the marvellous mysql, I like to post new benchmarks of the
my object pooling over 100mbit LAN.

Previous post are about a Mysql server running into the same machine where
the client application run.
Object pooling avoid the needing of instance tcp/ip open/close.

I have repeated the test with MySql server running on Duron900 on winXP, and
the client loaded into a Celeron 1000 with firewalls disabled.

Obviously the bench now make justice to mysql.

A normal bench query select take around 7.2 msec to run: ~140 queries for
second
My object pool bench same query select take around 2.0 msec to run: ~500
queries for second (3.5 more times selects)

If you like:
www.dellapasqua.com/nopool_100Mbit.gif
www.dellapasqua.com/pool_100Mbit.gif

I very like this SQL engine, it fly !!!

Tomorrow I will send a bench with mysql under linux (I have a mandrake 8
optimized into the same Duron900 machine), but please no flames.

Cheers,

(Continue reading)

Sebastian Bergmann | 18 Jun 2002 07:37

Picon

depcomp

  Hi,

  I checked out (cloned, in BitKeeper speech) a fresh copy of mysql-4.0
  from the repository. I ran

    aclocal && autoheader && autoconf && automake

  in both mysql-4.0/ and mysql-4.0/innobase, but automake gives me (an) 
  error(s):

automake: configure.in: required file `./depcomp' not found
dbug/Makefile.am:34: invalid unused variable name: `OMIT_DEPENDENCIES'
extra/Makefile.am:30: invalid unused variable name: `OMIT_DEPENDENCIES'
heap/Makefile.am:39: invalid unused variable name: `OMIT_DEPENDENCIES'
isam/Makefile.am:47: invalid unused variable name: `OMIT_DEPENDENCIES'
libmysql_r/Makefile.am:39: invalid unused variable name:
`OMIT_DEPENDENCIES'
libmysqld/Makefile.am:73: invalid unused variable name:
`OMIT_DEPENDENCIES'
merge/Makefile.am:31: invalid unused variable name: `OMIT_DEPENDENCIES'
myisam/Makefile.am:62: invalid unused variable name: `OMIT_DEPENDENCIES'
myisammrg/Makefile.am:32: invalid unused variable name:
`OMIT_DEPENDENCIES'
mysys/Makefile.am:109: deprecated feature: `test_charset' overrides
`test_charse
t$(EXEEXT)'
mysys/Makefile.am:109: change your target to read `test_charset$(EXEEXT)'
mysys/Makefile.am:77: invalid unused variable name: `OMIT_DEPENDENCIES'
regex/Makefile.am:38: invalid unused variable name: `OMIT_DEPENDENCIES'
sql/Makefile.am:106: invalid unused variable name: `OMIT_DEPENDENCIES'

(Continue reading)

Sebastian Bergmann | 18 Jun 2002 08:38

Picon

Re: depcomp

Sebastian Bergmann wrote:
> automake gives me (an) error(s):

  Downloading

    http://www.fastcgi.com/devkit/depcomp

  and putting it into mysql-4.0/ and mysql-4.0/innobase/ solved the
  problem...

--

-- 
  Sebastian Bergmann
  http://sebastian-bergmann.de/                 http://phpOpenTracker.de/

  Did I help you? Consider a gift: http://wishlist.sebastian-bergmann.de/

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail internals-thread3884 <at> lists.mysql.com
To unsubscribe, e-mail <internals-unsubscribe <at> lists.mysql.com>

heikki | 18 Jun 2002 09:34

Picon

bk commit into 4.0 tree

Below is the list of changes that have just been committed into a
4.0 repository of heikki. When heikki does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1032 02/06/18 10:34:00 heikki <at> hundin.mysql.fi +1 -0
  manual.texi:
    Emphasize that the size and the signedness of integer types has to be the same in a foreign key constraint

  Docs/manual.texi
    1.996 02/06/18 10:33:42 heikki <at> hundin.mysql.fi +1 -1
    Emphasize that the size and the signedness of integer types has to be the same in a foreign key constraint

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	heikki
# Host:	hundin.mysql.fi
# Root:	/home/heikki/mysql-4.0

--- 1.995/Docs/manual.texi	Mon Jun 17 19:35:39 2002
+++ 1.996/Docs/manual.texi	Tue Jun 18 10:33:42 2002
 <at>  <at>  -38521,7 +38521,7  <at>  <at> 
 and the referenced key must have similar internal data types
 inside InnoDB so that they can be compared without a type
 conversion.
-The size and the signedness of integer types has to be the same.

(Continue reading)

akishkin | 18 Jun 2002 10:43

Picon

bk commit into 4.0 tree

Below is the list of changes that have just been committed into a
4.0 repository of akishkin. When akishkin does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet <at> 1.1033, 2002-06-18 10:43:23+02:00, walrus <at> mysql.com
  mysql-test-run.sh	correction typo MYSQL_MYPORT to MASTER_MYPORT

  BitKeeper/etc/logging_ok
    1.233 02/06/18 10:43:19 walrus <at> mysql.com +1 -0
    Logging to logging <at> openlogging.org accepted

  mysql-test/mysql-test-run.sh
    1.141 02/06/18 10:41:59 walrus <at> mysql.com +1 -1
    correction typo MYSQL_MYPORT to MASTER_MYPORT

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	akishkin
# Host:	work.mysql.com
# Root:	/home/akishkin/mysql-4.0

--- 1.140/mysql-test/mysql-test-run.sh	Wed Jun  5 22:14:17 2002
+++ 1.141/mysql-test/mysql-test-run.sh	Tue Jun 18 10:41:59 2002
 <at>  <at>  -203,7 +203,7  <at>  <at> 
     --local-master)
       MASTER_MYPORT=3306;

(Continue reading)

=?iso-8859-1?Q?Anthony_Johnston_._Antix?= | 18 Jun 2002 12:38

RE: object pool benchmark over 100mbit lan

hi, which version of MySQL?
_______________________________________________________
Anthony Johnston
	tech <at> antix.co.uk
Antix Software Limited
	http://www.antix.co.uk

-----Original Message-----
From: Roberto <at> dellapasqua.com [mailto:roberto <at> dellapasqua.com]
Sent: 17 June 2002 22:18
To: mysql <at> lists.mysql.com; internals <at> lists.mysql.com;
win32 <at> lists.mysql.com
Subject: object pool benchmark over 100mbit lan

Hello!

To be fair with the marvellous mysql, I like to post new benchmarks of the
my object pooling over 100mbit LAN.

Previous post are about a Mysql server running into the same machine where
the client application run.
Object pooling avoid the needing of instance tcp/ip open/close.

I have repeated the test with MySql server running on Duron900 on winXP, and
the client loaded into a Celeron 1000 with firewalls disabled.

Obviously the bench now make justice to mysql.

A normal bench query select take around 7.2 msec to run: ~140 queries for
second

(Continue reading)

Roberto@dellapasqua.com | 18 Jun 2002 13:34

last email, promised!

Due to the fact that I have received many personal emails, I now publish my
last benchmark.
Isn't a real query bench, because I don't test massively multithreading
queries, but I launch sequential queries to misurate the impact time of the
tcp open/close connection.
So into this test we can (maybe) misurate only the I/O tcp speed of mysql
daemons.

The client access directly to libmysql.dll. The server version is the
3.23.51. I use a fantastic borland compiler.

I reduced the output of the select at around 40 bytes (select limit 1)... so
we can misurate only the I/O subsystem throughtput...

Unfortunately I have a winxp pro copy on the pc where I have a linux 2.4
kernel, I think that a win2k server with kernel quantum table linear at 120
msec can do best results (~5-10% I suppose)...
hovewer we can say that the mysql I/O under linux can be ~10-20% faster that
the equivalent under xp version.

www.dellapasqua.com/Linux2.4_pooled_LAN.gif
www.dellapasqua.com/Linux2.4_NOTpooled_LAN.gif
www.dellapasqua.com/XPPRO_pooled.gif
www.dellapasqua.com/XPPRO_NOTpooled.gif
www.dellapasqua.com/localhost_pooled.gif
www.dellapasqua.com/localhost_NOTpooled.gif

My thougths are:
- a pooling manager it's obligatory under win2k-xp client-server if you use
a localhost mysqlserver accessed directly by the libmysql.dll (to avoid the

(Continue reading)

holyfoot | 18 Jun 2002 14:10

Picon

bk commit into 4.0 tree

Below is the list of changes that have just been committed into a
4.0 repository of hf. When hf does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1033 02/06/18 17:10:39 hf <at> bison.(none) +1 -0
  Merge abotchkov <at> work.mysql.com:/home/bk/mysql-4.0
  into bison.(none):/home/hf/work/mysql-4.0.te

  BitKeeper/etc/logging_ok
    1.233 02/06/18 17:10:27 hf <at> bison.(none) +1 -1
    auto-union

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	hf
# Host:	bison.(none)
# Root:	/home/hf/work/mysql-4.0.te/RESYNC

--- 1.232/BitKeeper/etc/logging_ok	Thu Jun 13 14:16:11 2002
+++ 1.233/BitKeeper/etc/logging_ok	Tue Jun 18 17:10:27 2002
 <at>  <at>  -12,6 +12,7  <at>  <at> 
 davida <at> isil.mysql.com
 heikki <at> donna.mysql.fi
 heikki <at> hundin.mysql.fi
+hf <at> bison.(none)

(Continue reading)

Michael Widenius | 18 Jun 2002 15:35

Picon

XOR locical and binary operators ...


Hi!

>>>>> "Hartmut" == Hartmut Holzgraefe <hartmut <at> six.de> writes:

Hartmut> ... were missing for no obvious reason, so i added them :)

<cut>

Thanks for the patch;  I will add this to the 4.0 source tree.

Regards,
Monty

--

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Michael Widenius <monty <at> mysql.com>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   www.mysql.com

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail internals-thread3890 <at> lists.mysql.com
To unsubscribe, e-mail <internals-unsubscribe <at> lists.mysql.com>

(Continue reading)

Sinisa | 18 Jun 2002 16:38

Picon

bk commit into 4.0 tree

Below is the list of changes that have just been committed into a
4.0 repository of Sinisa. When Sinisa does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet <at> 1.1033, 2002-06-18 17:38:06+03:00, Sinisa <at> sinisa.nasamreza.org
  Fixed some comments , plus introduced some tests so that I do not
  make some new mistakes.

  mysql-test/r/merge.result
    1.13 02/06/18 17:38:05 Sinisa <at> sinisa.nasamreza.org +3 -0
    Fixed some comments , plus introduced some tests so that I do not
    make some new mistakes.

  mysql-test/t/merge.test
    1.15 02/06/18 17:38:05 Sinisa <at> sinisa.nasamreza.org +1 -0
    Fixed some comments , plus introduced some tests so that I do not
    make some new mistakes.

  sql/sql_update.cc
    1.57 02/06/18 17:38:05 Sinisa <at> sinisa.nasamreza.org +3 -3
    Fixed some comments , plus introduced some tests so that I do not
    make some new mistakes.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	Sinisa

(Continue reading)

Group

gmane.comp.db.mysql.devel.

Search Archive

Page

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 13

Articles in period: 129

June 2002

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane

Recent entries

Patch for mysqldump (5 May 2013)
outputting varchars to a file to be read by load data infile (5 May 2013)
adding an index of my own type/code (23 Apr 2013)
after cross compile, mysql table hidden while operation on it still wo (10 Mar 2013)
inconsistency in source-code/comments in mf_keycache (4 Mar 2013)
effects of load data local on RSS (28 Feb 2013)
properly detecting cases where handler can silently overwrite rows (26 Feb 2013)
[Maria-developers] Fwd: some question on bundled libedit in mysql (25 Feb 2013)
Fwd: some question on bundled libedit in mysql (25 Feb 2013)
Are handlerton->commit calls serialized in MySQL 5.6? (21 Feb 2013)
API version for STORAGE ENGINE plugin is too different (15 Feb 2013)
debugging how query plans are made (12 Feb 2013)
when propagate_cond_constants will be called? (10 Feb 2013)
[PATCH] use fallocate to create table (8 Feb 2013)
source does not compile (5 Feb 2013)
reducing fsyncs during handlerton->prepare and handlerton->commit in 5 (30 Jan 2013)
what pros/cons of storing binary log in an InnoDB table? (28 Jan 2013)
making a system variable that is a float or double (18 Jan 2013)
making a system variable that is a float or double (18 Jan 2013)
detecting select SQL statements that are functions (18 Jan 2013)
detecting select SQL statements that are functions (18 Jan 2013)

Archives

4	May 2013
6	April 2013
12	March 2013
27	February 2013
28	January 2013
39	December 2012
21	November 2012
33	October 2012
10	September 2012
21	August 2012
18	July 2012
23	June 2012
9	May 2012
24	April 2012
21	March 2012
28	February 2012
18	January 2012
13	December 2011
16	November 2011
3	October 2011
5	September 2011
2	August 2011
23	July 2011
18	June 2011
21	May 2011
33	April 2011
23	March 2011
18	February 2011
10	January 2011
13	December 2010
45	November 2010
45	October 2010
69	September 2010
46	August 2010
27	July 2010
54	June 2010
34	May 2010
48	April 2010
89	March 2010
75	February 2010
61	January 2010
48	December 2009
106	November 2009
121	October 2009
53	September 2009
44	August 2009
189	July 2009
223	June 2009
245	May 2009
93	April 2009
177	March 2009
99	February 2009
35	January 2009
69	December 2008
40	November 2008
103	October 2008
64	September 2008
58	August 2008
76	July 2008
137	June 2008
88	May 2008
82	April 2008
73	March 2008
98	February 2008
46	January 2008
59	December 2007
44	November 2007
49	October 2007
107	September 2007
67	August 2007
134	July 2007
105	June 2007
83	May 2007
129	April 2007
126	March 2007
64	February 2007
60	January 2007
60	December 2006
109	November 2006
100	October 2006
78	September 2006
94	August 2006
63	July 2006
104	June 2006
60	May 2006
52	April 2006
37	March 2006
66	February 2006
71	January 2006
439	December 2005
1175	November 2005
1113	October 2005
1450	September 2005
1359	August 2005
1189	July 2005
1142	June 2005
924	May 2005
955	April 2005
1034	March 2005
1204	February 2005
1151	January 2005
956	December 2004
1059	November 2004
845	October 2004
797	September 2004
863	August 2004
576	July 2004
667	June 2004
646	May 2004
466	April 2004
771	March 2004
540	February 2004
431	January 2004
422	December 2003
345	November 2003
512	October 2003
364	September 2003
415	August 2003
450	July 2003
415	June 2003
382	May 2003
441	April 2003
523	March 2003
430	February 2003
509	January 2003
408	December 2002
636	November 2002
361	October 2002
243	September 2002
360	August 2002
221	July 2002
116	June 2002

Design

Zawodny | Right Menu | Left Menu

Your Own Design

Paste the URL of your CSS below. Download CSS template