MySQL segfaults anytime someone connects to 3306 port

>Description: After installation and setting basic authentication data I tried to connect to MySQL from other machine with the mysql client. I could not connect, I just got an error message "ERROR 2013: Lost connection to MySQL server during query" It does not matter which user, databse

Re: MySQL & Delphi 6

As an alternative, you could try this: http://www.fichtner.net/delphi/mysql.delphi.phtml You need to be familiar with the C API unfortunately, but you end up doing a lot with just a few lines of code. > Can somebody help me with Delphi 6 and MySQL? > I'm using Delphi en a WinXP box and the MyS

RE: MySQL & Delphi 6

I cant send you for now...it's a big file...cant be possible using email... But ill try if I can a utility program that slice the file into pieces as like as 1.44MB disk Do you have those programs? R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) (088) 858-1028 (Ho

Re: MySQL & Delphi 6

I think the standart tsqlconnection in delphi6 have some problems. Instead you can use ado or tmysqlconnection from "http://www.productivity.org/projects/mysql/";. Hope it helps. Patricio Díaz G. wrote: Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL

MySQL Installation

Hi, i am doing a setup program that eventually install mySQL, myODBC, and my system. during my system installation, it require mySQL is installed and already run the WinMySQLAdmin.exe, where by from there i will be able to do some record insertion on the db. but now, since for the first time we ru

Dump

After I dump the database what is the command to import it into another computer? Do I have to create a new database and then import all tables and data or will it create the database, tables, and data? MYSQL - Before posting

RE: MySQL & Delphi 6

That command is set more secure on the version you use v3.23.53 That's one of the reason why I kept the old version running, which is v3.23.44 I cant find a way to upgrade to the latest which is giving me headache when it comes to LOAD DATA statement I also found out that the LIBMYSQL.DLL used i

table_cache too high?

