REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.

Perhaps the subject will get someone to actually read this and offer even one reply with a suggestion? NB: This now kills mysql (process hang) in around 24 hours of uptime. --- I'm hoping someone can help me, I've got a problem with mysql going insane.. I've a quite busy application (avg 700 qu

Extreme frustration with cryptic error messages

Hello, all. I have been staring at this problem for an entire day. Googling turns up very little in the way of helpful information for solving my problem. So here's the situation: I have installed mySQL on Debian testing. I'm using mySQL version 3.23.52. It's running as a daemon. I have su

install on SuSE/PPC

iH trying to install mySQL 4.0.10 onto SuSE/PPC and getting an error when running ./configure cant create executable any ideas? thanks - hcir - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: CREATE INDEX is sooo slow! any ideas?

In the last episode (Feb 16), Michael T. Babcock said: > > At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote: > > > Well, MySql stores all its index information in one index file, > > > so when you add another index it has to rebuild the WHOLE file. > > > :) > > Anyone on the MySQL team feel like ex

Re: CREATE INDEX is sooo slow! any ideas?

At 06:27 PM 2/16/2003 -0500, Peter Grigor wrote: Well, MySql stores all its index information in one index file, so when you add another index it has to rebuild the WHOLE file. :) Anyone on the MySQL team feel like explaining that design decision, besides historical reasons? I doubt its any

EXPLAIN and TYPE = ALL

Hello All, I'm trying to optimize the following query and don't understand why the second line in the EXPLAIN result is type "ALL" and is not using the index on the primary key column in the individual table - can anybody shed any light? mysql> EXPLAIN SELECT individual.id, individual.name_

Re: Print out

mysql db -e "select * from test3;" | lpr Assuming Linux / UNIX, you have a line printer defined and db is the database to connect to. Van -- = Linux rocks!!! http://www.dedserius.com/ ==

Need Distinct and Min...

I have a table with three fields. In the first field I have a range of numbers 1-20; all repeated more than once. In the third field I have a number ranging from 1 to 20 in each row. I need to choose the lowest amount in the third column for each distinct value in the fist column. Will some

Print out

What would be the command in mysql for print out this: select * from test3; this prints out the table and show the records on screen now if I wanted to a hard copy.. how would I do this. Thanks- Rick - Before posting, please c

Re: CREATE INDEX is sooo slow! any ideas?

Thanks. So, after I've travelled to Seattle to get my coffee, do you think that creating this index will speed up the select queries? Would it be faster if I had created separate tables and indexed them individually? What is the thoughts about searching text fields for text. Is it best to st

Re: CREATE INDEX is sooo slow! any ideas?

Well, MySql stores all its index information in one index file, so when you add another index it has to rebuild the WHOLE file. :) Peter <^_^> - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: "david" <[EMA

Re: date functions

At 17:24 -0500 2/16/03, Melih Onvural wrote: Hi all i'm new to the SQL programming language and i was trying to play with a date/time counter of sorts. I was trying to teach myself the various date functions, but I feel like I've failed. I had a database with birthdates in it, and I subtracted

Re: date functions

Melih, > Year(Date - BirthDate) - 1900 What you're looking for is in the manual. Check it out: http://www.mysql.com/doc/en/Date_calculations.html Have fun! :) Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH Heesestr. 6, 12169 Berlin (Germany) Telefon: +49

Re: date functions

I know this is a MySQL list but Personally being a php coder, I'd do it in php. http://www.mysql.com/doc/en/Date_and_time_functions.html - Jerry @ MetalCat.Net - - Original Message - From: "Melih Onvural" <[EMAIL PROTECTED]> To: <[EMAIL PROTE

Re: CREATE INDEX is sooo slow! any ideas?

Yes it is but why would that slow down index creation on the other field. The full text index is just for the body field. Thanks At 05:58 PM 2/16/2003 -0500, Peter Grigor wrote: That body column wouldn't happen to be a fulltext index, would it? :) If so, 'ave another coffee. Peter <^_^> --

Re: CREATE INDEX is sooo slow! any ideas?

I meant buy the whole chain, its going to take a few cups Jerry - Original Message - From: "Peter Grigor" <[EMAIL PROTECTED]> To: "Jerry" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 11:11 PM Subject: Re: CREATE INDEX is sooo slow! any ideas? > Yes, and

Re: CREATE INDEX is sooo slow! any ideas?

Yes, and better go to the one across town to get it :) Peter <^_^> - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: "Jerry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 6:00

date functions

Hi all i'm new to the SQL programming language and i was trying to play with a date/time counter of sorts. I was trying to teach myself the various date functions, but I feel like I've failed. I had a database with birthdates in it, and I subtracted that from date in the Year() function and th

