A quick question on the performance of the SELECT statement.
I have a table with a set of 50 products, each product has about 10 attributes
associated with it.
The user will select certain aspects of a product (height, weight, colour,
length etc.), and many products may display a particular att
Brent Baisley wrote:
Not as far as I know. Boolean forces all matches to have all the words
searched on, rather than relevance ranking the results based on how many
of the specified search words are in a record. Searching in boolean mode
will always return the same or less results than a regula
Brent Baisley wrote:
The other thing to consider is the 50% rule. If more than 50% of the
records match, the search is consider irrelevant and no records are
returned. So if you have 120 records and 61 have DB2 in them, you won't
get a result set.
But the 50% rule is overridden when the search
Richard Davey wrote:
Hello Shane,
Wednesday, March 31, 2004, 5:43:10 AM, you wrote:
SA> using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.
SA> Is this expected behaviour? If so, is there a way to circumvent it?
By default, the full text indexing engine
I have a table with the following:
CREATE TABLE foo (
...
description text,
...
FULLTEXT INDEX (description),
...
);
select count(*) from foo where description like '%db2%';
returns 61 rows. Checking them confirms that the "word" db2 exists as a
standalone word separated either by punctuation or
I've read through the boolean mode fulltext docs, and they address all
my questions well except how searches containing exact phrases are
handled when there is more than one. I believe the following will work
as I expect, but was wondering if anyone can confirm it for me:
Given the following se
Any idea what this would do?
alter table tt union=(t1,t2,t3);
The four tables are all the same and all contain data. I posted the
details (schema, contents) of the tables here:
http://nopaste.php.cd/10918
I'm running mysql Ver 11.18 Distrib 3.23.58,
Shane
--
MySQL General Mailing Lis
ing anything
abnormal in the admin server logs, and I'm not sure where else to look.
Could someone point me in the right direction for solving this problem?
And I'm also looking to confirm that this is mysqld actually crashing
and restarting.
Thanks in advance,
Shane Iseminger
-
I have recently installed MySQL my mac running OS X 10.3 and can connect to
MySQL using the command:
/Library/MySQL/bin/mysql
However, once connected, I have tried to create a database and received the
error message:
ERROR 1044: Access denied for user: '@localhost' to database 'new_database'
I
At 09:24 PM 11/10/2003, Leo wrote:
notice the _and_ ?
*grin*
good point. I guess my reply (which I found out later was unnecessary since
the question had already been answered) would have been better stated had I
just pointed out the distinct keyword rather than constructing a sample
query. :)
At 07:45 PM 11/7/2003, Jonathan Terhorst wrote:
One way I have found to implement this is
SELECT Table1.id from Table1 JOIN Features USING(id) WHERE
Features.FeatureCode='A01' OR Features.FeatureCode='B02' GROUP BY Table1.id
HAVING COUNT(*)=2;
e.g. counting the duplications of id and selecting th
I've searched the archives and was unable to find anything that seemed
pertinent.
Earlier today I had to stop and start mysql. When I issued mysqladmin
shutdown, however, the process did not die cleanly (reason unknown), and I
ended up having to kill -9 mysqld and mysqld_safe.
When the DB came
what i think it might be (like username 'localhost'...), but they have
gotten me nowhere.
I really don't know what im doing here, so i would appreciate any advice.
Cheers
Shane
_
Get less junk mail with ninemsn Premiu
Running 4.0.15a. The second select's FOUND_ROWS() returns the wrong number of rows.
To test yourself:
create database test1234;
\r test1234
create table test (id int, primary key (id));
insert into test values (1), (2), (3), (4), (5);
select SQL_CALC_FOUND_ROWS * from test where id > 3 limit 0, 1
, changing
either setting would require a rebuild of the FT index(es), but then, so
does FT_MIN_WORD_LENGTH...
TIA
--
Shane Allen <[EMAIL PROTECTED]>
http://www.emphasys.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
We're considering switching to InnoDB tables for a couple of tables in
our database where we need transactions. We're complete newbies with
reference to innodb, although we are seasoned veterans with regards to
MySQL/MyISAM and general concepts.
We have come up with a couple questions that we have
I've actually noticed this in the past several releases; I apologize for
not mentioning it sooner.
I run:
BUILD/compile-pentium --with-other-libc=/usr/local/mysql-glibc-2.2.5
--prefix=/usr/local --with-extra-charsets=none --without-innodb --without-isam
and part-way through, it fails.
Specifical
7s" which will be parsed correctly in the SQL statement itself.
Hope this helps,
-Shane
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 18, 2003 2:08 AM
Subject: Re: Apstrophee Errors
> If you&
firewalling in occurance, Windows may still be the criminal, or at least the
Windows version of MySQL with it's default my.ini file.
If I've just been ranting uselessly, ignore me :)
-Shane
- Original Message -
From: "Primaria Falticeni" <[EMAIL PROTECTED]>
To:
Thanks, Mike. I should have checked the bug database first. I thought for sure we had
it working right before, but I think someone might have snuck a newer version of the
MySQL on the server without telling me. :-)
Oh well, go figure.
-Shane
---Original Message---
From: Mike Hillyer
Thanks, Mike. I should have checked the bug database first. I thought for sure we had
it working right before, but I think someone might have snuck a newer version of the
MySQL on the server without telling me. :-)
Oh well, go figure.
-Shane
---Original Message---
From: Mike Hillyer
configuration, as I recall it was
something commented out, perhaps the port number if I recall correctly.
-Shane
- Original Message -
From: "Renato" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, J
Are you running AIX?
This problem was just addressed, and is fixed in 4.0.13
I thought it was a name resolution problem, sorry for the misdirection on
whoever had this problem earlier.
-Shane
- Original Message -
From: "Shane Kirk" <[EMAIL PROTECTED]>
To: <[EMA
precompiled for FreeBSD packages. I will
be compiling 4.0.13 with linuxthreads to gain any benefits there as well.
Thanks,
-Shane
p.s. I always find a last question. Off topic, compiled properly for each machine,
would MySQL run better on a quad ppro 200 (IBM PC704), or a similarily stocked 2.
he extended documentation. The MySQL
team has documented it on the website very well, and you don't need to
install anything extra for the library, since it comes with MySQL.
Hope that helps,
-Shane
- Original Message -
From: "M. Bader" <[EMAIL PROTECTED]>
To:
too, for efficiency.
Best of luck,
-Shane
- Original Message -
From: "Phill Gillespie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 15, 2003 3:54 PM
Subject: Re: Simple MySQL help needed...
> Shane Bryldt wrote:
>
> >I think t
could have been coincidence, so
with a second opinion, if static char field is faster than using any text,
varchar or blob fields, I'll keep the code as it is with char fields.
Thanks,
-Shane
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
pSQL[256];
int iHighNum = ObtainHighestFromDB(void);
iHighNum++;
snprintf(pSQL, 256, "UPDATE Ops SET cardnumb=%d WHERE newphoto=1 and
tbprinted=1;", iHighNum);
This in effect leaves any processing possible to the client side.
Hope that helps,
-Shane
- Original Message
longer on a larger scale.
-Shane
- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 15, 2003 3:21 AM
Subject: Re: Question about INSERT vs UPDATE
> Consider going over Section 5.2.9 of the manual.
&
would update fewer records.
Anyone with some insight on this would be much appreciated if they could offer some
ways to speed up the process.
Thanks,
-Shane
>Description
This may be by design, but I figured I'd bring it up because it caused
less-than-desirable behaviour for me. I executed an alter table query, designed to
change the length of a fixed width char field to 128 from 255. The alter occured fine,
with no problems, except that there were a
How about this:
mysql> CREATE TABLE tablename (value1 int(10) AUTO_INCREMENT, value2 timestamp(14),
PRIMARY KEY (value1));
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT SQL_RETURN_INSERT_ID INTO tablename (value1, value2) VALUES (0, NOW());
+-+
| INSERT_ID() |
+-+
|
This is a repost of my previous message with a new and improved title
that will hopefully catch more eyes and generate a response. :)
> We have two users, lets call them test and test2.
>
> When we log in as test from our front end web servers, we can execute queries and
>they replicate.
>
> Wh
We have two users, lets call them test and test2.
When we log in as test from our front end web servers, we can execute queries and they
replicate.
When we log in as test from our back end db servers (say to run a cleanup script by
hand), the queries replicate.
When we log in as test2 from our
D INDEX combined (to_id, owner_id);
or
SELECT * FROM telegramme WHERE to_id = 3157 UNION SELECT * FROM telegramme WHERE
owner_id = 3157;
HTH
--
Shane Allen <[EMAIL PROTECTED]>
-
Before posting, please check:
http:
I am trying to build MySQL from a new clone of the bitkeeper repository, and am
running into some difficulty...
I am running Debian Woody, and am running unstable. Following are the relevant
utilities/versions installed on my system:
==
I haven't seen any traffic on this thread, so I figured I'd repost it
with a slightly more catchy subject. :)
Has anyone looked into this?
On Tue, Oct 08, 2002 at 09:12:13PM -0500, Shane Allen wrote:
> >Description:
>
> See "How-To-Repeat"
>
> >How
On Sat, Oct 05, 2002 at 03:47:18PM +0300, Heikki Tuuri wrote:
> Shane,
>
> > 021004 12:57:00 Slave: error 'Incorrect key file for table:
> 'listing_text'. Try to repair it' on query 'UPDATE sell.listing_text SET
> description='blah' WHERE lis
problem, however, adding:
ALTER TABLE question ADD INDEX combined (buyer_id, listing_id, last_modified);
did not.
>Fix:
Adding indexes (See "How-To-Repeat")
>Submitter-Id:
>Originator: Shane Allen <[EMAIL PROTECTED]>
>Organization: sell.com
>MySQL support: n
On Fri, Oct 04, 2002 at 12:36:30PM -0700, David McInnis wrote:
> Can someone please help me with the following? Normally I would do this
> with a nested select, but since this is not available in MySQL I think I
> need help.
>
> Here is what I have: An order table with sales tax total and an
>
On Thu, Oct 03, 2002 at 06:39:26PM -0500, Shane Allen wrote:
> We have a 4.0.4-beta master and slave.
>
> The slaving process starts correctly, but randomly (and frequently) has
> issues.
>
> When the server starts, it will slave, but eventually will hit one o
72
0x81aa79a __nss_lookup_function + 686
Reverting the slave to 4.0.3 fixed the instability AFAICT (it's only
been reverted for a brief period). The master has remained at 4.0.4
Let me know if you need further info.
Thanks
--
Shane Allen <[EMAIL PROTECTED]>
-
Apologies,
I thought I had done a decent search to see if anyone else had reported
it, but apparently my search skills are lacking, I see that it was fixed
in 4.0.4.
On Wed, Sep 25, 2002 at 11:34:07PM -0500, Shane Allen wrote:
> >Description:
>
> selecting distinct when executing
EY (i1)
);
insert into test1 values (1,'test');
insert into test1 values (2,'test');
insert into test2 values (1,'test');
insert into test2 values (2,'test');
select distinct * from test1 t1 left join test2 t2 on (t1.i1=t2.i1);
>Fix:
None known
>Submitter-
On Fri, Aug 02, 2002 at 10:59:18PM +0200, Georg Richter wrote:
> On Friday, 2. August 2002 20:48, Shane Allen wrote:
> > I digress... at this point, the question that plagues me is: Is it normal
> > for MySQL to die under high load?
>
> you have a lot of programs, which pref
[mysqlhotcopy]
interactive-timeout
[safe_mysqld]
open-files-limit=8192
err-log=/usr/local/var/mysqld.err
--
Shane Allen <[EMAIL PROTECTED]>
sell.com : Buy & Sell Anything
http://www.sell.com
-
Before posting, pl
ly help either - it only gives a
small performance increase. If it makes any odds, the SQL only talks to 3
tables, all are properly indexed and there's enough RAM to keep it all from
swapping.
Any help appreciated, thanks.
- --
Shane
http://www.shanewright.co.uk/
Public key: http://ww
om my config.log with regards to the gethost* function(s)
Thanks
On Sat, Jun 22, 2002 at 02:40:38AM -0500, Shane Allen wrote:
> configure:12730: checking style of gethost* routines
> configure:12773: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions
>-fno-rtti
> -fpermissive -
pro -O3 -fno-omit-frame-poi
> nter -fno-implicit-templates -fno-exceptions -fno-rtti
> -DUSE_MYSYS_NEW -Werror conftest.cc >&5
> configure:15312: $? = 0
> configure:15315: test -s conftest.o
> configure:15318: $? = 0
> configure:15328: result: glibc2
>
> )
>
> Regards,
&g
27;
libmysql.c:1325: warning: assignment makes pointer from integer without a cast
make[2]: *** [libmysql.lo] Error 1
make[2]: Leaving directory `/usr/local/src/mysql-3.23.51/libmysql_r'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/mysql-3.23.51'
make: *** [al
t I'm wondering
why the discrepancy?
--
Shane Allen <[EMAIL PROTECTED]>
sell.com : Buy & Sell Anything
http://www.sell.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Gemini, but if I can't get the source to
compile with gemini enabled, maybe that's my answer. :) However, If anyone
knows how to
do it I would still appreciate the help.
Thanks,
Shane Corgatelli
[EMAIL PROTECTED]
4125:34: macro "uint8korr" passed 2 arguments, but takes just 1
make[3]: *** [field.o] Error 1
make[3]: Leaving directory `/home/shane/mysql-3.23.42/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory `/home/shane/mysql-3.23.42/sql'
make[1]: *** [all-recursive]
If gemini_init fails, mysqld sets gemini to disabled. It
seems to do this if any table type fails on initialization.
Now what this piece of code is trying to do I have no idea.
Shane
--
Shane Wegner: [EMAIL PROTECTED]
http://www.cm.nu/~shane/
PGP:
ing!
u don't need to make any modifications to your code if you are using the
mmmysql driver which can be located at
http://mmmysql.sourceforge.net/
regards
shane
-Original Message-
From: Sibel Toprakkiran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 5:09 PM
To: [EMAIL PROTEC
if you need a record id which increments automatically, then you can use the
int types( tiny, medium or int) with the attribute that it be unsigned and
auto_increment like this:
record_id mediumint unsigned not null auto_increment
regards
shane
-Original Message-
From: Peter Wiherkoski
if you are working on windows, unzip the file using winzip classic and then
use the extract function to extract the files to a desired directory. after
that, just click on setup.exe to setup mysql.
regards
shane
-Original Message-
From: Maggie Cheang [mailto:[EMAIL PROTECTED]]
Sent
thing but my fix was different. Try
going into gemini/incl/pscsys.h and look for this:
+#ifndef bzero
#define bzero(s,n) memset((s),(int)0,(n))
#endif
Just pop that bit out so it doesn't bother defining it.
Assuming you have bzero which you appear to. Put config.h
back the way it was and
ng?
3. running mysql client on a local computer and connecting to the pc hosting
the mysql server. how do you connect in thisway then?
thks for any advice.
shane
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi,
i've installed mysql on a win2000 os and downloaded myodbc zip file and went
through the process of setting it up. it says sucessful installation but the
environment tab of my mysqladmin says that myodbc is not found. what do i
need to do?
thks
gt; To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
could you pls send us the samples again, thks
shane
-Original Message-
From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 20, 2001 11:45 AM
To: Ric
Hi, the driver which i am using is type IV. do i still need to install
myodbc?
thks
-Original Message-
From: Venu Anuganti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 2:04 PM
To: shane
Cc: [EMAIL PROTECTED]
Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for
.
regards
shane
-Original Message-
From: Kalpesh Modha [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 5:00 PM
To: 'raghavan'; [EMAIL PROTECTED]
Subject: RE: jdbc connectivity
Hello.
I have the same problem let me know if you find a solution. Mine is on
redhat 7.1
lly do appreciate any kind of help.
thks a million
Shane
-
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 <
nection.connectionInit(Connection.java:89)
at org.gjt.mm.mysql.Driver.connect(Driver.java:167)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at Connected.main(Connected.java:16)
thks
this is my code:
import java.sql.*;
import java.util.*;
public class Connected {
public static void main (String[] args) throws Exception{
Connection con = null;
try{
String url = "jdbc:mysql://localhost:3306/mydatabase";
1.html file and find programming information under programming
interface.
shane
-Original Message-
From: Daniel Aderhold [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 1:39 AM
To: Siomara Pantarotto
Cc: [EMAIL PROTECTED]
Subject: RE: java connection
Must I install additionally
Hi,
got the same problem too after i rebooted my linux RH7.
i solved it by restarting the server :
bin/safe_mysqld --user=mysqladm &
I got the command from Paul Dubois book on MySQL
hope it helps
-Original Message-
From: Roberto Carlos Sánchez Barroso [mailto:[EMAIL PROTECTED]]
Sent: Wed
i've written a java file to connect to the database in a linux rh7 os. the
file runs fine on a win2000 os so i think that there is no problem with the
code. I've set my class path to the dir where i've downloaded the
mm.mysql.jar file and the path set to my jdk1.3.1/bin and jdk1.3.1/lib
directorie
- Original Message -
From: "Shane Peacock" <[EMAIL PROTECTED]>
To: "Simon K. Chan" <[EMAIL PROTECTED]>
Sent: Saturday, June 23, 2001 6:18 PM
Subject: Re: can't connect to local MySQL-Server
> Hi Simon,
>
> Yes, i did all did
ql-daemon ended
When i run mysqladmin version i get the message:
connect to local MySQL-Server failed
error: can't connect to local MySQL-Server throuhg socket: 'tmp/mysql.sock'
This socket does not exist in /tmp
what must i do to get MySQL started?
MfG
Shane
olumns.
Cheers,
Shane
--
Shane Wegner: [EMAIL PROTECTED]
http://www.cm.nu/~shane/
PGP: 1024D/FFE3035D
A0ED DAC4 77EC D674 5487
5B5C 4F89 9A4E FFE3 035D
-
Before posting, please
hindered
enough to need to split records between several smaller tables? Any
information leading to an optimal solution would be greatly appreciated.
Thanks
Shane Anderson
Software Developer
Web Accessibility in Mind - http://www.WebAIM.org
Does it help to put an Index on a column when you
use a LIKE query.
ex. SELECT * FROM users WHERE name LIKE '%tom%'
Thanks in Advance!
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
I am trying to restore my database using the binary
log. I have restored the last full backup and want to
rerun the updates from that point. I have tried
running this command (mysqlbinlog log-file | mysql -h
server_name), which is shown in the manual but it
doesn't seem to work. Any suggestions
I am trying to figure out how to do this so I can do
incremental backups. Any ideas would be appreciated.
Thanks,
Shane
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com
I am trying to figure out how to use the binary log
for incremental backups. I have read the section for
this in the manaul but I have not been able to get it
to work. My main problem is I don't know the exact
command to use or exactly how the process works. Any
suggestoins on how to set this u
77 matches
Mail list logo
