How to index this properly (to make it go faster) ?

2001-03-24 Thread Nemholt, Jesper Frank
Hi! I have this table : mysql describe proc; +-+---+--+-+ -+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+ -+---+

Re: MySql Amiga

2001-03-24 Thread Sinisa Milivojevic
SixK writes: Hello, First of all, i'm proud to announce the first Port of MySql to AmigaOs... you know this old gaming computer based on 68000 motorola chip... you don't know it ?? never mind .. I had several probleme when compiling. First of all, configure could not find PS

Re: Bug in mysql_info()?

2001-03-24 Thread Sinisa Milivojevic
Robert MacDonald writes: MySQL (version 3.23.33 on Linux 2.2.5-15) is returning an empty string from mysql_info() following an UPDATE query. The docs say: char *mysql_info(MYSQL *mysql) Description Retrieves a string providing information about the most recently executed

Re: Re[28]: Warning: Got signal 14 from thread X

2001-03-24 Thread Sinisa Milivojevic
BAUMEISTER Alexandre writes: Sinisa, SM No, nothing, No need to test further. SM Try those Solaris patches, re-install gcc and build from the fresh SM tarball without debug and with all the options like the last time. Fresh tarball. Latest Solaris 2.8 patch applied !

Re: Bad optimization with two conditions?

2001-03-24 Thread Federico Giannici
Fred van Engen wrote: Hi, On Fri, Mar 23, 2001 at 07:46:48PM +0100, Federico Giannici wrote: We have a table where we register the data of all the modem connections of the users of a small ISP. The table contains 2 million records and has the following structure: ... What

RE: mysql gui core dump on Solaris 2.8

2001-03-24 Thread Sinisa Milivojevic
deCarmo, Linden writes: Hi! It is from the bug in MySQL++. I am sending you a patch in direct mail. Regards, Sinisa Thanks for the patch. It solved the core dump, but now mysql_real_connect() is failing rather than core dumping. connection.cc then

Re: autocommit == innobase_flush_log_at_trx_commit ?

2001-03-24 Thread Heikki Tuuri
Hi! No, autocommit means that the system automatically issues a commit after each SQL statement. You do not have to explicitly write 'COMMIT' in your application. If you set innobase_flush_log_at_trx_commit=0, then Innobase will not flush the log to disk immediately at a commit, and you may

Re[30]: Warning: Got signal 14 from thread X

2001-03-24 Thread BAUMEISTER Alexandre
Sinisa, SM There is no thread 4 because may be it has died. SM If your daemon is multithreaded, then some of it's thread has may be SM died, thus causing timeout. SM I hate myself for saying this, as logically there could be no SM connection, but Just out of curiosity if you build without

Re[13]: Warning: Got signal 14 from thread X

2001-03-24 Thread Michael Widenius
Hi! "BAUMEISTER" == BAUMEISTER Alexandre [EMAIL PROTECTED] writes: cut BAUMEISTER No I did not do "make clean". I didn't knew that I had to in order BAUMEISTER to update mysqlbug. One must always doe a 'make clean' if one changes any configure arguments. BAUMEISTER As I was each

Re: Bug in mysql_info()?

2001-03-24 Thread Robert MacDonald
On Sat, 24 Mar 2001 14:40:03 Sinisa Milivojevic wrote: Robert MacDonald writes: MySQL (version 3.23.33 on Linux 2.2.5-15) is returning an empty string from mysql_info() following an UPDATE query. Is this a known bug? I saw a similar report in the archives from last year, but no

Re[14]: Warning: Got signal 14 from thread X

2001-03-24 Thread BAUMEISTER Alexandre
Michael, BAUMEISTER No I did not do "make clean". I didn't knew that I had to in order BAUMEISTER to update mysqlbug. MW One must always doe a 'make clean' if one changes any configure arguments. I'm compiling from a fresh tarball each time. .. MW I assume you did used gnu make for