date functions

Hi all i'm new to the SQL programming language and i was trying to play with a date/time counter of sorts. I was trying to teach myself the various date functions, but I feel like I've failed. I had a database with birthdates in it, and I subtracted that from date in the Year() function and th

Re: CREATE INDEX is sooo slow! any ideas?

Another coffee ? I'd buy Starbucks . Jerry - Original Message - From: "Peter Grigor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "david" <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 10:58 PM Subject: Re: CREATE INDEX is sooo slow! any ideas? > That body column would

Re: CREATE INDEX is sooo slow! any ideas?

That body column wouldn't happen to be a fulltext index, would it? :) If so, 'ave another coffee. Peter <^_^> - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: "david" <[EMAIL PROTECTED]> To: <[EMAIL PROTE

CREATE INDEX is sooo slow! any ideas?

Hi I have one table with 12 million records. I'm trying to create an index on one of the fields and it's taking hours ( over 6 so far)! Am I doing something wrong? The command I issued was create index title on article ( title); The table files are -rwxrwxrwx1 mysqlmysql86

Re: Red Hat 8.0 compile problems with 4.0.10

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark T. Dame wrote: On 2/16/03 8:40 AM, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark T. Dame wrote: On 2/15/03 1:25 AM, Duncan Maitland wrote: I am having trouble compiling a custom mysqld (version 4.0.10) under Red

Re: Questions regarding mysql architecture

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dj W wrote: Hello, I've been looking through the source code for version 4.0.10-gamma trying to discern how exactly this thing runs by tracing back through the various inits() but because of how poorly it has been documented its slightly overwhel

Re: order by problem with 3.22

Am Sonntag, 16. Februar 2003 21:15 schrieb Paul DuBois: > At 20:43 +0100 2/16/03, sascha mantscheff wrote: > >The following query works with mysql 3.23: > > SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer ) > >It does not with mysql 3.22.27. Neither does any query with a function >

MySQL quitting, restarts only after hard reboot

Strange problem, maybe someone can help! Mac OS X Server, 10.2.1 - MySQL 3.23.51 Occasionally, MySQL just quits serving databases. The first indication is a forum or something comes up with a "could not connect to database" message. Logging in to MySQL via the command line works, but a show da

Re: order by problem with 3.22

At 20:43 +0100 2/16/03, sascha mantscheff wrote: The following query works with mysql 3.23: SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer ) It does not with mysql 3.22.27. Neither does any query with a function call in the order by clause. Is this documented somewhere? Am I missing

Can this be solved with just SQL?

Hi everyone! As I'm developer, i'd like to have my data from a database in just one query (and not some loops doing the result in 2 or more SQL-statements sending them 10 or more times). In my actual project i have a db structure like the on you can find here: http://www.schlitt-design.de/fahrschu

Re: joining queries

Hi Garry, As far as i understand you need to update two tables at the same time, but instead you are doing the other way around i guess? You are first inserting into one table, then retrieving from that table to update the tblStock, why not update them at the same time, in the same code? LOCK TAB

order by problem with 3.22

The following query works with mysql 3.23: SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer ) It does not with mysql 3.22.27. Neither does any query with a function call in the order by clause. Is this documented somewhere? Am I missing something? Is there a workaround other t

How to move database from one directory to another

Hi, everybody, I have installed the mysql server in /var/lib/mysql and created my database "Protein" under the this path as required in mysql and linux(the operationg system is linux). But the problem is the space for /var is not enough, there exists an exteral driver to try to solve this proble

Questions regarding mysql architecture

Hello, I've been looking through the source code for version 4.0.10-gamma trying to discern how exactly this thing runs by tracing back through the various inits() but because of how poorly it has been documented its slightly overwhelming to figure out what structures belongs to what modules o

Re: INSERTs getting slower with growing tabel, using no indexes?

That's what I'm hoping jerry - Original Message - From: "Peter Grigor" <[EMAIL PROTECTED]> To: "Jerry" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 1:39 PM Subject: Re: INSERTs getting slower with growing tabel, using no indexes? > I'm hoping that it's a MyI

Re: encrypted password

However, I currently have a need to extract and decode that data. I need a two way function. Curtis On Sun, 16 Feb 2003, Michael T. Babcock wrote: > Curtis Maurand wrote: > > >need to encrypt data and then retrieve it later (credit card data). I could > >probably pass it through and md5 or

Re: encrypted password

Point well taken. I will do remotes that way. Curtis On Sun, 16 Feb 2003, Michael T. Babcock wrote: > Curtis Maurand wrote: > > >need to encrypt data and then retrieve it later (credit card data). I could > >probably pass it through and md5 or des function via openssl I suppose and > >then

