Michael Fischer wrote:
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql> desc people;
+---+
Having a very bad time with the subject sorts of queries.
Here is a simple reproduction of the problem for me.
Perhaps I'm blind/stupid while looking at the docs,
or there's a bug...
mysql version 5.0.24-standard
simple schema:
mysql> desc people;
+---+--+--+-+
I find some code about role management in mysql5.2 's source code
" \mysql-5.2.0-falcon-alpha\storage\falcon "
Does MySQL 5.2 include support for roles based access control now? Does it be
supported by falcon engine?
I have some data in a regular MySQL table called usplaces:
city |state|country|latitude |longitude |population|comments
-+-+---+-+---+--+
New York |NY |USA|40.704234| -73.917927|8008278 |Big Apple
Chicago |IL |USA
In the last episode (Jan 31), Mike Morton said:
> Mike:
>
> :) I wish! Free ham for everyone!
>
> I had already changed the min length to 2 actually - so that is not the
> affecting factor...
>
> It is more of an issue to prioritizing fields for relevance, and whether it
> is possible to do th
Mike:
:) I wish! Free ham for everyone!
I had already changed the min length to 2 actually - so that is not the
affecting factor...
It is more of an issue to prioritizing fields for relevance, and whether it
is possible to do this within a fulltext query, or whether it needs to be
done through
Mike,
It's likely because MySQL fulltext index defaults to a word length
of 4 characters or more. So "Ham" probably is not being indexed. You will
need to change the minimum word length. See
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html
Mike
(P.S. Send me a free ham
Dimitar Vassilev asks:
Hello,
Can anyone point me to a section of manual or link how to reduce digits
after
a decimal sign?
I have a table
mysql> desc part;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+---
Hello,
Can anyone point me to a section of manual or link how to reduce digits
after
a decimal sign?
I have a table
mysql> desc part;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+
Does anyone have any suggestions on how to solve the result weighting
problem? I have a client whose search results are becoming more and more
important, and the relevance demands on the results are not entirely
satisfactory...
The fields that are searched are code, name, small description and lar
On Tue, 2006-10-17 at 10:15 -0600, Peter Gulutzan wrote:
> Hi,
>
> MySQL is looking for an authoritative, official statement
> which states all the current Hungarian collation rules.
> Please let other MySQL-using Hungarians (especially if you
> know a user group in Hungary) know about these
> que
In the last episode (Jan 31), Jesse said:
> Sorry, I hit send before I was actually done. So Given the error
> I am getting:
>
> 070131 11:53:55 [ERROR] Slave I/O thread: error connecting to master
> '[EMAIL PROTECTED]:3306': Error: 'Can't connect to MySQL server on
> 'Anchorman' (10061)' e
Sorry, I hit send before I was actually done. So Given the error I am
getting:
070131 11:53:55 [ERROR] Slave I/O thread: error connecting to master
'[EMAIL PROTECTED]:3306': Error: 'Can't connect to MySQL server on
'Anchorman' (10061)' errno: 2003 retry-time: 60 retries: 86400
There a
Also, given the error I got:
- Original Message -
From: "Michael DePhillips" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Tuesday, January 30, 2007 7:57 PM
Subject: Re: Replication not working?
Should be almost instantaneous. Do a show slave status on t
Show Slave Status returns a bunch of stuff that I can't view in the command
line utility. When I use a visual tool, it shows me a bunch of different
fields, but I didn't see anything that looked like an error.
Slave_IO_State = "Connecting to master". Last_Errno is 0. So, from that
perspectiv
In the last episode (Jan 31), [EMAIL PROTECTED] said:
> I'm trying to wrap my head around a performance problem our
> institution is having on our Mysql Server which hosts all of our logs
> from around campus.
>
> Specifically our MailLogs tables.
>
> What I'm having a hard time with is we have m
Hi guys,
I know nothing about MySQL, but
please check this and make some bucks
http://www.anrdoezrs.net/click-2275618-10459013
Your friend,
Gabusa
Duncan Hill-3 wrote:
>
> On Tuesday 04 July 2006 21:33, Karl Larsen wrote:
>> I have not yet found how I can put a $ in front of all the money
>>
Hello, I think your major contributing problem is the database engine
that you are using, MYISAM. For this type of processing, I would highly
recommend you use INNODB to allow maximum concurrency and minimize your
outage. With all things considered, your processing by all estimates,
whether you a
The delete would definitely depend upon the size of the record set being
deleted, anyway assuming I comprehended your situation correctly ,I would
suggest using the Merge storage engine for your needs , and keep every
single day of data in a seperate MyISAM table, and merge all those tables
togeth
I'm trying to wrap my head around a performance problem our institution is
having on our Mysql Server which hosts all of our logs from around campus.
Specifically our MailLogs tables.
What I'm having a hard time with is we have metadata such as:
CREATE TABLE mail00 (
host varchar(32) default
Dear MySQL developers and users,
Version 0.9.8 Beta of the PrimeBase XT storage engine for MySQL 5.1
has just been released.
PBXT is a transactional storage engine for MySQL which can be loaded
dynamically by the pluggable storage engine API of MySQL 5.1. Full
MVCC (multi-version concurre
Hi,
I'm using MySQL 4.1.15, WinXP and my problem is that
SELECT CHARSET(CONCAT(int_column, string_column)) FROM mytable;
always returns charset 'binary' and I need resulting charset to be same
as a charset of a string_column because I don't want to look for
charset of a column whenever I have t
Hi Mark
I would appreciate if we can define Under_extreme_conditions as you
have mentioned in this link below
http://archives.neohapsis.com/archives/mysql/2005-q3/0163.html
I would appreciate if you can give us a workaround for this, which
can eliminate this set autocommit =1 command being sent
$ chown -R mysql:mysql yourdirectoryofmysql
On 1/31/07, WebIT <[EMAIL PROTECTED]> wrote:
Sorry, probably a really simple thing, but when I try and start mysqld it
fails.
[EMAIL PROTECTED] yum.repos.d]# /sbin/service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MyS
Sorry folks - worked out why.
The ownership of the mysqld directory had been changed by another
application I'd installed.
Sorry!
-Original Message-
From: WebIT [mailto:[EMAIL PROTECTED]
Sent: 31 January 2007 09:53
To: mysql@lists.mysql.com
Subject: Error starting service
Sorry, probab
Sorry, probably a really simple thing, but when I try and start mysqld it
fails.
[EMAIL PROTECTED] yum.repos.d]# /sbin/service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:[FAILED]
I've checked the mysqld.log file and
26 matches
Mail list logo