Re: size limitation

2001-03-24 Thread Heikki Tuuri
Pascal, could you describe what indexes you should have on the data, and how you will add to it and delete from it? In order to choose a DBMS, i've to check to MySQL is able to support our requirements. I've got to manage one database. This database is made of one table. This table will grow

Connection related SIG 11 crash in 3.23

2001-03-24 Thread Michael Widenius
Hi! "Voytek" == Voytek Lapinski [EMAIL PROTECTED] writes: Voytek Ok... I've posted briefly regarding this, but heres a complete bug report. Voytek Yeah I know its kinda long, but I thought it better to include more rather Voytek than less. Voytek We are seeing a problem which results in

Re[31]: Warning: Got signal 14 from thread X

2001-03-24 Thread Heikki Tuuri
Hi Sinisa, Monty, and Alex! I am just compiling a debug version of Innobase. I will try to run stress tests on our Sun. I see that also Monty is currently running a test on our Sun. But could you Alex describe, was it so that you were able to get signal 14 even without running your 30 UPDATE

mysqlc.exe

2001-03-24 Thread E Ruzicka
Hello mysql users, I have installed "mysql-3_23_32-win.zip" in c:\mysql on Windows 98. All what I start is OK (mysqld, mysql, Winmysqladmin, mysqlmanager, mysqlshow,...) except mysqlc.exe When I start mysqld.exe or mysqld-opt.exe and then mysqlc.exe I obtain error message: error 2003: Can't

BADLY NEED HELP

2001-03-24 Thread Nuno Ferreira
-rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD -rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM -rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm I've been reading all the archieve files about a error i get when trying to do

Re: autocommit == innobase_flush_log_at_trx_commit ?

2001-03-24 Thread Dan Nelson
In the last episode (Mar 24), └»╜┬╚╞ said: Hi, I have a newbie question. Is "autocommit == innobase_flush_log_at_trx_commit" ? No; autocommit is more of a logical SQL operation, where innobase_flush_log_at_trx_commit causes a physical action. With autocommit unset, you can send multiple

compile error (MacOS-X retail version)

2001-03-24 Thread Tr909 Dr . Umachine
Hello MySQL, i downloaded 3.23.25 from the MySQL website and it errors in ./configure included are the last lines from the terminal window. (if neccesary i can send the config.log too 88KB) it has lots of failed programms i'll include some snippets below. ./configure says the system is Darwin

compile error (MacOS-X retail version) 2

2001-03-24 Thread Tr909 Dr . Umachine
Sorry, the error is in the MAKE process not the configure process. tr909 (gerhard) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: How to index this properly (to make it go faster) ?

2001-03-24 Thread Benjamin Pflugmann
Hi. On Sat, Mar 24, 2001 at 10:53:19AM -, [EMAIL PROTECTED] wrote: Hi! I have this table : mysql describe proc; +-+---+--+-+ -+---+ | Field | Type | Null | Key | Default | Extra |

Re: Bug in mysql_info()?