My database has many hundreds of tables. Originally I set my table_cache to 512. Today I realize this might not be a good idea. By default open_files_limit is 0. According to my understanding of the manual this means each MySQL process will open at most 1124 file handles: max_connections + (table_

RE: MySQL & Delphi 6

You can download winzeos for delphi I use it when connecting to MySQL Try searching it in google R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No.(Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From:

MySQL & Delphi 6

Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server in a Linux box. I am having trouble connecting to the server with the CLX/dbExpress TSQLConnection component. Please, if somebody can help me, let me know and I'll explain the whole situation. Regard

MySQL & Delphi 6

Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server in a Linux box. I am having trouble connecting to the server with the CLX/dbExpress TSQLConnection component. Please, if somebody can help me, let me know and I'll explain the whole situation. Regard

Re: using explicit locking

HI I have a similar question. I'm using InnoDb table type (ver 3.23.53), according to the web side, it does a row level locking. Does this mean that I don't need to do any table locking during the Update/Delete/Insert queries?? How do I test it that It really doing the locking (other than ta

using explicit locking

Hello. MySQL newbie here. I've managed to build my first web database using MySQL and accessing it with Python CGI scripts. I only have two tables going, and not many columns per table, but I'm suspecting that there will be many calls to INSERT, UPDATE, and SELECT. So my question is this: do

Re: What is wrong with this query?

Never mind, I figured it out. Busted link sending me to the wrong file. Guess that's what you get when you don't check the most obvious thing, like the address file. At 07:42 PM 11/19/2002 -0700, JohnMeyer wrote: $strQuery = "SELECT users.UserID,UserAIM,FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM

What is wrong with this query?

$strQuery = "SELECT users.UserID,UserAIM,FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM UserDOB))/ 12) as Age,UserFName,UserLName,UserDOB,UserCity,UserState,UserEmail,UserSchoolName,UserSchoolType FROM users, user_interest where users.UserID=user_interest.UserID and u

Re: another field type bigger then varchar

Dear Victoria n Bruce, thanks a lot, it is work better now :-) cheers... Ivan Paul SQL, Query - Original Message - From: Bruce Lee <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 6:13 PM Subject: Re: another field type bigger then varchar > Hi, > > "te

Re: help with innodb

At 20:10 -0500 11/19/02, Peter Boivin wrote: Hi, I like to know if you can help me. I installed mysql-3.23.53-win.zip which should have the Innodb feature as part of MySQL. However, I am unable to create an Innodb database. The problem may be that one of my variables which says "have_innodb" st

$$ Wanted: MySQL & PHP expert assistance

W am looking for some expert assistance using MySQL & PHP on a Linux/Apache based internet site development project. The project shouldn't take a knowledgeable & experienced professional long so you should be able to work it in your schedule without stopping everything forever. Interested parties

help with innodb

Hi, I like to know if you can help me. I installed mysql-3.23.53-win.zip which should have the Innodb feature as part of MySQL. However, I am unable to create an Innodb database. The problem may be that one of my variables which says "have_innodb" states that it is "Disabled". Do you know how I

MySQL saturating Fast Ethernet after 3500 qps?

Hi all, Does anyone with experience with MySQL with over 3000 queries per second willing to shed some light for me? By my guess, full duplex Fast Ethernet can only handle 8000-1 packets per second. Doing 3000+ queries per second then ought to be saturating the network, right? Reason is that t

Intermitent join problems

I'm using PHP 4.22, MySQL 3.23.53a on a RedHat Apache web server. I have a join that 99.9% of the time works fine but there have been 3 occasions in the last few weeks where extra records have found their way into the resulting dataset. This has happened during high load times. The join is a

RE: i'm just missing something

Look at GRANT Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 -

Re: Re[2]: delete where column <=> null

just what the world needs: more non-standard sql syntax. > Ok, so it seems to be a bug. What's the procedure for reporting it (or > do the developers read this list?) > > -David > A minimal test case that demonstrates the bug: > create table t ( > id integer, > index id_idx(id) > ); > in

Re: MySQl LEFT JOIN Syntax

suggestion: if you have a windows machine that you can use as a front end, download a copy of corereader. http://corereader.com it lets you create joins by clicking on objects in your database. you can quickly experiment with the logic instead of worrying about syntax. let corereader take

Re: Inserting values from PHP.

Try closing them in single quotes. If that doesn't work, perhaps you need to add_slashes() to each value before inserting, or read up on magic quote in the PHP manual. Cheers, Justin on 20/11/02 10:37 AM, Damien Buttler ([EMAIL PROTECTED]) wrote: > > I hope someone can help. I have w

Re: Inserting values from PHP.

Damien Buttler wrote: I hope someone can help. I have written a PHP script which adds a row to a MySQL table. The columns are all of type 'char'. The script works fine when only numerical values are passed, but when I try to pass values a-z A-Z the script fails. When I attempt to add the

Re: Inserting values from PHP.

- Original Message - From: "Damien Buttler" <[EMAIL PROTECTED]> > I hope someone can help. I have written a PHP script which adds a row to a > MySQL table. The columns are all of type 'char'. The script works fine > when only numerical values are passed, but when I try to pass values a-

Inserting values from PHP.

I hope someone can help. I have written a PHP script which adds a row to a MySQL table. The columns are all of type 'char'. The script works fine when only numerical values are passed, but when I try to pass values a-z A-Z the script fails. When I attempt to add the same values straight fro

RE: memory leak

At 12:53 PM 11/19/2002, you wrote: Yeah, I've experienced the same thing -- if I leave my computer unattended it just saps memory until I start getting complaints from Windows about VM usage. Same deal -- W2K with all the updates. -JF You can try a resident memory manager that will automatical

MySQL Featured in Out-of-the-Box

FYI, MySQL is featured in Out-of-the-Box 1.0, a distribution of Open Source projects. Free Community Edition for Linux documentation on basic MySQL installation and configuration can be found here: http://www.ejbsolutions.com/products/obox/community/ch11.html --

Re: i'm just missing something

Actually there is a slightly better way to add a user. Read the following entry in the mysql docs: http://www.mysql.com/doc/en/GRANT.html In fact you might want to read this whole section: http://www.mysql.com/doc/en/User_Account_Management.html Example: grant select, insert on *.* to joeuser@loc

Re: help with selecting accross multiple, related tables...

problem solved! Thanks Mark for the message offlist. I used something like: select threads.* from threads left join replies on threads.id = replies.tid and (threads.stamp > {$weekago} and replies.stamp > {$weekago}) order by threads.id DESC Thanks, Justin on 19/11/02 9:22 PM, Justin F

Re: i'm just missing something

There is a mysql database with a user table in it. Add a new user, then reload the database! Remember to password the password. And it will work! > I been tring to read the docs on the website, and tried looking it up, but > i'm getting confused. I am trying to make a database and a user. > to m

RE: CPU Load extremely high with MySQL 4.0.4

OK, it seems to be working. The load is not spiraling out of control. :) Sincerely, Steven Roussey http://Network54.com/ > -Original Message- > From: Lenz Grimmer [mailto:[EMAIL PROTECTED]] > Before I make a 4.0.5a release of the Linux binaries (and finally announce > 4.0.5), could som

i'm just missing something

I been tring to read the docs on the website, and tried looking it up, but i'm getting confused. I am trying to make a database and a user. to make the database i use mysql> create database dbname; that seems to work. but how do i make a user for it?

Re: How to direct mysqldump error to a file?

Hi, paul, I got why, the first time I run the command is under "tcsh", after I change to "bash" the command works. === mysql@/usr/local/mysql > /usr/local/bin/mysql -ujqu -pjqu1234@ --opt nondb > bkp_nondb.sql 2> err.log Ambiguous output redirect. mysql@

Re: Thx to Martin Waite, and 1 more question

Hi Warren, > I wrote in a little while ago about getting unique visits to a website > listed by day. Martin Waite came up with a very nice formulation, which > does wonders! > However, I have done something that is now yielding inconsistent results. > The screen shot is basically like this: > > D

Re: mysql source for 4.0.5

In the last episode (Nov 19), Ken Menzel said: > I have tried 4 mirrors in USA to download mysql source for 4.0.5 > seems like the file is missing. Is anyone else having the same > problem? ftp://mirror.mcs.anl.gov/pub/mysql/Downloads/MySQL-4.0/mysql-4.0.5-beta.tar.gz worked for me this morning.

Re: Creating foreign key

HI Victoria, Harald, Dyego you all were right, the database is not supporting the InnoDb tables; I configure it with "--with --innodb" option & add innodb_data_file_path to the my.cnf. Now it's working!! Thank you so much Vinita sql Dyego Souza do Carmo wrote: vvM> HI vvM> still not workin

MySQl LEFT JOIN Syntax

Hi there, My MySQL LEFT JOIN Syntax as following is wrong? I cannot get the right result. SELECT name, email form T1 LEFT JOIN T2 ON T1.Snum=T2.Bnum T1(Snum,name,email,address) T2(Bnum, notes, time) I wnat ot get the result(name, email, notes). Any suggestion, comments? Thanks

Re: How to direct mysqldump error to a file?

At 20:45 + 11/19/02, Jannie Qu wrote: Hi, all, sql, query. I am scheduling a cronjob to backup mysql database using mysqldump. mysql@/usr/local/mysql/output > /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb > bkp1.sql 2> err.log Ambiguous output

Re[2]: delete where column <=> null

At 15:58 -0500 11/19/02, David Mechner wrote: Ok, so it seems to be a bug. What's the procedure for reporting it Check the manual: http://www.mysql.com/doc/en/Bug_reports.html - Before posting, please check: http://www.mysq

Re: CPU Load extremely high with MySQL 4.0.4

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 19 November 2002 12:19, Lenz Grimmer wrote: > On Monday 18 November 2002 19:52, Steven Roussey wrote: > > :( Sadly, 4.0.5 does _not_ fix this issue. I just tried it and our load > > > > went from 1 to 145 in 20 seconds... > > Thanks for the

mysql source for 4.0.5

I have tried 4 mirrors in USA to download mysql source for 4.0.5 seems like the file is missing. Is anyone else having the same problem? Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] -

Re[2]: delete where column <=> null

Ok, so it seems to be a bug. What's the procedure for reporting it (or do the developers read this list?) -David A minimal test case that demonstrates the bug: create table t ( id integer, index id_idx(id) ); insert into t(id) values(null); select * from t; delete from t where id <=> 1;

Re: Mysql and use rmanagement

Greetings MySQL-Front has problems with User Manager module. It does not creates permission correctly. Try SQLyog at http://www.webyog.com/sqlyog/download.html Rgds Insane - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, Nove

Re: Does mysql_real_connect allocate memory?

Greetings You dont have to do mysql = new mysql; it is dont automatically. Rgds Insane SQLyog - The Definitive Win32 MySQL Front End http://www.webyog.com/sqlyog/download.html - Original Message - From: "Anna Fowles-Winkler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday,

Re: fulltext, trying to index 2 character words

I thought that option was only available on version 4.0 and above? I'm using 3.23.52-max. thanks On Tuesday, November 19, 2002, at 07:22 AM, Thomas Spahni wrote: On Mon, 18 Nov 2002, Kevin Lewandowski wrote: I'm using mysql fulltext indexes and want them to see words of 2 or more characters,

How to direct mysqldump error to a file?

Hi, all, sql, query. I am scheduling a cronjob to backup mysql database using mysqldump. mysql@/usr/local/mysql/output > /usr/local/mysql/bin/mysqldump -umysql -pmysqlpw --opt nondb > bkp1.sql 2> err.log Ambiguous output redirect.

Re: Unable to connect, Connection lost during query. Solved

Daniel Griggs wrote: Ah ha. Discovered the problem, hosts.allow/hosts.deny was configured to only allow connections from one host. The thing that was confusing was that it allowed the initial connection, but then closed it. But I guess that makes sense in a way. But it still a small stupid thi

Unable to connect, Connection lost during query. Solved

Ah ha. Discovered the problem, hosts.allow/hosts.deny was configured to only allow connections from one host. The thing that was confusing was that it allowed the initial connection, but then closed it. But I guess that makes sense in a way. But it still a small stupid thing, so look out for i

Re: Foreign (Non-English) characters

Egor Egorov wrote: Roger, Monday, November 18, 2002, 9:56:05 PM, you wrote: RW> I'm running MySQL 323 under Win 2000 SP2. I'm using Apache 2.0.43 and Cold Fusion MX. I have this Cold Fusion RW> application that has worked well under MS-Access but when i ported it to MySQL the Swedish character

Does mysql_real_connect allocate memory?

Hi, Does the MySQL C API function mysql_real connect allocate memory or do I need to do it? This is what my code currently does: MYSQL *mysql; mysql = new MYSQL mysql_init(mysql); mysql_real_connect(mysql, host, user, password, dbase, 0, 0, 0); Thanks, Anna -

RE: simple question

order by date_format(mydate,'-mm-dd') desc -Original Message- From: Carter, Scott [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 11:30 AM To: 'Doug Durham'; '[EMAIL PROTECTED]' Subject: RE: simple question The problem is the command is not ordering in either direction.

RE: simple question

The problem is the command is not ordering in either direction. The ORDER BY clause does not seem to have any effect at all. Maybe ORDER BY is not the right solution. If I want to return records sorted by a column of date type, how do I do this? Thanks - Scott Carter -Original Message---

RE: Insert row in x for every row in y

insert into group_map (user_id, group_id) select distinct user_id , from user ; -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 10:52 AM To: [EMAIL PROTECTED] Subject: re: Insert row in x for every row in y Zabel, Monday, November 18, 200

RE: memory leak

Yeah, I've experienced the same thing -- if I leave my computer unattended it just saps memory until I start getting complaints from Windows about VM usage. Same deal -- W2K with all the updates. -JF > -Original Message- > From: Jon Finanger [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, N

re: BUG REPORT : key creation

Angeloluca, Tuesday, November 19, 2002, 12:21:58 PM, you wrote: AdBamdc> I have a problem with key creation : AdBamdc> Server version: 4.0.4-beta-max-nt Binary version AdBamdc> PC : DELL OPTIPLEX GX100 AdBamdc> OS : Windows 2000 Professional AdBamdc> RAM: 256 Mb [skip] AdBamdc> 236 Is the maxi

re: Re: SLAVE STOP

Massimo, Tuesday, November 19, 2002, 12:35:46 PM, you wrote: MP> In the 4.0.5 version the problem is still alive. Have some notice about this MP> problem will be solved ? This bug is not fixed yet, we gonna fix it later. -- For technical support contracts, goto https://order.mysql.com/?ref=en

re: Bug in UNION?

J., Monday, November 18, 2002, 12:32:35 PM, you wrote: JCO> Try this: JCO> mysql> CREATE TABLE a ( JCO> id int NOT NULL PRIMARY KEY, JCO> des varchar(20) default NULL JCO> ); JCO> Query OK, 0 rows affected (0.00 sec) JCO> mysql> INSERT INTO a VALUES (1,'pepe'),(2,'juan'),(3,'mariano'); JCO>

re: Foreign (Non-English) characters

Roger, Monday, November 18, 2002, 9:56:05 PM, you wrote: RW> I'm running MySQL 323 under Win 2000 SP2. I'm using Apache 2.0.43 and Cold Fusion MX. I have this Cold Fusion RW> application that has worked well under MS-Access but when i ported it to MySQL the Swedish characters ÅÖÄ åöä RW> in the

re: How to turn on/off log_bin while mysql is running?

Á¤, Tuesday, November 19, 2002, 6:10:44 AM, you wrote: ÁÇ> I'm setting up two servers as one master and one slave, and the slave will take over ÁÇ> master's role when the original master fails. ÁÇ> I'd like to turn off log_bin in slave and turn on it only when the slave becomes a maste

re: Strange Error with MySQL 4.0.4 under Win2K

Stefan, Sunday, November 17, 2002, 5:12:52 PM, you wrote: SH> yesterday I imported some tables from MS Access via ODBC into my brand SH> new MySQL 4.0.4 server. Everything went fine, but the tables did not SH> have a primary key, so I did the following: SH> mysql> ALTER TABLE auftrag CHANGE Numme

re: Question about mysql4

Siomara, Sunday, November 17, 2002, 5:16:06 PM, you wrote: SP> Can someone help on this question? SP> I have downloaded and intalled succesfully mysql-max 4.0.4. However, when I SP> checked the information I stored via insert statements, I noticed weird SP> characters placed in the positions of

re: Re: Creating foreign key

vinita, Tuesday, November 19, 2002, 2:06:01 AM, you wrote: vvM> still not working :-( vvM> I didn't do the installation , Do we need to set any option vvM> specifically during the installation for foreign key to work?? Check that your both tables are InnoDB: SHOW TABLE STATUS LIKE "tabl

re: Mysql and use rmanagement

krisbekkers, Monday, November 18, 2002, 11:55:37 PM, you wrote: katdb> I have a 'simple' question regarding the mysql privileges. katdb> The database at home: katdb> version 4.04 beta max katdb> all of my tables are innodb tables. (except the mysql privileges table) katdb> As of version 4.02 of

re: Insert row in x for every row in y

Zabel, Monday, November 18, 2002, 6:35:06 PM, you wrote: ZI> I've having trouble figuring out the SQL to do this. ZI> I have two tables, user, and group_map, and I want to insert a row into ZI> group_map for every row in user. ZI> user ZI> ZI> user_id ZI> group_map ZI> ---

re: newbie really need help > mysql binary installation problem

David, Monday, November 18, 2002, 2:53:33 AM, you wrote: DW> I am trying to install mysql-3.23.53a-pc-linux-gnu-i686 to my linux kernel DW> 2.2.14(Caldera OpenLinux 2.4). I follow throught the installation porcess DW> in the documentation in the mysql.com web site. DW> I am using bash shell, here

Re: MySQL Left Join Query

Thanks, John (and Mark), for your comments. I was inspired to write something, because it seems to be hard to find any explanation of LEFT JOIN. I looked through the half dozen SQL books on my shelf and at the reference manuals for MySQL and DB2. All of them had a brief example of the straightfo

Re: delete where column <=> null

The manual calls '<=>', which was added in 3.23.0, the 'null safe operator', and says... - If one or both arguments are `NULL', the result of the comparison is `NULL', except for the `<=>' operator. - indexes can use = and <=> but the <=> operator is not in SQL92, and AFAIK no other major db su

Re: delete where column <=> null

Hi. On Tue 2002-11-19 at 12:38:33 -0500, [EMAIL PROTECTED] wrote: > Nothing can be compared to null, not even null, which implies that MySQL is > wrong in returning two rows in the SELECT. I have to disagree. The "<=>" operator is explicitly defined to allow that. "<=>" is the same as "=", except

Thx to Martin Waite, and 1 more question

Hi! I wrote in a little while ago about getting unique visits to a website listed by day. Martin Waite came up with a very nice formulation, which does wonders! However, I have done something that is now yielding inconsistent results. The screen shot is basically like this: Day by Day Summary f

RE: delete where column <=> null

At 12:38 -0500 11/19/02, Arthur Fuller wrote: Nothing can be compared to null, not even null, which implies that MySQL is wrong in returning two rows in the SELECT. Your query needs to say IS NULL: delete from t where id = 1 and num is null; Arthur That is false. The <=> operator is like = e

RE: simple question

At 11:37 -0600 11/19/02, Carter, Scott wrote: There might be ten different records with a fname of scott and the dates might be 2002-11-18, and 2002-11-10 and 2002-10-15. When the query results are returned the ORDER BY clause seems to have no effect on the results. I would want the record with

RE: delete where column <=> null

>>Nothing can be compared to null, not even null This is not so... mysql> select NULL <=> NULL; +---+ | NULL <=> NULL | +---+ | 1 | +---+ 1 row in set (0.00 sec) As explained in the manual http://www.mysql.com/doc/en/Comparison_Operators.html <=> i

RE: simple question

There might be ten different records with a fname of scott and the dates might be 2002-11-18, and 2002-11-10 and 2002-10-15. When the query results are returned the ORDER BY clause seems to have no effect on the results. I would want the record with the most current date to be returned first, the

RE: delete where column <=> null

Nothing can be compared to null, not even null, which implies that MySQL is wrong in returning two rows in the SELECT. Your query needs to say IS NULL: delete from t where id = 1 and num is null; Arthur -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]] Sent: Tuesday

RE: InnoDB != FULLTEXT?

In the meantime, Jan, you don't have to commit your whole database to one table type. Consider using MyISAM tables where you need fulltext search and InnoDB for your other data. Arthur -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 12:02

RE: delete where column <=> null

You should use "IS NULL" or "IS NOT NULL" query. -- Chung Ha-nyung SayClub NeoWiz > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 20, 2002 1:45 AM > To: [EMAIL PROTECTED] > Subje

RE: delete where column <=> null

David, I get the same behaviour with mysql 3.23.47 (not max) and with mysql v 4.0.4-beta Without the index it works fine. Must be a bug Cheers, Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 November 2002 16:45 To: [EMAIL PROTECTED] Subject:

Re: InnoDB != FULLTEXT?

Jan, - Original Message - From: "Jan Steinman" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, November 19, 2002 4:37 AM Subject: InnoDB != FULLTEXT? > I'm interested in using InnoDB, but am loathe to give up FULLTEXT indexing. > > Anyone (Heikki?) know why this is

delete where column <=> null

Hi, I'm trying to delete from a table where col <=> null, but it doesn't seem to work. I don't see anything in the manual that says that <=> can't be used in the where clause of a delete statment, but: mysql> select * from t; ++--+ | id | num | ++--+ | 1 | NULL | | 1 | NULL |

Re: current connections to server

Thanks, Jeremy. At 03:14 PM 11/18/2002 -0800, Jeremy Zawodny wrote: >mytop -- http://jeremy.zawodny.com/mysql/mytop/ > >That's what I wrote it for. - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: fulltext, trying to index 2 character words

At 16:22 +0100 11/19/02, Thomas Spahni wrote: On Mon, 18 Nov 2002, Kevin Lewandowski wrote: I'm using mysql fulltext indexes and want them to see words of 2 or more characters, and no stopwords. I've edited the appropriate files (ftdefs.h, ft_static.c), then recompile, install, restart mysql,

Re: How to calculete used memmory when using heap tables in Mysql

Hi. On Mon 2002-11-18 at 17:05:23 -0800, [EMAIL PROTECTED] wrote: > Hello , > I need help with heap tables and calculating memory usage. I checked > in the Manual and found a formula, but I need help > deciphering it ;) > > " The memory needed for one row in a HEAP table is: > > sizeof(char*) i

