AW: Problem compiling MySQL-4.0.0-alpha with charset german1

2001-10-26 Thread Stephan Skusa
]] > Gesendet: Freitag, 26. Oktober 2001 11:32 > An: Stephan Skusa > Cc: [MYSQL] > Betreff: Re: Problem compiling MySQL-4.0.0-alpha with charset german1 > > > On Fri, 26 Oct 2001, Stephan Skusa wrote: > > > if I do a > > > > ./configure --prefix=/usr/local

AW: Problem compiling MySQL-4.0.0-alpha with charset german1

2001-10-26 Thread Stephan Skusa
latin1_de results in the same problem! > -Ursprungliche Nachricht- > Von: Thomas Spahni [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 26. Oktober 2001 11:32 > An: Stephan Skusa > Cc: [MYSQL] > Betreff: Re: Problem compiling MySQL-4.0.0-alpha with charset german1 >

Problem compiling MySQL-4.0.0-alpha with charset german1

2001-10-26 Thread Stephan Skusa
rc/mysql-4.0.0-alpha' make: *** [all-recursive-am] Error 2 Where is the problem?? TIA -- Stephan Skusa mailto:[EMAIL PROTECTED] Lippe-Net Online-Service http://www.lippe-net.de Herforder Strasse 309 tel.: +49 (0)521 - 977 998

Help optimizing server ...

2001-08-01 Thread Stephan Skusa
Hello, I need some help for database optimization ... is there any documentation about tuning server parameters except this one in MySQL-documentation which ist not very detailed I think especially in case of effects on server or threads. TIA Stephan -- ***

Help optimizing server ...

2001-07-31 Thread Stephan Skusa
Stephan Skusa mailto:[EMAIL PROTECTED] Lippe-Net Online-Service http://www.lippe-net.de Trees hit cars only in self-defence

AW: [mysql.server stop fails under OpenBSD 2.9]

2001-07-23 Thread Stephan Skusa
I don't think it's a OpenBSD Problem ... I've got the same behavior on several Unix - Machines ... running 3.23.33 - 3.23.39 ... > -Ursprungliche Nachricht- > Von: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 23. Juli 2001 12:43 > An: [EMAIL PROTECTED] > Cc: [EMAIL P

AW: How to create table in msql DB through cgi script

2001-07-21 Thread Stephan Skusa
What about installing and using phpMyAdmin?? http://phpmyadmin.sourceforge.net/ > -Ursprungliche Nachricht- > Von: Joseph Maxwell [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 21. Juli 2001 12:58 > An: [EMAIL PROTECTED] > Betreff: How to create table in msql DB through cgi script > >

AW: Outer join syntax..

2001-07-16 Thread Stephan Skusa
MySQL uses the LEFT JOIN, RIGHT JOIN Syntax ... RTFM: http://www.mysql.com/doc/J/O/JOIN.html > -Ursprüngliche Nachricht- > Von: Bruce Stewart [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 16. Juli 2001 11:54 > An: Mysql-Help (E-mail) > Betreff: Outer join syntax.. > > > Hi all, > > MyS

AW: Another signal 11 dump ...

2001-05-22 Thread Stephan Skusa
cept this large mailings ... ;o) > -Ursprungliche Nachricht- > Von: Colin Faber [mailto:[EMAIL PROTECTED]] > Gesendet: Mittwoch, 23. Mai 2001 05:43 > An: Stephan Skusa > Cc: [MYSQL] > Betreff: Re: Another signal 11 dump ... > > > have you tried trussing the mysqld

Another signal 11 dump ...

2001-05-22 Thread Stephan Skusa
Another signal 11 dump ... cutting down sort_buffer to 4194296 Bytes seems not to be the solution for the signal 11 at 0 o'clock ... stated some weeks ago! mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a r

AW: MySQL-Server getting signal 11 ... !!

2001-05-07 Thread Stephan Skusa
The Cron-Jobs working on all tables of these database are all running between 2:00 and 4:00 ... none at 0:00! > -Ursprungliche Nachricht- > Von: Gerald Clark [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 7. Mai 2001 15:24 > An: Stephan Skusa > Cc: MySQL > Betreff

MySQL-Server getting signal 11 ... !!

2001-05-06 Thread Stephan Skusa
is a temporary table. Every time I execute this statement manualy using tool mysql everything works fine. TIA Stephan Skusa mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace t

MySQL-Server getting signal 11 ... almost every day arround 0:00 am ... using temporary tables

2001-05-04 Thread Stephan Skusa
is a temporary table. Every time I execute this statement manualy using tool mysql everything works fine. TIA Stephan Skusa mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace t

Add: Problem removing multiple udf functions ...

2001-03-21 Thread Stephan Skusa
Number of processes running now: 1 mysqld process hanging, pid 30175 - killed 010322 05:16:56 mysqld restarted /usr/local/mysql-3.23.33/libexec/mysqld: Warten auf Verbindungen. -Ursprüngliche Nachricht- Von: Stephan Skusa [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 22. Mär

Problem removing multiple udf functions ...

2001-03-21 Thread Stephan Skusa
Hello, I've got a problem. If I remove multiple udf-Funktions of one udf-Library i get a 'lost connection' error. I'm using a sql-script deleting for example 4 functions and then recreate them (because of an update of the .so) Any ideas?? TIA

AW: Antwort: Select from dual?

2001-03-01 Thread Stephan Skusa
DUAL is a dummy table in oracle ... ! In mysql you have two way to set variables: 1. set them directly via SET @variable={ integer expression | real expression | string expression }[,@variable= ...]. 2. or do something like select @variable:={ integer expression | real expression | string expre

Logfile message???

2001-02-27 Thread Stephan Skusa
What does this message in my logfile mean?? 010227 21:23:01 Verbindungsabbruch 1976 zu db: 'database' user: 'user' host: `archimedes.int.lippe-net.de' (Fehler beim Lesen eines Communication-Packets)

AW: Maximum Capacity and Stability

2001-02-08 Thread Stephan Skusa
If that's the case u r running it but not really using it ... !! > -Ursprüngliche Nachricht- > Von: Joshua J. Kugler [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 8. Februar 2001 22:24 > An: Chan, Kwok-Hing; '[EMAIL PROTECTED]' > Betreff: Re: Maximum Capacity and Stability > > > I c

AW: Strange behavior of MySQL 3.23.xx with GROUP BY ...

2001-01-26 Thread Stephan Skusa
I think that is the wrong answer ... Standard-SQL and ANSI-SQL require that a column that is displayed and has no grouping function applied to it MUST also appear in the GROUP BY-clause!!! The result: fldNAME fldMONAT sum(fldSALARY) boris 1 10200 stephan 1 6000 i

Strange behavior of MySQL 3.23.xx with GROUP BY ...

2001-01-25 Thread Stephan Skusa
INTO groupbyTEST VALUES ( 'boris', '5', '2300', '2001-01-25 23:16:01'); INSERT INTO groupbyTEST VALUES ( 'boris', '6', '200', '2001-01-25 23:16:11'); A statement like: SELECT fldNAME, fldMONTH, sum(fldSALARY) FROM