error:mysqld got signal 11

Hello, I have started mysql server keeping binary logs and once in a while I execute "reset master". Irregularly mysqld crashes and in the error logs I read the lines bellow: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it

Re: Updating blob from command line

Paul, I checked for InnoDb and this have to work with MyIsam also. But also decide your size. If your size exceeds the limit, it get truncated and u never come to know during insert. so you can go for mediumblob if it exceeds the blob size. Check for the size restrictions in the manual. rega

Re: signal 11 when SELECT DISTINCT blah FROM table LEFT JOIN blah...

Apologies, I thought I had done a decent search to see if anyone else had reported it, but apparently my search skills are lacking, I see that it was fixed in 4.0.4. On Wed, Sep 25, 2002 at 11:34:07PM -0500, Shane Allen wrote: > >Description: > > selecting distinct when executing a left join ca

MySQL on Red Hat Advanced Server?

Hi there, Anyone have experience (good or bad) running recent 3.23.49-or-higher MySQL releases on Red Hat Advanced Server? I'm thinking of test driving it and was wondering if anyone has seen noticeable performance improvements over 7.3 or any gotcha's to watch out for. Oddly enough, I'm sort

Re: Wrong path for temp file

Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) From: [EMAIL PROTECTED] Date: Mon, 23 Sep 2002 11:57:19 -0800 (AKDT) News-Group: list.mysql Reply-To: <[EMAIL PROTECTED]> >Description: While trying to run this query: SELECT users_1.* FROM user

Re: transactions...

From: Dana Diederich <[EMAIL PROTECTED]> Date: Mon, 23 Sep 2002 09:40:45 -0500 Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from MyISAM to Innodb, because we have database tables that have many updates, inserts, deletes and selects going on at the same tim

InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using AUTO_INCREMENT column)

We have been using InnoDB with MySQL (MySQL-Max-3.23.52-1) for transaction support in some complex situations in our application when maintaining consistency is critical. Recently we did some stress testing by simulating 10 concurrent users (perl/DBD) doing large number of inserts on a few tab

How to create a table from other tables

Dear all i had two tables, tableA & Table B. I want to create a permanent table call Table C which the first two field will be equal to Table A's first 2 field and last field will be equal to Table B's first field. can anyone pls tell me what query should i use? it will be nice if you can provid

default date time insertion in the database

Hi, can anyone tell me how can i set the default datetime as current datetime in the mysql. so that every time i insert a record in the table current datetime automaticall inserted. Thanks in advance. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court DLF phase IV Gurgaon, India

signal 11 when SELECT DISTINCT blah FROM table LEFT JOIN blah...

>Description: selecting distinct when executing a left join causes mysql to die >How-To-Repeat: CREATE TABLE test1 ( i1 int(10) unsigned NOT NULL default 0, s1 varchar(30), PRIMARY KEY (i1) ); CREATE TABLE test2 ( i1 int(10) unsigned NOT NULL default 0, s1 varchar(30), PRIMARY KEY (i1) ); ins

Fw: Updating blob from command line

sorry i missed the update statement UPDATE temponly SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name = 'velan' ; regards - Original Message - From: "kayamboo" <[EMAIL PROTECTED]> To: "Chris" <[EMAIL PROTECTED]> Cc: "list mysql" <[EMAIL PROTECTED]> Sent: Thursday, September 2

Re: Mysql Error

I have installed the php-mysql package and can now connect to the database. There is however another error which i do not undertand. Warning: No MySQL-Link resource supplied in /usr/local/www/vantweststamps/databaselogin.php on line 15 Connected successfully These pages all work without error on

Not Null

I create a table with a VarChar field set to not null. When I do an insert into this table with no value for this field it goes through without a problem. I realize MySQL inserts a empty string into the field. But what a want is an error when this happens. Is there any way to force this?

Re: primary keys

At 11:55 -0700 9/23/02, johnbarri wrote: >Hi - I'm a mysql newbie. As I've yet to discover a method of batching mysql >commands I prefer to input lengthy instructions (such as large file >structures) in stages, so input errors can be dealt with more easily. For >example, I first define table str