Re: MySQL Left Join Query

wow! that's known as "above and beyond the call of duty". hope the newbies appreciate your work. > Here's a mini-tutorial on left join that should solve your problem. > > First, let's make a smaller example. (It would have been helpful if > you had done that and formatted your select so i

Re: Bug on MySQL4.0.5 with InnoDB+TEMPORARY TABLES ?

Dyego, - Original Message - From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 2:33 PM Subject: Bug on MySQL4.0.5 with InnoDB+TEMPORARY TABLES ? > Hello ! > > I recent migrate from 3.23 to 4.0.5 version and >

RE: simple question

At 9:06 -0600 11/19/02, Carter, Scott wrote: The actual query is : SELECT * FROM PROFILES WHERE fname="scott" ORDER BY lastused; The lastused field is of type date, and I want the returned result set to be ordered by that date. Still need more info. What dates are in the records with "scott" a

Re: bugs with Widows Me

Wouldn't you need if (!mysql_query("INSERT INTO table(field) VALUES('$var')")) die("Always die"); ?? (Put the $var in single quotes, as it's a text field) Nick Elliott - Original Message - From: "Erumba Gotha Henri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 19,

Re: bugs with Widows Me

* Erumba Gotha Henri > /* >$var="some long text" >or >$var='some long text' > */ The kind of quoting used within PHP does not matter to mysql. > if (!mysql_query("INSERT INTO table(field) VALUES($var)")) die("Always > die"); > > /* >1. MySQL doesn't insert the content of the varia

syntax problem with replicate-rewrite-db

Hi All, (sorry if this is a duplicate -- I don't think the original made it) Running mysql 3.23.53-max binary on a RedHat 7.2 based server. Replication is working fine, but I'm running into errors with the replicate-rewrite-db directive. Here's a snippet from my my.cnf file on the slave: maste

RE: simple question

The actual query is : SELECT * FROM PROFILES WHERE fname="scott" ORDER BY lastused; The lastused field is of type date, and I want the returned result set to be ordered by that date. Thanks - Scott Carter -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, N

bugs with Widows Me

/* $var="some long text" or $var='some long text' */ if (!mysql_query("INSERT INTO table(field) VALUES($var)")) die("Always die"); /* 1. MySQL doesn't insert the content of the variable $var into the field table wich is a VARCHAR type or TEXT type 2. table contains other fields - t

How to calculete used memmory when using heap tables in Mysql

Hello , I need help with heap tables and calculating memory usage. I checked in the Manual and found a formula, but I need help deciphering it ;) " The memory needed for one row in a HEAP table is: SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2) + ALIGN(length_of_row+1, sizeof(char*))

RE: memory leak

If it makes you feel better, your not the only one with this problem. I ran into it as well and still have the problem from time to time. Any clues as to why? -Original Message- From: Jon Finanger [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 19, 2002 5:56 AM To: Dyego Souza do Carmo;

Re: The Error in InnoDB upgrading from 3.23.53 to 4.0.5

Dyego, - Original Message - From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, November 19, 2002 1:35 PM Subject: The Error in InnoDB upgrading from 3.23.53 to 4.0.5 > > The log put this error : > > InnoDB: Error: table ./wnotas25/ITEMREC h

Re: Mysql & Encryption

* Fraser Stuart > Here are my two main security issues. > > 1) (valid) user does a sudo to root and runs "strings .MYD" - out > drops all the sensitive text > 2) (clever) user gets hold of the application user/password for > MySQL (it's > in the app config somewhere) - they run "mysql --user=foo --

Re: fulltext, trying to index 2 character words

On Mon, 18 Nov 2002, Kevin Lewandowski wrote: > I'm using mysql fulltext indexes and want them to see words of 2 or > more characters, and no stopwords. I've edited the appropriate files > (ftdefs.h, ft_static.c), then recompile, install, restart mysql, > rebuild indexes, and there is no change. I

Bug on MySQL4.0.5 with InnoDB+TEMPORARY TABLES ?

Hello ! I recent migrate from 3.23 to 4.0.5 version and in my server , i set the Default table type to InnoDB. it works as well, but my temporary tables crashes mysqlserver on truncate command, the logdump is: - start here mysqld got signal 11; This could be because you hit a bug. It is al

Problem on mysqld with --bind-address

>Description: Mysqld has some trouble with hostname resolution. My server has several IP and I want to bind on one of them : --bind-addresse=servername But it doesn't work. Mysqld always bind on the IP which is given by `hostname -i`. >Fix: By qui

  1   2   >