2001-03-24 Thread Benjamin Pflugmann
Hello. On Sat, Mar 24, 2001 at 09:48:43AM -0500, [EMAIL PROTECTED] wrote: On Sat, 24 Mar 2001 14:40:03 Sinisa Milivojevic wrote: [...] Yes, this is a known bug, here is a patch for it: Thanks! I looked in the manual under "Known errors and design deficiencies in MySQL" (doing a search

SIG 11 problem/ coredumps/ stack traces

2001-03-24 Thread Sasha Pachev
Voytek: This is in regards to your post regarding the problems you were having with MySQL getting signal 11 with the stack trace, and some follow up messages. First some background. Signal 11 (SIGSEGV) happens when a program tries to follow an invalid memory reference. While this is possible

Re: Bad optimization with two conditions?

2001-03-24 Thread Fred van Engen
Hi, On Sat, Mar 24, 2001 at 02:04:57PM +0100, Federico Giannici wrote: Fred van Engen wrote: On Fri, Mar 23, 2001 at 07:46:48PM +0100, Federico Giannici wrote: We have a table where we register the data of all the modem connections of the users of a small ISP. The table contains 2

RE: How to index this properly (to make it go faster) ?

2001-03-24 Thread Nemholt, Jesper Frank
-Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: sabado, 24 de marzo de 2001 23:31 To: Nemholt, Jesper Frank Cc: '[EMAIL PROTECTED]' Subject: Re: How to index this properly (to make it go faster) ? First, you should run an analyize on your indexes

SQL Market share

2001-03-24 Thread Dan Harrington
Greetings everyone, Does anyone know if a reputable source has done market share studies with the various SQL servers out there in enterprise Web settings? I'm trying to convince a company to have support for more than Microsoft and Oracle servers so I am looking for some numbers to back me up

query

2001-03-24 Thread Shawn
Everythng that I find seems to be a little advanced for what I am needing. All I want to do is select a value (sales,marketing,finance,etc from a table row) all I seem to find is how to return all data for that row in a formated order. How should I request this. Shawn House

Re: SQL Market share

2001-03-24 Thread Jeremy D . Zawodny
On Fri, Mar 23, 2001 at 10:42:10AM -0700, Dan Harrington wrote: Greetings everyone, Does anyone know if a reputable source has done market share studies with the various SQL servers out there in enterprise Web settings? I'm trying to convince a company to have support for more than

Cannot insert data into table

2001-03-24 Thread kuttappan
Hello all. This is a snippet from my JavaBean that I'm using to insert data into MySql database. The bean is working perfectly alright but I can't insert data into the user table. Please help and do tell what I'm doing wrong here. This is the code: public String saveToDB() { try {

Re: mysql_auth HELP!

2001-03-24 Thread kuttappan
Hello Linsen, I would like to know more about mysql_auth and how to use htpasswd file [I don't even know what this is!!] for user authentication. Please guide me or refer me to a url where I can find this info. Thanks. Rohit. - Original Message - From: "Linsen Limsico" [EMAIL

Re: size limitation

2001-03-24 Thread Jeremy D . Zawodny
On Sat, Mar 24, 2001 at 05:30:52PM +0200, Heikki Tuuri wrote: MySQL/Innobase may be able to do what you need, but we should have a real-world test of using a big disk farm. I do not know if any MySQL user uses a disk farm. Maybe Jeremy Zawodny knows? I don't know of anyone doing that yet...

Re: compile error (MacOS-X retail version)

2001-03-24 Thread Paul DuBois
At 7:26 PM +0100 3/24/01, Tr909 Dr. Umachine wrote: Hello MySQL, i downloaded 3.23.25 from the MySQL website and it errors in ./configure included are the last lines from the terminal window. (if neccesary i can send the config.log too 88KB) it has lots of failed programms i'll include some

Memory leakage? With MySQL GUI v1.7.4-1

2001-03-24 Thread Aidan McGuinness
Hello, I've encountered a problem with MySQL GUI 1.7.4.-1. I'm not quite sure what triggers the error - whenever its open Ive had a MySQL server (3.22) running, as well as Java Forte Editor (v2.0) and Internet Explorer (v5.5). The problem is fairly nasty and I only detected it with TaskInfo 2000

Coredump on quickly disconnecting clients

2001-03-24 Thread Sasha Pachev
Voytek: Found the problem with your signal 11 with strange traces from inside LinuxThreads. This was a hard concurrency bug - the problem was that a memory reference passed to pthread_create was getting invalidated by the thread that pthread_create was launching before pthread_create would

Re: Large search engine

2001-03-24 Thread Cedric Veilleux
Hi, You are right about this, I should have thought about it. There is just one problem: A word can occur multiple times in the same documents, so the table which gives the position of a word in a doc. must give all the positions of the word. If we keep your logic, we would have to make a