Link request.

[Rajesh V. Tavakari]

Hello!

Let me introduce myself.  My name is Mr. Rajesh Tavakari from 
www.website-promotion-ranking-services.com, and you can contact 
me at [EMAIL PROTECTED] or [EMAIL PROTECTED]

I enjoyed visiting your interesting site at http://www.mysql.com/documentation/.  You 
may know that having high link popularity can help you in the search engine ranking.  
Link popularity is defined as the number of web sites that link back to your site. 
Links from other pages are one of the main sources of web traffic, and they are 
becoming increasingly important for other reasons.  

There have been studies that show the majority of traffic to web sites comes from 
people clicking on links from other sites.  The  Search engines are also beginning to 
use the number (and in some cases quality) of links to your pages to assist in their 
ranking of your site. 
 
For these reasons and others, you need to have links to your site from other sites if 
you want to increase traffic to your site.

I am looking forward to add your URL to our website at 
http://www.website-promotion-ranking-services.com/links.htm.  To add your website link 
to our website please visit : 
http://www.website-promotion-ranking-services.com/links.htm.

It would be kind of you, if you could link back to me, thus increasing link popularity 
of both sites.

As soon as you add our link on your website, You Get  3 Bonus :

1. Submission of your website in the appropriate categories.  Our SEO Experts will 
submit your individual link pages in appropriate 
category every 15 days for 1 month.

2.  Basic Directory Listing with 6 month Classified Ad* with Sunny Side Business 
Directory

3.  FREE ! Three Ultimate E-books on Web promotion and Optimization worth 125 $.

Best Regards,


Rajesh. V. Tavakari [ Specialist in Web Promotion & Web Optimization ]
CEO - WebPromotionGuru.com & 
  - Website-Promotion-Ranking-Services.com.

Address : 
B-I/3, P & T Quarters. Kavalbyrasandra.
R.T Nagar Post. BANGALORE - 32.
State : Karnataka. INDIA.

E-Mail :   [EMAIL PROTECTED]
E-Mail :   [EMAIL PROTECTED] 

URL :   www.Website-Promotion-Ranking-Services.com 
URL :   www.WebPromotionGuru.com 

Phone : ( 00 91 ) 9845089687.

Contact Us Online at :
ICQ   : 19511229.
Yahoo Messenger : [EMAIL PROTECTED]
MSN : [EMAIL PROTECTED]


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem with mysqldump

[Agent Smith]

Hi everybody,

I got a problem with the "mysqldump" function.

I connect to mySql trough phpMyAdmin, select the database "xyz", which
is the only database on the server.
Then I enter the following string into the text field "Run SQL
query/queries on database xyz:":

mysqldump xyz | mysql --host=XXX.168.XXX.14 --port=3306
--socket=/var/mysql/mysql.sock --username=X --password[X] xyz

I want to copy the whole databse from one server to the other, but i
always get th error message,

MySQL said: You have an error in your SQL syntax near 'mysqldump
catfxpboard | mysql --host=194.168.102.14 --port=3306 --socket=/var/my'
at line 1

But I can't find a mistake there!? Can you helpp me?


Thanks!


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Thinking of switching from MyISAM to InnoDB

[ryc]

If you want a MyISAM table to grow larger than 4GB you have to do

alter table tablename max_rows=1

or maybe its 'maxrows'...

Once you do that, you will be able to stuff the table as full as the OS will
let you.

Innobase will allow you to get around this by making a bunch of smaller
files to create a larger table space... but keep in mind the max size for a
blob is 4GB.. (yah that is pretty damn huge tho heh). Im not sure what the
max size for a MyISAM blob is.

Hope this helps.

ryan

- Original Message -
From: "Nick Seidenman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 04, 2001 9:54 AM
Subject: Re: Thinking of switching from MyISAM to InnoDB


> On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote:
>
> > Nick Seidenman writes:
> > > Apparentlly there's a 4 GB limit to a MyISAM file when the table it
> > > contains has VARCHAR, TEXT, or BLOB columns.  In order to get around
this
> >
> > There is no 4 Gb limit in MyISAM with later 3.23 versions.
>
> I an running version 3.23.32.
>
> > This limit is imposed by a filesystem only.
>
> Don't think so.  When I do a SHOW TABLE STATUS I have several tables that
are
> well in excess of 4 GB (2^32-1), as well as those that show exactly 4GB.
The
> difference is that the larger tables are of fixed type while the smaller
ones
> are of dynamic type.  It is one of the dynamic tables that repeatedly runs
> into space problems.  This one happens to have a TEXT column in it the
values
> for which can be (and often are) in excess of 2 KB.
>
> 
>  Nick Seidenman, CISSP
>  Director of Software Development
>  Hyperon, Inc.
>  www.hyperon.com
>
> -
> 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 <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

portable query?

[Jamie Burns]

hi all...

i have a mysql query as follows:

SELECT *,

( if((description LIKE '%keyword_one%'), 1, 0)+
if((description LIKE '%keyword_two%'), 1, 0)+
if((description LIKE '%keyword_three%'), 1, 0)+
if((description LIKE '%keyword_four%'), 1, 0) ) as keyword_score,

FROM table WHERE

