[Mono-list] poor mysql performance under debian testing

Duncan Mak duncan@ximian.com
Tue, 18 May 2004 00:41:17 -0400


--=-VyLo/0HPz2ascq3ItOeX
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Hello Reggie,

On Mon, 2004-05-17 at 19:22, Reggie wrote:

> I have given a link to the latest sources to Miguel so it should be
> updated fairly soon.


Miguel asked me to sync up the latest ByteFX tree to CVS and I just did
that. It took a little while to do, and I missed a few things, but I
think I got it all.

I made two changes:

     1. Added a /r:Mono.Posix.dll to the Makefile.
     2. Reverted the AssemblyInfo.cs file to the previous version. We
        can't use the one in the zip file, because bytefx.snk is not
        distributed.


With everything in place, I still have a few problems. As it is, ByteFX
is not buildable from Mono CVS.

I see this error:

diphthong:~/Mono/mcs/class/ByteFX.Data $ make
Creating ../../build/deps/default_ByteFX.Data.dll.makefrag ...
MONO_PATH="../../class/lib/default:$MONO_PATH" mono  ../../mcs/mcs.exe  
-d:NET_1_1 -d:ONLY_1_1 -g /noconfig /r:mscorlib.dll /r:System.dll
/r:System.Xml.dll /r:System.Data.dll /r:ICSharpCode.SharpZipLib.dll
/r:System.Design.dll /r:System.Drawing.dll /r:System.Windows.Forms.dll
/r:Mono.Posix.dll /res:mysqlclient/Designers/command.bmp
/res:mysqlclient/Designers/connection.bmp
/res:mysqlclient/Designers/dataadapter.bmp /target:library
/out:../../class/lib/default/ByteFX.Data.dll @ByteFX.Data.dll.sources
./Common/StreamCreator.cs(98) error CS1502: The best overloaded match
for method ' Mono.Posix.UnixEndPoint..ctor (string)' has some invalid
arguments
./Common/StreamCreator.cs(98) error CS1503: Argument 0: Cannot convert
from 'char' to 'string'
./Common/StreamCreator.cs(98) error CS1501: No overload for method
`Mono.Posix.UnixEndPoint' takes `1' arguments
./Common/StreamCreator.cs(98) error CS1501: New invocation: Can not find
a constructor in `Mono.Posix.UnixEndPoint' for this argument list
./Common/StreamCreator.cs(99) error CS0165: Use of unassigned local
variable `endPoint'
./mysqlclient/transcaction.cs(76) error CS0117:
`ByteFX.Data.MySqlClient.Driver' does not contain a definition for
`SendCommand'
./mysqlclient/transcaction.cs(97) error CS0117:
`ByteFX.Data.MySqlClient.Driver' does not contain a definition for
`SendCommand'
Compilation failed: 7 error(s), 0 warnings
make: *** [../../class/lib/default/ByteFX.Data.dll] Error 1

I can make a quick patch for the error in the UnixEndpoint constructor,
but not having SendCommand defined is definitely a problem.

Duncan.

--=-VyLo/0HPz2ascq3ItOeX
Content-Type: text/html; charset=utf-8

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.0.10">
</HEAD>
<BODY>
Hello Reggie,<BR>
<BR>
On Mon, 2004-05-17 at 19:22, Reggie wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE><FONT COLOR="#737373"><I>I have given a link to the latest sources to Miguel so it should be
updated fairly soon.</I></FONT></PRE>
</BLOCKQUOTE>
<BR>
Miguel asked me to sync up the latest ByteFX tree to CVS and I just did that. It took a little while to do, and I missed a few things, but I think I got it all.<BR>
<BR>
I made two changes:
<OL TYPE=1>
    <LI TYPE=1 VALUE=1>Added a <TT>/r:Mono.Posix.dll</TT> to the Makefile.
    <LI TYPE=1 VALUE=2>Reverted the <TT>AssemblyInfo.cs</TT> file to the previous version. We can't use the one in the zip file, because bytefx.snk is not distributed.
</OL>
<BR>
With everything in place, I still have a few problems. As it is, ByteFX is not buildable from Mono CVS.<BR>
<BR>
I see this error:<BR>
<BR>
<TT>diphthong:~/Mono/mcs/class/ByteFX.Data $ make<BR>
Creating ../../build/deps/default_ByteFX.Data.dll.makefrag ...<BR>
MONO_PATH=&quot;../../class/lib/default:$MONO_PATH&quot; mono&nbsp; ../../mcs/mcs.exe&nbsp;&nbsp; -d:NET_1_1 -d:ONLY_1_1 -g /noconfig /r:mscorlib.dll /r:System.dll /r:System.Xml.dll /r:System.Data.dll /r:ICSharpCode.SharpZipLib.dll /r:System.Design.dll /r:System.Drawing.dll /r:System.Windows.Forms.dll /r:Mono.Posix.dll /res:mysqlclient/Designers/command.bmp /res:mysqlclient/Designers/connection.bmp /res:mysqlclient/Designers/dataadapter.bmp /target:library /out:../../class/lib/default/ByteFX.Data.dll @ByteFX.Data.dll.sources<BR>
./Common/StreamCreator.cs(98) error CS1502: The best overloaded match for method ' Mono.Posix.UnixEndPoint..ctor (string)' has some invalid arguments<BR>
./Common/StreamCreator.cs(98) error CS1503: Argument 0: Cannot convert from 'char' to 'string'<BR>
./Common/StreamCreator.cs(98) error CS1501: No overload for method `Mono.Posix.UnixEndPoint' takes `1' arguments<BR>
./Common/StreamCreator.cs(98) error CS1501: New invocation: Can not find a constructor in `Mono.Posix.UnixEndPoint' for this argument list<BR>
./Common/StreamCreator.cs(99) error CS0165: Use of unassigned local variable `endPoint'<BR>
./mysqlclient/transcaction.cs(76) error CS0117: `ByteFX.Data.MySqlClient.Driver' does not contain a definition for `SendCommand'<BR>
./mysqlclient/transcaction.cs(97) error CS0117: `ByteFX.Data.MySqlClient.Driver' does not contain a definition for `SendCommand'<BR>
Compilation failed: 7 error(s), 0 warnings<BR>
make: *** [../../class/lib/default/ByteFX.Data.dll] Error 1<BR>
</TT><BR>
I can make a quick patch for the error in the UnixEndpoint constructor, but not having <TT>SendCommand</TT> defined is definitely a problem.<BR>
<BR>
Duncan.
</BODY>
</HTML>

--=-VyLo/0HPz2ascq3ItOeX--