Deadlock errors - Can nobody help??!!

Hi, Can anybody help with the problem that I posted last week (26/04/2002 11:31) regarding deadlock errors via the Perl DBD::mysql module? To summarize, the following ridiculously simple program works fine when run in isolation, but immediately leads to deadlock when two are run together. --

ODBC Problem.....

I've downloaded a version of MySQL ODBC Driver from The MySQL.com site named [ myodbc-2.50.36-win95.zip ] which is supposed to be supported on an Operating System of Win98 but when i installed it on a Win 98 Second Version Operating System it installed itself without any error messages whatsoever

Sorts

Hi List, If I run the sql query SHOW STATUS how can I tell how many queries required sorting? Here are some of the variables SHOW STATUS returns Questions 6623371 Sort_merge_passes 357 Sort_range 29213 Sort_rows 11271509 Sort_scan 231944 I want to try and calculate the percentage of sort

Re:  character

Hi, Are you sure ? We don't make confusion between character and font. If this character appear in the last field(on the right) of the table.No doubt.Is ENTER or NEW LINE. else it's a NON-PRINTABLE character anyway. Regards, Gelu _ G.NET SOFTWARE

To ban mysql server user login

Hi, As I see after the installation mysql server user can login because it has bash shell in passwd file; mysql:x:100:101:MySQL server:/var/lib/mysql:/bin/bash Can I change it to /sbin/nologin without so much as it hangs up? Or does this user handle the mysql client logins? Thanks in advance!

does mysql support multilanguage?

does mysql support multilanguage? for example I've got table names "tbl_example" which has fields like the list below title_id,eng_name,fra_name,chi_name,ger_name in field "eng_name" contains text in english language, in field "fra_name" contains text in france language, in field "chi_name" cont

SELECT/JOIN problems

Hello, list! (filter-fodder: sql,query) I've got a problem that's been bothering me for quite some time: If I've got two tables, where I list people who's paid their membership fee, year, etc., and another table with the names tbl_membernames : name_id, firstname, lastname tbl_paid: n

Re: How get the columns that are between an interval?

Hi, Dra. Silvia Andreasi wrote: >Hi, > >How can I get the columns between a given time interval? Something like: " >The patients admitted between january 25, 2000 and january 30, 2001" >?? > >I'm new to MySql and would like a suggestion from you... > >Best Regards > >Silvia > > SQL is close

Mysql Crashed

Dear All, While running our application, mysql suddenly started giving an error as MYD file not found for our database. On restoring the database through backup which was taken withthe help of mysqldump, it now converts all the tables to MyIsam and not Innodb even after specifying the the table

Re: To ban mysql server user login

>>> Takacs Istvan<[EMAIL PROTECTED]> Wrote: >>> Hi, >> >>As I see after the installation mysql server user can >>login because it has bash shell in passwd file; >> >>mysql:x:100:101:MySQL server:/var/lib/mysql:/bin/bash >> Don't worry, this user has no password :), so mysql won't be able to logi

How to make the Win target from source?

Hi! > "Dennis" == Dennis George <[EMAIL PROTECTED]> writes: Dennis> I downloaded mysql-3.23.49-win-src.zip. Dennis> There are various files missing (e.g. Makefile) that would enable compiling with gcc. Dennis> Has anyone out there made mysql from source on Win platform Dennis> with gcc?

insert problem

hi everybody, I have problem with inserting data into table. MY table is:- Name type IDint(9)autoincrement Total int(9) while i insert the data,i want the total(ID+2).Its mean the record should be like this:- ID Total 1 3 2 4 3 5 is it possiblei have try is like this mysql>in

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: my

Results relevance

Anybody knows how to get a percentage out of the Relevance Mysql returns when queried with the match() function? I am using Perl, so if there are any scripts or modules that you know of, those are also welcome. Alex - Before pos

Slave crashes with SEGV on master shutdown

>Description: I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49 with master/slave replication. The master mysqld is running on one machine, the slave on another. Everything works fine until I shutdown the master server. The slave the

Re: SELECT/JOIN problems

Hi, you need a LEFT JOIN on your query. See http://mysql.com/doc/J/O/JOIN.html Try somthing like: SELECT m.firstname, m.lastname FROM tbl_membernames as m LEFT JOIN tbl_paid as p ON (m.name_id=p.name_id and p.year=2000) WHERE p.name_id IS NULL On Mon, 2002-04-29 at 09:37, Markus Lervik wrot