( (description LIKE '%keyword_one%) OR
(description LIKE '%keyword_two%) OR
(description LIKE '%keyword_three%) OR
(description LIKE '%keyword_four%) )

GROUP BY ref ORDER BY keyword_score DESC;

this query is great for my search engine because it ranks the results based
on how many keywords were found in each row (users love this).

i know have to think about making it portable (i found the if() statement
didnt work in PostgreSQL).

are there any portable equivilents to this MySQL specific query?

thanks for your thoughts,

jamie burns.


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Thinking of switching from MyISAM to InnoDB

[Chris Cameron]

Is there a place that outlines the advantages/disadvantages of both
MyISAM and InnoDB?

Thanks,
Chris

-Original Message-
From: Tonu Samuel [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 2:34 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Thinking of switching from MyISAM to InnoDB


On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote:

> There is no 4 Gb limit in MyISAM with later 3.23 versions.
>
> This limit is imposed by a filesystem only.


and RAIDed table can help to build aby size tables if only index
file doesn't get too big.

Actually InnoDB is nice thing. Just bith MyISAM and InnoDB have good
advantages and you should decide, which ones you need more.

--
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
/_/  /_/\_, /___/\___\_\___/   Hong Kong, China
   <___/   www.mysql.com


-
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
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Thinking of switching from MyISAM to InnoDB

[Tonu Samuel]

On 04 Aug 2001 16:25:14 +0300, Sinisa Milivojevic wrote:

> There is no 4 Gb limit in MyISAM with later 3.23 versions.
> 
> This limit is imposed by a filesystem only.


and RAIDed table can help to build aby size tables if only index
file doesn't get too big. 

Actually InnoDB is nice thing. Just bith MyISAM and InnoDB have good
advantages and you should decide, which ones you need more.

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
/_/  /_/\_, /___/\___\_\___/   Hong Kong, China
   <___/   www.mysql.com


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Char Set (Arabic) question

[Tonu Samuel]

On 04 Aug 2001 22:57:39 +0300, Khaled I. Hammouda wrote:
> Greetings ALL:
> 
> I am developing a database application using mySQL & php for a client
> that requires data entry (at least) to be in Arabic.
> 
> I am know that mySQL supports charsets, but it is not clear if it
> supports charsets that are not left-to-right, such as Arabic.
> 
> If the answer to this is obvious and documented then please accept my
> apologies, and direct me to the right resource(s).

I didn't knew also and searched manual for word "arabic". There was
nothing about this. So if this charset not called somehow different then
it is not supported. But if this an true we are really interested about
information, how Arabic language is organized. Maybe you can point to
some source on the web? Changing left-right directions seems easy to me
on first look. We need information:

Is Arabic an single or multibyte character set?

In which order these characters should appear? (prorably some national
standard describes this)

Also we need information about upper->lower conversion if it is
applicable at all.

And after all the smallest thing is translating about 220 error messages
to Arabic. This is the part we cannot do as nobody of us can speak this
language as far I know :(
 


-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Tonu Samuel <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
/_/  /_/\_, /___/\___\_\___/   Hong Kong, China
   <___/   www.mysql.com


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: New member question

[Venu]

Hi !
> -Original Message-
> From: shawn reed [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, August 04, 2001 12:50 PM
> To: RCA Webmaster
> Cc: [EMAIL PROTECTED]
> Subject: Re: New member question
>
>
> there are a number of ways you could accomplish this.
>
> depending on how large the database is, you may want to try exporting it
> to csv (comma separated value) format, and then importing it into mysql,
> using either the "load" command, or a third-party utility like phpmyadmin
> (which is what i generally use for tasks like that).
>
> another way is if you are indeed using php and you have odbc support
> compiled in... you could simply read from the access database and
> simultaneously write it to a new mysql table.
>
> that's what i could think of offhand..someone else out there might have a
> better solution or three. =)
>
> ~shawn
>
> On Sat, 4 Aug 2001, RCA Webmaster wrote:
>
> >
> > I have just subscribed to this list, so forgive me if my
> question has been
> > answered many times before but I was not sure where else to find this
> > information.
> >
> > I am new to mysql and am going to be using it on a website that
> I maintain.
> > My question is, is there a program/utility or easy way to convert an MS
> > Access database to mysql format?
> >
> > Thanks,
> >

Install latest MyODBC driver by downloading from
http://www.mysql.com/downloads/api-myodbc.html. Once installation done, try
to export the table from access to mysql through MyODBC. Please read the
following manual for more details.
http://www.mysql.com/documentation/mysql/bychapter/manual_ODBC.html#ODBC

Also there is a " mysqlfront " GUI tool, where in you can directly import
the tables from access (using access DB files) to mysql. You can download
this from www.mysqlfront.de.


Hope this helps you.
Regards
venu

--
For technical support contracts, go to https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Venu <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Redwood city, California  USA
   <___/   www.mysql.com


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Char Set (Arabic) question

[Khaled I. Hammouda]

Greetings ALL:

I am developing a database application using mySQL & php for a client
that requires data entry (at least) to be in Arabic.

I am know that mySQL supports charsets, but it is not clear if it
supports charsets that are not left-to-right, such as Arabic.

If the answer to this is obvious and documented then please accept my
apologies, and direct me to the right resource(s).

Please respond to this list, and to me directly @
mailto:[EMAIL PROTECTED]

TIA
KHaled.

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: New member question

[shawn reed]

there are a number of ways you could accomplish this.

depending on how large the database is, you may want to try exporting it
to csv (comma separated value) format, and then importing it into mysql,
using either the "load" command, or a third-party utility like phpmyadmin
(which is what i generally use for tasks like that).

another way is if you are indeed using php and you have odbc support
compiled in... you could simply read from the access database and
simultaneously write it to a new mysql table.

that's what i could think of offhand..someone else out there might have a
better solution or three. =)

~shawn

On Sat, 4 Aug 2001, RCA Webmaster wrote:

> 
> I have just subscribed to this list, so forgive me if my question has been
> answered many times before but I was not sure where else to find this
> information.
> 
> I am new to mysql and am going to be using it on a website that I maintain.
> My question is, is there a program/utility or easy way to convert an MS
> Access database to mysql format?
> 
> Thanks,
> 
> Chris
> 
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01
> 
> 
> -
> 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 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

New member question

[RCA Webmaster]

I have just subscribed to this list, so forgive me if my question has been
answered many times before but I was not sure where else to find this
information.

I am new to mysql and am going to be using it on a website that I maintain.
My question is, is there a program/utility or easy way to convert an MS
Access database to mysql format?

Thanks,

Chris



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.265 / Virus Database: 137 - Release Date: 7/18/01


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Thinking of switching from MyISAM to InnoDB

[Jeremy Zawodny]

On Sat, Aug 04, 2001 at 09:15:52AM -0500, Gerald R. Jensen wrote:
> 
> To the best of my knowledge, MySQL doesn't impose file size limits
> ... that is dictated by the O/S's file system. Switching to InnoDB
> wouldn't change that.

But InnoDB would let you use multiple tablespaces to get around any
such limitation.

In this case, however, that's probably not the problem anyway.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936 <-- NEW

MySQL 3.23.29: up 49 days, processed 393,812,934 queries (92/sec. avg)

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: missing setup.dll

[Miguel Angel Solórzano]

At 18:29 04/08/2001 +0300, Hiba Muhrez wrote:
Hi,

When you unzipped the 3.23.40 distribution file you should
have the following files:

02/08/2001  00:31  128 DATA.TAG
02/08/2001  00:31   11.535.662 data1.cab
30/05/1997  11:314.557 lang.dat
02/08/2001  00:31  386 layout.bin
06/05/1997  14:15  417 os.dat
08/02/2001  04:07   62.646 SETUP.BMP
19/11/1997  16:09   59.904 SETUP.EXE
02/08/2001  00:31   90 SETUP.INI
14/06/2001  03:56   57.122 setup.ins
02/08/2001  00:31   49 setup.lid
19/11/1997  16:05  300.178 _INST32I.EX_
19/11/1997  16:058.192 _ISDEL.EXE
19/11/1997  16:08   11.264 _setup.dll
02/08/2001  00:31  186.302 _sys1.cab
02/08/2001  00:31   45.137 _user1.cab

Compare the size with your ones. If you see different
sizes, means that your download got a corrupt file.

Regards,
Miguel



>please,
>i downloaded the mysql 3.23 from your site and i made the unzip
>and when i begin to make setup i found error: missing setup.dll
>what can i do?
>please reply fast
>[EMAIL PROTECTED]
>yasmeen
>-
>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 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

missing setup.dll

[Hiba Muhrez]

please,
i downloaded the mysql 3.23 from your site and i 
made the unzip
and when i begin to make setup i found error: 
missing setup.dll
what can i do?
please reply fast
[EMAIL PROTECTED] 
yasmeen

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Bug report.

[Cal Evans]

Hi,

Sorry to have bothered everyone. I was using .38.  I just noticed that and
am currently building .40.

Cal
http://www.calevans.com


-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 9:59 AM
To: Sinisa Milivojevic; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Bug report.


Hi!

What InnoDB version you are using? A bad rollback
bug was fixed in version 3.23.39.

Regards,

Heikki

At 05:40 PM 8/4/01 +0300, you wrote:
>Content-Type: message/rfc822
>Content-Description: forwarded message
>Content-Transfer-Encoding: 7bit
>
>MIME-Version: 1.0
>Content-Type: text/plain;
>   charset="iso-8859-1"
>Subject: Bug report.
>From: "Cal Evans" <[EMAIL PROTECTED]>
>To: "Mysql" <[EMAIL PROTECTED]>
>Date: Sat, 4 Aug 2001 09:25:55 -0500
>
>I have a reproducible but it's not easy to reproduce. It involves a complex
>transaction that gets rolled back instead of committed.
>
>Cal
>
>Innobase: Assertion failure in thread 8201 in file trx0roll.c line 887
>Innobase: we intentionally generate a memory trap.
>Innobase: Send a bug report to [EMAIL PROTECTED]
>mysqld got signal 11;
>The manual section 'Debugging a MySQL server' tells you how to use a
>stack trace and/or the core file to produce a readable backtrace that may
>help in finding out why mysqld died.
>Attempting backtrace. You can use the following information to find out
>where mysqld died.  If you see no messages after this, something went
>terribly wrong...
>Stack range sanity check OK, backtrace follows:
>0x4007c552
>0x8178fea
>0x813d2b7
>0x813dc9e
>0x8177851
>0x8179310
>0x811aaec
>0x81122b1
>0x80d3233
>0x80d4889
>0x80cfc39
>0x80cf16e
>Stack trace successful, trying to get some variables.
>Some pointers may be invalid and cause the dump to abort...
>thd->query at 0x83540c0 = rollback
>thd->thread_id = 1
>Successfully dumped variables, if you ran with --log,
>take a look at the details of what thread 1 did to cause the crash.
>In some cases of really bad corruption, this value may be invalid
>Please use the information above to create a repeatable
>test case for the crash, and send it to [EMAIL PROTECTED]
>
>Cal
>http://www.calevans.com
>
>
>
>-
>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 <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>Content-Type: text/plain; charset=us-ascii
>Content-Description: message body and .signature
>Content-Transfer-Encoding: 7bit
>
>
>Something for you ...
>
>--
>Regards,
>   __  ___ ___   __
>  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
>/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
>   <___/   www.mysql.com
>



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

libmysqlclient[_r].so + pthreads + gdb

[Vladimir Zidar]

>Description:
mysql refuses connection [local/unix-socket] when client is ran under GDB,
and linked with pthread library. It doesn't need to call any pthread_*()
function, it just fails when linked with it.

>How-To-Repeat:

#include 
#include 


main()
{
MYSQL m;

if(mysql_connect(&m, NULL, "root", "mysqlroot")) {
printf("Connect okay\n");
mysql_close(&m);
  } else {
fprintf(stderr, "MYSQL:%d %s\n", mysql_errno(&m), mysql_error(&m));
  }
}


gcc m2.c -o m2 -D_REENTRANT -lmysqlclient_r

gdb ./m2

run


>Fix:

 Don't know.

>Submitter-Id:  
>Originator:root
>Organization:
  ==
  Mail  : [EMAIL PROTECTED]  WWW : http://www.mindnever.org
  Phone : +381 63 550 161 ICQ : 15414204
  ==
>
>MySQL support: [none]
>Synopsis:  libmysqlclient_r + pthreads + gdb fails to connect to server
>Severity:  critical
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.36 (Linux-Mandrake MySQL RPM)

>Environment:

System: Linux noteboox 2.4.4 #3 Sat Jul 21 21:12:31 CEST 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs
gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk)
Compilation info: CC='gcc'  CFLAGS='-O3 -fomit-frame-pointer -pipe 
-mcpu=pentiumpro -march=i586 -ffast-math -fno-omit-frame-pointer'  CXX='g++'  
CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 
-ffast-math -fno-omit-frame-pointer'  LDFLAGS=''
LIBC: 
lrwxrwxrwx   1 root root   13 Apr 27 02:08 /lib/libc.so.4 -> 
libc.so.4.7.6
-rwxr-xr-x   1 root root   634880 Apr 29  1996 /lib/libc.so.4.7.6
lrwxrwxrwx   1 root root   13 May  2 02:37 /lib/libc.so.6 -> 
libc-2.2.2.so
-rwxr-xr-x   1 root root  1216268 Feb 21 11:38 /lib/libc-2.2.2.so
-rw-r--r--   1 root root 26366908 Feb 21 11:31 /usr/lib/libc.a
-rw-r--r--   1 root root  178 Feb 21 11:31 /usr/lib/libc.so
Configure command: ./configure  --enable-shared --enable-thread-safe-client 
--enable-assembler --with-mysqld-user=mysql 
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ 
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin 
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql 
--infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man 
--with-berkeley-db --without-innobase '--with-comment=Linux-Mandrake MySQL 
RPM'
Perl: This is perl, version 5.005_03 built for i586-linux
a
-- 
==
Mail  : [EMAIL PROTECTED]  WWW : http://www.mindnever.org
Phone : +381 63 550 161 ICQ : 15414204
==

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Bug report.

[Heikki Tuuri]

Hi!

What InnoDB version you are using? A bad rollback
bug was fixed in version 3.23.39.

Regards,

Heikki

At 05:40 PM 8/4/01 +0300, you wrote:
>Content-Type: message/rfc822
>Content-Description: forwarded message
>Content-Transfer-Encoding: 7bit
>
>MIME-Version: 1.0
>Content-Type: text/plain;
>   charset="iso-8859-1"
>Subject: Bug report.
>From: "Cal Evans" <[EMAIL PROTECTED]>
>To: "Mysql" <[EMAIL PROTECTED]>
>Date: Sat, 4 Aug 2001 09:25:55 -0500
>
>I have a reproducible but it's not easy to reproduce. It involves a complex
>transaction that gets rolled back instead of committed.
>
>Cal
>
>Innobase: Assertion failure in thread 8201 in file trx0roll.c line 887
>Innobase: we intentionally generate a memory trap.
>Innobase: Send a bug report to [EMAIL PROTECTED]
>mysqld got signal 11;
>The manual section 'Debugging a MySQL server' tells you how to use a
>stack trace and/or the core file to produce a readable backtrace that may
>help in finding out why mysqld died.
>Attempting backtrace. You can use the following information to find out
>where mysqld died.  If you see no messages after this, something went
>terribly wrong...
>Stack range sanity check OK, backtrace follows:
>0x4007c552
>0x8178fea
>0x813d2b7
>0x813dc9e
>0x8177851
>0x8179310
>0x811aaec
>0x81122b1
>0x80d3233
>0x80d4889
>0x80cfc39
>0x80cf16e
>Stack trace successful, trying to get some variables.
>Some pointers may be invalid and cause the dump to abort...
>thd->query at 0x83540c0 = rollback
>thd->thread_id = 1
>Successfully dumped variables, if you ran with --log,
>take a look at the details of what thread 1 did to cause the crash.
>In some cases of really bad corruption, this value may be invalid
>Please use the information above to create a repeatable
>test case for the crash, and send it to [EMAIL PROTECTED]
>
>Cal
>http://www.calevans.com
>
>
>
>-
>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 <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>Content-Type: text/plain; charset=us-ascii
>Content-Description: message body and .signature
>Content-Transfer-Encoding: 7bit
>
>
>Something for you ...
>
>-- 
>Regards,
>   __  ___ ___   __
>  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
>/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
>   <___/   www.mysql.com
>


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Thinking of switching from MyISAM to InnoDB

[Nick Seidenman]

On Saturday 04 August 2001 09:25, Sinisa Milivojevic wrote:

> Nick Seidenman writes:
> > Apparentlly there's a 4 GB limit to a MyISAM file when the table it
> > contains has VARCHAR, TEXT, or BLOB columns.  In order to get around this
>
> There is no 4 Gb limit in MyISAM with later 3.23 versions.

I an running version 3.23.32.

> This limit is imposed by a filesystem only.

Don't think so.  When I do a SHOW TABLE STATUS I have several tables that are 
well in excess of 4 GB (2^32-1), as well as those that show exactly 4GB.  The 
difference is that the larger tables are of fixed type while the smaller ones 
are of dynamic type.  It is one of the dynamic tables that repeatedly runs 
into space problems.  This one happens to have a TEXT column in it the values 
for which can be (and often are) in excess of 2 KB.

  
 Nick Seidenman, CISSP  
 Director of Software Development  
 Hyperon, Inc.  
 www.hyperon.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Bug report.

[Cal Evans]

I have a reproducible but it's not easy to reproduce. It involves a complex
transaction that gets rolled back instead of committed.

Cal

Innobase: Assertion failure in thread 8201 in file trx0roll.c line 887
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL PROTECTED]
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died.
Attempting backtrace. You can use the following information to find out
where mysqld died.  If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x4007c552
0x8178fea
0x813d2b7
0x813dc9e
0x8177851
0x8179310
0x811aaec
0x81122b1
0x80d3233
0x80d4889
0x80cfc39
0x80cf16e
Stack trace successful, trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x83540c0 = rollback
thd->thread_id = 1
Successfully dumped variables, if you ran with --log,
take a look at the details of what thread 1 did to cause the crash.
In some cases of really bad corruption, this value may be invalid
Please use the information above to create a repeatable
test case for the crash, and send it to [EMAIL PROTECTED]

Cal
http://www.calevans.com



-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Thinking of switching from MyISAM to InnoDB

[Gerald R. Jensen]

Nick:

What O/S are you running ... Windows?

To the best of my knowledge, MySQL doesn't impose file size limits ... that
is dictated by the O/S's file system. Switching to InnoDB wouldn't change
that.

Gerald Jensen

- Original Message -
From: "Nick Seidenman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 6:44 PM
Subject: Thinking of switching from MyISAM to InnoDB



Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains
has VARCHAR, TEXT, or BLOB columns.  In order to get around this limitation
I
was looking to switching to InnoDB table types.  As this looks like a
relatively new subsystem I'm wondering if it is stable enough for production
systems, or is it still too new (and too "feature-prone".)  I'd appreciate
hearing feedback on this.  If I do wind up switching, it won't be for at
least a month.

TiA,

nick


 Nick Seidenman, CISSP
 Director of Software Development
 Hyperon, Inc.
 www.hyperon.com

-
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
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Further FreeBSD 4.3 Issues (CPU hogging)

[Sinisa Milivojevic]

Ken Menzel writes:
> Hi Michael,
>   Sounds like the mysqld may have been stuck in a tight loop then.
> Any ideas Sinisa?
> Try the truss once more if it happens again.  I can't think of
> anything that would cause this.
> Let me know what happens,  also try the truss when the server is
> running normally just to see the output and make sure you know how to
> do it,  even on an idle server it  Prints something like this:
> (null)() = 0 (0x0)
> gettimeofday(0x283558e8,0x0) = 0 (0x0)
> clock_gettime(0x0,0xbfafefa4)= 0 (0x0)
> poll(0x82df000,0x2,0x0)  = 0 (0x0)
> 
> Ken

Hi!

I must admit I have not followed a thread, so I do not know what is a
basic problem 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: CREATE INDEX -- bug?

[Sinisa Milivojevic]

David White writes:
> I have a problem with some data disappearing after a CREATE INDEX
> statement.  Here's the sequence of events:
> 
> 1.  I have the tables MASTER_ACCOUNT, MASTER_EMAIL, MASTER_GROUP,
> MASTER_INDIVIDUAL, TMP_PHONE_DAY, TMP_PHONE_FAX, and TMP_PHONE_NIGHT.
> All of these are populated with lots of data, between 20,000 and 250,000
> rows each.  There are other tables in the database, but these are the only
> ones that I'm interested in here.
> 
> 2.  I run a Perl script.  It uses DBI (1.14) to access the
> database.  It contains the lines:
> 
> $dbh->do("CREATE INDEX ma ON $DB_SOURCE.MASTER_ACCOUNT(RACCOUNT)");
> $dbh->do("CREATE INDEX mi ON $DB_SOURCE.MASTER_INDIVIDUAL(RACCOUNT)");
> $dbh->do("CREATE INDEX mg ON $DB_SOURCE.MASTER_GROUP(RACCOUNT)");
> $dbh->do("CREATE INDEX me ON $DB_SOURCE.MASTER_EMAIL(RACCOUNT)");
> $dbh->do("CREATE INDEX pd ON $DB_SOURCE.TMP_PHONE_DAY(RACCOUNT)");
> $dbh->do("CREATE INDEX pn ON $DB_SOURCE.TMP_PHONE_NIGHT(RACCOUNT)");
> $dbh->do("CREATE INDEX pf ON $DB_SOURCE.TMP_PHONE_FAX(RACCOUNT)");
> 
> So far, everything is ok.  The tables have all of their data, and are
> indexed.
> 
> 3.  Later, I run the script again.  (None of the data has changed in
> the interim.)  This will try to create duplicate indices, which is a
> mistake that I hadn't thought about.  I don't get any warning about
> duplicate indices.  Further, all of the data gets erased from the
> tables!  It looks like:
> 
> -rw-rw1 mysqlmysql9674 Aug  3 09:45 MASTER_ACCOUNT.frm
> -rw-rw1 mysqlmysql   0 Aug  3 09:45 MASTER_ACCOUNT.MYD
> -rw-rw1 mysqlmysql1024 Aug  3 09:45 MASTER_ACCOUNT.MYI
> -rw-rw1 mysqlmysql8686 Aug  3 09:45 MASTER_EMAIL.frm
> -rw-rw1 mysqlmysql   0 Aug  3 09:45 MASTER_EMAIL.MYD
> -rw-rw1 mysqlmysql1024 Aug  3 09:45 MASTER_EMAIL.MYI
> -rw-rw1 mysqlmysql8772 Aug  3 09:45 MASTER_GROUP.frm
> -rw-rw1 mysqlmysql   0 Aug  3 09:45 MASTER_GROUP.MYD
> -rw-rw1 mysqlmysql1024 Aug  3 09:45 MASTER_GROUP.MYI
> ... and so forth for all of the tables mentioned. 

Hi!

This should not have happened !!

Please try our latest 3.23.40 binary and see if there is anyway you
can reproduce the problem. 

If you can reproduce it with our binaries (and your settings are all
OK), we would like to take a closer look at your tables.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: socket error: Can't connect to local MySQL server through socket '' (111)

[Sinisa Milivojevic]

Charles Mégnin writes:
> I am getting an error message
> 
> Can't connect to local MySQL server through socket '' (111)
> 
> trying to connect via mySQLgui on my Linux box running RH6.2
> I do have a
> /tmp/mysql.sock
> with proper authorizations
> and have no problem connecting to the serverwithout the client.
> Thanks for your clues
> Charles


All you have to do is follow instructions from README that came with
mysqlgui. 

This is a relevant excerpt:

When you start mysqlgui for the first time, you'll need to tell it how to
connect to the MySQL server.  To do this, click on the ``Options'' button.
Select the ``Server'' tab and fill in the fields that indicate where to
find the server.  On Unix, if you have problems with mysqlgui not knowing
the location of the socket file for connections to localhost, enter the
full pathname of the socket file in the ``SQL command on the start-up''
field.  On Windows, this field is used if you wish to specify the named pipe
option.  Then select the ``Client'' tab and fill in your MySQL user name.
Take care to select the right value for the ``Ask for password'' button,
depending on whether or not you want mysqlgui to prompt you for your
MySQL password.  After you have filled in the server and client values,
click on the ``Save'' button.  From then on, each time mysqlgui starts up,
it will connect to the MySQL server automatically.


-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Thinking of switching from MyISAM to InnoDB

[Sinisa Milivojevic]

Nick Seidenman writes:
> 
> Apparentlly there's a 4 GB limit to a MyISAM file when the table it contains 
> has VARCHAR, TEXT, or BLOB columns.  In order to get around this limitation I 
> was looking to switching to InnoDB table types.  As this looks like a 
> relatively new subsystem I'm wondering if it is stable enough for production 
> systems, or is it still too new (and too "feature-prone".)  I'd appreciate 
> hearing feedback on this.  If I do wind up switching, it won't be for at 
> least a month.
> 
> TiA,
> 
> nick
>  
>   
>  Nick Seidenman, CISSP  
>  Director of Software Development  
>  Hyperon, Inc.  
>  www.hyperon.com

There is no 4 Gb limit in MyISAM with later 3.23 versions.

This limit is imposed by a filesystem only.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: floor/ceiling with myodbc

[Sinisa Milivojevic]

Kevin X Lin writes:
> Hi there,
> 
> I'm running into problems with functions "floor/ceiling" when I use
> Visual Basic to talk to mySQL through myODBC.
> 
> My code looks like this:
> sSQL = "select floor(3.2)"
> Set rs = MySQL_conn.Execute(sSQL)
> 
> I got rs.eof = true after execution of the query. However the following
> codes works fine.
> sSQL = "select round(3.2)"
> Set rs = MySQL_conn.Execute(sSQL)
> rs.fields(0)=3
> 
> Can anyone tell if this is a bug of myODBC or VB's problem?
> 

Sorry, but what is your problem ??

round(3.2) = 3

The above is quite true. As you have not specified number of decimals,
MySQL is using default of 0, which conforms with SQL 92 standard.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Delete

[Sinisa Milivojevic]

Eric Fegraus writes:
> Hello,
> I just checked the list for answer to this question and looks like there
> hasn't been one. I have a similar problem, I want to delete a record
> from a table where the value of the field is equal to the value of a
> field in another table. 
> 
> delete from table1 where table1.column = table2.column;
> 
> Any thoughts?
> 
> Thanks,
> Eric
> 


Beside Jeremy's valuable comment, you should know that the above is
already possible in 4.0. 4.0 will be released this autumn.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: perforamnce

[Tadej Guzej]

Well, sometimes I use all of the fields in the SELECT statement,
sometimes just one.
How about if I create both indexes?
How would it affect the performance? I don't care about update time as i
insert or update records at night only once a day.

Thanks for the answer

- Original Message -
From: "Kahled Al Sahmaa" <[EMAIL PROTECTED]>
To: "Tadej Guzej" <[EMAIL PROTECTED]>
Sent: Saturday, August 04, 2001 12:25 PM
Subject: Re: perforamnce


> Hello...
>
> that related to your select statement which you are use, if you have
> field1, field2 and field3 in the where section then the first index:
>
> CREATE INDEX ix1(field1, field2, field3);
>
> will be better for you, but if you are using select statements which has
been
> used one of that fields alon then the secound choice will be better.
>
>
>
> - Original Message -
> Subject: perforamnce
> Sent: Sat, 4 Aug 2001 12:53:15 +0100
> From: "Tadej Guzej" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> >
> >What is better:
> >
> >CREATE INDEX ix1(field1, field2, field3);
> >
> >or
> >
> >CREATE INDEX ix1(field1), ix2(field2), ix3(field3);
> >
> >I have a large table of some 30,000,000 records and am wondering
> >which indexing gives better performance and why.
> >
> >
> >How do I optimize search on this table - I'm using lots of OR statements
in
> WHERE clause.
> >
> >Thanks in advance,
> >
> >Tadej
> >
>
>
> Sincerely,
> Khaled Al-Sham'aa
> http://www.mazadmaktoob.com
>
> _
> Send Your favorite Arabic Card from Maktoob Cards,
http://cards.maktoob.com
>
>


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Kernel crash caused by mysql?

[Van]

Mario Witte wrote:
> 
> On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote:
> > Mario Witte wrote:
> > Memory or motherboard. How many sticks of RAM do you have in the machine?  Are
> > they the same speed (p100/p133, etc.)?  What kind of motherboard? Is updatedb
> > running at this time?  (might be a hard-drive croaking while trying to update
> > the locate database).
> There are 2x256 MB and 2x128MB sticks in there, all at a spped of 133.
> Please don't ask me what kind of motherboard we're running in there, but
> that shouldn't be a problem.

Couple months ago I had 256 MBytes in my Slackware Athlon workstation labeled
100MHz-128MBytes on both chips.  Turns out one of the chips was 133MHz and the
other was 100MHz (Fry's electronics labeling dep't).  Sadly, the bucks I spent
on a new PIII true Intel Board qualified the chips and I put the 2 133MHz chips
into the Athlon and the 2 qualified P100Mhz chips into the PIII Intel board. 
Honestly, my Athlon was crashing on Slackware and the Intel was crashing on
Advanced Server regularly.  Slackware with 2.4.1 kernel sometimes twice;
sometimes 3 times in a day; sometimes would go for a few days;  The Advanced
Server couldn't stay up long enough to show a login without a BSOD, except
randomly sometimes.  Switched the chips after verifying them, and now the Athlon
can run 3 weeks at a time

vanboers@sedona:~$ w
  4:06am  up 22 days, 13:27,  0 users,  load average: 1.10, 1.24, 1.14
USER TTY  FROM  LOGIN@   IDLE   JCPU   PCPU  WHAT

(developer machine, what can I say?  1+ Load Avg due to SetiAtHome, BTW) and
I've seen the Advanced server run close to a month (between virus patches and
IIS security updates).  On average, the developer Athlon machine still beats the
Advanced Server machine on uptime, but the point is that the memory was killing
both of them.  Don't take the label for granted.  I can't tell you how much time
I wasted determining this.  I can tell you I lost over $5k US in billing, though
because I assumed the label was correct.  I lost the time because I assumed I
was doing something wrong and couldn't bill my client for development during the
month it took me to find out what the problem was; disparate memory on the same
motherboard.   If the labeling had been correct; I would have just swapped the
chips.  Hope that makes sense.

> 
> Updatedb is running around midnight, but I just found out that
> cron.hourly could be a problem in there as we experienced another crash
> tonight which was at 1:59, the crash yesterday occured at 4:59. Always
> around the full hour. I've tried and disabled cron.hourly for now,
> hoping it will help. Seems like it wasn't a problem of mysql, it was
> just mysql which was killed and thus appeared in the kerne ltrace or
> something.

You're probably onto something here.  Great forensics work! I have experience
with the cron.hourly/cron.daily/etc. processes that fire up when you have the
logrotate packages installed.  It's been a while, but while I was using RedHat
at Intel I convinced them these crons and the logrotate packages should either
be audited thoroughly, or pitched because of the second-guessing they do to the
admin of the machine/network.  

Intel opted to replace logrotate with an implementation (msgarch) I've had
running on all of my production machines for several years on some of their
monitoring servers in the division in which I was working.   (Intel applied my
implementation on modified Red Hat and Slackware monitoring servers at that
time.  I have no idea what they've done with their Red Hat implementations and
don't know if they currently deploy Slackware servers at this point in that
division).  I haven't been at Intel for over 4 months, so I have no idea what
they're up to with their server software in that division, at this point.

If logrotate is the cause, I'll send you msgarch and the cron entries for
msgarch.  Sorry I didn't OSS msgarch before, but I hadn't heard of many
complaints on logrotate.   The BSD people use it also and most with a certain
level of satisfaction.  msgarch is my own recipe, but has been implemented by
many of my affiliates for many years.  I just didn't OSS it because most people
have been using LogRotate and I thought it redundant to toss msgarch to the
community.  If that assumption was wrong, let me know.  I'll pitch msgarch into
the community.  

> 
> > Seems your machine might have a wrong hardware component somewhere.  I'd check
> > it out if it's a production machine.
> We sure will, but the system is located about 500 kilometers from where
> our bureau is, so I hope it will stay alive at least over the weekend
> :-)

This is a problematic situation.  Hardware is SO important in remote
deployments.  I hate to say this, but my most important machine is 2000 miles
away from me, but I tested it locally for 2 months on the hardware I put it on
before I deployed it.  That might be the lesson, here.  The hardware didn't fail
after 2 months testing.

perforamnce

[Tadej Guzej]

What is better:

CREATE INDEX ix1(field1, field2, field3);

or

CREATE INDEX ix1(field1), ix2(field2), ix3(field3);

I have a large table of some 30,000,000 records and am wondering
which indexing gives better performance and why.


How do I optimize search on this table - I'm using lots of OR statements in WHERE 
clause.

Thanks in advance,

Tadej

Re: Kernel crash caused by mysql?

[Mario Witte]

On Fri, Aug 03, 2001 at 03:42:28AM -0700, Van wrote:
> Mario Witte wrote:
> Memory or motherboard. How many sticks of RAM do you have in the machine?  Are
> they the same speed (p100/p133, etc.)?  What kind of motherboard? Is updatedb
> running at this time?  (might be a hard-drive croaking while trying to update
> the locate database).
There are 2x256 MB and 2x128MB sticks in there, all at a spped of 133.
Please don't ask me what kind of motherboard we're running in there, but
that shouldn't be a problem.

Updatedb is running around midnight, but I just found out that
cron.hourly could be a problem in there as we experienced another crash
tonight which was at 1:59, the crash yesterday occured at 4:59. Always
around the full hour. I've tried and disabled cron.hourly for now,
hoping it will help. Seems like it wasn't a problem of mysql, it was
just mysql which was killed and thus appeared in the kerne ltrace or
something.

> Seems your machine might have a wrong hardware component somewhere.  I'd check
> it out if it's a production machine.  
We sure will, but the system is located about 500 kilometers from where
our bureau is, so I hope it will stay alive at least over the weekend
:-)


> mysqld can't run as the only service.  You can't run anything without initd.
Ok, you won! ;)

