Remote access using sqlyog

[Ritesh Nadhani]

We have set up mysql on a linux webserver running apache at our college for
students. We can create users at the site and log in to databases from a
number of user ID's however when I try this from a dial up using sqlyog I
always get the error message "connection lost with mysql during query". have
tried creating users with '%' for address and IP ranges, but still have the
problem. Any suggestions would be very much appreciated

Insane


-
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: Return every Nth row in a result set

[ric]

Dear Spamsucks86,

With Mysql 4.0.x I think you are limited to either performing the
algorithm at the client side as James suggested or using temporary tables
and mysql variables at the server side.

create table test (var int);
insert into test values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

create temporary table nth select *,@a:=@a+1,@a%2 as modulo from test;
select * from nth where modulo=0;

or alternatively,

create temporary table nth select *,@a:=@a+1 as row_count from test;
select * from nth where row_count%2=0;

Of course you would also need some order by's in there to make sure the
ordering of the nth value is to your liking.

Or if you happen to be using mysql 4.1 something like,

select * from (select *,@a:=@a+1 as rc from test) rc where rc%2=0;

will do the job.

Richard.

p.s. Great name.

- Original Message -
From: "SpamSucks86" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 4:37 AM
Subject: Return every Nth row in a result set


> What would be the SQL query to return every Nth row in a result set? So
> it would return the 5th row, the 10th row, the 15th row, etc. Thanks for
> any and all replies!
>
>


-
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: Return every Nth row in a result set

[JamesD]

seems like it would be easier to 
write a perl script

#repeated SQL selects 
$count=0;
$sth = $dbh->prepare(qq(select * from table LIMIT ?,?)); 
while ($sth){
$sth->execute($count,1);
$ref =$sth->fetchrow_arrayref();
print FILEHANDLE "my item is $ref->[0],$ref->[1]...etc\n";
$count+=5;
}

#or use modulo 

$count=0;
$sth = $dbh->prepare(qq(select * from table)); 
$sth->execute();
$ref =$sth->fetchrow_arrayref();

@stuff = @$ref; #dereference the array
$total = @stuff;#get item count

LINE: while ($total) {
next LINE unless ($count == 0||$count % 5 == 0){
print FILEHANDLE "my item is $ref->[0],$ref->[1]...etc\n";
} continue { $count++; $total--;}

Jim
-Original Message-
From: SpamSucks86 [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 21, 2002 8:38 PM
To: [EMAIL PROTECTED]
Subject: Return every Nth row in a result set


What would be the SQL query to return every Nth row in a result set? So
it would return the 5th row, the 10th row, the 15th row, etc. Thanks for
any and all replies!



-
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

4.1 questions: subqueries which use dual

[ric]

Mysql,
Selecting from `dual` with a simple query works fine,

mysql> select 1 x from dual;
+---+
| x |
+---+
| 1 |
+---+

but within a derived table,

mysql> select * from (select 1 x from dual) s;
ERROR 1146: Table 'test.dual' doesn't exist

Is this an oversight or is it purposefully so?

Thank you,
Richard.



-
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

Return every Nth row in a result set

[SpamSucks86]

What would be the SQL query to return every Nth row in a result set? So
it would return the 5th row, the 10th row, the 15th row, etc. Thanks for
any and all replies!

MySQL password confusion.

[William Bradley]

At the present time I am using Mandrake 9.0 and installed the MySql
programmes that con the three disks: 

MySQL-3.23.52-1mdk.i586.rpm*
MySQL-bench-3.23.52-1mdk.i586.rpm* 
MySQL-client-3.23.52-1mdk.i586.rpm*
MySQL-Max-3.23.52-1mdk.i586.rpm

#mysql_install_db has been run. The last time I did this it said to
change the root password in the book I am using: "Sams Teach Yourself
MySQL in 21 Days" with the following:

#mysqladmin -password newpassword

As the old password is supposed to be empty I used the following on the
command line: 

#mysqladmin -password green 

but something was not right and later executions it would not accept this 
password. 

The above was installed as root. So now when I do the following:

# or $ mysqld -p

It asks for a password and I can't get it to work. To ensure the server 
is working if I do the following:

$ps -aux | grep mysql 

It gives me:

william 3083 0.0 0.4 1672 pts/1  S  23:24  0:00 grep mysql

If anyone can help put order into my disorder over all this, it will be truly
appreciated.

Thank you,

Bill.

-- 
William Bradley
http://www.catholicmissionleaflets.org


-
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 install of mysql-4.0.5a-beta

[Bill Patterson]

When configuring mysql-4.0.5a-beta I found that if I were to configure
as follows:

CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro
-felide-constructors -fno-exceptions -fno-rtti" ./configure
--prefix=/usr/local/mysql --enable-assembler
--with-mysqld-ldflags=-all-static --disable-shared
--with-extra-charset=complex

I get the following at the end of the make install phase:

/usr/bin/install: `./README' and `/usr/local/mysql/mysql-test/README'
are the same file
make[2]: *** [install-data-local] Error 1
make[2]: Leaving directory `/usr/local/mysql/mysql-test'
make[1]: *** [install-am] Error 2
make[1]: Leaving directory `/usr/local/mysql/mysql-test'
make: *** [install-recursive] Error 1
[root@localhost mysql]#

BUT, if I change the configuration parameters removing the --prefix
parameter as such it compiles and installs without noting those errors:

CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro
-felide-constructors -fno-exceptions -fno-rtti" ./configure
--enable-assembler --with-mysqld-ldflags=-all-static --disable-shared
--with-extra-charset=complex

This happens in RedHat linux 7.2 and 7.3.


Bill Patterson


-
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: How long is my piece of string?

[John Hinton]

wcb wrote:

> seems to lack detail in answering the question, which might be phrased "when
> might indices start making a performance difference?".


Well, I'm no wizard or anything, but have just spent the last twos days
on this subject here on my project. Anyway, waht I have learned is they
make a performance difference immediately, but that can be increases or
decreases in performance.

The basic rules I have laid out for myself include, only build an index
if you 'are' going to be sure you write the SQL to make use of it. This
is an area where I'm struggling, but have made a break thru or two. Only
index fields with lots of the same data. If every piece of data is
different, the index gets to be about as convoluted as the field itself.
Indexes slow down writes and updates to the database and take up disk
space, so indexing every field in your database is generally not a good
idea. I think I read something about mysql getting a bit confused about
how best to use the indices if you have lots of them... so, again,
carefully create the ones that 'will' for sure be used, and are in a
field of like data.

In my earlier post regarding the success on my date index stuff, I think
the only way the index would be used is if in the WHERE statement, the
indexed field was the first to display? and also, maybe it could not be
used inside of a function?


So, here I am a newbie to indices talking about something I know little
about... Hopefully someone will read this post and correct anything that
is in error... So, I'll learn if I've made any errors in my thinking?

-- 
John Hinton - Goshen, VA.
http://www.ew3d.com

Those who dance are considered insane 
by those who can't hear the music

-
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: How long is my piece of string?

[Mike Wexler]

Sure. Indices increase the time it takes to add or update a record.
They also take up disk space.
Also when scanning a database, its quicker ot just read the data records 
directly than to use an index if most of the data records need to be 
read anyway. For example, if you had a table with 10,000 records and 
9,999 records had fielda="a". Then
   SELECT * FROM myTable WHERE fieldA="A"
would be quicker without using an index on fieldA than it would be with 
an index of fieldA.


Mark wrote:

- Original Message -
From: "wcb" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 2:23 AM
Subject: Re: How long is my piece of string?


 

Hi!

I was interested in the answer to this person's question, too!

The following response:

   

You need indexes as soon as (or rather just before) they provide
a performance difference.

Alan
 

seems to lack detail in answering the question, which might be phrased
"when might indices start making a performance difference?".
   



I would rather reverse the question: is there ever a good reason NOT to use
an index?

- Mark

mysql,query


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[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: How long is my piece of string?

[Mark]

- Original Message -
From: "wcb" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 2:23 AM
Subject: Re: How long is my piece of string?


> Hi!
>
> I was interested in the answer to this person's question, too!
>
> The following response:
>
> > You need indexes as soon as (or rather just before) they provide
> > a performance difference.
> >
> > Alan
>
> seems to lack detail in answering the question, which might be phrased
> "when might indices start making a performance difference?".


I would rather reverse the question: is there ever a good reason NOT to use
an index?

- Mark

mysql,query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: request

[Mark]

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 2:12 AM
Subject: Re: request

If it is not, his computer should probably not have been on to begin with.
:)

- Mark


> if it's not you have probably just shamed him into never turning his
> computer on again.
>
> Quoting Chris Knipe <[EMAIL PROTECTED]>:
>
> > LOOL! This *IS* a joke right? ;)
> >
> > - Original Message -
> > From: "lateef ayinla" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, December 22, 2002 2:13 AM
> > Subject: request
> >
> >
> > > Dear sir, i come across your manual [mySQL Reference] when browsing
> > > through the internet, i read it but i didn't understand it. i like to
> > > develop software of my own through writing software programs but don't
> > > know how to do it, i would like you to teach me how to write software
> > > programme. i want to use it to find people's data and information on
> > > the internet. this is because i've lost contact with most of my
> > > friends in usa. i want to use the software programme i'm asking you to
> > > teach me to find their whereabout. i'm a beginner in internet browsing
> > > i want you to teach me exclusively how to software use progmmam to
> > > find people information. i will expecting your repy soon. thanks for
> > > anticipaion co-operation
> > >
> > > yours biola rufai


-
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: How long is my piece of string?

[wcb]

Hi!

I was interested in the answer to this person's question, too!

The following response:

> You need indexes as soon as (or rather just before) they provide a
> performance difference.
>
> Alan

seems to lack detail in answering the question, which might be phrased "when
might indices start making a performance difference?".

Can anyone give rules of thumb?

Cheers!

-warren



- Original Message -
From: "Alan McDonald" <[EMAIL PROTECTED]>
To: "Iain Lang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 21, 2002 4:22 PM
Subject: RE: How long is my piece of string?


> You need indexes as soon as (or rather just before) they provide a
> performance difference.
>
> Alan
>
> -Original Message-
> From: Iain Lang [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, 22 December 2002 11:15 AM
> To: [EMAIL PROTECTED]
> Subject: How long is my piece of string?
>
>
> .
> Dear List,
>
> I'm using php & MySQL for a cycling club website, results, guest-book,
> events and so on.  I've just started and have faithfully created indices
> all over the place.
>
> At present, we have less than 400 records, be they of members, of image
> URLs, whatever.  Each year will, I expect, create an additional 400
records.
>
> Am I gilding the lily adding indices for such a small database?  Does such
> a small database really *need* indices, and beyond what number of records
> might indices provide faster extraction/presentation?
>
> I realise how vague a question it is, hence the subject title.
>
> Yooors,
>
> Iain.
>
>
> --
--
> -
> "Most progress has been the result of the
>   actions of unreasonable men."   G.B.Shaw.
> http://www.johnstone-wheelers.co.uk
>   Johnstone-Wheelers - the friendliest
>cycling club in Scotland!
>
>
>
> -
> 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
>


-
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: request

[jacob]

if it's not you have probably just shamed him into never turning his computer 
on again.

Quoting Chris Knipe <[EMAIL PROTECTED]>:

> LOOL! This *IS* a joke right? ;)
> 
> - Original Message -
> From: "lateef ayinla" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, December 22, 2002 2:13 AM
> Subject: request
> 
> 
> > Dear  sir,
> > i  come  across   yourmanual  [mySQL  Reference]  when  browsing
> through  the  internet,  i  read it
> > but  i  didn't   understand  it.  i   like to develop  software  of  my
> own   through  writing   software
> > programs   but  don't   know  how  to do it,  i would  like you  to  teach
> me   how  to  write  software
> > programme.  i want  to   use  it  to  find  people's   data  and
> information  on the  internet.
> > this isbecause  i've  lost  contact  with  most  of  my  friends  in
> usa.  i want to use the  software
> > programme   i'm  asking   you   to  teach me to find  their  whereabout.
> i'm   a   beginner  in   internet
> > browsingi want  you  to teach  me  exclusively  how  to  software use
> progmmam
> > to   find  people  information.  iwill   expecting  your  repy  soon.
> thanks  for   anticipaion
> > co-operation
> >
> > yours
> > biola  rufai
> >
> >
> > --
> > __
> > Sign-up for your own FREE Personalized E-mail at Mail.com
> > http://www.mail.com/?sr=signup
> >
> > Meet Singles
> > http://corp.mail.com/lavalife
> >
> >
> > -
> > 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
> 
> 



-
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

A Newbie Question on Passwords

[William Bradley]

At the present time I am using Mandrake 9.0 and installed the MySql
programmes that con the three disks: 

MySQL-3.23.52-1mdk.i586.rpm*
MySQL-bench-3.23.52-1mdk.i586.rpm* 
MySQL-client-3.23.52-1mdk.i586.rpm*
MySQL-Max-3.23.52-1mdk.i586.rpm

#mysql_install_db has been run. The last time I did this it said to
change the root password in the book I am using: "Sams Teach Yourself
MySQL in 21 Days" with the following: #mysqladmin -password newpassword.
As the old password is supposed to be empty I used the following on the
command line: #mysqladmin -password green but something was not right
and later executions it would not accept this password. Any help would
be appreciated.

Thank you,
-- 
William Bradley
http://www.catholicmissionleaflets.org


-
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

A perl program to replace mysql_setpermissions

[Barry Pollock]

 I have written menu-1.13.tar.gz
and
menu-1.13.tar.bz2 for download at:
http://www.hurontel.on.ca/~barryp

 This program will help the user with SQL and the handling of mysql
reserve words. You can rename fields or columns or tables from a menu. The
program  `menu.pl' keeps track of all the commands you send to mysql so you can
 edit them and send them directly to mysql in a file.
You can also backup tables and databases using mysqldump.
You can save them in `.gz'  or `.bz2' files if you wish.
You can also create your own sql commands and try them out.

 You may email me at:
[EMAIL PROTECTED] if you have any questions or problems or
suggestions, plese contact me!
Barry Pollock


-
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: need index date help

[John Hinton]

FYI...

Yes, I created a new field called 'd_now' with data inserted as
(TO_DAYS(NOW()), updated it to include the proper date format for all
the old records and of course then had to paste in the old timestamp
values that automatically updated when I did that update... lots of fun
on 2800 records. Anyway, I then created an index on the 'd_now' field
and changed from:

SELECT TO_DAYS(adate), mask FROM $table WHERE mask NOT LIKE '$user_net'
AND page LIKE '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6

where 'adate' is the mysql timestamp to:

SELECT d_now, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page
= '$page[$i]' AND d_now >= TO_DAYS(NOW()) - 6

I reduced the number of times the statement was run by 20% and I wound
up with a reduction in time of 70% total!!! Excellent Very
excellent! This indexing stuff is really sweet. The whole trouble I
had with indexing the timestamp, was the inability to create a clean use
of the indexed field, as it was inside of a TO_DAYS() function. Or at
least that is my understanding of it.

Anyway, this might be just totally boring stuff to many, but I'm feeling
pretty good right now. I was about to the point of creating this
additional field, and the responses from this list really confirmed that
I needed this.

Joseph Bueno wrote:
> 
> Instead of:
> TO_DAYS(adate) >= TO_DAYS(NOW()) - 6
> you can try:
> adate >= unix_timestamp(now()) - 6 * 24 * 3600
> This way, you don't need to apply a function to 'adate'.
> 
> You should also note that these expressions are not exactly
> equivalent since yours compares day numbers but mine compares
> seconds.
> If you really need to work on day numbers, it would
> be more efficient to use a separate column where you explicitely
> insert TO_DAYS(NOW()). This way you can index it and efficiently
> use it on SELECTs.
> 
> Hope this helps
> Joseph Bueno
> 

-- 
John Hinton - Goshen, VA.
http://www.ew3d.com

Those who dance are considered insane 
by those who can't hear the music

-
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

Temporary Table Size / Big Queries

[John P]

SHOW STATUS (after 24 hrs uptime):
created_tmp_disk_tables = 597
created_tmp_tables = 8893.
SHOW VARIABLES:
tmp_table_size = 33554432.

Does this mean that 597 queries have created a result set in excess of 33MB?

How can I find these rogue queries and optimise them? I could increase the
tmp_table_size (over 1GB RAM) but I am concerned that tables this big are
being created! Can this be logged somehow?

Thanks,
John


-
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: request

[Chris Knipe]

LOOL! This *IS* a joke right? ;)

- Original Message -
From: "lateef ayinla" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, December 22, 2002 2:13 AM
Subject: request


> Dear  sir,
> i  come  across   yourmanual  [mySQL  Reference]  when  browsing
through  the  internet,  i  read it
> but  i  didn't   understand  it.  i   like to develop  software  of  my
own   through  writing   software
> programs   but  don't   know  how  to do it,  i would  like you  to  teach
me   how  to  write  software
> programme.  i want  to   use  it  to  find  people's   data  and
information  on the  internet.
> this isbecause  i've  lost  contact  with  most  of  my  friends  in
usa.  i want to use the  software
> programme   i'm  asking   you   to  teach me to find  their  whereabout.
i'm   a   beginner  in   internet
> browsingi want  you  to teach  me  exclusively  how  to  software use
progmmam
> to   find  people  information.  iwill   expecting  your  repy  soon.
thanks  for   anticipaion
> co-operation
>
> yours
> biola  rufai
>
>
> --
> __
> Sign-up for your own FREE Personalized E-mail at Mail.com
> http://www.mail.com/?sr=signup
>
> Meet Singles
> http://corp.mail.com/lavalife
>
>
> -
> 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: How long is my piece of string?

[Alan McDonald]

You need indexes as soon as (or rather just before) they provide a
performance difference.

Alan

-Original Message-
From: Iain Lang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, 22 December 2002 11:15 AM
To: [EMAIL PROTECTED]
Subject: How long is my piece of string?


.
Dear List,

I'm using php & MySQL for a cycling club website, results, guest-book,
events and so on.  I've just started and have faithfully created indices
all over the place.

At present, we have less than 400 records, be they of members, of image
URLs, whatever.  Each year will, I expect, create an additional 400 records.

Am I gilding the lily adding indices for such a small database?  Does such
a small database really *need* indices, and beyond what number of records
might indices provide faster extraction/presentation?

I realise how vague a question it is, hence the subject title.

Yooors,

Iain.



-
"Most progress has been the result of the
  actions of unreasonable men."   G.B.Shaw.
http://www.johnstone-wheelers.co.uk
  Johnstone-Wheelers - the friendliest
   cycling club in Scotland!



-
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

request

[lateef ayinla]

Dear  sir,
i  come  across   yourmanual  [mySQL  Reference]  when  browsing   through  the  
internet,  i  read it  
but  i  didn't   understand  it.  i   like to develop  software  of  my  own   through 
 writing   software
programs   but  don't   know  how  to do it,  i would  like you  to  teach  me   how  
to  write  software
programme.  i want  to   use  it  to  find  people's   data  and   information  on the 
 internet.
this isbecause  i've  lost  contact  with  most  of  my  friends  in  usa.  i want 
to use the  software 
programme   i'm  asking   you   to  teach me to find  their  whereabout. i'm   a   
beginner  in   internet
browsingi want  you  to teach  me  exclusively  how  to  software use  progmmam
to   find  people  information.  iwill   expecting  your  repy  soon. thanks  for  
 anticipaion
co-operation

yours 
biola  rufai


-- 
__
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Meet Singles
http://corp.mail.com/lavalife


-
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

How long is my piece of string?

[Iain Lang]

.
Dear List,

I'm using php & MySQL for a cycling club website, results, guest-book, 
events and so on.  I've just started and have faithfully created indices 
all over the place.

At present, we have less than 400 records, be they of members, of image 
URLs, whatever.  Each year will, I expect, create an additional 400 records.

Am I gilding the lily adding indices for such a small database?  Does such 
a small database really *need* indices, and beyond what number of records 
might indices provide faster extraction/presentation?

I realise how vague a question it is, hence the subject title.

Yooors,

Iain.


-
"Most progress has been the result of the
 actions of unreasonable men."   G.B.Shaw.
http://www.johnstone-wheelers.co.uk
 Johnstone-Wheelers - the friendliest
  cycling club in Scotland!



-
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: MySQL Command to edit a single record

[Jeffrey Ellis]

Thanks, Adolfo! I appreciate very much you taking the time to help me:)