Re: Row numbers

just as: $myquery = "select * from sometable"; $myresult = mysql_query($myquery, $mysql_link); $rows = $mysql_fetch_array($myresult) $count = 1; while ($rows) { print(" $count$rows[0]$rows[1]... $count++; } I would do the same thing in perl, C++, or Java. Curtis On Sun, 16 Feb 2003, Micha

Re: joining queries

On Sun, 2003-02-16 at 16:38, Arda Balci wrote: > Hi Garry, > > Check INSERT ... SELECT syntax from the manual, > here is the example from there: > > INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fldOrder_ID FROM tblTemp1 WHERE > tblTemp1.fldOrder_ID > 100; > > If the source values are to be proce

Re: bandwidth, etc.

Paul DuBois wrote something vaguely resembling a message about SQL and QUERY: Bandwidth may appear to be adequate, but it seem to me like the network is where you want to look to find the latency problems. To follow up on that, set up something like RRDTool on the network (or get someone

Re: encrypted password

Curtis Maurand wrote: need to encrypt data and then retrieve it later (credit card data). I could probably pass it through and md5 or des function via openssl I suppose and then store it. Perl and PHP both have functions to handle that. Just to be a security nut, you shouldn't use the encry

install tar.gz help

hello all, i seem to be getting stuck right at the beginning of attempting to install mysql! I have downloaded 3.23.42.tar.gz and then I perform the following commands as instructed in the manual... tar -zxvf mysql-3.23.42.tar.gz cd mysql-3.23.42 ./configure --prefix=/usr/local/mysql --localst

Re: Need Help With MySQL Query

Veysel Harun Sahin wrote: select vanNumber, sum(grossPay) from usertableDaily group by vanNumber; The above is the correct query, to save yourself some time. As for your problem: But when I execute I get this: Resource id#3 Resource id#4 This means you're using a resource resp

Re: joining queries

Hi Garry, Check INSERT ... SELECT syntax from the manual, here is the example from there: INSERT INTO tblTemp2 (fldID) SELECT tblTemp1.fldOrder_ID FROM tblTemp1 WHERE tblTemp1.fldOrder_ID > 100; If the source values are to be processed before inserting into the target table then you may use the

Re: Red Hat 8.0 compile problems with 4.0.10

On 2/16/03 8:40 AM, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark T. Dame wrote: On 2/15/03 1:25 AM, Duncan Maitland wrote: I am having trouble compiling a custom mysqld (version 4.0.10) under Red Hat 8.0 - I did email this list a few weeks ago and I have tried a few

Re: Red Hat 8.0 compile problems with 4.0.10

hello afaik: turn off the optimizing options before compiling/making. ... or get a completely new glibc family and compile each and everything pertinent. ... or use rh 7.3 kr mr >>> Mark Matthews <[EMAIL PROTECTED]> 02/16/03 14:43 PM >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark T.

joining queries

I would like to use values in one table to update those in another but i only want to use one query. Is there any way to do this. regards garry saddington - Before posting, please check: http://www.mysql.com/manual.php (th

Re: Row numbers

Luc Foisy wrote: I didn't say it had nothing to do with the data, I said it had nothing to do with the data in the database. I'm making the assumption as a DBA that _all_ the data relevant is in the database; so the comment I made was equivalent to the above. As I said, sure I could make ext

Re: Red Hat 8.0 compile problems with 4.0.10

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mark T. Dame wrote: On 2/15/03 1:25 AM, Duncan Maitland wrote: I am having trouble compiling a custom mysqld (version 4.0.10) under Red Hat 8.0 - I did email this list a few weeks ago and I have tried a few things since then but I am asking again in

Re: INSERTs getting slower with growing tabel, using no indexes?

I'm hoping that it's a MyIsam table. Peter <^_^> - Peter Grigor Hoobly Free Classifieds http://www.hoobly.com - Original Message - From: "Jerry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 5:52 AM Subject: Re: IN

Re: INSERTs getting slower with growing tabel, using no indexes?

What type of table is it ? Would that effect it ? Jerry - Original Message - From: "Magnus Själander" <[EMAIL PROTECTED]> To: "'Peter Grigor'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 9:17 AM Subject: RE: INSERTs getting slower with growing tabel, using no

RE: INSERTs getting slower with growing tabel, using no indexes?

The platform I'm using is Windows 2000 with NTFS and the file is around 250MB. /Magnus -Original Message- From: Peter Grigor [mailto:[EMAIL PROTECTED]] Sent: den 16 februari 2003 00:13 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: INSERTs getting slower with growing tabel, using