primary keys

Hi - I'm a mysql newbie. As I've yet to discover a method of batching mysql commands I prefer to input lengthy instructions (such as large file structures) in stages, so input errors can be dealt with more easily. For example, I first define table structures and then indexes. This led me to use

Re: Updating blob from command line

CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE = INNODB ; INSERT INTO temponly(name , pic) values( 'velan', load_file('e:/mysql/images/Click.gif')) ; Hope this helps. - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesda

Re: Set Path Environment

Why not you set the path in your environment variables and restart the computer Are you using win98 or NT? - Original Message - From: "William Martell" <[EMAIL PROTECTED]> To: "MySQL Main List" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 11:33 AM Subject: Set Path Environment

newbie only

i've installed ver 3.23.47 sa win2k pero di ko sya mstart as service.. if i type this==>mysqladmin create database01 ERROR==>mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MYSQL server on 'localhost' <10061>' Check that mysqld is running on localhost and that the p

Re: MySQL as a desktop DB

> I think MySQL will be more faster in Desktop environment and if you are > adverse to using the text based interface to MySQL then you can try out some > GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but > since MySQL-Front has been discontinued you can try SQLyog at > h

Re: Temporary tables

On Wed, 2002-09-25 at 10:10, Keith C. Ivey wrote: > On 25 Sep 2002, at 0:57, John Coder wrote: > > > So it's probably the fact that I didn't make the connection persistent > > that screwed me up sometimes I feel so stupid. > > I don't think that will help. Read Paul's message again. Even if >

RE: OT Re: Mysql, PHP and a wrapper

whew, I found it. I looked at my installed rpm's ('rpm -q php') found the install php 4.1.2-7.3.4. Tried to remove ('php -e php*.rpm') got multiple dependent errors. That when I noticed I had about 6 rpm's had installed 6 different flavors of php. I uninstalled all and reinstalled just php-4.1.2

Re: RE: rE: re: mi fa so la ti do... Character Set Settings Query

Query: can you guys please trim up your quotes a little? -- : Jan Steinman -- nature photography: : Bytesmiths -- artists' services: : Join the forums at ---

Re: client library no longer LGPL licensing

> Does this also apply to non-open-source but free applications? For > example, we give away Escapade for free - always have, always will, > at least for the minimal version of the product. If we develop a > non-free version of Escapade that uses mysqlclient, what happens > then? We also dist

Re: speed problems (?!)

On Wed, Sep 25, 2002 at 11:33:37PM +0300, Gergely Imre wrote: > > hi all > > i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000 > records in it (4 field/record). i have 256megs of RAM, and the linux > version is RedHat 7.3. i do a simple delete, like: > > delete from foo

MySQL InnoDb restore

I am new to InnoDb and was wondering what steps I would have to do to restore a table. Lets assume I am backing up the data by backing up the tablespaces. Thanks in advance (MySQL, query) - Before posting, please check: htt

Re: The record_buffer ,join_buffer, sort_buffer

On Wed, Sep 25, 2002 at 08:42:05AM -0300, Dyego Souza do Carmo wrote: > > The variables record_buffer,join_buffer and sort_buffer are alocated > every "user connect" ? No, their are allocated on an as-needed basis for each thread. If a thread doesn't need to join anything, there will be no join

Re: MyISAM or InnoDB

On Wed, Sep 25, 2002 at 08:26:25AM -0600, Scott Pippin wrote: > We are moving a databse over from Oracle to MySQL 4.0.3 and I was > wondering if I should use MyISAM or InnoDb. The databse currently has > 800-900 updates and inserts done to it in a day along with about 1000 > selects. Would I run

RE: client library no longer LGPL licensing

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > The change is made to avoid lots of discussions about when the GPL > is effective. Basically we follow the same rules as we always have > about when we want people to pay us for a commercial license but > now we have a better legal ground to base it

Re: speed problems (?!)

