Bryan,
Can you send the output of show create table matrix? You've just sent
the location table output, but your select command refers to a table
called matrix.
[]s,
Sergio.
On Wed, 22 Dec 2004, Bryan Heitman wrote:
I am experiencing extreme slowness performing a query in which 2 rows are
On Thu, 23 Dec 2004, Bryan Heitman wrote:
My mistake! Here you go:
Ok, no prob :)
CREATE TABLE `matrix` (
`WordID` int(11) unsigned NOT NULL default '0',
`LocationID` int(11) unsigned NOT NULL default '0',
`Position` enum('Body','From','Subject','To','Mailbox','File') NOT NULL
bind-address is what you need.
http://dev.mysql.com/doc/mysql/en/Server_options.html
[]s,
Sergio.
On Fri, 25 Jun 2004, Marten Lehmann wrote:
Hello,
I was reading through the documentation, but I couldn't find anything on
how to bind mysql to a certain ip-address. The only thing I found
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
[]s,
Sergio Salvi.
On Thu, 24 Jun 2004, MerchantSense wrote:
Hi - I need some help :)
I set up a simple
On Fri, 25 Jun 2004, Michael Stassen wrote:
Sergio Salvi wrote:
Hi!
Can you send the output of the following command?
show index from ip2org;
It seems you don't have an index on both fields (even though it says you
have multi-field index)...
MUL doesn't mean part
command to create this index:
alter table ip2org add index test (ip_start,ip_end);
[]s,
Salvi.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 24, 2004 10:37 PM
To: Sergio Salvi
Cc: MerchantSense; [EMAIL PROTECTED]
Subject: Re: strange table
amount of memory for that.
[]s,
Sergio Salvi.
On Tue, 22 Jun 2004, Aram Mirzadeh wrote:
We have an internal SNMP monitoring system that is monitoring about
10,000 devices. Each device is pinged then pulled for about an average
of 25-30 elements. Each of the ping results and elements
On Mon, 21 Jun 2004, David Blomstrom wrote:
Suppose I have a field with the names of states,
linked to their home pages:
a href=http://www.alabama.gov/;Alabama/a
a href=http://access.wa.gov/;Washington/a
If I display this on a webpage, I'll get the names of
the states, linked to their
On Mon, 21 Jun 2004, David Blomstrom wrote:
Sergio Salvi wrote:
[...]
Separate data from how it's displayed. I mean, create
a table called
states with the fields state_id, state_name and
state_url. Put
the data in the according field:
state_id state_name state_url
1 Alabama
check the documentation:
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Upgrade
[]s,
Sergio Salvi.
On Thu, 30 Oct 2003, Mike Nelson wrote:
Hello,
Can somebody give me some instructions on how to uninstall Mysql
4.1. I have a redhat 2.1 AS box. I installed
Rainer,
To find out if there is any query that is taking too long to run, enable
the log-slow-queries option and set long_query_time to some
initial value like 5 or 10 (it's in seconds).
Then check your slow queries log file and try to understand why those
queries are taking too much time to
11 matches
Mail list logo