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 NU
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
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 foun
dexes:
>
Oops, you forgot to paste it :)
Anyway, make sure you've used the following 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
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
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 s
te just a small 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
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"
On Mon, 21 Jun 2004, David Blomstrom wrote:
> Suppose I have a field with the names of states,
> linked to their home pages:
>
> http://www.alabama.gov/";>Alabama
> http://access.wa.gov/";>Washington
>
> If I display this on a webpage, I'll get the names of
> the states, linked to their home pag
o the
original directory.
Also 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
>
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
11 matches
Mail list logo