All My Best,
Jeffrey


on 12/21/02 3:10 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:

> Look in the manual the ALTER TABLE command. I don't remember the syntax
> but it can be done.
> 
> Adolfo
> 
> On Sat, 2002-12-21 at 18:56, Jeffrey Ellis wrote:
>> Hi, Adolfo--
>> 
>> Thank you again!
>> 
>> However, the problem is, the table is linked to a file on the web. If I
>> create a new table with a different name the link wont work and no data will
>> be entered.
>> 
>> Is there a way to rename a table once you create it? Then, I could delete
>> the old table after I create the new one, and then rename the new one to the
>> old name so it will work with the website.
>> 
>> All My Best,
>> Jeffrey
>> 
>> 
>> on 12/21/02 2:02 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
>> 
>>> CONCAT(FullName,' ',Address)
>>> 
>>> regarding the lack of an ID field, create a new table with all the
>>> fields from the original table plus an ID field, auto_numeric, and
>>> insert the registers from the old table to the new one. Then, use the
>>> UPDATE on the new table.
>>> 
>>> Adolfo
>>> 
>>> On Sat, 2002-12-21 at 17:35, Jeffrey Ellis wrote:
 Hi, Adolfo--
 
 Thank you!
 
 But I have two problems here...First, I (whoops!) don't have an id field.
 In
 the program I use, you can only set a key field when you first create the
 database. I would love to have an id field, but don't know how to create
 one
 now. :(
 
 The second is that the command will -- I think -- place the last name right
 up against the first name with no space before. Is there a way to do that
 so
 it looks like "Foo Bar"?
 
 All My Best,
 Jeffrey
 
 
 on 12/21/02 1:23 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
 
> The following query adds NAME and ADDRESS (where the last name is
> wrongly placed) and set ADDRESS to an empty string.
> 
> UPDATE tablename SET FullName=CONCAT(FullName,Address),Address=''
> WHERE ID=
> 
> Adolfo
> 
> On Sat, 2002-12-21 at 17:07, Jim Hankins wrote:
>> Jeff,
>> 
>> Are you looking for an update table syntax?
>> 
>> Example
>> Update tablename
>> Set FullName="Their Full Name" where someotherfield="someother value";
>> 
>> Careful with this one.  As if you omit the where clause it will update
>> every record!
>> 
>> 
>> 
>> -Original Message-
>> From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, December 21, 2002 3:52 PM
>> To: [EMAIL PROTECTED]
>> Subject: MySQL Command to edit a single record
>> 
>> Hi--
>> 
>> I have just begun using MySQL...I am using a program called MySQL to
>> manage
>> an online database. I can see the entire table I need and all the
>> records in
>> that table for the db I©öm working with. I have a field called fullname
>> which
>> is supposed to receive the full name of the person entering the
>> information.
>> But sometimes, folks are entering their first name only in this field
>> and
>> then entering their last name in the address field by mistake. I would
>> like
>> to be able to send a command to the database to be able manually edit
>> those
>> records to add the last name back into the fullname field.
>> 
>> Is there a way to do this?
>> 
>> All My Best,
>> Jeffrey Ellis
>> 
>> 
>> 
>> 
>> 
>> -
>> 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: MySQL Command to edit a single record

[Adolfo Bello]

Look in the manual the ALTER TABLE command. I don't remember the syntax
but it can be done.

Adolfo

On Sat, 2002-12-21 at 18:56, Jeffrey Ellis wrote:
> Hi, Adolfo--
> 
> Thank you again!
> 
> However, the problem is, the table is linked to a file on the web. If I
> create a new table with a different name the link wont work and no data will
> be entered.
> 
> Is there a way to rename a table once you create it? Then, I could delete
> the old table after I create the new one, and then rename the new one to the
> old name so it will work with the website.
> 
> All My Best,
> Jeffrey
> 
> 
> on 12/21/02 2:02 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
> 
> > CONCAT(FullName,' ',Address)
> > 
> > regarding the lack of an ID field, create a new table with all the
> > fields from the original table plus an ID field, auto_numeric, and
> > insert the registers from the old table to the new one. Then, use the
> > UPDATE on the new table.
> > 
> > Adolfo
> > 
> > On Sat, 2002-12-21 at 17:35, Jeffrey Ellis wrote:
> >> Hi, Adolfo--
> >> 
> >> Thank you!
> >> 
> >> But I have two problems here...First, I (whoops!) don't have an id field. In
> >> the program I use, you can only set a key field when you first create the
> >> database. I would love to have an id field, but don't know how to create one
> >> now. :(
> >> 
> >> The second is that the command will -- I think -- place the last name right
> >> up against the first name with no space before. Is there a way to do that so
> >> it looks like "Foo Bar"?
> >> 
> >> All My Best,
> >> Jeffrey
> >> 
> >> 
> >> on 12/21/02 1:23 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
> >> 
> >>> The following query adds NAME and ADDRESS (where the last name is
> >>> wrongly placed) and set ADDRESS to an empty string.
> >>> 
> >>> UPDATE tablename SET FullName=CONCAT(FullName,Address),Address=''
> >>> WHERE ID=
> >>> 
> >>> Adolfo
> >>> 
> >>> On Sat, 2002-12-21 at 17:07, Jim Hankins wrote:
>  Jeff,
>  
>  Are you looking for an update table syntax?
>  
>  Example
>  Update tablename
>  Set FullName="Their Full Name" where someotherfield="someother value";
>  
>  Careful with this one.  As if you omit the where clause it will update
>  every record!
>  
>  
>  
>  -Original Message-
>  From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]]
>  Sent: Saturday, December 21, 2002 3:52 PM
>  To: [EMAIL PROTECTED]
>  Subject: MySQL Command to edit a single record
>  
>  Hi--
>  
>  I have just begun using MySQL...I am using a program called MySQL to
>  manage
>  an online database. I can see the entire table I need and all the
>  records in
>  that table for the db I¹m working with. I have a field called fullname
>  which
>  is supposed to receive the full name of the person entering the
>  information.
>  But sometimes, folks are entering their first name only in this field
>  and
>  then entering their last name in the address field by mistake. I would
>  like
>  to be able to send a command to the database to be able manually edit
>  those
>  records to add the last name back into the fullname field.
>  
>  Is there a way to do this?
>  
>  All My Best,
>  Jeffrey Ellis
>  
>  
>  
>  
>  
>  -
>  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
>  
> >> 
> 
-- 
Adolfo Bello <[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: MySQL Command to edit a single record

[Jeffrey Ellis]

Hi, Adolfo--

Thank you again!

However, the problem is, the table is linked to a file on the web. If I
create a new table with a different name the link wont work and no data will
be entered.

Is there a way to rename a table once you create it? Then, I could delete
the old table after I create the new one, and then rename the new one to the
old name so it will work with the website.

All My Best,
Jeffrey


on 12/21/02 2:02 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:

> CONCAT(FullName,' ',Address)
> 
> regarding the lack of an ID field, create a new table with all the
> fields from the original table plus an ID field, auto_numeric, and
> insert the registers from the old table to the new one. Then, use the
> UPDATE on the new table.
> 
> Adolfo
> 
> On Sat, 2002-12-21 at 17:35, Jeffrey Ellis wrote:
>> Hi, Adolfo--
>> 
>> Thank you!
>> 
>> But I have two problems here...First, I (whoops!) don't have an id field. In
>> the program I use, you can only set a key field when you first create the
>> database. I would love to have an id field, but don't know how to create one
>> now. :(
>> 
>> The second is that the command will -- I think -- place the last name right
>> up against the first name with no space before. Is there a way to do that so
>> it looks like "Foo Bar"?
>> 
>> All My Best,
>> Jeffrey
>> 
>> 
>> on 12/21/02 1:23 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
>> 
>>> The following query adds NAME and ADDRESS (where the last name is
>>> wrongly placed) and set ADDRESS to an empty string.
>>> 
>>> UPDATE tablename SET FullName=CONCAT(FullName,Address),Address=''
>>> WHERE ID=
>>> 
>>> Adolfo
>>> 
>>> On Sat, 2002-12-21 at 17:07, Jim Hankins wrote:
 Jeff,
 
 Are you looking for an update table syntax?
 
 Example
 Update tablename
 Set FullName="Their Full Name" where someotherfield="someother value";
 
 Careful with this one.  As if you omit the where clause it will update
 every record!
 
 
 
 -Original Message-
 From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, December 21, 2002 3:52 PM
 To: [EMAIL PROTECTED]
 Subject: MySQL Command to edit a single record
 
 Hi--
 
 I have just begun using MySQL...I am using a program called MySQL to
 manage
 an online database. I can see the entire table I need and all the
 records in
 that table for the db I©öm working with. I have a field called fullname
 which
 is supposed to receive the full name of the person entering the
 information.
 But sometimes, folks are entering their first name only in this field
 and
 then entering their last name in the address field by mistake. I would
 like
 to be able to send a command to the database to be able manually edit
 those
 records to add the last name back into the fullname field.
 
 Is there a way to do this?
 
 All My Best,
 Jeffrey Ellis
 
 
 
 
 
 -
 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: need index date help

[Adolfo Bello]

Just a wild guess. If you are only using TO_DAYS(somedate) for the
queries, why don't you create the column 'adate' as INT and index it?
When you need the real DATE, use the FROM_DAYS() function.

Just a wild guess that I think could improve your queries speed.

Adolfo

On Sat, 2002-12-21 at 17:50, John Hinton wrote:
> I keep getting weird return messages from the list.. not sure if this
> made it through..
> 
> 
> I am running into a system wall here. I have at the moment about 2600
> rows of data totaling 650K. I expect this to grow at a rate of about an
> additional 1200-1500 rows per week. I am using PHP to format the returns
> into webspace.
> 
> I have a field named 'adate' which is a mysql 14 character timestamp
> (yes, I need HHMMSS data for other stuff). I am creating an array based
> on a distinct return from the database. I then am in turn looping
> through that array of about 25 entries, (which will remain at about 25
> with time) and running each through 10 queries all based on date.
> The queries are really only two, with the exception of choosing separate
> intervals of time to return, one having distinct fields parsed, the
> other all rows parsed. The following are the two snippets of code which
> get repeated five more times with only the time interval changed.
> 
> $table, $user_net are PHP variables and $page[$i] is the array of 25
> entries.
> 
> SELECT TO_DAYS(adate), mask FROM $table WHERE mask NOT LIKE '$user_net'
> AND page LIKE '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6
> SELECT adate, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page
> = '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6
> 
> All I need is the count from each query.
> 
> So, these ten queries are being run 25 times on 2600 rows of data and it
> is taking about 4-6 seconds. I plan to collect data up to a limit of
> about 70,000 rows. If I can expect the query time to grow linearly, it
> would take about 2 minutes to generate this data. I need to get that
> down to maybe 15 seconds  or as little as possible.
> 
> I have indexed 'adate', but don't think the index really works within
> the functions? Maybe I'm stuck thinking inside of a box here? Perhaps
> there is one blindingly great solution which I have not considered. This
> is the first time I have ever created anything that really taxed a
> system... therefore I am new at thinking in many of these terms. Perhaps
> I should be rolling the data off into a temp file or something and
> running the results using PHP? I really don't know what direction to
> take, but I do see what appears to be a lot of repeating work, with only
> little changes in time chunks. 
> 
> Should I perhaps create a 'date' field, grabbing only MMDD and
> working from there? What am I not thinking about here?
> 
> Any suggestions are very much welcome.
-- 
Adolfo Bello <[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: MySQL Command to edit a single record

[Adolfo Bello]

CONCAT(FullName,' ',Address)

regarding the lack of an ID field, create a new table with all the
fields from the original table plus an ID field, auto_numeric, and
insert the registers from the old table to the new one. Then, use the
UPDATE on the new table.

Adolfo

On Sat, 2002-12-21 at 17:35, Jeffrey Ellis wrote:
> Hi, Adolfo--
> 
> Thank you!
> 
> But I have two problems here...First, I (whoops!) don't have an id field. In
> the program I use, you can only set a key field when you first create the
> database. I would love to have an id field, but don't know how to create one
> now. :(
> 
> The second is that the command will -- I think -- place the last name right
> up against the first name with no space before. Is there a way to do that so
> it looks like "Foo Bar"?
> 
> All My Best,
> Jeffrey
> 
> 
> on 12/21/02 1:23 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:
> 
> > The following query adds NAME and ADDRESS (where the last name is
> > wrongly placed) and set ADDRESS to an empty string.
> > 
> > UPDATE tablename SET FullName=CONCAT(FullName,Address),Address=''
> > WHERE ID=
> > 
> > Adolfo
> > 
> > On Sat, 2002-12-21 at 17:07, Jim Hankins wrote:
> >> Jeff,
> >> 
> >> Are you looking for an update table syntax?
> >> 
> >> Example
> >> Update tablename
> >> Set FullName="Their Full Name" where someotherfield="someother value";
> >> 
> >> Careful with this one.  As if you omit the where clause it will update
> >> every record!
> >> 
> >> 
> >> 
> >> -Original Message-
> >> From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]]
> >> Sent: Saturday, December 21, 2002 3:52 PM
> >> To: [EMAIL PROTECTED]
> >> Subject: MySQL Command to edit a single record
> >> 
> >> Hi--
> >> 
> >> I have just begun using MySQL...I am using a program called MySQL to
> >> manage
> >> an online database. I can see the entire table I need and all the
> >> records in
> >> that table for the db I¹m working with. I have a field called fullname
> >> which
> >> is supposed to receive the full name of the person entering the
> >> information.
> >> But sometimes, folks are entering their first name only in this field
> >> and
> >> then entering their last name in the address field by mistake. I would
> >> like
> >> to be able to send a command to the database to be able manually edit
> >> those
> >> records to add the last name back into the fullname field.
> >> 
> >> Is there a way to do this?
> >> 
> >> All My Best,
> >> Jeffrey Ellis
> >> 
> >> 
> >> 
> >> 
> >> 
> >> -
> >> 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
> >> 
> 
-- 
Adolfo Bello <[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

need index date help

[John Hinton]

I keep getting weird return messages from the list.. not sure if this
made it through..


I am running into a system wall here. I have at the moment about 2600
rows of data totaling 650K. I expect this to grow at a rate of about an
additional 1200-1500 rows per week. I am using PHP to format the returns
into webspace.

I have a field named 'adate' which is a mysql 14 character timestamp
(yes, I need HHMMSS data for other stuff). I am creating an array based
on a distinct return from the database. I then am in turn looping
through that array of about 25 entries, (which will remain at about 25
with time) and running each through 10 queries all based on date.
The queries are really only two, with the exception of choosing separate
intervals of time to return, one having distinct fields parsed, the
other all rows parsed. The following are the two snippets of code which
get repeated five more times with only the time interval changed.

$table, $user_net are PHP variables and $page[$i] is the array of 25
entries.

SELECT TO_DAYS(adate), mask FROM $table WHERE mask NOT LIKE '$user_net'
AND page LIKE '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6
SELECT adate, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page
= '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6

All I need is the count from each query.

So, these ten queries are being run 25 times on 2600 rows of data and it
is taking about 4-6 seconds. I plan to collect data up to a limit of
about 70,000 rows. If I can expect the query time to grow linearly, it
would take about 2 minutes to generate this data. I need to get that
down to maybe 15 seconds  or as little as possible.

I have indexed 'adate', but don't think the index really works within
the functions? Maybe I'm stuck thinking inside of a box here? Perhaps
there is one blindingly great solution which I have not considered. This
is the first time I have ever created anything that really taxed a
system... therefore I am new at thinking in many of these terms. Perhaps
I should be rolling the data off into a temp file or something and
running the results using PHP? I really don't know what direction to
take, but I do see what appears to be a lot of repeating work, with only
little changes in time chunks. 

Should I perhaps create a 'date' field, grabbing only MMDD and
working from there? What am I not thinking about here?

Any suggestions are very much welcome.


-- 
John Hinton - Goshen, VA.
http://www.ew3d.com

Those who dance are considered insane 
by those who can't hear the music

-
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: need index date help

[Joseph Bueno]

Instead of:
TO_DAYS(adate) >= TO_DAYS(NOW()) - 6
you can try:
adate >= unix_timestamp(now()) - 6 * 24 * 3600
This way, you don't need to apply a function to 'adate'.

You should also note that these expressions are not exactly
equivalent since yours compares day numbers but mine compares
seconds.
If you really need to work on day numbers, it would
be more efficient to use a separate column where you explicitely
insert TO_DAYS(NOW()). This way you can index it and efficiently
use it on SELECTs.

Hope this helps
Joseph Bueno

John Hinton wrote:
> OK.. no takers the first time... I'll try to give more/better
> information..
> 
> I am running into a system wall here. I have at the moment about 2600
> rows of data totaling 650K. I expect this to grow at a rate of about an
> additional 1200-1500 rows per week. I am using PHP to format the returns
> into webspace.
> 
> I have a field named 'adate' which is a mysql 14 character timestamp
> (yes, I need HHMMSS data for other stuff). I am creating an array based
> on a distinct return from the database. I then am in turn looping
> through that array of about 25 entries, (which will remain at about 25
> with time) and running each through 10 queries all based on date.
> The queries are really only two, with the exception of choosing separate
> intervals of time to return, one having distinct fields parsed, the
> other all rows parsed. The following are the two snippets of code which
> get repeated five more times with only the time interval changed.
> 
> $table, $user_net are PHP variables and $page[$i] is the array of 25
> entries.
> 
> SELECT TO_DAYS(adate), mask FROM $table WHERE mask NOT LIKE '$user_net'
> AND page LIKE '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6
> SELECT adate, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page
> = '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6
> 
> All I need is the count from each query.
> 
> So, these ten queries are being run 25 times on 2600 rows of data and it
> is taking about 4-6 seconds. I plan to collect data up to a limit of
> about 70,000 rows. If I can expect the query time to grow linearly, it
> would take about 2 minutes to generate this data. I need to get that
> down to maybe 15 seconds  or as little as possible.
> 
> I have indexed 'adate', but don't think the index really works within
> the functions? Maybe I'm stuck thinking inside of a box here? Perhaps
> there is one blindingly great solution which I have not considered. This
> is the first time I have ever created anything that really taxed a
> system... therefore I am new at thinking in many of these terms. Perhaps
> I should be rolling the data off into a temp file or something and
> running the results using PHP? I really don't know what direction to
> take, but I do see what appears to be a lot of repeating work, with only
> little changes in time chunks. 
> 
> Should I perhaps create a 'date' field, grabbing only MMDD and
> working from there? What am I not thinking about here?
> 
> Any suggestions are very much welcome.
> 
> John Hinton - Goshen, VA.
> http://www.ew3d.com
> 
> Those who dance are considered insane 
> by those who can't hear the music
> 


-
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: MySQL Command to edit a single record

[Jeffrey Ellis]

Hi, Adolfo--

Thank you!

But I have two problems here...First, I (whoops!) don't have an id field. In
the program I use, you can only set a key field when you first create the
database. I would love to have an id field, but don't know how to create one
now. :(

The second is that the command will -- I think -- place the last name right
up against the first name with no space before. Is there a way to do that so
it looks like "Foo Bar"?

All My Best,
Jeffrey


on 12/21/02 1:23 PM, Adolfo Bello at [EMAIL PROTECTED] wrote:

> The following query adds NAME and ADDRESS (where the last name is
> wrongly placed) and set ADDRESS to an empty string.
> 
> UPDATE tablename SET FullName=CONCAT(FullName,Address),Address=''
> WHERE ID=
> 
> Adolfo
> 
> On Sat, 2002-12-21 at 17:07, Jim Hankins wrote:
>> Jeff,
>> 
>> Are you looking for an update table syntax?
>> 
>> Example
>> Update tablename
>> Set FullName="Their Full Name" where someotherfield="someother value";
>> 
>> Careful with this one.  As if you omit the where clause it will update
>> every record!
>> 
>> 
>> 
>> -Original Message-
>> From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, December 21, 2002 3:52 PM
>> To: [EMAIL PROTECTED]
>> Subject: MySQL Command to edit a single record
>> 
>> Hi--
>> 
>> I have just begun using MySQL...I am using a program called MySQL to
>> manage
>> an online database. I can see the entire table I need and all the
>> records in
>> that table for the db I©öm working with. I have a field called fullname
>> which
>> is supposed to receive the full name of the person entering the
>> information.
>> But sometimes, folks are entering their first name only in this field
>> and
>> then entering their last name in the address field by mistake. I would
>> like
>> to be able to send a command to the database to be able manually edit
>> those
>> records to add the last name back into the fullname field.
>> 
>> Is there a way to do this?
>> 
>> All My Best,
>> Jeffrey Ellis
>> 
>> 
>> 
>> 
>> 
>> -
>> 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: MySQL Command to edit a single record

[Adolfo Bello]

The following query adds NAME and ADDRESS (where the last name is
wrongly placed) and set ADDRESS to an empty string.

UPDATE tablename SET FullName=CONCAT(FullName,Address),Address=''
WHERE ID=

Adolfo

On Sat, 2002-12-21 at 17:07, Jim Hankins wrote:
> Jeff,
> 
> Are you looking for an update table syntax?
> 
> Example
> Update tablename
> Set FullName="Their Full Name" where someotherfield="someother value";
> 
> Careful with this one.  As if you omit the where clause it will update
> every record!
> 
> 
> 
> -Original Message-
> From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, December 21, 2002 3:52 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL Command to edit a single record
> 
> Hi--
> 
> I have just begun using MySQL...I am using a program called MySQL to
> manage
> an online database. I can see the entire table I need and all the
> records in
> that table for the db I¹m working with. I have a field called fullname
> which
> is supposed to receive the full name of the person entering the
> information.
> But sometimes, folks are entering their first name only in this field
> and
> then entering their last name in the address field by mistake. I would
> like
> to be able to send a command to the database to be able manually edit
> those
> records to add the last name back into the fullname field.
> 
> Is there a way to do this?
> 
> All My Best,
> Jeffrey Ellis
> 
> 
> 
> 
> 
> -
> 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
> 
-- 
Adolfo Bello <[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: MySQL Command to edit a single record

[Jim Hankins]

Jeff,

Are you looking for an update table syntax?

Example
Update tablename
Set FullName="Their Full Name" where someotherfield="someother value";

Careful with this one.  As if you omit the where clause it will update
every record!



-Original Message-
From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]] 
Sent: Saturday, December 21, 2002 3:52 PM
To: [EMAIL PROTECTED]
Subject: MySQL Command to edit a single record

Hi--

I have just begun using MySQL...I am using a program called MySQL to
manage
an online database. I can see the entire table I need and all the
records in
that table for the db I¹m working with. I have a field called fullname
which
is supposed to receive the full name of the person entering the
information.
But sometimes, folks are entering their first name only in this field
and
then entering their last name in the address field by mistake. I would
like
to be able to send a command to the database to be able manually edit
those
records to add the last name back into the fullname field.

Is there a way to do this?

All My Best,
Jeffrey Ellis





-
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: Help with Joins

[Adolfo Bello]

SEELECT t1.* FROM ticket t1,customer t2 WHERE
t1.customerid=t2.customer.id AND t2.email='[EMAIL PROTECTED]'

On Sat, 2002-12-21 at 16:52, Jim Hankins wrote:
> Greetings,
> 
>  
> 
> I'm very new to Mysql and am trying to work with my first multi-table
> database project.  Here are my two table descriptions.  I'm trying to
> get the correct syntax for a sql query to do the following.
> 
>  
> 
> Display Ticket.Ticketnum,Ticket.Priority,Ticket.Title,Ticket.Status.  I
> assume the customer does not know the CustomerID but only their email
> address (actually I'm parsing this with an email processor and passing
> the senderemail to it.  Anyway, I know what Customer.Email is.  The
> common field is CustomerID between the two tables.  Can someone help me
> out?  
> 
>  
> 
> +---+-+--+-+-++
> 
> | Field | Type| Null | Key | Default | Extra  |
> 
> +---+-+--+-+-++
> 
> | CustomerID| int(5)  |  | PRI | NULL| auto_increment |
> 
> | Email | varchar(40) |  | | ||
> 
> | FirstName | varchar(40) |  | | ||
> 
> | LastName  | varchar(40) |  | | ||
> 
> | Title | varchar(40) |  | | ||
> 
> | Company   | varchar(40) |  | | ||
> 
> | Address1  | varchar(40) |  | | ||
> 
> | Address2  | varchar(40) |  | | ||
> 
> | City  | varchar(40) |  | | ||
> 
> | State | varchar(40) |  | | ||
> 
> | Zip   | int(5)  |  | | 0   ||
> 
> | phonedaytime  | varchar(10) | YES  | | NULL||
> 
> | phoneevening  | varchar(10) | YES  | | NULL||
> 
> | phonecellular | varchar(10) | YES  | | NULL||
> 
> | phonepager| varchar(40) | YES  | | NULL||
> 
> | domain| varchar(40) |  | | ||
> 
> | username  | varchar(20) |  | | ||
> 
> | passwd| varchar(15) |  | | ||
> 
> | ContractNum   | int(10) |  | | 0   ||
> 
>  
> 
> 
> mysql> Describe Ticket;
> 
> ++-+--+-+-++
> 
> | Field  | Type| Null | Key | Default | Extra  |
> 
> ++-+--+-+-++
> 
> | TicketNum  | int(10) |  | PRI | NULL| auto_increment |
> 
> | CustomerID | int(5)  |  | | 0   ||
> 
> | Priority   | int(1)  |  | | 0   ||
> 
> | Status | varchar(30) |  | | ||
> 
> | Title  | varchar(60) |  | | ||
> 
> | ProblemSum | longtext| YES  | | NULL||
> 
> | SupportID  | int(5)  | YES  | | 0   ||
> 
>  
>   
>   
>   
>   
>   
>  
> 
> 
> 
> 
> -
> 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
> 
-- 
Adolfo Bello <[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

MySQL Command to edit a single record

[Jeffrey Ellis]

Hi--

I have just begun using MySQL...I am using a program called MySQL to manage
an online database. I can see the entire table I need and all the records in
that table for the db I¹m working with. I have a field called fullname which
is supposed to receive the full name of the person entering the information.
But sometimes, folks are entering their first name only in this field and
then entering their last name in the address field by mistake. I would like
to be able to send a command to the database to be able manually edit those
records to add the last name back into the fullname field.

Is there a way to do this?

All My Best,
Jeffrey Ellis

Help with Joins

[Jim Hankins]

Greetings,

 

I'm very new to Mysql and am trying to work with my first multi-table
database project.  Here are my two table descriptions.  I'm trying to
get the correct syntax for a sql query to do the following.

 

Display Ticket.Ticketnum,Ticket.Priority,Ticket.Title,Ticket.Status.  I
assume the customer does not know the CustomerID but only their email
address (actually I'm parsing this with an email processor and passing
the senderemail to it.  Anyway, I know what Customer.Email is.  The
common field is CustomerID between the two tables.  Can someone help me
out?  

 

+---+-+--+-+-++

| Field | Type| Null | Key | Default | Extra  |

+---+-+--+-+-++

| CustomerID| int(5)  |  | PRI | NULL| auto_increment |

| Email | varchar(40) |  | | ||

| FirstName | varchar(40) |  | | ||

| LastName  | varchar(40) |  | | ||

| Title | varchar(40) |  | | ||

| Company   | varchar(40) |  | | ||

| Address1  | varchar(40) |  | | ||

| Address2  | varchar(40) |  | | ||

| City  | varchar(40) |  | | ||

| State | varchar(40) |  | | ||

| Zip   | int(5)  |  | | 0   ||

| phonedaytime  | varchar(10) | YES  | | NULL||

| phoneevening  | varchar(10) | YES  | | NULL||

| phonecellular | varchar(10) | YES  | | NULL||

| phonepager| varchar(40) | YES  | | NULL||

| domain| varchar(40) |  | | ||

| username  | varchar(20) |  | | ||

| passwd| varchar(15) |  | | ||

| ContractNum   | int(10) |  | | 0   ||

 
 

mysql> Describe Ticket;

++-+--+-+-++

| Field  | Type| Null | Key | Default | Extra  |

++-+--+-+-++

| TicketNum  | int(10) |  | PRI | NULL| auto_increment |

| CustomerID | int(5)  |  | | 0   ||

| Priority   | int(1)  |  | | 0   ||

| Status | varchar(30) |  | | ||

| Title  | varchar(60) |  | | ||

| ProblemSum | longtext| YES  | | NULL||

| SupportID  | int(5)  | YES  | | 0   ||

 
  
  
  
  
  
 




-
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: need index date help

[John Hinton]

OK.. no takers the first time... I'll try to give more/better
information..

I am running into a system wall here. I have at the moment about 2600
rows of data totaling 650K. I expect this to grow at a rate of about an
additional 1200-1500 rows per week. I am using PHP to format the returns
into webspace.

I have a field named 'adate' which is a mysql 14 character timestamp
(yes, I need HHMMSS data for other stuff). I am creating an array based
on a distinct return from the database. I then am in turn looping
through that array of about 25 entries, (which will remain at about 25
with time) and running each through 10 queries all based on date.
The queries are really only two, with the exception of choosing separate
intervals of time to return, one having distinct fields parsed, the
other all rows parsed. The following are the two snippets of code which
get repeated five more times with only the time interval changed.

$table, $user_net are PHP variables and $page[$i] is the array of 25
entries.

SELECT TO_DAYS(adate), mask FROM $table WHERE mask NOT LIKE '$user_net'
AND page LIKE '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6
SELECT adate, mask FROM $table WHERE mask NOT LIKE '$user_net' AND page
= '$page[$i]' AND TO_DAYS(adate) >= TO_DAYS(NOW()) - 6

All I need is the count from each query.

So, these ten queries are being run 25 times on 2600 rows of data and it
is taking about 4-6 seconds. I plan to collect data up to a limit of
about 70,000 rows. If I can expect the query time to grow linearly, it
would take about 2 minutes to generate this data. I need to get that
down to maybe 15 seconds  or as little as possible.

I have indexed 'adate', but don't think the index really works within
the functions? Maybe I'm stuck thinking inside of a box here? Perhaps
there is one blindingly great solution which I have not considered. This
is the first time I have ever created anything that really taxed a
system... therefore I am new at thinking in many of these terms. Perhaps
I should be rolling the data off into a temp file or something and
running the results using PHP? I really don't know what direction to
take, but I do see what appears to be a lot of repeating work, with only
little changes in time chunks. 

Should I perhaps create a 'date' field, grabbing only MMDD and
working from there? What am I not thinking about here?

Any suggestions are very much welcome.

John Hinton - Goshen, VA.
http://www.ew3d.com

Those who dance are considered insane 
by those who can't hear the music

-
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: mysqladmin access denied error

[Egor Egorov]

On Friday 20 December 2002 15:31, Imran Khan wrote:

> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
>
> -this appears to work fine.
>
> However as user1 in the solaris shell, when I run:
> $:/usr/local/mysql/bin/mysqlimport db1 table1.txt
>
> I get :
> /usr/local/mysql/bin/mysqlimport: Error: Access denied for user:
> 'user1@localhost' (Using password: NO), when using table: table1
>
> So how can I allow a user to run mysqlimport to my db1 database, and
> without a password?

To use mysqlimport you must have FILE privilege. It's not a database 
privilege, it's a global privilege.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   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: Bug Report

[Heikki Tuuri]

Christopher,

- Original Message -
From: ""Christopher Stephan"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, December 21, 2002 6:00 PM
Subject: Bug Report


> Hello,
> following problem occurs using MySql.
> Can you help me with that Error?

this is memory corruption, possibly a memory overrun by the memory buffer
which is being freed when the assertion fails.

Can you repeat the crash? It would be very valuable to trace a memory
corruption bug. I can send a special memory debug version of mysqld which
makes it easier. I have now also added diagnostic code to this assertion in
4.0.7.

What distro of MySQL-Max-4.0.6 you are using? Please do the following to
resolve the stack dump: go to the directory where the MySQL binaries are
and:

shell> gzip -d mysqld.sym.gz

shell> resolve_stack_dump mysqld.sym


Now it should print a resolved stack dump. If it was a memory overrun, the
stack dump would be very valuable.

Regards,

Heikki
Innobase Oy

sql query

> Betriebssystem: [ SuSE Linux 7.3 (i386) ]
> MySql Verision: MySql Max 4.0.6
> OMEGA.ERR:
> 021221 14:24:21  InnoDB: Assertion failure in thread 16401 in file
> mem0pool.c line 491
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
> InnoDB: Thread 10251 stopped in file row0mysql.c line 92
> mysqld got signal 11;
> This could be because you hit a bug. It is also possible that this binary
> or one of the libraries it was linked against is corrupt, improperly
built,
> or misconfigured. This error can also be caused by malfunctioning
hardware.
> We will try our best to scrape up some info that will hopefully help
> diagnose
> the problem, but since we have already crashed, something is definitely
> wrong
> and this may fail.
>
> key_buffer_size=16777216
> read_buffer_size=131072
> sort_buffer_size=524280
> max_used_connections=6
> max_connections=100
> threads_connected=7
> It is possible that mysqld could use up to
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
> 80383 K
> bytes of memory
> Hope that's ok; if not, decrease some variables in the equation.
>
> thd=0x87cea58
> 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...
> Cannot determine thread, fp=0xbd9fe508, backtrace may not be correct.
> Stack range sanity check OK, backtrace follows:
> 0x80da95a
> 0x40040bc4
> 0x830e0e5
> 0x830cbd2
> 0x8222d0d
> 0x822784b
> 0x813ce03
> 0x813f9cf
> 0x810cb65
> 0x8106b39
> 0x81067e3
> 0x80ff7b0
> 0x810c099
> 0x80e69c6
> 0x80e8908
> 0x80e4123
> 0x80e9df2
> 0x80e32ff
> 0x4003df37
> 0x40199baa
> New value of fp=(nil) failed sanity check, terminating stack trace!
> Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
> instructions on how to resolve the stack trace. Resolved
> stack trace is much more helpful in diagnosing the problem, so please do
> resolve it
> Trying to get some variables.
> Some pointers may be invalid and cause the dump to abort...
> thd->query at 0x87db350 = INSERT INTO xselected1 ( issueid, accesskey )
> SELECT xissue.issueid, '1040477060015' FROM  xissue INNER JOIN xstatus ON
> xissue.attributevalue = xstatus.statusid WHERE (((xissue.projectID)=26)
AND
> (xissue.deleted <> 'on') AND ((xissue.attributeid=128) And (
> ((xstatus.statusid)<>45) And  ((xstatus.statusid)<>46) And
> ((xstatus.statusid)<>42) And  ((xstatus.statusid)<>42) And
> ((xstatus.statusid)<>43) And  ((xstatus.statusid)<>44) And
> ((xstatus.statusid)<>42) And  ((xstatus.statusid)<>42) And
> ((xstatus.statusid)<>42) And  ((xstatus.statusid)<>42) And
> ((xstatus.statusid)<>46) And  ((xstatus.statusid)<>42) And
> ((xstatus.statusid)<>42) And  ((xstatus.statusid)<>42) And
> ((xstatus.statusid)<>49) And  ((xstatus.statusid)<>49) And
> ((xstatus.statusid)<>46) And  ((xstatus.statusid)<>43) And
> ((xstatus.statusid)<>48) And  ((xstatus.statusid)<>48) And
> ((xstatus.statusid)<>45) And  ((xstatus.statusid)<>45)) Or
> (((xissue.attributeid)=128) And ((xstatus.name) Like'%closed%' GROUP
BY
> xissue.issueid
> thd->thread_id=7
>
> Successfully dumped variables, if you ran with --log, take a look at the
> details of what thread 7 did to cause the crash.  In some cases of really
> bad corruption, the values shown above may be invalid.
>
> The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
> information that should help you find out what is causing the crash.
>
>
>
> Christopher Stephan
> [EMAIL PROTECTED]
> http://www.xudoo.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
>



---

mysql sporadic crashes in find_item_in_list

[Paul P Komkoff Jr]

>Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 + 248
0x80ef531 setup_order__FP3THDP13st_table_listRt4List1Z4ItemT2P8st_order + 49
0x80e0431 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result
 + 421
0x80ee8ec handle_select__FP3THDP6st_lexP13select_result + 92
0x80c760a mysql_execute_command__Fv + 934
0x80cac91 mysql_parse__FP3THDPcUi + 349
0x80c69a8 dispatch_command__F19enum_server_commandP3THDPcUi + 1280
0x80cc210 do_command__FP3THD + 92
0x80c5e38 handle_one_connection + 608
0x4011bb9c _end + 938538624
0x402ce1ea _end + 940317902

some queries from errorlog:
thd->query at 0x8236fd0 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÃÎÐÎÄÑÊÎÅ %') AND LOWER(keywords) LIKE LOWE
R('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(keywords) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(keywords) 
LIKE LOWER('%  %')) OR (LOWER(CONCAT(' ',ti
tle,' ')) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% 
ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(CONCAT(' ',title,'
 ')) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('%  %')) 
ORDER BY lm DESC

thd->query at 0x8733a08 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ËÅÍÈÍ %')) OR (LOWER(CONCAT(' ',title,' '))
 LIKE LOWER('% ËÅÍÈÍ %')) ORDER BY lm DESC

thd->query at 0x87409a8 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÀÍÀËÈÇ %') AND LOWER(keywords) LIKE LOWER('
% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(keywords) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')) OR 
(LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÀÍÀËÈÇ %')
 AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(CONCAT(' 
',title,' ')) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')
) ORDER BY lm DESC


>How-To-Repeat:
Not researched yet
>Fix:
Not known yet

>Submitter-Id:  
>Originator:
>Organization:
>MySQL support: none
>Synopsis:  pseudprandom mysqld segfaults in find_item_in_list
>Severity:  serious
>Category:  mysql
>Class: sw-bug
>Release:   mysql-4.0.5, mysql-4.0-1.1482 (cset 1.1482 as from 
>bk://work.mysql.com:7001)

>Environment:

System: Linux netstat 2.4.20-s7 #2 SMP ðÔÎ äÅË 13 18:51:21 MSK 2002 i686 unknown
Architecture: i686

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx1 root root   13 áÐÒ 25  2002 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root  1282588 óÅÎ  4  2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 óÅÎ  4  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 óÅÎ  4  2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-static=no' 
'--with-server-suffix' '--enable-thread-safe-client' '--enable-assembler' 
'--with-raid' '--with-mysqld-user=mysql' '--without-debug' '--with-comment' 
'--with-mysqlfs' '--with-vio' '--with-openssl' '--with-charset=cp1251' 
'--with-extra-charsets=all' '--without-innodb'


-
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

How to enter data in MySQLCC

[KPS]

Please someone email me at [EMAIL PROTECTED] how to do this as well...I
am lost on how to ad data to MYSQLCC


-
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 -lwrap on mysqld/mysqltest?

[ch]

>Description:
gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o  -lstdc++ ../libmysqld.a 
-lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread
../libmysqld.a(lib_sql.o)(.text+0x2736): In function 
`handle_connections_sockets':
: undefined reference to `request_init'
...
make[4]: Leaving directory 
`/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples'

>How-To-Repeat:
Build with --embedded-server
>Fix:
Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case
defined this variable in Makefile.am.

>Submitter-Id:  
>Originator:Christian Hammers
>Organization:
 The Debian Project
>MySQL support: none
>Synopsis:  Missing -lwrap to libmysqld/mysqltest
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.54 (Source distribution)
>Environment:

System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686
Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 2002-11-20 02:56 /lib/libc.so.6 -> 
libc-2.3.1.so
-rwxr-xr-x1 root root  1109068 2002-11-19 19:13 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2344038 2002-11-19 19:14 /usr/lib/libc.a
-rw-r--r--1 root root  178 2002-11-19 19:14 /usr/lib/libc.so
-rw-r--r--1 root root   716080 2002-01-13 21:06 
/usr/lib/libc-client.so.2001
Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' 
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' 
'--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' 
'--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' 
'--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' 
'--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' 
'--with-mysqld-user=mysql' '--without-bench' '--without-docs' 
'--with-client-ldflags=-lstdc++' '--with-extra-charsets=all'

-
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

[patch] Error in Makefile prevents complete distclean

[ch]

>Description:
The unpacked source differs from the source tree after a 
./configure && make && make distclean. This should be considered
as Makefile bug, as e.g. package maintainers like me depends on
a souce that cleans up it self so that we can easyly produce diffs
containing only our own modifications. 
>How-To-Repeat:
./configure && make && make clean; diff -u --recursive ../orig .
>Fix:

Some diffs:

# 
# Cleans up the vio_* and ctype-* symlinks that are created by link_source
#
$ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared 
mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 
--- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 
10:11:57.0 +0100
+++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 
++0100
@@ -84,6 +84,8 @@
rm -f `echo $(mystringsobjects) | sed "s;\.lo;.c;g"` \
  `echo $(dbugobjects) | sed "s;\.lo;.c;g"` \
  `echo $(mysysobjects) | sed "s;\.lo;.c;g"` \
+ `echo $(vio_objects) | sed "s;\.lo;.c;g"` \
+  $(CHARSET_SRCS) $(CHARSET_OBJS) \
   $(mystringsextra) $(mystringsgen) $(mysysheaders) \
   ctype_extra_sources.c net.c ../linked_client_sources

There are some others.. maybe I search them later.  

>Submitter-Id:  
>Originator:Christian Hammers
>Organization:
 The Debian Project
>MySQL support: none
>Synopsis:  distclean target misses some files
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   4.0.6 and probably mysql-3.23.54 (Source distribution)
>Environment:

System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686
Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 2002-11-20 02:56 /lib/libc.so.6 -> 
libc-2.3.1.so
-rwxr-xr-x1 root root  1109068 2002-11-19 19:13 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2344038 2002-11-19 19:14 /usr/lib/libc.a
-rw-r--r--1 root root  178 2002-11-19 19:14 /usr/lib/libc.so
-rw-r--r--1 root root   716080 2002-01-13 21:06 
/usr/lib/libc-client.so.2001
Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' 
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' 
'--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' 
'--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' 
'--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' 
'--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' 
'--with-mysqld-user=mysql' '--without-bench' '--without-docs' 
'--with-client-ldflags=-lstdc++' '--with-extra-charsets=all'

-
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

Docs make wrong statement about Debians init scripts

[ch]

>Description:
http://www.mysql.com/doc/en/Linux-x86.html
says what to do to start MySQL on system boot in "Debian GNU/Linux".
I don't know if this holds true for some of your binary packages
under Debian, but the official Debian package is configure by
debconf. So this text is misleading for Debian users and should
be removed completely.

>How-To-Repeat:

>Fix:
remove the note

>Submitter-Id:  
>Originator:Christian Hammers (Debian maintainer of MySQL)
>Organization:
 The Debian Project
>MySQL support: none
>Synopsis:  Wrong statement about Debian init scripts
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: doc-bug
>Release:   mysql-3.23.54 (Source distribution)
>Environment:

System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686
Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 2002-11-20 02:56 /lib/libc.so.6 -> 
libc-2.3.1.so
-rwxr-xr-x1 root root  1109068 2002-11-19 19:13 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2344038 2002-11-19 19:14 /usr/lib/libc.a
-rw-r--r--1 root root  178 2002-11-19 19:14 /usr/lib/libc.so
-rw-r--r--1 root root   716080 2002-01-13 21:06 
/usr/lib/libc-client.so.2001
Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' 
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' 
'--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' 
'--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' 
'--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' 
'--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' 
'--with-mysqld-user=mysql' '--without-bench' '--without-docs' 
'--with-client-ldflags=-lstdc++' '--with-extra-charsets=all'

-
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: mysqldump user prive

[Victoria Reznichenko]

On Thursday 19 December 2002 21:29, Arun kumar R wrote:
> I want to run mysqldump through a batch process, in
> order to do that what prive do i need to give to the
> user. It will be running as a cron job, i don't want
> to give any creation or deletion authorization. Your
> help will be greatly appreciated.

You should have SELECT privileges.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   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

mysql sporadic crashes in find_item_in_list

[Paul P Komkoff Jr]

>Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 + 248
0x80ef531 setup_order__FP3THDP13st_table_listRt4List1Z4ItemT2P8st_order + 49
0x80e0431 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result
 + 421
0x80ee8ec handle_select__FP3THDP6st_lexP13select_result + 92
0x80c760a mysql_execute_command__Fv + 934
0x80cac91 mysql_parse__FP3THDPcUi + 349
0x80c69a8 dispatch_command__F19enum_server_commandP3THDPcUi + 1280
0x80cc210 do_command__FP3THD + 92
0x80c5e38 handle_one_connection + 608
0x4011bb9c _end + 938538624
0x402ce1ea _end + 940317902

some queries from errorlog:
thd->query at 0x8236fd0 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÃÎÐÎÄÑÊÎÅ %') AND LOWER(keywords) LIKE LOWE
R('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(keywords) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(keywords) 
LIKE LOWER('%  %')) OR (LOWER(CONCAT(' ',ti
tle,' ')) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% 
ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(CONCAT(' ',title,'
 ')) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('%  %')) 
ORDER BY lm DESC

thd->query at 0x8733a08 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ËÅÍÈÍ %')) OR (LOWER(CONCAT(' ',title,' '))
 LIKE LOWER('% ËÅÍÈÍ %')) ORDER BY lm DESC

thd->query at 0x87409a8 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÀÍÀËÈÇ %') AND LOWER(keywords) LIKE LOWER('
% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(keywords) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')) OR 
(LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÀÍÀËÈÇ %')
 AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(CONCAT(' 
',title,' ')) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')
) ORDER BY lm DESC


>How-To-Repeat:
Not researched yet
>Fix:
Not known yet

>Submitter-Id:  
>Originator:
>Organization:
>MySQL support: none
>Synopsis:  pseudprandom mysqld segfaults in find_item_in_list
>Severity:  serious
>Category:  mysql
>Class: sw-bug
>Release:   mysql-4.0.5, mysql-4.0-1.1482 (cset 1.1482 as from 
>bk://work.mysql.com:7001)

>Environment:

System: Linux netstat 2.4.20-s7 #2 SMP ðÔÎ äÅË 13 18:51:21 MSK 2002 i686 unknown
Architecture: i686

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC:
lrwxrwxrwx1 root root   13 áÐÒ 25  2002 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root  1282588 óÅÎ  4  2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 óÅÎ  4  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 óÅÎ  4  2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-static=no' 
'--with-server-suffix' '--enable-thread-safe-client' '--enable-assembler' 
'--with-raid' '--with-mysqld-user=mysql' '--without-debug' '--with-comment' 
'--with-mysqlfs' '--with-vio' '--with-openssl' '--with-charset=cp1251' 
'--with-extra-charsets=all' '--without-innodb'


-
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

How to enter data in MySQLCC

[KPS]

Please someone email me at [EMAIL PROTECTED] how to do this as well...I
am lost on how to ad data to MYSQLCC


-
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 -lwrap on mysqld/mysqltest?

[ch]

>Description:
gcc -O3 -DDBUG_OFF -rdynamic -o mysqltest mysqltest.o  -lstdc++ ../libmysqld.a 
-lrt -ldl -lpthread -lz -lcrypt -lnsl -lm -lpthread
../libmysqld.a(lib_sql.o)(.text+0x2736): In function 
`handle_connections_sockets':
: undefined reference to `request_init'
...
make[4]: Leaving directory 
`/home/ch/debian/mysql-dfsg-4.0.6.gamma/libmysqld/examples'

>How-To-Repeat:
Build with --embedded-server
>Fix:
Makefile.in: add -lwrap to mysqltest_LDFLAGS or in your case
defined this variable in Makefile.am.

>Submitter-Id:  
>Originator:Christian Hammers
>Organization:
 The Debian Project
>MySQL support: none
>Synopsis:  Missing -lwrap to libmysqld/mysqltest
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.54 (Source distribution)
>Environment:

System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686
Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 2002-11-20 02:56 /lib/libc.so.6 -> 
libc-2.3.1.so
-rwxr-xr-x1 root root  1109068 2002-11-19 19:13 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2344038 2002-11-19 19:14 /usr/lib/libc.a
-rw-r--r--1 root root  178 2002-11-19 19:14 /usr/lib/libc.so
-rw-r--r--1 root root   716080 2002-01-13 21:06 
/usr/lib/libc-client.so.2001
Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' 
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' 
'--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' 
'--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' 
'--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' 
'--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' 
'--with-mysqld-user=mysql' '--without-bench' '--without-docs' 
'--with-client-ldflags=-lstdc++' '--with-extra-charsets=all'

-
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

[patch] Error in Makefile prevents complete distclean

[ch]

>Description:
The unpacked source differs from the source tree after a 
./configure && make && make distclean. This should be considered
as Makefile bug, as e.g. package maintainers like me depends on
a souce that cleans up it self so that we can easyly produce diffs
containing only our own modifications. 
>How-To-Repeat:
./configure && make && make clean; diff -u --recursive ../orig .
>Fix:

Some diffs:

# 
# Cleans up the vio_* and ctype-* symlinks that are created by link_source
#
$ diff -u mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared 
mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 
--- mysql-dfsg-4.0.6.gamma.orig/libmysql/Makefile.shared2002-12-16 
10:11:57.0 +0100
+++ mysql-dfsg-4.0.6.gamma/libmysql/Makefile.shared 2002-12-21 01:56:07.0 
++0100
@@ -84,6 +84,8 @@
rm -f `echo $(mystringsobjects) | sed "s;\.lo;.c;g"` \
  `echo $(dbugobjects) | sed "s;\.lo;.c;g"` \
  `echo $(mysysobjects) | sed "s;\.lo;.c;g"` \
+ `echo $(vio_objects) | sed "s;\.lo;.c;g"` \
+  $(CHARSET_SRCS) $(CHARSET_OBJS) \
   $(mystringsextra) $(mystringsgen) $(mysysheaders) \
   ctype_extra_sources.c net.c ../linked_client_sources

There are some others.. maybe I search them later.  

>Submitter-Id:  
>Originator:Christian Hammers
>Organization:
 The Debian Project
>MySQL support: none
>Synopsis:  distclean target misses some files
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   4.0.6 and probably mysql-3.23.54 (Source distribution)
>Environment:

System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686
Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 2002-11-20 02:56 /lib/libc.so.6 -> 
libc-2.3.1.so
-rwxr-xr-x1 root root  1109068 2002-11-19 19:13 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2344038 2002-11-19 19:14 /usr/lib/libc.a
-rw-r--r--1 root root  178 2002-11-19 19:14 /usr/lib/libc.so
-rw-r--r--1 root root   716080 2002-01-13 21:06 
/usr/lib/libc-client.so.2001
Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' 
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' 
'--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' 
'--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' 
'--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' 
'--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' 
'--with-mysqld-user=mysql' '--without-bench' '--without-docs' 
'--with-client-ldflags=-lstdc++' '--with-extra-charsets=all'

-
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

Docs make wrong statement about Debians init scripts

[ch]

>Description:
http://www.mysql.com/doc/en/Linux-x86.html
says what to do to start MySQL on system boot in "Debian GNU/Linux".
I don't know if this holds true for some of your binary packages
under Debian, but the official Debian package is configure by
debconf. So this text is misleading for Debian users and should
be removed completely.

>How-To-Repeat:

>Fix:
remove the note

>Submitter-Id:  
>Originator:Christian Hammers (Debian maintainer of MySQL)
>Organization:
 The Debian Project
>MySQL support: none
>Synopsis:  Wrong statement about Debian init scripts
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: doc-bug
>Release:   mysql-3.23.54 (Source distribution)
>Environment:

System: Linux app109 2.4.20-app109-1 #4 Thu Dec 5 21:44:44 CET 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686
Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs
gcc version 2.95.4 20011002 (Debian prerelease)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 2002-11-20 02:56 /lib/libc.so.6 -> 
libc-2.3.1.so
-rwxr-xr-x1 root root  1109068 2002-11-19 19:13 /lib/libc-2.3.1.so
-rw-r--r--1 root root  2344038 2002-11-19 19:14 /usr/lib/libc.a
-rw-r--r--1 root root  178 2002-11-19 19:14 /usr/lib/libc.so
-rw-r--r--1 root root   716080 2002-01-13 21:06 
/usr/lib/libc-client.so.2001
Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' 
'--localstatedir=/var/lib/mysql' '--includedir=/usr/include' 
'--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' 
'--with-libwrap' '--enable-assembler' '--with-berkeley-db' '--with-innodb' 
'--enable-static' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' 
'--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' 
'--with-mysqld-user=mysql' '--without-bench' '--without-docs' 
'--with-client-ldflags=-lstdc++' '--with-extra-charsets=all'

-
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: mysqldump user prive

[Victoria Reznichenko]

On Thursday 19 December 2002 21:29, Arun kumar R wrote:
> I want to run mysqldump through a batch process, in
> order to do that what prive do i need to give to the
> user. It will be running as a cron job, i don't want
> to give any creation or deletion authorization. Your
> help will be greatly appreciated.

You should have SELECT privileges.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   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: mysqladmin access denied error

[Egor Egorov]

On Friday 20 December 2002 15:31, Imran Khan wrote:

> I'm using solaris 8 with mysql v 3.23.54.
>
> I want to enable a solaris user - 'user1', to use the mysqlimport command
> without using a password.
>
> I've run, as root, the following sql command:
> mysql>grant all on db1.* to user1@localhost
>
> -this appears to work fine.
>
> However as user1 in the solaris shell, when I run:
> $:/usr/local/mysql/bin/mysqlimport db1 table1.txt
>
> I get :
> /usr/local/mysql/bin/mysqlimport: Error: Access denied for user:
> 'user1@localhost' (Using password: NO), when using table: table1
>
> So how can I allow a user to run mysqlimport to my db1 database, and
> without a password?

To use mysqlimport you must have FILE privilege. It's not a database 
privilege, it's a global privilege.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   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

New DBTools Manager Release

[Crercio O. Silva]

Hi all,

We are pleased to announce the new DBTools Manager Professional 2.0.
This version is not a bug fixed, but a brend new application with much more
features and still easier to use. This version has been developed for
almost a year, and now with a new and improved GUI, really cool new
features and better support for data manipulation. Here is a simple list of
the features available

- New GUI which makes possible to explorer a server or a database in a
easier way.
This version uses a professional library which allow us to create a GUI
similar to MSOffice XP and Windows XP.
- Complete database management (dbs, tables, indexes, foreign keys, check
constraints, etc)
- New DAO Import Data Wizard, with more options (to import queries and
relationships)
- New Text Import Wizard
- New Dump Wizard
- New PHP Web Script Generator
- New Data Viewer
- New Query Editor with syntax coloring and codesense and function hilight
- New Query Designer with drag and drop support to create relationships on
the fly
- and more, much more

You can get detailed information at
http://www.dbtools.com.br/EN/dbmanagerpro.php and download it at
http://www.dbtools.com.br/EN/downloads.php.

Have fun and a very nice Christmas to all.

[]s

Crercio O. Silva / DBTools Software




-
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: Can MySQL handle 120 million records?

[JamesD]

Thanks Dean.

-Original Message-
From: Dean Harding [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 21, 2002 12:46 AM
To: 'JamesD'; [EMAIL PROTECTED]
Subject: RE: Can MySQL handle 120 million records?


It's just that the number of rows in a table is stored directly in the
.MYD file (I believe) so a query like "select count(*) from table" will
just return that value, rather than counting all the rows.  It's not
that the functions are "built-in", rather they're *optimized* - a
totally different thing.

Dean.

> -Original Message-
> From: JamesD [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, 21 December 2002 7:33 pm
> To: [EMAIL PROTECTED]
> Subject: RE: Can MySQL handle 120 million records?
>
> Jeremy,
>
> if i run the command
>
> show tables; on some database
> it returns
>
> "5 rows in set (0.02 sec)"
>
> and if, on the same database i run
> the command
>
> select count(*) from 'table';
> it returns
>
> +-+
> | count(*)|
> +-+
> | 47226322|
> +-+
> 1 row in set (0.00 sec)
>
> now, i believe its reasonable to assume
> a CPU must spend more time to count 47 million records,
> than to count 5 tables. This is why I believe
> that many common selects are built-in to mysql in the code
> somewhere. make sense? Its a good idea actually, that building
> in commonly run selects when the process is idling and stuffing
> results into variables that can be called in an instant, saves
> us all time and money...
>
> Jim
>
>
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 20, 2002 3:28 PM
> To: JamesD
> Cc: [EMAIL PROTECTED]
> Subject: Re: Can MySQL handle 120 million records?
>
>
> On Wed, Dec 18, 2002 at 08:05:46PM -0800, JamesD wrote:
> >
> > i like mySQL, but it has a long way to go to gain the level of
> > 'confidence' that oracle, db2 or mssql or sybase have when it comes
> > to frontline mission critical stuff.
>
> Can you explain why?
>
> > I think it will in time...thats why i stick with it. besides,
> > confidence is often just a synonym for 'knowledge'
>
> Really?  I tend to see it more like confidence builds with experience
> (and therefore time).  You don't need to know a lot about to become
> confident in its operation.  Many of us don't *really* understand how
> gravity works, but we're quite confident in it.
>
> > select count(*) from x (0.00 seconds)
> >
> > if you dig into the source, you will probably find this common
> > select is built in and running all the time,
> >
> > and we are all just getting a pre-filled variable
> > returned from the method " select count(*) from (x) "
>
> Please find it.  I'll bet you money that it's not.
>
> > I hope someone can prove me wrong...
>
> I think the burden of proof is on you.
>
> Jeremy
> --
> Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
>
> MySQL 3.23.51: up 5 days, processed 219,909,773 queries (441/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
>
>
> -
> 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


-
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: i need help

[Cal Evans]

either mysql is not running or php doesn't know where to find your sock.
make sure that php.ini has the correct location for your sock and that ps
auxwww shows mysql running.

=C=

*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*


-Original Message-
From: Rich Dodge [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 21, 2002 9:10 AM
To: [EMAIL PROTECTED]
Subject: i need help


I keep getting this message what can i do to correct this problem ?


Warning: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) in
/web/repository/sites/www/inc/generate-page.php on line 4


-
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: MySQL Decimal Column Types Question

[Michael She]

At 10:12 PM 12/20/2002 -0600, Paul DuBois wrote:

 >>> For a 10,2 decimal column, should this be a valid number: 
1234567890.12?

 It's easy to test:

 mysql> CREATE TABLE t (d DECIMAL(10,2));
 Query OK, 0 rows affected (0.01 sec)

 mysql> INSERT INTO t SET d = 1234567890.12;
 Query OK, 1 row affected (0.01 sec)

 mysql> SELECT * FROM t;
 +--+
 | d|
 +--+
 | 9.99 |
 +--+
 1 row in set (0.00 sec)

 The value's been clipped to the upper end of the range.

 Your next question should be why that value has 9 digits to the left
 of the decimal point. :-)



 How did you guess!  This behaviour is why I asked the question in the 
first
 place.  Why does it get clipped for a 10 digit number.  Without the 
decimal
 value I believe it inserts correctly, but with the 2 decimal places it get
 clipped...
 --
 Michael She  : [EMAIL PROTECTED]
 Mobile   : (519) 589-7309
 WWW Homepage : http://www.binaryio.com/



 mysql> INSERT INTO t SET d = 1234567890.12;
 Query OK, 1 row affected (0.01 sec)


A different question would be why does MySQL not generate an error or
warning on the insert when it mangled the value?


The philosophy is that it's the clients responsibility not to insert
bad data.



I think more error checking should still be done.

Often times the client doesn't know the datatype of the columns, hence it 
is very hard for the client to do error checking.


--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.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

[Christopher Stephan]

Hello,
following problem occurs using MySql.
Can you help me with that Error?

Betriebssystem: [ SuSE Linux 7.3 (i386) ]
MySql Verision: MySql Max 4.0.6
OMEGA.ERR:
021221 14:24:21  InnoDB: Assertion failure in thread 16401 in file
mem0pool.c line 491
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
InnoDB: Thread 10251 stopped in file row0mysql.c line 92
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail.

key_buffer_size=16777216
read_buffer_size=131072
sort_buffer_size=524280
max_used_connections=6
max_connections=100
threads_connected=7
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections =
80383 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0x87cea58
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...
Cannot determine thread, fp=0xbd9fe508, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80da95a
0x40040bc4
0x830e0e5
0x830cbd2
0x8222d0d
0x822784b
0x813ce03
0x813f9cf
0x810cb65
0x8106b39
0x81067e3
0x80ff7b0
0x810c099
0x80e69c6
0x80e8908
0x80e4123
0x80e9df2
0x80e32ff
0x4003df37
0x40199baa
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x87db350 = INSERT INTO xselected1 ( issueid, accesskey )
SELECT xissue.issueid, '1040477060015' FROM  xissue INNER JOIN xstatus ON
xissue.attributevalue = xstatus.statusid WHERE (((xissue.projectID)=26) AND
(xissue.deleted <> 'on') AND ((xissue.attributeid=128) And (
((xstatus.statusid)<>45) And  ((xstatus.statusid)<>46) And
((xstatus.statusid)<>42) And  ((xstatus.statusid)<>42) And
((xstatus.statusid)<>43) And  ((xstatus.statusid)<>44) And
((xstatus.statusid)<>42) And  ((xstatus.statusid)<>42) And
((xstatus.statusid)<>42) And  ((xstatus.statusid)<>42) And
((xstatus.statusid)<>46) And  ((xstatus.statusid)<>42) And
((xstatus.statusid)<>42) And  ((xstatus.statusid)<>42) And
((xstatus.statusid)<>49) And  ((xstatus.statusid)<>49) And
((xstatus.statusid)<>46) And  ((xstatus.statusid)<>43) And
((xstatus.statusid)<>48) And  ((xstatus.statusid)<>48) And
((xstatus.statusid)<>45) And  ((xstatus.statusid)<>45)) Or
(((xissue.attributeid)=128) And ((xstatus.name) Like'%closed%' GROUP BY
xissue.issueid
thd->thread_id=7

Successfully dumped variables, if you ran with --log, take a look at the
details of what thread 7 did to cause the crash.  In some cases of really
bad corruption, the values shown above may be invalid.

The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains
information that should help you find out what is causing the crash.



Christopher Stephan
[EMAIL PROTECTED]
http://www.xudoo.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: MySQL Decimal Column Types Question

[Michael She]

How did you guess!  This behaviour is why I asked the question in the 
first place.  Why does it get clipped for a 10 digit number. Without the 
decimal value I believe it inserts correctly, but with the 2 decimal 
places it get clipped...

No, it won't insert correctly, it will still get clipped.

The reason for the 9 digits is that the column requires an extra byte to
store the sign for negative numbers.  For positive numbers, the sign is
not present, so MySQL uses it to extend the upper range.



That is what I thought initially, but the manual is not very clear:

"The decimal point and, for negative numbers, the `-' sign, are not counted 
in M (but space for these is reserved)"

The manual states that the negative sign and decimal points are not counted 
in M.  By this wording, it should be 10 numeric digits.

I guess it's bad wording... or just an incorrecct entry?

--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.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: i need help

[Adolfo Bello]

Is mysql service started?

Check with:
ps -ax mysql | grep -i mysql

If it does't appear on tje list, start the service with:

service mysql start

Adolfo

P.S. I have mysql.sock in /var/lib/mysql which is the default. Check
also basedir in your /etc/my.cnf.

> -Original Message-
> From: Rich Dodge [mailto:[EMAIL PROTECTED]] 
> Sent: Saturday, December 21, 2002 11:10 AM
> To: [EMAIL PROTECTED]
> Subject: i need help 
> 
> 
> I keep getting this message what can i do to correct this problem ?
> 
> 
> Warning: Can't connect to local MySQL server through socket 
> '/var/run/mysqld/mysqld.sock' (2) in 
> /web/repository/sites/www/inc/generate-page.php on line 4
> 
> 
> -
> 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: Re: MySQL Decimal Column Types Question

[Michael She]

At 09:18 PM 12/20/2002 -0500, Michael She wrote:
The value's been clipped to the upper end of the range.

>>Your next question should be why that value has 9 digits to the left
>>of the decimal point. :-)
>
>
>How did you guess!  This behaviour is why I asked the question in the
>first place.  Why does it get clipped for a 10 digit number.  Without the
>decimal value I believe it inserts correctly, but with the 2 decimal
>places it get clipped...

Oops correction.

A 10 digit value gets clipped at the upper range.

So I guess the range is really n-1.

Odd.


sql, query, mysql, smallint
--
Michael She  : [EMAIL PROTECTED]
Mobile   : (519) 589-7309
WWW Homepage : http://www.binaryio.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: i need help

[B. van Ouwerkerk]

This has been answered a zillion times in the past.

Search the archive.

mysqld.sock will usually live in /tmp

Change the appropriate paths.


-B.



-Oorspronkelijk bericht-
Van: Rich Dodge [mailto:[EMAIL PROTECTED]]
Verzonden: zaterdag 21 december 2002 16:10
Aan: [EMAIL PROTECTED]
Onderwerp: i need help 


I keep getting this message what can i do to correct this problem ?


Warning: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) in
/web/repository/sites/www/inc/generate-page.php on line 4




-
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: mysql corruption probelm - urgent

[Gerald R. Jensen]

MySQL is not the problem.

Are you shutting down MySQL before you shutdown/restart the machine?

When you say Win9x, which flavor or Win9x do you really mean ('95, 98,
98SE?)

- Original Message -
From: "Lalit Chandwani" <[EMAIL PROTECTED]>
To: "MySql Mail" <[EMAIL PROTECTED]>
Sent: Saturday, December 21, 2002 8:18 AM
Subject: mysql corruption probelm - urgent


hi all ,

i am facing a great trouble of mysql corruption on
windows
i am using mysql 3.23.53-max-debug version on win 9x
plateform

i am using both PHP and VB as a client
mysqld is running

some the the cause of the table corruption is the
sometimes improper shutdown
sometimes normal shutdown
sometimes unknows

their is no virus on the system and i tried the same
installtion in diffrent systems
along with the PHP , i am using the mysqlfront for
database manupulations.

thire is nothing data length or process with the table
, i don't know why mysql is so sensitive

tell the stable version of mysql for windows plateform
or also suggest the
secured and accurate way to communicate with mysql via
PHP so that it can be prevent
for the data corruption

it's very urgent ,
please reply

=
---
Dream Team Network Solutions Pvt. Ltd.,
C-97 , shastri nagar,Opp. PNB,
jodhpur. ( india ) - 342001
PHONE  : 91-0291-308074 , 75
VISIT http://www.dreamteamonline.com
---

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.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: mysql corruption probelm - urgent

[Mark]

- Original Message -
From: "Lalit Chandwani" <[EMAIL PROTECTED]>
To: "MySql Mail" <[EMAIL PROTECTED]>
Sent: Saturday, December 21, 2002 3:18 PM
Subject: mysql corruption probelm - urgent


> hi all ,
>
> i am facing a great trouble of mysql corruption on
> windows
> i am using mysql 3.23.53-max-debug version on win 9x
> plateform
>
> i am using both PHP and VB as a client
> mysqld is running
>
> some the the cause of the table corruption is the
> sometimes improper shutdown
> sometimes normal shutdown


Use this formula:

sometimes improper shutdown + sometimes normal shutdown = always corruption.
:)

> secured and accurate way to communicate with mysql
> via PHP so that it can be prevent
> for the data corruption

Looking at the above, I doubt it has anything to do with PHP. Just in case,
it might help if you actually said what gets when corrupted in what query,
and what the corruption looks like.

- Mark


-
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

i need help

[Rich Dodge]

I keep getting this message what can i do to correct this problem ?


Warning: Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2) in
/web/repository/sites/www/inc/generate-page.php on line 4


-
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

mysql corruption probelm - urgent

[Lalit Chandwani]

hi all ,

i am facing a great trouble of mysql corruption on
windows
i am using mysql 3.23.53-max-debug version on win 9x
plateform

i am using both PHP and VB as a client
mysqld is running 

some the the cause of the table corruption is the 
sometimes improper shutdown
sometimes normal shutdown
sometimes unknows 

their is no virus on the system and i tried the same
installtion in diffrent systems
along with the PHP , i am using the mysqlfront for
database manupulations.

thire is nothing data length or process with the table
, i don't know why mysql is so sensitive

tell the stable version of mysql for windows plateform
or also suggest the 
secured and accurate way to communicate with mysql via
PHP so that it can be prevent
for the data corruption

it's very urgent ,
please reply

=
---
Dream Team Network Solutions Pvt. Ltd.,
C-97 , shastri nagar,Opp. PNB,
jodhpur. ( india ) - 342001
PHONE  : 91-0291-308074 , 75
VISIT http://www.dreamteamonline.com
---

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.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

More info on mysql sporadic crashes

[Paul P Komkoff Jr]

I tracked down the bug

I have one table with BLOB field in it
Then I execute queries like

SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))

here, keywords is a blob fields

when (LOWER(keywords) LIKE LOWER('% blabla %')) is true, mysql dies

hope this helps

-- 
Paul P 'Stingray' Komkoff 'Greatest' Jr /// (icq)23200764 /// (http)stingr.net
  When you're invisible, the only one really watching you is you (my keychain)

-
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

server load

[Sankaranarayanan Mahadevan]

hi
we have developed for a client and now its testing
phase by next week...
using Linux/PHP/MySQL 3.23
we need to test the database load...
like how efficienty query is executing...
how many inserts..updataes taking place...etc...
how much the data etc...
is there any tools available for this?
any idea?

Shankar

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.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

need index date help

[John Hinton]

OK.. I have a field named 'adate' which is a mysql auto timestamp. I
need to use this data to do many time functions on a large 160,000 or so
row database. I have indexed adate, but am having trouble with this
WHERE statement because I am unable to make clean use of the index. I
have to do everything I can to get this to run as fast as possible.

to get today - MMDDHHMMSS <= 364 (to return all entries this year) I
run

WHERE TO_DAYS(NOW()) - TO_DAYS(adate) <= 364 

or  

TO_DAYS(adate) >= TO_DAYS(NOW()) - 364

to get TO_DAYS(MMDDHHMMSS) = today I run

WHERE TO_DAYS(adate) = TO_DAYS(NOW())

I simply cannot figure a way to get adate outside of the TO_DAYS()
function.

BTW, I am collecting a 14 char timestamp as in another location I will
need to pull the time to the second.

Perhaps I simply need to add another field to deal with this part of the
date stuff?

-- 
John Hinton - Goshen, VA.
http://www.ew3d.com

Those who dance are considered insane 
by those who can't hear the music

-
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

Memory allocation error in MySQL

[Bruno Batarelo]

Greetings

Recently I have a great problem. My whole project depends on it and some
people are not satisfied with my aplication because of it. I use database
for storing into InnoDB tables word documents into BLOBs, and some other
information about docs into standard column types. However, after a database
file has grown to 60 MB everything started working very slow and MySQL
server (4.0.4 max) reports to my VB application Memory Allocation Error when
I try to insert a document of 16 mb size. I have not found this type of
error anywhere in documentation or on news. I use ADO and stream object for
inserting binary data. Server is 1100 mhz celeron with 256 mb of RAM. That
should be enough for database of 60-70 mbytes. Please help me.

Thank you in advance
Bruno


-
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

mysql sporadic crashes in find_item_in_list

[Paul P Komkoff Jr]

>Description:
Sometimes my hosting mysql server segfaulting
typical backtrace follows
0x80be1f8 handle_segfault + 424
0x4011e8d5 _end + 938550201
0x80dbf61 find_item_in_list__FP4ItemRt4List1Z4Item + 417
0x80ec0b0 find_order_in_list__FP3THDP13st_table_listP8st_orderRt4List1Z4ItemT3 + 248
0x80ef531 setup_order__FP3THDP13st_table_listRt4List1Z4ItemT2P8st_order + 49
0x80e0431 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result
 + 421
0x80ee8ec handle_select__FP3THDP6st_lexP13select_result + 92
0x80c760a mysql_execute_command__Fv + 934
0x80cac91 mysql_parse__FP3THDPcUi + 349
0x80c69a8 dispatch_command__F19enum_server_commandP3THDPcUi + 1280
0x80cc210 do_command__FP3THD + 92
0x80c5e38 handle_one_connection + 608
0x4011bb9c _end + 938538624
0x402ce1ea _end + 940317902

some queries from errorlog:
thd->query at 0x8236fd0 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÃÎÐÎÄÑÊÎÅ %') AND LOWER(keywords) LIKE LOWE
R('% ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(keywords) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(keywords) 
LIKE LOWER('%  %')) OR (LOWER(CONCAT(' ',ti
tle,' ')) LIKE LOWER('% ÃÎÐÎÄÑÊÎÅ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% 
ÓÏÐÀÂËÅÍÈÅ %') AND LOWER(CONCAT(' ',title,'
 ')) LIKE LOWER('% ÐÎÑÑÈÈ %') AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('%  %')) 
ORDER BY lm DESC

thd->query at 0x8733a08 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ËÅÍÈÍ %')) OR (LOWER(CONCAT(' ',title,' '))
 LIKE LOWER('% ËÅÍÈÍ %')) ORDER BY lm DESC

thd->query at 0x87409a8 = SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% 
ÀÍÀËÈÇ %') AND LOWER(keywords) LIKE LOWER('
% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(keywords) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')) OR 
(LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÀÍÀËÈÇ %')
 AND LOWER(CONCAT(' ',title,' ')) LIKE LOWER('% ÌÓÇÛÊÀËÜÍÎÃÎ %') AND LOWER(CONCAT(' 
',title,' ')) LIKE LOWER('% ÏÐÎÈÇÂÅÄÅÍÈß %')
) ORDER BY lm DESC


>How-To-Repeat:
Not researched yet
>Fix:
Not known yet

>Submitter-Id:  
>Originator:
>Organization:
>MySQL support: none
>Synopsis:  pseudprandom mysqld segfaults in find_item_in_list
>Severity:  serious
>Category:  mysql
>Class: sw-bug
>Release:   mysql-4.0.5, mysql-4.0-1.1482 (cset 1.1482 as from 
>bk://work.mysql.com:7001)

>Environment:

System: Linux netstat 2.4.20-s7 #2 SMP ðÔÎ äÅË 13 18:51:21 MSK 2002 i686 unknown
Architecture: i686

Some paths:  /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 áÐÒ 25  2002 /lib/libc.so.6 -> libc-2.2.4.so
-rwxr-xr-x1 root root  1282588 óÅÎ  4  2001 /lib/libc-2.2.4.so
-rw-r--r--1 root root 27304836 óÅÎ  4  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 óÅÎ  4  2001 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--enable-static=no' 
'--with-server-suffix' '--enable-thread-safe-client' '--enable-assembler' 
'--with-raid' '--with-mysqld-user=mysql' '--without-debug' '--with-comment' 
'--with-mysqlfs' '--with-vio' '--with-openssl' '--with-charset=cp1251' 
'--with-extra-charsets=all' '--without-innodb'


-
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: chroot() in 3.23.54

[Sergei Golubchik]

Hi!

On Dec 18, Andrew Rucker Jones wrote:
> Sergei,
>   Forgive my ignorance, but i've been thinking about this. Isn't it 
> impossible to get it to work with the system calls i listed from strace? 
> To repeat:
> 
> chdir("/usr/local/var/mysql/")  = 0
> chroot("/chroot/mysql") = 0
> chdir("/")  = 0
> open("./mysql/host.frm", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file
> or directory)
> 
> This says to me that it does not matter what i choose for my datadir. 
> chdir() to the directory that open() is expecting is done before the 
> chroot(). Then comes chroot() and chdir("/"), which puts the program 
> where it is not expecting to be, and forces all database directories to 
> be under the root of the chrooted filesystem. There are no other 
> chdir()s between chdir("/") and open().

You're right.
In fact, I tested only 4.0 branch - and chroot() worked perfectly there,
I didn't notice first, that you were writing about 3.23 :(
Sorry for this.

It happens out, that it's not possible to make --chroot option to work
correctly in MySQL 3.23 without making my.cnf files
backward-incompatible (that is, users will have to fix their my.cnf
files after upgrade, otherwise mysqld won't work).

Taking this into account, we decided to revert --chroot fix in 3.23.
So, in 3.23.55 --chroot will behave the same way it did in 3.23.53 -
and it will NOT provide 100% closed chroot jail :(

In 4.0, instead, --chroot works as one may expect - nothing outside
chroot jail is visible - and, still, my.cnf files are perfectly
backward-compatible.

So, I recommend you to upgrade to 4.0.6, if you want to use --chroot
option.

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   <___/

-
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: Can MySQL handle 120 million records?

[Dean Harding]

It's just that the number of rows in a table is stored directly in the
.MYD file (I believe) so a query like "select count(*) from table" will
just return that value, rather than counting all the rows.  It's not
that the functions are "built-in", rather they're *optimized* - a
totally different thing.

Dean.

> -Original Message-
> From: JamesD [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, 21 December 2002 7:33 pm
> To: [EMAIL PROTECTED]
> Subject: RE: Can MySQL handle 120 million records?
> 
> Jeremy,
> 
> if i run the command
> 
> show tables; on some database
> it returns
> 
> "5 rows in set (0.02 sec)"
> 
> and if, on the same database i run
> the command
> 
> select count(*) from 'table';
> it returns
> 
> +-+
> | count(*)|
> +-+
> | 47226322|
> +-+
> 1 row in set (0.00 sec)
> 
> now, i believe its reasonable to assume
> a CPU must spend more time to count 47 million records,
> than to count 5 tables. This is why I believe
> that many common selects are built-in to mysql in the code
> somewhere. make sense? Its a good idea actually, that building
> in commonly run selects when the process is idling and stuffing
> results into variables that can be called in an instant, saves
> us all time and money...
> 
> Jim
> 
> 
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 20, 2002 3:28 PM
> To: JamesD
> Cc: [EMAIL PROTECTED]
> Subject: Re: Can MySQL handle 120 million records?
> 
> 
> On Wed, Dec 18, 2002 at 08:05:46PM -0800, JamesD wrote:
> >
> > i like mySQL, but it has a long way to go to gain the level of
> > 'confidence' that oracle, db2 or mssql or sybase have when it comes
> > to frontline mission critical stuff.
> 
> Can you explain why?
> 
> > I think it will in time...thats why i stick with it. besides,
> > confidence is often just a synonym for 'knowledge'
> 
> Really?  I tend to see it more like confidence builds with experience
> (and therefore time).  You don't need to know a lot about to become
> confident in its operation.  Many of us don't *really* understand how
> gravity works, but we're quite confident in it.
> 
> > select count(*) from x (0.00 seconds)
> >
> > if you dig into the source, you will probably find this common
> > select is built in and running all the time,
> >
> > and we are all just getting a pre-filled variable
> > returned from the method " select count(*) from (x) "
> 
> Please find it.  I'll bet you money that it's not.
> 
> > I hope someone can prove me wrong...
> 
> I think the burden of proof is on you.
> 
> Jeremy
> --
> Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
> 
> MySQL 3.23.51: up 5 days, processed 219,909,773 queries (441/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
> 
> 
> -
> 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: Can MySQL handle 120 million records?

[JamesD]

Jeremy,

if i run the command

show tables; on some database
it returns

"5 rows in set (0.02 sec)"

and if, on the same database i run
the command

select count(*) from 'table';
it returns

+-+
| count(*)|
+-+
| 47226322|
+-+
1 row in set (0.00 sec)

now, i believe its reasonable to assume
a CPU must spend more time to count 47 million records,
than to count 5 tables. This is why I believe
that many common selects are built-in to mysql in the code
somewhere. make sense? Its a good idea actually, that building
in commonly run selects when the process is idling and stuffing
results into variables that can be called in an instant, saves
us all time and money...

Jim


-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 3:28 PM
To: JamesD
Cc: [EMAIL PROTECTED]
Subject: Re: Can MySQL handle 120 million records?


On Wed, Dec 18, 2002 at 08:05:46PM -0800, JamesD wrote:
>
> i like mySQL, but it has a long way to go to gain the level of
> 'confidence' that oracle, db2 or mssql or sybase have when it comes
> to frontline mission critical stuff.

Can you explain why?

> I think it will in time...thats why i stick with it. besides,
> confidence is often just a synonym for 'knowledge'

Really?  I tend to see it more like confidence builds with experience
(and therefore time).  You don't need to know a lot about to become
confident in its operation.  Many of us don't *really* understand how
gravity works, but we're quite confident in it.

> select count(*) from x (0.00 seconds)
>
> if you dig into the source, you will probably find this common
> select is built in and running all the time,
>
> and we are all just getting a pre-filled variable
> returned from the method " select count(*) from (x) "

Please find it.  I'll bet you money that it's not.

> I hope someone can prove me wrong...

I think the burden of proof is on you.

Jeremy
--
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 5 days, processed 219,909,773 queries (441/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


-
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