Thanks for your fast help,
With regards,
-- 
Mario Witte <[EMAIL PROTECTED]>

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Query Not Using Indexing

[Sinisa Milivojevic]

Adam Douglas writes:
> Ahh what do you mean "all tables are not related with common columns"? They
> are not suppose to be related with a common columns. PostalCodeInfo and
> Company table are completely two different things.
> 
> Yes that is correct, I've resolved the issue with PostalCodeInfo for
> indexing in the query. I had column types not matching the same through my
> tables. But I'm still lost as to why I can not get CompanyShipInfo to use
> indexing in the query.
> 
> That's find but shouldn't I still be able to go down even further as to how
> many rows are analyzed? CompanyShipInfo has 235 rows and all are being read
> by the query. Here's the new explain of the query below.
> 
> Another thing that happens is when I tried to ALTER PostalCodeInfo and
> PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage
> at 99.0% to 99.02% (never ending it seems). Both those tables only have
> 42657 rows each. Any ideas why these two tables seem to hang when anything
> major is done on them? Funny thing is it seems to be random when you execute
> a query that uses these two tables. Is there something I'm missing for MySQL
> configuration or bad table design? I'll post the table schema's below the
> explain query.

MySQL is truly doing it's best in your case. 

If of 6 tables you have a broken chain of relations, you will have a
Cartesian product. 