Results relevance

Anybody knows how to get a percentage out of the Relevance Mysql returns when queried with the match() function? I am using Perl, so if there are any scripts or modules that you know of, those are also welcome. Alex - Before p

Performance problems...

Hi :) We're running 3 MySQL-servers for our customers databases (hosting-provider), and once in a while they give us REAL headaches. This time it's our 2nd server. At night, the load is +/- 34-50. Daily, it's between 2 and 20. All servers are dual PIII/1000 with 2GB of memory and U160 10K SCS

Slave crashes with SEGV on master shutdown

>Description: I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49 with master/slave replication. The master mysqld is running on one machine, the slave on another. Everything works fine until I shutdown the master server. The slave the

mysql on macos x - where to find the configuration file my.ini ormy.cnf

Hi there, is there anyone out there who knows where I can find my.ini or my.cnf on a MacOS X system? I use the MYSQL version that came with the standard MacOS X installation (updated to 10.1.4) thanx, Eric - Before posting, pl

Is transaction_isolation honoured with BDB tables?

Hi, In addition to the deadlock problems that I'm having, as described in previous e-mails (still not solved...), it appears that the transaction_isolation level setting is not being honoured, at least when using BDB tables. (I'm running mysql-max-nt 3.23.49a on Windows NT4 SP6.) On a simple

Usage of client-server in mysql

Hello all, How to implement client and server in mysql The actual thing which i need is that. I am having the server and the client in single machine and also having client in some other machine. Can i have the data from the server to the client that is placed in some remote machine with

general query

Hi Guru's, We say MySQL is open source database, so it can easily be adjusted to your requirements. But I wonder how many administrators have actually gone into the source code and made any modifications to match their specific needs, if any. If no, then why is MySQL better than other databases a

Re: mysql_real_query and escaping a semicolon

