have you checked the error log for anything
related?
Matt
- Original Message -
From: "sascha mantscheff"
Sent: Friday, April 09, 2004 4:21 PM
Subject: Fulltext index is not being built with large database
I'm trying to build a fulltext index on a table with about 4 million
it to a partition with 50GB space
(about 15 times as much as the database tables).
Mysql runs on gentoo-linux 2.4 with 800MB RAM with server version 4.0.17.
Any clues, hints or tips?
Thank you.
sascha mantscheff
hahnenbach
51570 windeck
[EMAIL PROTECTED]
telefon +49-2292-922 492
telefax +49-229
Am Sonntag, 16. Februar 2003 21:15 schrieb Paul DuBois:
> At 20:43 +0100 2/16/03, sascha mantscheff wrote:
> >The following query works with mysql 3.23:
> > SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer )
> >It does not with mysql 3.22.27. Neither
The following query works with mysql 3.23:
SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer )
It does not with mysql 3.22.27. Neither does any query with a function call
in the order by clause. Is this documented somewhere? Am I missing something?
Is there a workaround other t
Am Freitag, 22. März 2002 11:58 schrieben Sie:
> > Egor:
> > Thanks for the hint. I browsed the manual for readline(3) and for
> > /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all
> > other programs and from the bash command-line - only in mysql they don't
> > work. Where
can't you filter the output with sed?
s.m.
Am Donnerstag, 21. März 2002 21:11 schrieben Sie:
> Is there a way to tell MySQL to put a blank space instead of \N in the
> tab-delimited files when it does a dump? I'm working on a MySQL to SQL
> Server migration and having problems with the output fi
Egor:
Thanks for the hint. I browsed the manual for readline(3) and for
/etc/inputrc, but found nothing wrong with it. I can enter umlauts in all
other programs and from the bash command-line - only in mysql they don't
work. Where else might I look for the source of the problem?
s.m.
Am Don
in the postrotate section, you have to add the user and password parameters
to mysqladmin:
mysqladmin -u someuser --password=somepassword flush-logs
s.m.
Am Donnerstag, 21. März 2002 19:23 schrieben Sie:
> Hello there!
>
>
> I have added recently administrative user to mysql database:
ue, by default LINUX sets the language
> environment for the shell to an ISO setting, FreeBSD does not.
>
> Ken
> ----- Original Message -
> From: "sascha mantscheff" <[EMAIL PROTECTED]>
> To: "Harald Fuchs" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PR
I run mysql on a SuSe 7.3 and a FreeBSD 4.5 server.
The FreeBSD mysql version is 3.23.49.
The linux mysql version is 3.23.33.
I just copied a large table using mysqldump | mysql from the linux server to
the FreeBSD server.
An explain statement on a select on this table shows different row cou
Am Mittwoch, 20. März 2002 11:24 schrieben Sie:
> > I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
> > mysql does not let me enter german umlauts, though. I tried to start it
> > with "mysql --default-character-set=latin_de", but it complained about
> > the character sets n
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
mysql does not let me enter german umlauts, though. I tried to start it with
"mysql --default-character-set=latin_de", but it complained about the
character sets not being installed. Then I installed the mysql server, which
probably something wrong with the permissions in the mysql database.
as a workaround, try to connect not via the local socket, but via a
tcp/ip-connection:
# mysql -h 127.0.0.1 -u my-user -p my-database
or insert the real ip of the machine instead of the loopback address.
check if there
> 'support-files' directory of the mysql source code.
>
> Ich hoffe daß ich dir geholfen habe.
> Ken
> - Original Message -
> From: "sascha mantscheff" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, March 19, 2002 9:46 AM
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
mysql does not let me enter german umlauts, though. I tried to start it with
"mysql --default-character-set=latin_de", but it complained about the
character sets not being installed. Then I installed the mysql server, which
Ihre Nachricht vom Friday 18 January 2002 12:14:
> sascha mantscheff wrote:
> > I'm not using replication, but for a test if it really works I would do
> > some data manipulations on the master and afterwards a complete mysqldump
> > of master and replica and diff the
Ihre Nachricht vom Friday 18 January 2002 12:14:
> sascha mantscheff wrote:
> > I'm not using replication, but for a test if it really works I would do
> > some data manipulations on the master and afterwards a complete mysqldump
> > of master and replica and diff the
I'm not using replication, but for a test if it really works I would do some
data manipulations on the master and afterwards a complete mysqldump of
master and replica and diff the result.
s.m.
-
Before posting, please check:
.
qualimedic ag
sascha mantscheff
telefon 02292-922 492
telefax 02292-922 493
mobil 0171-620 0380
e-Mail [EMAIL PROTECTED]
-
Before posting, please
Ihre Nachricht vom Monday 09 July 2001 17:10:
> It's so easy, you won't think of it: start mysqld with parameter
> -h (=help):
>
> mysqld -h
>
> shows all parameters and current settings
Alas, it does not. It shows a couple of variable settings, but not the syntax
for tha various logging options
Where do I find a complete documentation of all options and entries in my.cnf
and the mysqld start options? I searched the mysql.com site, but to no avail.
Neither does the online documentation doesn't seem to have a chapter on it.
s.m.
Qualimedic AG
S
21 matches
Mail list logo