Any reason you can't upgrade to a newer version? mysql,query DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this threa

Re: Meidumtext vs. varchar

On 25 Sep 2002, at 16:28, Brent Baisley wrote: > Your biggest speed benefit can actually be attained by avoiding varchar > and text fields altogether, use char(). This will cause each record to > be exactly the same length, which will allow MySQL to "jump" to spot in > the file quicker. It's l

Re: OT: Multiple Referral Levels

Not really a MySQL question, but... The way you have it now definitely won't work. Your select statement for getting the number of referrals for level one will always return a count of one -- because id is the primary key of your table. One way to do this, without listing all the referrals in a s

RE: phpMyAdmin/MySQL Question

Yes, please, someone please tell how that mysql.sock file is working. I get the same general thing as well when I try to connect using just mysqladmin. Don B. -Original Message- From: Easton, William [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 10:55 AM To: '' Subject:

speed problems (?!)

hi all i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000 records in it (4 field/record). i have 256megs of RAM, and the linux version is RedHat 7.3. i do a simple delete, like: delete from foo_db where foo>10; (this is around 15.000 record) and after 30 minutes, still

RE: phpMyAdmin/MySQL Question

I believe you need to change the socket to the location in your /etc/my.cnf file. I usually add both sections in it just to kep things straight. [client] socket=path-for-socket-file [mysqld] socket=path-for-socket-file I used /ldata/mysql/tmp/mysql.sock my.cnf isn't automatically there so you

Re: Meidumtext vs. varchar

It's probably faster to retrieve from a varchar field than a mediumtext field, but any benefit is completely erased by the need to perform an "OR" query to search in both fields. Your biggest speed benefit can actually be attained by avoiding varchar and text fields altogether, use char(). Thi

Re: I want to unsubscribe but the freaking commands don't work

Then, go here: http://lists.mysql.com/php/unsubscribe.php Or, try using a real MUA. Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = David Busby wrote

Load Data from multiple sources

Hello All, Can someone tell me if I can load only one column of data from a tab delimited text file into MySQL 4.0? If so, then can I assume that I can load data from multiple data stores, picking columns as I need to. Thank you for your assistance. William --

Re: Multiple Referral Levels

You are on the right track that you don't want to modify the database just to add a "level". You also want to have your "levels" in one column/field so that you can use an index to search it quickly and easily. You didn't mention whether someone can be referred on multiple levels, this will r

Re: Case sensitivety behaviour [followup re: bugfix]

At 20:25 -0500 9/23/02, Paul DuBois wrote: >At 16:43 -0700 9/23/02, Jan Steinman wrote: >> >From: "Moestl, Wolfgang" <[EMAIL PROTECTED]> >>> >>>Is there a defined behaviour for handling the case-sensitivety for >>>user- and hostnames? >> >>According to the specification for the Domain Name Syste

re: No my.cnf file on Linux?

Lindberg, Wednesday, September 25, 2002, 5:17:53 PM, you wrote: LP> I use mysql 3.23.4 max on linux and it have worked just fine. LP> Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. If you want to use transaction, you should use InnoDB or BDB tabl

RE: MySQL as a desktop DB

also: - mysqlstudio -> http://www.mysqlstudio.com mascon -> http://www.scibit.com -j -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: September 25, 2002 1:09 PM To: Insanely Great; MySQL List Subject: RE: MySQL as a desktop DB I use MySQL as a desktop db

New to MySql

Hello all, I am brand new to MySql and I wanted to know if you could recommend any books that are a good start on learning the mechanics of MySql. Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Max NB of MyISAM tables / DB ( Ext3 & linux )

> If not, i know that ext3 can have ten of thousands files in a directory. > But commande like 'ls' will become slower and slower ... > Is this also slowing mysql ? I believe it would have to. There is a patch somewhere (I don't know if it's maintained) for adding indexed directories to ext2/ext

Re: client library no longer LGPL licensing

On Tue, 2002-09-24 at 23:05, Ken Menzel wrote: > Hi Everyone, >I don't know if it makes a difference to anyone, but mysql client > libraries are no longer LGPL. see > http://www.mysql.com/doc/en/Copyright.html. (original licenses can be > found in old source tar files documentation). I think t

Re: 3.23.52 hangs sometimes

Some people have had problems with the binary of 3.23.5x. We had that problem, and when we went back to a self-compiled 3.23.46 things worked normally again. The bad behavior looked like normal operation for anywhere from two hours to five days, followed by a CPU meltdown with loads over 200, wh

Re: Set Path Environment

Hi, Just to clarify a bit, the file in \windows is called winstart.bat, but it seems to be discontinued in Windows XP (may not be available in W2K either). In Windows NT it works, though. In NT/W2K/XP the most efficient way to modify these variables _and_ persist them is through My Computer->Pr

RE: Win32::ODBC Question (Oracle)

hope that i don't muddy the waters here, but there's a solution for all of your data sources that doesn't require knowledge of any commands. the corereader app loads and displays the information that you want when you connect to a data source, in this case to a database. it's free as a down

Re: Multiple Referral Levels

- Original Message - From: "Daren Cotter" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 7:34 PM Subject: Multiple Referral Levels > I have a question regarding tracking multiple referral > levels in a database. The number of referral

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Jocelyn, below the latest patch which puts the code as it was in 4.0.3. Some LIKE 'abc%' ... DESC queries may return wrong results, but this is the best we can get to 4.0.4. I have to ask Monty about the use of HA_READ_PREFIX_LAST. Other bugs may be lurking in the use/non-use of that search flag

I want to unsubscribe but the freaking commands don't work

Help! sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail

I want to unsubscribe but the freaking commands don't work

Help! The following works are required so that this mail goes through sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

Re: access denied ????

At 15:08 25/9/2002 +0300, Iikka Meriläinen wrote: Hi, Only for to clarify: There is a rename table bug for some NT family (Win2k I tested) when is used at the command rename tables names with uppercase and the default lower_case_tables_names =1. This is already fixed in the next releases. >On We

Re: Set Path Environment

Under NT and XP you set the environment variables by clicking on the My Computer icon and selecting Properties, then clicking the Environment variables on the Advanced tab. Make sure you set the PATH under the System Variables instead of User Variables if you want MySQL to be available to all

load data

> > I load a table whit the query: > > > > LOAD DATA INFILE 'a.txt' INTO TABLE table FIELDS TERMINATED BY '\t' LINES > > TERMINATED BY '\n'; > > > > the file: > > > > 211ppp222 > > 222ooo333uuuo > > > > and more > > > > the problem is, the last field in the table

I want to unsubscribe but the freaking commands don't work

Help! The following works are required so that this mail goes through sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Hi Heikki, The query doesn't crash anymore, but the ORDER BY doesn't work at all (I tested it on a table with data). How-to-repeat : INSERT INTO threadhardwarefr13 (pseudo,date,numreponse) VALUES ('kytine','2002-09-18 20:37:31','1360'),('joce','2002-09-18 20:42:20','1361'),('kytine','2002-09-18

phpMyAdmin/MySQL Question

Maybe someone else can come up with an answer for me on this question. I am getting the following error when I try to run my index.php file. I think I have configured it correctly, but obviously I haven't. And my host basically told to go shove it. >>Welcome to phpMyAdmin 2.3.1-rc1 >>Error >>MySQ

Re: Max NB of MyISAM tables / DB ( Ext3 & linux )

Hello, If the number of files is your concern, have you considered using InnoDB? It spans tables across any number of data files you want. The performance is great, too. Best regards, Iikka On Wed, 25 Sep 2002, David Bordas wrote: > Hi list, > > I've just a little question for the end. > I pla

Meidumtext vs. varchar

Hi All, I've built a survey application in MySQL that allows people to enter free-form comments. In processing the input, if the comments string is less than 256 characters long, I save it to a varchar column; if longer, I use a mediumtext. This works fine, but I'm wondering if I'm getting any r

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

On Wed, Sep 25, 2002 at 08:09:08PM +0300, Heikki Tuuri wrote: > Jeremy, Jocelyn, > > can you try the following this patch? I'm building a new binary row. > The flag which bans MySQL using a descending cursor to calculate > > column LIKE 'jhghj%' ORDER BY column DESC > > queries was apparently

Re: Max NB of MyISAM tables / DB ( Ext3 & linux )

In the last episode (Sep 25), David Bordas said: > I've just a little question for the end. I planned to have around 10K > tables under a DB and this number surelly grow up to 20K. I know that > a database is a directory and a table is 3 files. I just want to know > is mysql have a limit in the nu

RE: MySQL as a desktop DB

I use MySQL as a desktop db. It is alot faster than access, and much more efficient. A great front end I use is phpMyAdmin. www.phpMyAdmin.org -Steve. -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject: R

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Jeremy, Jocelyn, can you try the following this patch? The flag which bans MySQL using a descending cursor to calculate column LIKE 'jhghj%' ORDER BY column DESC queries was apparently put to the wrong place in ha_innodb.h. The assertion I had added to 4.0.4 revealed this hidden bug. The patc

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Hi Jeremy, Same problem for me, I submitted a bug report with a repeatable testcase yesterday to the bugs list. Reading the source code and changeset 1.1287, it appears this part of the source code should be desactivated ? (ChangeSet 1.1287 02/09/15 02:23:53 [EMAIL PROTECTED] +2 -0 ha_innodb

Re: Set Path Environment

Try to modify the autoexec.bat if you are using Win9x or the Path User env in Winnt. Another choice in some systems is to modify DOSTART.bat or something like that in "\windows". A way to keep the previous setting of the PATH env is to issue a stat like SET PATH=%PATH%;c:\mysql; ... I hope this h

Multiple Referral Levels

I have a question regarding tracking multiple referral levels in a database. The number of referral levels tracked needs to be at least 4, but should be able to be expanded later (without modifying the database). The first design I considered was: table: id int(8) unsigned not null auto_incremen

Re: 3.23.52 hangs sometimes

On Wed, Sep 25, 2002 at 10:02:52AM -0500, Philip Molter wrote: > On Tue, Sep 24, 2002 at 08:21:36PM -0700, Andrew Maltsev wrote: > : Any suggestions how to approach the problem? How and what to test? It > : happens randomly, can work for a day or two with no problems and then > : hang three times

Re: MySQL as a desktop DB

David Lloyd wrote: >MySQL in a single user environment is a pain in the arse because of its >lack of an Access Like front end that is actually useful and featureful >(Access is crap, but it's a better database frontend than currently >exists). > > I've never done it, but have you tried Access l

RE: Win32::ODBC Question (Oracle)

Figured it out. just use the "use name_of_db" and you can switch to another DB. thanks. -Original Message- From: Norris, Joseph Sent: Wednesday, September 25, 2002 9:02 AM To: 'Ian Robertson'; Norris, Joseph; 'Peter van der Goes'; 'Thomas R Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List (

Re: MyISAM or InnoDB

> We are moving a databse over from Oracle to MySQL 4.0.3 and I was > wondering if I should use MyISAM or InnoDb. The databse currently has > 800-900 updates and inserts done to it in a day along with about 1000 > selects. Would I run in to any table locking problems with MyISAM? If you want t

Re: Set Path Environment

Hello, On Windows 9x edit your c:\autoexec.bat On Windows NT/2000/XP/.NET, right-click My Computer, then Properties, then on XP click Advanced tab and then "Environment Variables". On NT/2000 this procedure is about the same, only the Environment stuff is on a different tab. Then re-run autoexe

RE: Win32::ODBC Question (Oracle)

Ian's help worked great. I have one question. How do I specify the DB? I mean in the query analyzer I can select a db from the pulldown box - is there a way to specify the db in the statements below? Thanks. -Original Message- From: Ian Robertson [mailto:[EMAIL PROTECTED]] Sent: Wedne

RE: No my.cnf file on Linux?

Hi - they're located in the mysql support-files dir. Choose from small, medium, large or huge depending on how you're going to use mysql. Copy & rename to /etc EG: cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf Cheers, Andrew -Original Message- From: Lindberg, Petrus [mail

Re: Temporary tables

At 10:12 -0400 9/25/02, Keith C. Ivey wrote: >On 25 Sep 2002, at 0:57, John Coder wrote: > >> So it's probably the fact that I didn't make the connection >> persistent that screwed me up sometimes I feel so stupid. > >I don't think that will help. Read Paul's message again. Even if >you make t

Re: No my.cnf file on Linux?

Hi, >I use mysql 3.23.4 max on linux and it have worked just fine. >Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. >Trouble is there is no my.cnf file on my computer. >Do I have to create the file myself ? >or is the InnoDB settings configured righ

Re: No my.cnf file on Linux?

At 16:17 +0200 9/25/02, Lindberg, Petrus wrote: >I use mysql 3.23.4 max on linux and it have worked just fine. > >Now I want to use Transactions so I thougt that I should use the >my.cnf to configure for that. > >Trouble is there is no my.cnf file on my computer. > >Do I have to create the file

RE: Win32::ODBC Question (Oracle)

Hi, Use the following: SELECT * FROM sysobjects WHERE type='U' This will show you all of the user tables And then select * from syscolumns where ID = (select ID from sysobjects where name = 'your_tablename' and type = 'U' This should get you started! HTH Ian. -Original Message-

Re: No my.cnf file on Linux?

> I use mysql 3.23.4 max on linux and it have worked just fine. > > Now I want to use Transactions so I thougt that I should use the my.cnf > to configure for that. > > Trouble is there is no my.cnf file on my computer. > > Do I have to create the file myself ? > or is the InnoDB settings config

Re: MySQL as a desktop DB

MySQL is much faster that Access when dealing with large databases. However, 300,000 records is actually quite small, so you may not see any speed difference. I wouldn't be surprised if Access would even be faster at that level. Putting 10 times that amount of records or adding users would con

RE: Win32::ODBC Question (Oracle)

This email leads to a question I have about SQL. I have been accustomed to Mysql with all of its nifty little extensions - like describe. Now I have a project with MSSQL (not because I wanted it - politics). Does any one now how to describe a table structure with standard SQL. Even more importan

Max NB of MyISAM tables / DB ( Ext3 & linux )

Hi list, I've just a little question for the end. I planned to have around 10K tables under a DB and this number surelly grow up to 20K. I know that a database is a directory and a table is 3 files. I just want to know is mysql have a limit in the number of table per database. If not, i know tha

InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Heikki and others, One of my slaves is dying frequently. It runs MySQL 4.0.4 (pulled yesterday) on FreeBSD. I'm getting an assertion failure on line 2180, which appears to be: case HA_READ_PREFIX_LAST: ut_a(0); return(PAGE_CUR_LE); What can I do to help debug this? Thanks, Jeremy -- J

Re: Select with order by clause on a MySQL BDB table returning incorrect

[EMAIL PROTECTED] wrote: > > Sridhar, > Wednesday, September 25, 2002, 12:23:29 AM, you wrote: > > SP> One of our MySQL db's containing BDB tables is exhibiting a strange > SP> behavior. > SP> A query consisting of an ORDER BY clause is returning wrong result set. > SP> The > SP> same query when

Fw: Set Path Environment

This is more information regarding the Path for my machine. It shows the default PATH information and the PATH information after I perform the SET PATH command. It also shows how MySQL responds after I type MySQL at the command prompt. Thanks in Advance, William C:\>path PATH=C:\WINNT\system

Re: 3.23.52 hangs sometimes

On Tue, Sep 24, 2002 at 08:21:36PM -0700, Andrew Maltsev wrote: : Any suggestions how to approach the problem? How and what to test? It : happens randomly, can work for a day or two with no problems and then : hang three times in one hour. And obviously I can't reproduce it in my : test environmen

Re: Spam

It seems they are using SPEWS (www.spews.org). A rude way to find out that our ISP has a problem with the IP address they gave us :-{ -- From: MySQL <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Spam Reply-To: [EMAIL PROTECTED] Message-Id: <[EMAIL PROTECTED]> Date: Tue, 24 Sep

Re: Mysql Error

if I remember right, there is a php-mysql*rpm package for redhat which corrects this problem. Thomas On Wed, 25 Sep 2002 23:23:07 +1000 "Peter Goggin" <[EMAIL PROTECTED]> wrote: > The php is as installed from the redhat distribution for 7.3 from the Next > handbooks. Do I need to down load a

Updating blob from command line

Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to b

Set Path Environment

Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\> prompt, I get the following error: C:\>mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open.

MyISAM or InnoDB

We are moving a databse over from Oracle to MySQL 4.0.3 and I was wondering if I should use MyISAM or InnoDb. The databse currently has 800-900 updates and inserts done to it in a day along with about 1000 selects. Would I run in to any table locking problems with MyISAM? Thanks in advance. --

No my.cnf file on Linux?

I use mysql 3.23.4 max on linux and it have worked just fine. Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. Trouble is there is no my.cnf file on my computer. Do I have to create the file myself ? or is the InnoDB settings configured right by d

Re: Temporary tables

On 25 Sep 2002, at 0:57, John Coder wrote: > So it's probably the fact that I didn't make the connection > persistent that screwed me up sometimes I feel so stupid. I don't think that will help. Read Paul's message again. Even if you make the connection persistent, you can't be sure you'll ge

Re: Performance whil Building Indices -- how does it scale?

Yes, I increased this to 512M, as suggested in another answer, and the perfomance improved dramatically. Thanks for the tip. Jeremy Zawodny wrote: >On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote: > > >>Joseph, >> >>Thanks for the quick answer. >> >>Very nice to know that add

re: Restart of mysqld processing a specific query

jn, Tuesday, September 24, 2002, 5:55:00 PM, you wrote: ja1dc> Running a specific query makes the mysqld goeing away... >How-To-Repeat: ja1dc> Under the following URL you find a partial mysqldump to repeat the error: ja1dc> http://1net.ch/mysqlerr/err.sql It's know bug

re: how to create host table?

Ilyas, Wednesday, September 25, 2002, 3:09:34 PM, you wrote: IK> I am using MacOSX SERVER. When I want to start MySQL it says: IK> [HostPowerBook:/] ilyas% mysql IK> ERROR 2002: Can't connect to local MySQL server through socket IK> '/tmp/mysql.sock' (61) IK> According to Mysql documentation t

RE: MySQL as a desktop DB

Oh fiddle sticks! I just noticed mySQL-Front has been discontinued. I love that program :( Oh well, I'll check out this SQLyog. Thanks for the tip. Mike -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject:

Re: installing mysql together with application

- Original Message - From: "Martijn van Iersel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 2:45 AM Subject: installing mysql together with application > Hello > > I want to distribute my java database application > together with mysql, and I want to

Sorting the query results of a MySQL BerkeleyDb Table produces incorrect results

Dear List, Sorry for reposting the issue, once again One of our MySQL db's containing BDB tables is exhibiting a strange behavior. A query consisting of an ORDER BY clause is returning wrong result set. The same query when used without an ORDER BY clause returns the correct result set. Environm

Re: Mysql Error

Hi, Getting a bit off-topic... I'm not sure whether you can add functionality to an already compiled PHP installation. Maybe your best bet is to recompile your PHP, that way you can get the latest version, and with only the functionality you want. Just remember to enable --with-mysql during the c

Re: Mysql Error

The php is as installed from the redhat distribution for 7.3 from the Next handbooks. Do I need to down load a later version of PHP or cn I modify what is already installed? Regards Peter Goggin - Original Message - From: "Iikka Meriläinen" <[EMAIL PROTECTED]> To: "Peter Goggin" <[EM

  1   2   >