The semicolon does not belong there. Anna Fowles-Winkler wrote: >Anna Fowles-Winkler wrote: > >>Paul DuBois wrote: >> Paul DuBois wrote: > At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: > >Well, the function is called like this: > > > >mysql_real_query( mysql_connec

Crashes during install

>Description: Following installation I am unable to run the my_install_db script. >How-To-Repeat: Follow steps for binary install, tarball untarred, symbolic link mysql created, run the my_install_db script and it crashes >Fix: >Submitter-Id: [EMAIL PROTECTED] >Ori

Re: Performance problems...

In addition, here the resolved stack-trace: 0x806cb54 handle_segfault__Fi + 428 0x8116c2a pthread_sighandler + 158 0x80e715e mi_lock_database + 14 0x80b5de8 external_lock__9ha_myisamP3THDi + 28 0x8069d75 lock_external__FPP8st_tableUi + 121 0x8069bea mysql_lock_tables__FP3THDPP8st_tableUi + 362 0x

Need help to find duplicate records.

Dear All, My record id is 10 char long, all records are unique. However, many of these ids consist of _. Trying to print all matching records with first eight characters of the id. For some weird reason, it's not working properly. Any comments or help will be greatly appreciated. Blow is m

Re: Why does MAX(this_col) when this_col has index?

Hello Jeremy and List, Thanks for that pointer, altho I am not feeling it will help, i'll try it today. It'll take quite some time to add the index, there are like 12,000,000 rows. What is also a bit odd is that the same query below, if I change the where clause to "where uri_scheme = 'mailt

Re: Performance problems...

> In addition, here the resolved stack-trace: > > 0x806cb54 handle_segfault__Fi + 428 > 0x8116c2a pthread_sighandler + 158 > 0x80e715e mi_lock_database + 14 > 0x80b5de8 external_lock__9ha_myisamP3THDi + 28 > 0x8069d75 lock_external__FPP8st_tableUi + 121 > 0x8069bea mysql_lock_tables__FP3THDPP8st_

Re: Usage of client-server in mysql

Charitha, Monday, April 29, 2002, 3:39:21 PM, you wrote: C> How to implement client and server in mysql C> The actual thing which i need is that. C> I am having the server and the client in single machine and also C> having client in some other machine. C> Can i have the data from the serve

Re: Mysql time zone problem

Scott, Monday, April 29, 2002, 1:46:09 AM, you wrote: SS> I am trying to get my time zone setup correctly with mySQL on a RedHat 7.2 SS> box, so the select now(); query returns the correct time. The show variable SS> command show that the time zone is being updated with the different values I SS

Re: FW: keymappings - PHP or MySQL?

baldey_uk, Monday, April 29, 2002, 6:31:24 AM, you wrote: b> At the moment im getting a difference in keymappings between what is typed b> into a field and what is stored in the database. I have an html form that b> gets a text string called $email and this is inserted into a VARCHAR b> database

Re: GUI managers for Linux

Rance, Sunday, April 28, 2002, 2:44:45 AM, you wrote: RH> Ive downloaded and sucessfully installed both mysqlgui, and mycc from the RH> mysql.com site RH> for some wierd reason I cant connect to the database with either of them RH> I can with the text mysql client, and the text mysqladmin RH>

Re: myisamchk: error: Found key at page 2472960 that points to record

Do-Risika, Monday, April 29, 2002, 7:54:51 AM, you wrote: DRR> Can someone tell me what this error mean ? DRR> myisamchk: MyISAM file /var/lib/mysql/radius/radacct.MYI DRR> myisamchk: warning: 1 clients is using or hasn't closed the table DRR> properly DRR> myisamchk: error: Found key at page 24

Re: does mysql support multilanguage?

Nutsiyamoto, Monday, April 29, 2002, 11:43:56 AM, you wrote: N> does mysql support multilanguage? N> for example N> I've got table names "tbl_example" which has fields N> like the list below N> title_id,eng_name,fra_name,chi_name,ger_name N> in field "eng_name" contains text in english language

Re: Newbie: Question about installation.

Saurabh, Saturday, April 27, 2002, 7:50:24 AM, you wrote: SC> I installed mysql on linux mandrake 7.2 over the weekend. However i SC> want to use it as part of my application and not as some sort of a server. I SC> wanted to install mysql in my own account. Also i installed using rpm's

Re: mysql on macos x - where to find the configuration file my.ini or

Eric, Monday, April 29, 2002, 1:53:09 PM, you wrote: EB> is there anyone out there who knows where I can find my.ini or my.cnf on a EB> MacOS X system? I use the MYSQL version that came with the standard MacOS X EB> installation (updated to 10.1.4) You should create my.cnf by yourself. Examples

Re: Re: mysql read only ? sql,query

Rw, Sunday, April 28, 2002, 8:52:47 PM, you wrote: >> How to enable the table for read write again ? I gave not enough info :( Did you get error "table is read only" or what? R> Ridwan R> Goldbase Technology -- For technical support contracts, goto https://order.mysql.com/ This email is sp

Re: Dynamic $table in SELECT?

Jan, Saturday, April 27, 2002, 7:00:13 PM, you wrote: JP> Is there any ability to put tables dynamic in a query? JP> I have to do a select * for many tables and it would be cool if I just do JP> something like this JP> select * from (select t from mytables). JP> Thanks a lot, You can't do this w

Re: mysql server question

Timothy, Sunday, April 28, 2002, 6:18:12 PM, you wrote: TK> 1. Windows is giving me the 1067 error, which states TK> that the MySQL server is terminating unexpectedly. I TK> guess I'm going to have to reinstall it, unless TK> there's some way to troubleshoot what's wrong and then TK> fix the pro

Re: Install problem!

João, Saturday, April 27, 2002, 5:29:54 PM, you wrote: JPS> Some time ago I have installed MySQL and after a JPS> short period of time I uninstalled it. JPS> Now when I try to install it again the installshield JPS> makes a sound (like a warning) show a message box to JPS> quickly (it disappea

Re: docs for mysql rpms

Michael, Sunday, April 28, 2002, 10:45:46 PM, you wrote: MF> If you install mysql-3.23.49 using a source tarball and compile it with gcc, MF> the package contains documentation directories and manual directories. MF> If you install mysql-3.23.49a using an rpm then there don't seem to be doc MF

Re: Crashes during install

tim, Monday, April 29, 2002, 3:23:43 PM, you wrote: t>Description: t> Following installation I am unable to run the my_install_db script. t>How-To-Repeat: t> Follow steps for binary install, tarball untarred, symbolic link mysql t> created, run the my_install_db script and it crashes

Re: Performance problems...

Wouter, Monday, April 29, 2002, 1:42:36 PM, you wrote: [] WdJ> Trying to get some variables. WdJ> Some pointers may be invalid and cause the dump to abort... wd1> thd->query at 0x610a9940 is invalid pointer wd1> thd->thread_id=868173 And that's why it's better to use MySQL precompiled binary!

Re: Performance problems...

Subject: Re: Performance problems... From: Vic Cekvenich <[EMAIL PROTECTED]> === DB's are IO bound. Get more cache in Raid? So 2 CPU should not help. Conisder PostgreSQL. Wouter de Jong wrote: > Hi :) > > We're running 3 MySQL-servers for our customers databases > (hosting-provider), and once

Re: mysql_real_query and escaping a semicolon

Gerald Clark wrote: > The semicolon does not belong there. Where? At the end of the query or in the string? --Anna > > > Anna Fowles-Winkler wrote: > > >Anna Fowles-Winkler wrote: > > > >>Paul DuBois wrote: > >> > Paul DuBois wrote: > > > At 14:37 -0600 4/26/02, Anna Fowles-Winkl

Re: mysql_real_query and escaping a semicolon

At 8:37 -0600 4/29/02, Anna Fowles-Winkler wrote: >Gerald Clark wrote: > >> The semicolon does not belong there. > >Where? At the end of the query or in the string? > >--Anna At the end. Semicolons are perfectly legal in data values (which is why this whole episode seems odd), but you don't pu

RE: Results relevance

Hi, You can just do SELECT MATCH(column name) AGAINST ('searchstring') AS relevance FROM tablename; There is an example at: http://www.mysql.com/doc/F/u/Fulltext_Search.html Gurhan -Original Message- From: Mouratidis [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 6:38 AM To: [E

MySQl 3.23.39 ..

I've been looking to no avail for a day or two for MySQL 3.23.39. The ad serving software we're running requires this version, and I've seen no downloads for it other than MySQL-3.23.39-1.i386.rpm offf rpmfind.net. But I stillc an't fine the client, shared, devel or bench rpm's. Can anyone point m

Problems setting up database for PHP/MySQL

I'm trying to set up the database link between apache+php and mysql. The error messages that I get have suggested the user 'httpd' does not have sufficient privileges to access the test data bases. I've tried various ways to 'grant' access, but none seem to have any effect. I've looked at the man

Re: Deadlock errors - Can nobody help??!!

Hi. On Mon, Apr 29, 2002 at 08:41:16AM +0100, [EMAIL PROTECTED] wrote: > Hi, > > Can anybody help with the problem that I posted last week (26/04/2002 > 11:31) regarding deadlock errors via the Perl DBD::mysql module? > > To summarize, the following ridiculously simple program works fine when

Re: Sorts

Hi. Please start a new thread next time, instead of replying to an existing one with a different topic. On Mon, Apr 29, 2002 at 08:47:22AM +0100, [EMAIL PROTECTED] wrote: > Hi List, > > If I run the sql query SHOW STATUS how can I tell how many queries > required sorting? I don't think there i

Re: foreign key / duplcation / optimization

On Mon, Apr 29, 2002 at 01:06:02PM +0100, David Hanney wrote: > I've got a nice fat varchar(255) primary key who's content is > duplicated (as a foreign key) in many other tables. I hope MySQL > optimizes away that duplication internally. Not as much as you're probably hoping for. Consider mak

Re: To ban mysql server user login

Hi. On Mon, Apr 29, 2002 at 10:40:15AM +0200, [EMAIL PROTECTED] wrote: > > As I see after the installation mysql server user can > login because it has bash shell in passwd file; > > mysql:x:100:101:MySQL server:/var/lib/mysql:/bin/bash > > Can I change it to /sbin/nologin without so much > a

Re: mysql_real_query and escaping a semicolon

I removed the semicolon from the end of the query string, and I still get the same syntax error: You have an error in your SQL syntax near ''.1' at line 10 This is what the query looks like: INSERT INTO micromodels (name, revision, dynamic, m_class, novars, equation, min_0, min_1, min_2, min_3

a version of mysql for unix true64 4.0d

hello, where I can find a kit source of mysql for alpha true64 4.0d. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request t

Re: Mysql Crashed

Hi. Could it be that your MySQL server was upgraded to a version compiled without InnoDB support? If you used InnoDB it should have never complained about MYD files, as they belong to MyISAM table format. Bye, Benjamin. On Mon, Apr 29, 2002 at 01:54:28AM -0700, [EMAIL PROTECTED] wrot

Re: insert problem

Hi. On Mon, Apr 29, 2002 at 10:00:07AM +, [EMAIL PROTECTED] wrote: > > hi everybody, > > I have problem with inserting data into table. > MY table is:- > Name type > IDint(9)autoincrement > Total int(9) > > while i insert the data,i want the total(ID+2).Its mean the record should > b

Re: Performance problems...

On Monday 29 April 2002 07:36 am, Wouter de Jong wrote: > > In addition, here the resolved stack-trace: > > > > 0x806cb54 handle_segfault__Fi + 428 > > 0x8116c2a pthread_sighandler + 158 > > 0x80e715e mi_lock_database + 14 > > 0x80b5de8 external_lock__9ha_myisamP3THDi + 28 > > 0x8069d75 lock_exte

Re: Results relevance

Hi. Could you please stop asking the same question again and again? Meanwhile, you sent it at least four times within half a day. If somebody knows an answer, one post is usually enough. Bye, Benjamin. On Mon, Apr 29, 2002 at 11:38:14AM +0100, [EMAIL PROTECTED] wrote: > Anybody knows

compiler mes examples

hi every body i have installed mysql++ for linux. when i try to compile examples , i get this message: gcc custom1.cc i obtain ... /usr/local/include/mysql.h :no file or directory with this name. should i put some option or what?? help me please

Re: Slave crashes with SEGV on master shutdown

On Monday 29 April 2002 04:39 am, David Harper wrote: > >Description: > I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49 > with master/slave replication. > > The master mysqld is running on one machine, the slave on another. > Everything works fine

Re: general query

Hi. On Mon, Apr 29, 2002 at 07:58:57AM -0500, [EMAIL PROTECTED] wrote: > Hi Guru's, > > We say MySQL is open source database, so it can easily be adjusted to your > requirements. But I wonder how many administrators have actually gone into > the source code and made any modifications to match th

FW: I need an example on DELETE /UPDATE with JOIN syntax

Greetings: My company migrated to MySQL a few months ago from Sybase Adaptive Server Anywhere. Where I'm very impressed with the performance and the simplicity of management I find its very difficult, however, to run regular updates or deletes because joins are not supported on delete and update

Re: Segmentation Fault on mysqladmin

On Friday 26 April 2002 08:19 pm, [EMAIL PROTECTED] wrote: > >Description: > After installing MySQL on my RedHat Linux 7.2 server with MySQL-3.23.49a-1.i386.rpm I can't run mysqladmin. mysqladmin with any parameter results in a segmentation fault and core dump. I can run mysql and connect to th

Re: Results relevance

ok, here is an example query "SELECT IDArticle, MATCH (ArticleTitle, ArticleContent, Keywords) AGAINST ('$keyword') AS relevance FROM article WHERE MATCH (ArticleTitle, ArticleContent, Keywords) AGAINST ('$keyword')" basicly you have to select the match statement too; this will not return a pe

Re: Deadlock errors - Can nobody help??!!

Benjamin Pflugmann wrote: >On Mon, Apr 29, 2002 at 08:41:16AM +0100, [EMAIL PROTECTED] wrote: > >>Can anybody help with the problem that I posted last week (26/04/2002 >>11:31) regarding deadlock errors via the Perl DBD::mysql module? >> >>To summarize, the following ridiculously simple program

upload file through servlet ,mysql

Hello, I am afraid to ask some questions. They seem a little bit long. please forgive me.thanks in advanced first. I am working an application which is help user to create questions for exams. I have finish this part but I think i should modify it. I use mysql as the backend and java servlet to

browse explorer in the server, mysql

Hello, I am afraid to ask some questions. They seem a little bit long. please forgive me.thanks in advanced first. I am working an application which is help user to create questions for exams. I have finish this part but I think i should modify it. I use mysql as the backend and java servlet to

Download of source

Hi, I downloaded the latest source from mysql.com with bk clone bk://work.mysql.com:7001 mysql-4.0 and after compile/install, it installs the 3.23.50 version. Is this correct? Seems very strange to me. so, I tried to download the source of 3.23 with the command bk clone bk://work.mysql.com:7001

What is the best way to do this

Hi everybody, I need do the following: I have two MySQL tables, Table1 . . field-n . . Table2 . . field-m . . and are both varchar(100) containing words separated by space. I need to find out if any of the words in also are in . Is it possible to do th

Not secting empty strings

I want to query records that do not contain empty strings and null values through a SELECT statement. IS NOT NULL works for the nulls, but how I select non-empty strings ("")? I tried everything I can think of and even some non-published statements like name IS NOT '' . I just can't figure i

Cross querying databases (again)

Hi, Hope you don't mind me hassling you about this yet again. >> ... So you would need to run two queries, a LEFT JOIN and a >> RIGHT JOIN (or a LEFT JOIN with tables swapped) to get all >> results. > ... ... which is what I did in the end. except that on further checking it doesn't work! T

start up problem

OK, it seems like every time I install mysql, I run smack dab into some type of access problem -- if it isn't a password hangup, it's a mysql.sock problem or (at the moment) a refusal to allow me to create databases. I've puzzled through most of it for now, but this one has me stumped. It's giv

Download of Source (Please, ignore the previous message)

Hi, I downloaded the latest source from mysql.com with bk clone bk://work.mysql.com:7001 mysql-4.0 and after compile/install, it installs the 3.23.50 version. Is this correct? Seems very strange to me. so, I tried to download the source of 3.23 with the command bk clone bk://work.mysql.com:7001

Not secting empty strings

I want to query records that do not contain empty strings and null values through a SELECT statement. IS NOT NULL works for the nulls, but how I select non-empty strings ("")? I tried everything I can think of and even some non-published statements like name IS NOT '' . I just can't figure i

RE: Not secting empty strings

Have you tried "... WHERE columnname=''; "?? Gurhan -Original Message- From: Andrew Kuebler [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 12:55 PM To: [EMAIL PROTECTED] Subject: Not secting empty strings I want to query records that do not contain empty strings and null value

Newbie - Mac OS X install question

I am getting this error when I try to run safe_mysqld /usr/local/mysql/bin/safe_mysqld --user=mysql & 020429 12:42:46 mysqld started 020429 12:42:46 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't exist 020429 12:42:46 mysqld ended Where is the mysql.host located? How can I cre

Re: Download of source

At 13:51 -0300 4/29/02, Luciano Barcaro wrote: >Hi, > >I downloaded the latest source from mysql.com with >bk clone bk://work.mysql.com:7001 mysql-4.0 > >and after compile/install, it installs the 3.23.50 version. >Is this correct? Seems very strange to me. That is odd. I just tried it and got 4

Re: Not secting empty strings

>I want to query records that do not contain empty strings and null >values through a SELECT statement. > >IS NOT NULL works for the nulls, but how I select non-empty strings >("")? I tried everything I can think of and even some non-published >statements like name IS NOT '' . I just can't fi

Re: start up problem

The var dir is usually where the databases and logs go. At least, from the sources I've compiled, thats where it always gets stored. On Mon, 2002-04-29 at 10:03, Cindy wrote: > > OK, it seems like every time I install mysql, I run smack dab into > some type of access problem -- if it isn't a pa

Re: Upgrade of mySQL on a Red Hat 7.2 - box

"Shaun Bramley" <[EMAIL PROTECTED]> writes: > Ladies and Gentleman of the list, > > I have been a member of the list for about two weeks now and I must say that > I have learned a lot. Needless to say I am relatively new to the whole db > scene. > > My question is that I installed mySQL onto m

What is `Aborted Clients` ?

Hello Everybody, can anyone explain me what is an Aborted Client ? I begin to wonder about this because this number was about 20 or 30 last week, and now suddenly it got above 200 ! I have no idea of what it means, so any help would be appreciated. Filter : sql -- João Paulo Vasconcellos

Re: 3.23.50 client needs IP addresses

Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] writes: > > >Description: > > mysql client from 3.23.50 won't connect to older servers running on remote hosts >unless you specify the host as an IP address: > > > > ERROR 2005: Unknown MySQL Server Host 'xxx' (2) > > > > >Sub

Re: Results relevance

Sorry about sending it four times, but I keep getting an error that the message was not sent because the mailbox is full???. Again, my apologies. - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Mouratidis" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday,

Re: Results relevance

Doing that will not give back a percentage or anything that can be used to calculate one (right?). I meant if there was a way to actually get a result that could be interpreted into a percentage somehow. - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Mouratidis" <[EMAI

Re: Newbie - Mac OS X install question

At 13:27 -0400 4/29/02, [EMAIL PROTECTED] wrote: >I am getting this error when I try to run safe_mysqld > >/usr/local/mysql/bin/safe_mysqld --user=mysql & > > >020429 12:42:46 mysqld started >020429 12:42:46 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't >exist >020429 12:42:46 mys

RE: What is the best way to do this

You can write a program to do this.. Just query the table one , and tokenize the string returned and query the second table for each token with LIKE clauses and wildcards in a loop. Gurhan -Original Message- From: Javier [mailto:[EMAIL PROTECTED]] Sent: Monday, April 29, 2002 12:53 PM To

Re: Download of source

Paul DuBois wrote: > At 13:51 -0300 4/29/02, Luciano Barcaro wrote: > >> Hi, >> >> I downloaded the latest source from mysql.com with >> bk clone bk://work.mysql.com:7001 mysql-4.0 >> >> and after compile/install, it installs the 3.23.50 version. >> Is this correct? Seems very strange to me. > >

Re: Not secting empty strings

Hmm. How about: SELECT * FROM tablename WHERE LENGTH(somecolumn) > 0 AND ISNULL(othercolumn) != 1 Michael On Mon, 29 Apr 2002, Andrew Kuebler wrote: > I want to query records that do not contain empty strings and null > values through a SELECT statement. > > IS NOT NULL works for the

Can't get the lower_case_file_names variable to change

I can't change the lower_case_file_names variables using the -O lower_case_file_names=1 parameter to either the mysqld or the /etc/rc.d/init.d/mysql script. Neither mysqld -O lower_case_file_names=1 or /etc/rc.d/init.d/mysql -O lower_case_file_names=1 works. Is this a bug or am I missing som

Re: What is `Aborted Clients` ?

>Hello Everybody, > > can anyone explain me what is an Aborted Client ? I begin to wonder about >this because this number was about 20 or 30 last week, and now suddenly it >got above 200 ! I have no idea of what it means, so any help would be >appreciated. The number of connections closed by th

Re: Results relevance

At 17:45 +0100 4/29/02, Mouratidis wrote: >Sorry about sending it four times, but I keep getting an error that the >message was not sent because the mailbox is full???. That's because someone who is subscribed to the list has a full mailbox. When you get a message like that, just delete it and i

Re: Results relevance

At 17:50 +0100 4/29/02, Mouratidis wrote: >Doing that will not give back a percentage or anything that can be used to >calculate one (right?). I meant if there was a way to actually get a result >that could be interpreted into a percentage somehow. No. The values returned by a FULLTEXT search ar

Re: start up problem

Cindy writes: > >OK, it seems like every time I install mysql, I run smack dab into >some type of access problem -- if it isn't a password hangup, it's a >mysql.sock problem or (at the moment) a refusal to allow me to create >databases. I've puzzled through most of it for now, but this one

Re: What is `Aborted Clients` ?

On Mon, Apr 29, 2002 at 02:52:16PM -0300, João Paulo Vasconcellos wrote: > Hello Everybody, > > can anyone explain me what is an Aborted Client ? I begin to > wonder about this because this number was about 20 or 30 last week, > and now suddenly it got above 200 ! I have no idea of what it mean

Re: What is the best way to do this

yep, that's the problem. But MySQL wouldn't do anything else, just a bit faster because there are no queries to "compile". The only problem is, i don't know how to split this field into single values. If this would be possible, you could fill another table3 w/ these values enclosed by % % as patte

Re: Is transaction_isolation honoured with BDB tables?

On Mon, Apr 29, 2002 at 12:52:23PM +0100, Steve Hay wrote: > Hi, > > In addition to the deadlock problems that I'm having, as described > in previous e-mails (still not solved...), it appears that the > transaction_isolation level setting is not being honoured, at least > when using BDB tables.

Re: start up problem

Hey Cindy, Usually you can get a better idea of the real problem by looking in the hostname.err (where hostname is the hostname of your machine) file in whatever directory you are storing your logs in. Is there any info in that file that you can post? You can check to make sure another mysql.so

Re: general query

Hi >>We say MySQL is open source database, so it can easily be adjusted to your requirements. But I wonder how many administrators have actually gone into the source code and made any modifications to match their specific needs, if any. << The point is you "can" make modifications if you want to

  1   2   >