Regarding ALTER TABLE, that is also expected behaviour, as MySQL is
re-building indices and has to use lot's of CPU.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Embedded SQL?

[Jeremy Zawodny]

On Fri, Aug 03, 2001 at 03:35:11PM -0700, L. S. wrote:
>
> Is there Embedded SQL support for MySQL?

There is some embedded work goin on in the 4.0 (development) branch of
MySQL.  The manual describes how to get access to the 4.0 tree if
you'd like to check it out.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936 <-- NEW

MySQL 3.23.29: up 48 days, processed 390,305,509 queries (92/sec. avg)

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Delete

[Jeremy Zawodny]

On Sat, Aug 04, 2001 at 12:46:06AM -0700, Eric Fegraus wrote:
>
> I just checked the list for answer to this question and looks like
> there hasn't been one. I have a similar problem, I want to delete a
> record from a table where the value of the field is equal to the
> value of a field in another table.
> 
> delete from table1 where table1.column = table2.column;
> 
> Any thoughts?

You can't do it (yet) in MySQL.  If you're using a programming
language of any sort to get to MySQL, though, it'd be trivial to do it
in 2 separate queries.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936 <-- NEW

MySQL 3.23.29: up 48 days, processed 390,289,076 queries (92/sec. avg)

-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Delete

[Eric Fegraus]

Hello,
I just checked the list for answer to this question and looks like there
hasn't been one. I have a similar problem, I want to delete a record
from a table where the value of the field is equal to the value of a
field in another table. 

delete from table1 where table1.column = table2.column;

Any thoughts?

Thanks,
Eric

-Original Message-
From: Jeremy Morano [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 1:30 PM
To: [EMAIL PROTECTED]
Subject: Delete


Hi, im trying to delete a record from a table where the value of a field
must be equal to the value of a field of another table.I
know
this is wrong but I need to show you what I mean. I think I'm missing a
very
important select statement to join them...can
anyone
help me out?


Delete from table1 where table1.value = table2.value



-
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
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php