On Sat, 19 Sep 2009, b wrote:
I'm trying to select all members who have not registered for an event. I
have tables 'members', 'events', and 'events_members', the latter a join
table with event_id and member_id columns.
The closest I've gotten is with this query:
SELECT m.id, m.first_name, m.
On Tue, 16 Jun 2009, Thomas Spahni wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk on any
table I get the following warnings:
Warning: option 'key_buffer_size': unsigned value 18446744073709551615
adjusted to 4294963200
Warning: option 'read_buffer_
On Wed, 17 Jun 2009, Johan De Meersman wrote:
Aren't those options defined in megabytes ?
On Tue, Jun 16, 2009 at 4:59 PM, Thomas Spahni wrote:
Hi
I have MySQL 5.0.64 compiled from source. When I run myisamchk
on any
table I get the following warnings:
Wa
_size=20971520
sort_buffer_size=20971520
read_buffer_size=2097152
write_buffer_size=2097152
What's wrong here?
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Thu, 14 May 2009, Ilia KATZ wrote:
Hi.
Currently I have a table:
1. MAC address defined as BIGINT
2. MAC address set as primary key
Should I consider changing it to CHAR(12)?
Replies will be appreciated.
Ilia
Hi
It depends. You may convert the MAC address to a decimal integer and store
Hi Scott
You may use the script below to reload replication if you can ensure that
the master db doesn't change during the dump operation. Otherwise you may
set a lock on the master manually.
Regards, Thomas
#!/bin/bash
#
# replicate-reload
#
# This is free software. There is no warranty a
Hi
I have configured MySQL to ignore stopwords from file
/etc/my.stopwords. While playing around with myisam_ftdump
I found that my fulltext index contains about a dozen words which are so
common that they have a negative weight.
Would it be a good idea to include these words in the stopwords
On Wed, 8 Apr 2009, Pete Wilson wrote:
Hi everyone --
I'm a MySQL noob. I have MySQL queries in my C code and I was surprised
to find I'm getting a success return from:
mysql_query(pmysql, "select * from usrs where(usr=\"illegal name\"");
In this table called "usrs," "usr" is the primary k
Hi
How can I specify 'unprintable' characters is a MySQL regexp ?
Query is (example only):
SELECT something FROM table WHERE column REGEXP 'Ã\\xA0';
I'm looking for an equivalent of the search part of a sed expression like
this:
s/Ã\xA0/à/g
which means I want to include a character with co
On Fri, 13 Mar 2009, mich...@j3ksolutions.com wrote:
Explanation(5): The more you understand how the database is to be used,
and the more complexity and thought you put into your database design, the
less complex it will be to retrieve reliable information out of it.
Furthermore, (and this is pr
On Mon, 9 Mar 2009, Sven wrote:
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
kind regards
Sven Aluoor
Hi
What about 'mysqladmin ping' ?
Regards,
Thomas Spahni
--
MySQL
ans that the query result is not cached. It does not mean
that the cache is not used to answer the query.
You may use RESET QUERY CACHE to remove all queries from the cache and
then your next query should be slow again. Same effect if you change
the table, because this makes all cached queries in
access to the replication user password on SLAVE and
has no access to MASTER (otherwise mysql -h MASTER -e "SHOW MASTER
STATUS," would do the trick).
Any other way to make the SLAVE tell me what is's replicating?
TIA
Thomas Spahni
--
MySQL General Mailing List
For list archive
On Tue, 4 Nov 2008, Jesse wrote:
> > prompt> perror 139
> > MySQL error code 139: Too big row
> >
> > Seems you are exceeding some limit.
>
> Where did you run the "perror" command from? I tried to run that in the
> MySQL command line utility and got an error?
>
> At any rate, the field in que
On Mon, 3 Nov 2008, Jesse wrote:
> I have an ASP.net web application running on a WS03 server using MySQL
> 5.0.67-community-nt-log.
>
> I have a form that allows the customer to use a visual HTML editor to input
> text that will appear on a web page. So, the text contains HTML tags. When
> it
is
wrong?
Thank you for any help.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--+--+
4 rows in set (0.00 sec)
i.e. row 3 of atable should be updated 2 times, adding 6 and 7, as there
are 2 rows in btable where column a is = 3.
How can I do this? Any help is apreciated.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
gt; select id, name from tableName where name like 'a%' or name like 'b%' or
> name like 'c%';
no. You have to use LIKE.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TAB=' '
WHITESPACE="${BLANK}${TAB}"
DATE=$(cat mydatafile.csv | sed \
-e "3 !d" \
-e "s/^[$WHITESPACE]*//" \
-e "s/.*/'&'/")
DATA=$(cat mydatafile.csv | sed \
-e "/[A-Z]/ d" \
-e "
e following:
SELECT reference.uid FROM reference
INNER JOIN ref_cat ON reference.ref_cat_id = ref_cat.ref_cat_id
INNER JOIN subject_name ON ref_cat.sub_id = subject_name.sub_id
WHERE subject_name.sub_id = 45
AND ref_cat.ref_cat_id = 3;
HTH
Thomas Spahni
--
MySQL General Mailing Li
*** 2. row ***
table: t2
type: ALL
possible_keys: locktwo
key: NULL
key_len: NULL
ref: NULL
rows: 5
Extra: Using where
This looks quite good for t1 but does not use any index for t2.
How should I set up my index to improve this situation?
Any help is appreciated.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dave,
what is the result of
prompt> set | grep LANG
? I suspect your problem is not within MySQL. Did you look at your
testfile using a editor?
Thomas Spahni
On Wed, 4 Jan 2006, Dave M G wrote:
> MySQL List,
>
> I have recently switched over from Windows to Ubuntu Linux,
ld become something like
const char *ft_boolean_syntax="+ =><()~*:\"\"&|";
Then recompile and try your luck. You have to rebuild your indexes.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Merlin,
you can create your own stopword file (one word per line) and activate it
in my.cnf like this:
# The MySQL server
[mysqld]
set-variable= ft_stopword_file=/etc/my.stopwords
HTH,
Thomas
On Fri, 28 Oct 2005, Merlin wrote:
> Hi there,
>
> as mysql docs describe, there is a stop wo
Hi suomi,
it can be done with a temporary table. See the following example.
Regards,
Thomas Spahni
USE test;
CREATE TABLE duprows (
id INT NULL AUTO_INCREMENT PRIMARY KEY,
content VARCHAR(255)
) TYPE=MyISAM;
INSERT INTO duprows VALUES(NULL, 'some text'),(NULL, &
the contents of CHAR, VARCHAR and
TEXT columns. In case of parse errors it should return the unchanged
string as a default.
What do others think? Any comments are welcome.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
et=/data/mysql/mysqldata/mysql.sock
Regards,
Thomas Spahni
On Sat, 2 Apr 2005, kaustubh shinde wrote:
> Hi,
> I have suse 9.2 and MySQL 4.21
> My basedir is /var/lib/mysql
> datadir /data/mysql/mysqldata
> Both the directories and subdirectories and files are owned by user mysq,l
&g
at\\'s nice'
None of those results can be re-inserted as is. The only possibility to
fix this would probably be to add a new option (how about --medium-raw ?)
to the mysql client. All else would break existing scripts.
Thomas Spahni
On Tue, 15 Mar 2005, Thomas Spahni wrote:
>
escaped
with ONE backslash. But now, look at this:
shell> mysql -N -B -e "SELECT QUOTE(sometext) FROM foo;" test
'Pitt\\'s Place'
Double backslash in batch mode. Same result if I pipe the query into
mysql. Why? This can't be fed into any INSERT query. Bug
ul to give some
extra relevance to those hits where the 'distance' between words is small.
Best regards,
Thomas Spahni
On Tue, 1 Mar 2005, Sergei Golubchik wrote:
> Hi!
>
> On Feb 26, leegold wrote:
> > Is there any way to make relevance when using boolean mode more usefu
st path is using
> Perl, but I would think this has been done before, just can't find it on
> google.
I use procmail to forward a copy of certain mail messages to the following
shell script which you can use as a starting point.
Cheers,
Thomas Spahni
#!/bin/sh
# This shell script i
***
txt: Some TextNULand some more
1 row in set (0.00 sec)
Cheers,
Thomas Spahni
On Thu, 10 Feb 2005, zzapper wrote:
> On Thu, 10 Feb 2005 10:17:00 +, wrote:
>
> >Hi,
> >I've successfully used the following update-replace statement to replace
> >st
/dev.mysql.com/doc/mysql/en/Replication_HOWTO.html>
Regrads,
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, 15 Dec 2004, EP wrote:
> Thomas Spahni <[EMAIL PROTECTED]> wrote:
>
> > the column type will limit the number of characters per row. A column
> > of type TEXT will hold up to 65,535 characters but with LONGTEXT you
> > can put up to 4,294,967,295 cha
very well.
Thomas Spahni
On Tue, 14 Dec 2004, EP wrote:
> I've looked in the documentation but didn't see any indication of the
> limits of Full-Text Search in terms of how many characters/words it can
> process per row.
>
> For example, if I have a column with 4,00
this context
before the comparison is made? I can certainly do it in my application but
I think that it would be a consistent behaviour if MySQL would do it. Any
opinions from the list?
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
reading your tables to different disk.
The recommended way to do this is to just symlink databases to a
different disk. Symlink tables only as a last resort.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Randy,
could it be that the word 'bird' appears in more than half of all rows in
your dataset? I strongly recommend to spend a few minutes reading the
manual about Fulltext Search.
Regards,
Thomas
On Mon, 20 Sep 2004, Randy Paries wrote:
> Hello
>
> I have a table
> CREATE TABLE community_file
ave to protect your server.
Regards,
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Uma,
the answer is 42 (or - probably - "mysqldump --help | less").
But what is your problem? Are you dumping in --extended-insert mode?
Can you give us an example?
Regards, Thomas
On Tue, 14 Sep 2004, T UmaShankari wrote:
>
> Hello ,
>
>I am having some 10 rows of data in my database tabl
John,
give it a try. I had to enable ft_min_word_len=2 on a collection of legal
texts because people are searching for abbreviations consisting of 2
letters. It works fine for me.
Thomas Spahni
On Mon, 13 Sep 2004 [EMAIL PROTECTED] wrote:
> I'm wondering whether or not I should i
Lee,
why not? That is what ft-search is meant for.
Regards, Thomas Spahni
On Tue, 7 Sep 2004, leegold wrote:
> I asked a ques, in a previous post but maybe I should simplify the
> question. Am I totallly crazy to use FullText for specific keyword
> searchs? Let's say I have a
TH GRANT OPTION;" \
| $MYSQL ; then
echo -e "\nfailed to GRANT rights for '$USER'"
exit 1
else
echo " has Password '$PW'"
echo "INSERT INTO usrpwd VALUES('$USER&#x
Ari, what's the result of
mysql -N -e "SHOW VARIABLES;" | grep 'ft_min_word_len'
? Default is 4 but you need to reduce this to 3 (or even to 2, if you
want to match first_name against('Al')).
Regards, Thomas Spahni
On Sun, 5 Sep 2004, Ari Denison wrote:
>
l-bin.003' and the offset is 73. Record the values. You will
need to use them later when you are setting up the slave.
Once you have taken the snapshot and recorded the log name and
offset, you can re-enable write activity on the master:
mysql> UNLOCK TABLES;
Regar
Jesse,
mysql> SHOW INDEX FROM mytable;
gives you all indexes for `mytable`; you can process the results with
perl.
Thomas Spahni
On Mon, 23 Aug 2004, Jesse Sheidlower wrote:
> I have a database where, most of the time, I'm bulk-loading
> data into new tables from an external s
LEFT JOIN msg_body ON msg_header.bodyid = msg_body.id
WHERE msg_header.list LIKE 'LISTNAME%'
AND MATCH(msg_body.body) AGAINST('WORD');
Regards, Thomas Spahni
On Fri, 20 Aug 2004, Fredrik Carlsson wrote:
> Hi all,
>
> I'm running a small mail archive a
Hi Daniel,
try this:
prompt> mysqladmin kill [id],[id]
(for usage see mysqladmin --help | less)
Cheers,
Thomas Spahni
On Mon, 16 Aug 2004, Beuter Daniel wrote:
> Hallo miteinander dies ist mein erster Thread.
> Weil ich nimmer weiter weiß wende ich mich an Euch.
> Hab nen Traffi
d I change the
> name from mysqladmin to mysql or something similar? I'll try.
>
> Laurent
Laurent,
with a fresh install, use 'root' as username and no password. Be sure to
set a password later.
Thomas Spahni
--
MySQL General Mailing List
For list archives: ht
list is global and will affect all tables.
As for me, in your situation I would prefer another aproach distributing
your text to several TEXT columns. Then your headers become column names.
Cheers, Thomas Spahni
On Mon, 12 Jul 2004, leegold wrote:
> Please let me show you one (TEXT
how I might approach it?
what about:
SELECT CONCAT( UPPER( LEFT(field,1) ),
LOWER( SUBSTRING(field,2) ) ) AS Something FROM ...
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mpared the performance of different file systems using MySQL. You
may want to check the archives.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e one computer that
contains several CPUs and use an operating system that handles threads
efficiently."
Alternatively you can spend on storage and replicate all data to 40 slave
servers.
Regards,
Thomas Spahni
On Thu, 27 May 2004, tachu wrote:
> WOuld the following scenario be possible
>
*/','/" \
-e "s/^/INSERT INTO categories VALUES('/" \
-e "s/$/');/" | mysql database
That's what sed is good for.
Regards,
Thomas Spahni
On Thu, 27 May 2004, Haplo wrote:
> Hi,
> I am trying to add this info into a table and I know there is a
Andre,
have a look at JOIN. This can solve your problem.
Thomas Spahni
On Fri, 30 Apr 2004, Andre MATOS wrote:
> Is it possible to create a Select performing a math formula? For example:
>
> First I need to add two values come from the same table but from different
> records. The
Hi Liz,
a column of type BLOB takes a maximum of 65535 bytes; try MEDIUMBLOB or
even LONGBLOB.
Regards, Thomas Spahni
On Tue, 20 Apr 2004 [EMAIL PROTECTED] wrote:
> hi,
> I am trying to enter genome sequences of length 170 and more into
> mysql database.
>
> I have
Jochen,
what's the result of
prompt> mysql -uroot -pXXX -hxxx.xxx.xxx.xxx
when you do it on the client host? (I still suspect that permissions are
not properly granted).
Regards, Thomas Spahni
On Wed, 17 Mar 2004, Jochen Kaechelin wrote:
> I use the following Script to backup a r
Stefan,
it depends ...
For MyISAM tables max size is limited by the maximum filesize of your
OS/Filesystem.
Regards,
Thomas
On Fri, 12 Mar 2004, Baum, Stefan wrote:
> Hi,
>
> I'm planning to use MySQL for logging from an SMTP-Relay.
> What is the maximum size of the database, that can be re
did you 1. read the manual and
2. run mysql_install_db ?
Regards, Thomas Spahni
On Wed, 3 Mar 2004, Liew Toh Seng wrote:
> > How to fix this problem
> >
> >
> > 040303 17:40:51 mysqld started
> > InnoDB: The first specified data file ./ibdata1 did not exi
Adam,
use the mysql client tool.
yourbox> mysql -h host -u user -pPasswd yourdatabase < sqlfile.sql
Cheers, Thomas Spahni
On Thu, 12 Feb 2004, Adam Staunton wrote:
> Hi all,
>
> I have an sql file that I exported from a database of mine that has over
> 3000 lines (records)
Mike,
you are close: you want the mysql client to give back just the data, no
column description. Change this line to read:
MYSQL="/usr/local/mysql/bin/mysql --user=$username --password=$password
--host=$server --skip-column-names cetechnology"
On Tue, 10 Feb 2004, Mike Tuller wrote:
> Ok. I
Michael,
have a look at the sources, especially myisam/ft_parser.c near line 108
and at myisam/ftdefs.h. It should not be difficult to hack the sources to
make the hyphen a real character. This will solve your problem (but could
create some new ones on others types of text input).
Thomas
On Wed
Hi,
is there any change in data format for MySQL 5.0.0? Is it safe (for a user
of stable 4.0.17) to test 5.0.0 on existing data and then go back to
4.0.17 for production?
Thanks, Thomas
On Wed, 24 Dec 2003, Michael Widenius wrote:
> Hi,
>
> MySQL 5.0.0, a new version of the popular Open Source/
your
environment.
Thomas Spahni
On Fri, 12 Dec 2003, Victor Medina wrote:
> Change myisam format to something else, like InoDB or BDB
>
> Best Regards!
>
> On Fri, 2003-12-12 at 15:05, James E Hicks III wrote:
> > I'm having sporadic myisam table corruption. This table i
essing a running system from the client. Use GRANT to set
a password for root and to add new users.
Where is the problem?
Liebe Grüsse
Thomas Spahni
On Sun, 7 Dec 2003, Franz Edler wrote:
> I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it
> very comfortable for
his in perl.
Thomas Spahni
--
filter: MySQL, Query
Shell script:
#!/bin/bash
# printtable
#
# usage: printtable []
#
# use a select query to generate desired
# example:
# echo "SELECT * FROM mytable;"
code should invoke a cgi script which in turn pulls a pathname from the
database, gets the data from the file, converts it to HTML and returns it
to the httpd.
Sorry, but I can't be more specific
Thomas Spahni
On Mon, 1 Dec 2003, Matthew Stuart wrote:
> I am going to take over an exi
look to the application event log. Where could I found this
> apllication event log.
Sylvain,
there should be an error log in your datadir. Use 'mysqladmin variables'
to find out where MySQL keeps its data.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql
Mark,
what's the output of
shell> mysqladmin version
It appears that you still have a version of 4.0.4-beta running.
Try
shell> find /usr /sbin /bin -name mysqld
to see whether there is more than one copy of mysqld hanging around.
Regards,
Thomas Spahni
On Wed, 19 Nov 2003, Ma
em with SuSE
distributions when installing over an old prm installation, because they
used to have a different directory layout. I can't tell you how RedHat did
this.
Thomas Spahni
> Thanks,
> Mark
>
>
> As of November 1st, 2003, Brandywine Senior Care's Corporate Office n
Mark,
I have not that many records but I can offer you ~29 million rows of
wordwide meteorological data. They can be bzip2'd to 300 MB and
are very tricky to summarize in a meaningful way. If you're interested pls
mail me off-line.
Regards,
Thomas Spahni
On Sat, 8 Nov 2003, Mark Ho
Dan,
SELECT ResourceTable.* FROM ResourceTable
LEFT JOIN ResourceLinkTable
ON ResourceTable.ResourceID = ResourceLinkTable.ResourceID
WHERE ResourceLinkTable.ResourceID IS NULL;
Regards,
Thomas
On Thu, 30 Oct 2003, Dan Lamb wrote:
> Hello All,
>
> I have two table the look like thi
-case-sensitive fashion.
Thomas Spahni
On Mon, 20 Oct 2003, Simon Green wrote:
> CONCAT turns every this in to a string then puts them together?
> LIKE is not case sensitive with string?
> When is this turned in to BINARY?
>
> What have I missed please
> Simon
>
> -Origina
? (besides
translating all characters to LOWER which is IMHO no elegant solution).
TIA
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I remember that some weeks ago Heikki announced it is on his todo list but
in the far future unless someone is funding the project.
Thomas Spahni
On Thu, 4 Sep 2003, electroteque wrote:
> Hi i was wondering if there was ever going to be a time when Innodb can also
> be fulltext ind
--> might be equal to the max number of directories you file system
supports.
Thomas Spahni
On Tue, 2 Sep 2003, Keith Schuster wrote:
> Is there a max number of databases that will run under mysql
> ---
> Keith Schuster
> Schuster & Company LL
together in the text (but not necessarily close to
the top).
Regards,
Thomas Spahni
On Sun, 24 Aug 2003, Matt W wrote:
> Hi all,
>
> I'm planning to use MySQL's full-text search for my forum system
> (possibly 5+ million posts). I've been playing with it a lot lately to
&
Iulian,
this is in the manual. Look at
Database Administration
Localisation
Character arrays
Regards,
Thomas Spahni
On Wed, 30 Jul 2003, Primaria Falticeni wrote:
> I can copy the latin2.conf into new one, but I need to know what each code
> from the conf file represen
Hi,
join two tables in your select. Might look like
insert into mm_tagrules
select ID, 'NIL', 'D' from mm_Tag
left join mm_tagrules on mm_Tag.ID = mm_tagrules.Tagid
where mm_tagrules.Tagid IS NULL;
Regards,
Thomas Spahni
On Tue, 29 Jul 2003, jsmurthy wrote:
> Hello
Iulian,
take the source code, go to 'sql/share/charsets' and create your own
character set 'romanian.conf' departing from 'latin2.conf' (or whatever is
closest to what you need).
Regards,
Thomas Spahni
On Mon, 28 Jul 2003, Primaria Falticeni wrote:
> Hell
applicable for ...
Regards,
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
you have to escape your binary data; check mysql_real_escape_string()
function in the manual and the archives. This is a frequently asked
question.
Thomas Spahni
On 14 Jul 2003, Sreesekhar Palaparthy wrote:
> Hi,
> How do i insert binary data into a BLOB field??? Like , if i
Asif,
try this:
prompt> echo "select * from Tickets limit 1;" | mysql mydb > result.file
You get everything in ONE line.
Cheers,
Thomas
On Tue, 3 Jun 2003, Asif Iqbal wrote:
>
> mysql> select * from Tickets limit 1;
> ++-+---++++---+
Delz,
what's the reason to put *.doc into a database? Format of *doc is a PITA
and you can't search it.
Store the path to the file instead along with a copy of it's content in
plain ASCII and run a fulltext index on that. Have a look at wvWare to do
the conversion.
Thomas Spahni
lect * from ft where match(r1) against('4þ0þ*' in boolean mode);
yields:
*** 1. row ***
r1: on mysql version 4þ0þ12
1 row in set (0.00 sec)
and its up to your client application to convert those 'þ' char(FE) back
to '.'
he same performance drawback,
> how does LIKE operator work with indexes?
exactly. LIKE '%something' will not use indexes but LIKE 'some%' will.
Thomas Spahni
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this list (example: doch weil aber dennoch) are added to the stopword
list. ft_min_word_len is set to 3.
What exactly are the problems you are seeing?
Have a nice day
Thomas Spahni
On Thu, 27 Mar 2003, Christian Jaeger wrote:
> At 22:26 Uhr -0600 25.03.2003, mos wrote:
> >How many p
's are
> present.
>
> Thomas Spahni wrote:
> > On Wed, 26 Mar 2003, Paul wrote:
> >
> >
> >>Can anyone tell me where I can get 4.0.12 server and client rpm's?
> >
> >
> > www.mysql.com
> >
> > Regards,
> > Thomas
> >
On Wed, 26 Mar 2003, Paul wrote:
> Can anyone tell me where I can get 4.0.12 server and client rpm's?
www.mysql.com
Regards,
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisam_max_sort_file_size
to a size appropriate for the size of your table. Double check
that you have enough disk space.
In my case I could reduce the time needed to create a fulltext index from
18 hrs to a few minutes.
Thomas Spahni
On Sun, 23 Mar 2003, Nick Arnett wrote:
> > -Original Message-
&g
Benjamin,
you are right: make distclean did the trick
Best regards,
Thomas
On Thu, 20 Mar 2003, Benjamin Pflugmann wrote:
> On Thu 2003-03-20 at 15:59:29 +0100, [EMAIL PROTECTED] wrote:
> > Hi,
> >
> > I was upgrading from 4.0.10 to 4.0.12 when a strange thing happened. I
> > compiled from sour
here?
TIA
Thomas Spahni
--
sql,query
-
int a=1,b,c=2800,d,e,f[2801],g;main(){for(;b-c;)f[b++]=a/5;
for(;d=0,g=c*2;c-=14,printf("%.4d",e+d/a),e=d%a)for(b=c;d+=f[b]*a,
f[b]=d%--g,d/=g--,--b;d*=b);}
-
Before
On Thu, 6 Mar 2003, Fabian Schmidt wrote:
> Am 05.03.03 schrieb Thomas Spahni:
>
> > Some words like "Tetraeder" have the combination 'ae' and should be found
> > looking for LIKE '%ae%'; surprisingly this works:
>
> Queries with "LIKE &#
in set (0.00 sec)
Whenever there is a joker it works:
mysql> select * from test where word like '%ae';
*** 1. row ***
word: ae
1 row in set (0.00 sec)
mysql> select * from test where word like 'ae%';
***
sed on the
> mysqldump man pages when restoring data back to the database. I
> use --extended-insert in my sql dumps.
unfortunately this is not an option in my case. Raw data contains certain
errors and this will trigger an error upon insertion, which can be dealt
with by the script when I d
to make this as fast as
possible? I'm already using --disable-auto-rehash, but what other
options could help?
Thomas Spahni
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Paulino,
do you have any auto_increment index of type SMALLINT ???
.. and what's in the error.log ?
Thomas Spahni
(sql, query)
On Thu, 27 Feb 2003, Paulino Michelazzo wrote:
> People
>
> I have a txt file with 250.000 lines but, I'm import only 32767 lines.
> The datab
a comparable machine holding 200
MB of text plus index.
Can you check for the response time on a not so common single word?
Thomas Spahni
(sql, query)
On Thu, 27 Feb 2003, Jesse Sheidlower wrote:
> On Thu, Feb 27, 2003 at 04:45:37PM +0100, Thomas Spahni wrote:
> > Jesse,
> >
> >
Jesse,
this is slow because you are SEARCH'ing for 'COUNT(*)' on a word occurring
many many times.
SELECT * FROM q WHERE MATCH(qt) AGAINST ('computer') LIMIT 100;
should be fast. Make sure to use a key_buffer_size as big as you can
afford, possibly keeping the whole
ugh with RAM your database may deliver much
more data than your bandwith can transmit unless you have a very good
feed.
Perhaps you provide us with some more details about your setup; otherwise
you can't expect more specific answers.
Thomas Spahni
--
sql, query (filter-food)
int a=1,b,c=2
1 - 100 of 222 matches
Mail list logo
