Mailing List Archive


Back to the month index Back to the list index
Guido Klapperich (klapper@rbg.informatik.tu-darmstadt.de)
Mon, 10 Nov 1997 04:16:45 +0100 

Message-ID: <34667C9D.F7564D68@rbg.informatik.tu-darmstadt.de>
Date: Mon, 10 Nov 1997 04:16:45 +0100
From: Guido Klapperich <klapper@rbg.informatik.tu-darmstadt.de>
Subject: (no subject)

I have installed the mSQL-Version for NT and works, but I have a
problem. When I try to create a database with the msqladm-tool tho
following errormessage appears:
mSQL-Command failed !
Server-Error = Error creating database

I'm logged in as root user and I'm working on the localhost.

Guido Klapperich.
From joerg@strindberg.ling.uu.se Mon Nov 10 03:06:56 1997
Received: from mocha.bunyip.com (mocha.Bunyip.Com [192.197.208.1])
        by services.bunyip.com (8.8.5/8.8.5) with ESMTP id DAA22027
        for <msql-list@services.bunyip.com>; Mon, 10 Nov 1997 03:06:56 -0500 (EST)
Received: from stp.ling.uu.se (strindberg.ling.UU.SE [130.238.167.40])
        by mocha.bunyip.com (8.8.5/8.8.5) with SMTP id DAA20124
        for <msql-list@bunyip.com>; Mon, 10 Nov 1997 03:06:27 -0500 (EST)
Received: from localhost by stp.ling.uu.se (AIX 4.1/UCB 5.64/4.03)
          id AA32772; Mon, 10 Nov 1997 09:06:51 +0100
Date: Mon, 10 Nov 1997 09:06:51 +0100 (NFT)
From: =?ISO-8859-1?Q?J=F6rg_Tiedemann?= <joerg@strindberg.ling.uu.se>
To: msql-list@bunyip.com
Subject: slow joins with mSQL 2.x
Message-Id: <Pine.A32.3.94.971110090633.26922G-100000@strindberg.ling.uu.se>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Hi,

The last two weeks I tried to test mSQL to use it for our linguistic
database here in Uppsala. This database consists of quite complex data and
should contain several tables. Now it is necessary to combine information
from several tables to process specific queries.

In one of my test databases I tried to define a join over 2 tables
containing about 7000 datasets. It took more than 30 minutes to compute
the result. As far as I read in several documentations this problem was
normal for mSQL 1.x but should be fixed in versions above 2.0?!

The system I'm working with is AIX, but this shouldn't be a problem.
Is mSQL maybe not suitable to more complex data structures.

Joerg

The msqladmin version information:

Version Details :-

        msqladmin version 2.0.3
        mSQL server version 2.0.3
        mSQL protocol version 23
        mSQL connection Localhost via UNIX socket
        Target platform AIX-4.1-rs6000

Configuration Details :-

        Default config file /usr/local/Hughes/msql.conf
        TCP socket 1114
        UNIX socket /usr/local/Hughes/msql2.sock
        mSQL user msql
        Admin user root
        Install directory /usr/local/Hughes
        PID file location /usr/local/Hughes/msql2d.pid
        Memory Sync Timer 30
        Hostname Lookup True

***********/\/\/\/\/\/\/\/\/\/\/\************************************
** Joerg Tiedemann e-mail: **
** Sernanders vaeg 5:520 joerg@stp.ling.uu.se **
** 75261 Uppsala tiedeman@sunpool.cs.uni-magdeburg.de **
** SWEDEN http://stp.ling.uu.se/~joerg/ **
*************************************/\/\/\/\/\/\/\/\/\/\/\**********