In the last episode (Apr 20), Willie Gnarlson said:
> I have been attempting to uncover a fast method for retrieving unique
> items from every column in a table. The table has approximately 60
> thousand rows. Each row has an index associated with it, and running
> 'explain select distinct class fr
Hello,
I have been attempting to uncover a fast method for retrieving unique
items from every column in a table. The table has approximately 60
thousand rows. Each row has an index associated with it, and running
'explain select distinct class from dlist' shows that it is using the
index.
However
On 4/16/05, Scott Gifford <[EMAIL PROTECTED]> wrote:
> Jeff Kolber <[EMAIL PROTECTED]> writes:
>
> > How are sites doing the search by zip and coming up with results within x
> > miles? Is there some OSS zip code download that has been created for this?
>
> The ones I'm familiar with use this:
>
Thank you so much Vivian! Your first solution was exactly what I was looking
for! It works perfectly!
Thanks so much!
Richard
Vivian Wang <[EMAIL PROTECTED]> wrote:
create table temp select * from viewvisitor order by lastviewtime desc;
select app, itemid, ownerid, visitorid, vusername,last
Yes, I downloaded the 4.1 rpms from
http://dev.mysql.com/downloads/mysql/4.1.html
>Hello.
>
>
>
>You're sure that you are running an official binary?
>
>
>
>
>
>"Xu Hao" <[EMAIL PROTECTED]> wrote:
>
>> Hi!
>
>>
>
>> I installed the same rpms on a SuSE 9.2 box and tried to reproduce that
>> pr
On Apr 19, 2005, at 1:35 PM, Jason Dixon wrote:
I'm trying to do an update to one of my tables, but I'm getting the
"table is full" error. I've reviewed the manual
(http://dev.mysql.com/doc/mysql/en/full-table.html), but nothing seems
to apply. I looked at the output of myisamchk, and everyth
I need to move my MySQL databases to another machine.
The current machine the databases are on is running MySQL version 3.23. The new
machine is running 4.0. The machines have the same floating point format. The databases
are *very* large (several hundred tables, most around 4MB, a couple over 4G
James Nobis <[EMAIL PROTECTED]> wrote on 04/19/2005
04:04:24 PM:
> The link below essentially means subquery support is useless for many
> traditional purposes. You are stuck in a correlated subquery thus
performance
> is the query being run out-to-in (subquery run for every row?) instead
of
>
Rich Brant wrote:
I forgot the important part: what I want is to filter on a userID in the
person table such as -
SELECT u.Username, p.UserID
FROM Users u LEFT OUTER JOIN
Person p ON u.UserID = p.UserID
WHERE (p.UserID = 5) OR
(p.UserID IS
OK, I don't see much wrong with this version either.
Again I ask you:
Which version you are using?
Can you post some sample data and the incorrect results?
Here is a similar query that is working for me. This matches Projects with
the people who have the resources to complete them (Suppliers).
The link below essentially means subquery support is useless for many
traditional purposes. You are stuck in a correlated subquery thus performance
is the query being run out-to-in (subquery run for every row?) instead of
in-to-out as desired. Does anyone know of a work around for this? Apparant
on 4/19/05 9:32 AM, Keith Ivey at [EMAIL PROTECTED] wrote:
> Hank wrote:
>
>> Talk about over complicating things... here's the above query simplifed.
>>
>> I can not figure out why they were self joining the table three times:
>
> Also, the index on zip_code, latitude, and longitude doesn't
>
I forgot the important part: what I want is to filter on a userID in the
person table such as -
SELECT u.Username, p.UserID
FROM Users u LEFT OUTER JOIN
Person p ON u.UserID = p.UserID
WHERE (p.UserID = 5) OR
(p.UserID IS NULL)
THis w
Rich Brant <[EMAIL PROTECTED]> wrote on 04/19/2005 03:05:51 PM:
> I'm used to doing something simple such as the following in sql server:
>
> SELECT u.Username, p.UserID
> FROM Users u LEFT JOIN
>Person p ON u.UserID = p.UserID
>
> However, I'm not seeing the same results i
I'm used to doing something simple such as the following in sql server:
SELECT u.Username, p.UserID
FROM Users u LEFT JOIN
Person p ON u.UserID = p.UserID
However, I'm not seeing the same results in MySQL. I don't get all
the recs in the users table and NULLs in the userID c
> No, those indexes were intentional. If you read the section of the manual
> on optimizing queries, you will encounter a page that mentions what are
> known as "covering indexes". The advantage to a covering index is that if
> your data is numeric and in the index,
Except that the zip code fie
Hi,
I've 2 tables of payments
1: payment emission (P: --> ID,ID_cli,tot)
2: part payments (A: --> ID,P_ID,val)
I'd like to retrieve all payment emissions, with all relative part
payments(with a left join), for all ID_cli
and I'd like to calculate the rest to pay...like tot-SUM(val).
but I
Hank <[EMAIL PROTECTED]> wrote on 04/19/2005 01:33:51 PM:
> On 4/19/05, Keith Ivey <[EMAIL PROTECTED]> wrote:
> > Also, the index on zip_code, latitude, and longitude doesn't
> > make sense.
>
> Yeah - I didn't even notice the indexes in the table def (I used my
> own existing zip code table).
I am installing MySQL on a server with limited space available and I'd
like to minimize the footprint of the installed database. is there
information available on what parts of the installation I can safely
delete without harming functionality of the database?
I'd love to hear recommendations
Both load data infile and mysqlimport both support the ignore option.
If you are loading a file into a table with a unique index and
duplicate rows in the file any duplicates will be silently ignored.
On 4/19/05, newbie c <[EMAIL PROTECTED]> wrote:
> thanks for the reply! I am not too concerned a
I'm trying to do an update to one of my tables, but I'm getting the
"table is full" error. I've reviewed the manual
(http://dev.mysql.com/doc/mysql/en/full-table.html), but nothing seems
to apply. I looked at the output of myisamchk, and everything looks
fine. The table file is only ~100M,
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: 5.0.4 (and 5.0.3) segfault when presented with a specific query
containing a subquery o
On 4/19/05, Keith Ivey <[EMAIL PROTECTED]> wrote:
> Also, the index on zip_code, latitude, and longitude doesn't
> make sense.
Yeah - I didn't even notice the indexes in the table def (I used my
own existing zip code table). That table def and query were obviously
created by someone pretty gree
Hank wrote:
Talk about over complicating things... here's the above query simplifed.
I can not figure out why they were self joining the table three times:
Also, the index on zip_code, latitude, and longitude doesn't
make sense. Only the zip_code part of it was used, so it should
have been on zi
Hi,
I wrote some weeks ago to the mailinglist with the same problem. The
performance isn't still much better.
I try to find the optimal value for tmp_table_size (now set to 67108864),
cause we have some problems. Sometimes I see, that the result data will be
copied to tmp table:
Copying to tmp
Talk about over complicating things... here's the above query simplifed.
I can not figure out why they were self joining the table three times:
SELECT b.zip_code, b.state,
(3956 * (2 * ASIN(SQRT(
POWER(SIN(((a.lat-b.lat)*0.017453293)/2),2) +
COS(a.lat*0.017453293) *
CO
Here are the sequence of queries that executed before the server crashed...
CREATE TEMPORARY TABLE COMETTRACKER.DELIVERY_TRACKING_ETA (
PACKAGEID BIGINT NOT NULL,
RECID_CTASKDATA BIGINT ,
RECTYPE INT(11) ,
USERID INT(11) ,
TIMETAG1 DATETIME ,
TIMETAG2 DATETIME ,
P_DATA1 VARCHAR(20) ,
P_DATA2 VARCH
Interestingly enough, I found another great circle
routine here:
http://www.meridianworlddata.com/Distance-Calculation.asp
and adapted it for MySQL like so:
SELECT
b.zipcode, b.state,
3963.0 * acos(
sin(a.latitude/57.2958) * sin(b.latitude/57.2958) +
cos(a.latitude/57.2958) * cos(b.latitude/57.2958
Hi,
Just as a speed note! It's faster to calculate a square and find those
records and then drop the corners with the circle calculation.
Scott.
> -Original Message-
> From: Eamon Daly [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 19, 2005 11:20 AM
> To: Scott Haneda; MySql
> Subject:
I don't think anyone's replied with an actual great circle
calculation. Here's our zipcode table, populated with data
from zipcodedownload.com (and note the index on zipcode,
latitude, and longitude:
CREATE TABLE `zipcodes` (
`zipcode` char(5) NOT NULL default '',
`zipcode_type` enum('S','P','U',
What were you doing when it failed? What type of connections was it
handling?
Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any
error messages to post. Server just stops???
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: "Joerg Bruehe" <[EMAI
Hmmm, it ran for about two hours (Win32) then crashed. I don't receive any
error messages to post. Server just stops???
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: "Joerg Bruehe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "MySQL General List" ;
<[EMAIL PROTECTED]
Hello
I have sent this e-mail 2 weeks ago and did not get any answers. Please
allow me to give a second try.
I have Mysql 4.1.7 on Solaris / innodb tables
I have 2 innodb_log_files of 100M each. A group of statements (19000
insert) does that both logfiles are stamped with the same time. It might
thanks for the reply! I am not too concerned about cutting out the columns
as I may need to other information for later.
I was just wondering does it make a difference if both of the columns that
I am interested have entries that are NOT unique?
Also, at what point does one need a parser or use
prathima rao wrote:
hai,
when ever the power goes or the system restarts when im entring data from my
vb application to mysql 4 database
it gets corrupted and i loose some data at the end please can any one help
me in this
regards
prathima rao
Get a backup powersupply with shutdown software.
Whe
i want to join mysql mail list
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hai,
when ever the power goes or the system restarts when im entring data from my
vb application to mysql 4 database
it gets corrupted and i loose some data at the end please can any one help
me in this
regards
prathima rao
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
Dear All,
I'm really happy to let you know that after a whole year of hard work
the University of St.Gallen has developed a new research
platform "Alexandria" based on MySQL and PHP.
http://www.alexandria.unisg.ch
I'm really would like to say thanks to MySQL AB who did support our
work in a
At 11:07 19.04.2005, Gleb Paharenko wrote:
Hello.
See:
http://dev.mysql.com/doc/mysql/en/blocked-host.html
thx. I know this. But some user comments are interesting, while we are
using nagios.
Regards,
Rafal
> our MySQL server can handle 1000 connections. We have two JBoss
> instances.
> Eac
From: "Lee Denny"
> site_id, page_id,header_text,main_text..
>
> I just need to duplicate existing records with a new site_id, so :
>
> 1,1,Hello,some text..
> 1,2,Hello Again, some more text...
>
> gets copied to
>
> 2,3,Hello,some text..
> 2,4,Hello Again, some more text...
>
> page_id is already
Hello.
You're sure that you are running an official binary?
"Xu Hao" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I installed the same rpms on a SuSE 9.2 box and tried to reproduce that
> problem, but that problem didn't happen. It seems that this problem has
> something to do with RHEL3, ri
Hello.
> Could be that the connect command fails, then I start trying and trying,
> and then the server blocks because it receives too many connections? Then
> the error message would be the one that I'm getting?
I also thought about this and therefore I gave you that advice. What
i
Hello.
See:
http://dev.mysql.com/doc/mysql/en/blocked-host.html
> our MySQL server can handle 1000 connections. We have two JBoss
> instances.
> Each configured with max. 100 connections in pool. furthermore we use
> php
> which make on each call a connection to MySQL. After a
On Tuesday 19 April 2005 13:17, Anna Henricson wrote:
> Hi,
> I have a problem with mysqldump when I want to copy a table from a
> database. I have mysql Ver 14.7, Distrib 4.1.9, for pc-linux-gnu.
>
> I use the following command:
>
> mysqldump -h host -u user -ppassword database_name table_name >
>
Hello,
Yesterday I asked for some help to create a program in C++ integrated with
MySQL. Now I have installed MySQL 4.1.11 and I suppose I will need to
include mysql.h in my code. But this header use 'libmysql.dll', where I have
to define the path in Visual C++? Or where I have to copy this file?
Hi,
I am trying to create a query that returns a users availability for the next
ten days using version 4.1.11. A user has 8.5 hours available per day so a
users availability is equal to 8.5 less any bookings they have on that day.
I have a table called Bookings (see below), and each 'Booking' h
Hi,
I have a problem with mysqldump when I want to copy a table from a database.
I have mysql Ver 14.7, Distrib 4.1.9, for pc-linux-gnu.
I use the following command:
mysqldump -h host -u user -ppassword database_name table_name >
table_name.sql
And get the following error message:
mysqldump: m
The model I described is indeed tailored more for tracking changes and
archiving historical records because those were the requirements of the
project I was implementing ;-) I just had to figure out the most optimal way
of addressing these requirements using MySQL 4.1.
MERGE tables are an excellen
Hello,
I've got a table with a simple structure:
site_id, page_id,header_text,main_text..
I just need to duplicate existing records with a new site_id, so :
1,1,Hello,some text..
1,2,Hello Again, some more text...
gets copied to
2,3,Hello,some text..
2,4,Hello Again, some more text...
page_i
> A new version of MySQL Community Edition 5.0.4-beta Open Source database
> management system has been released. This version now includes support
for
> Stored Procedures, Triggers, Views and many other features. It is now
> available in source and binary form for a number of platforms from our
At 11:14 19.04.2005, prasanna a wrote:
Hi
It means that mysqld has received many connect
requests from that host.If the erro on connecting to
But than we should get to many connections.
mysqld exedes the parameter max_connect_errors
How can there be an error?
(Default value is 10).
We change this
Hi, we're running 4.1.11 on two Debian woody machines and replication on the
'laterooms' database is working marvellously with the exception of altering
table structure. If I execute an ALTER TABLE ... ADD... no error is
generated, but the slave does not add the column.
Of course then INSERTS t
Hi,
our MySQL server can handle 1000 connections. We have two JBoss instances.
Each configured with max. 100 connections in pool. furthermore we use php
which make on each call a connection to MySQL. After a while (some days) we
get this:
java.sql.SQLException
MESSAGE: Data source rejected esta
From: "David Lloyd"
> journalling file system. It's not always that clear cut. I've just
> switched a number of big customer databases to InnoDB and noone's
> noticed any difference - if anything it's going faster.
For small tables (<50,000 records) MyISAM is usually a lot faster. However,
MyISAM
I haven't tried it yet, but I'll try it next time it happens, to see if
the problema disappears.
We actually have some connection problems that can be relevant to my
problem:
Warning: Lost connection to MySQL server during query in
/home/httpd/...some.php on line 9
We solved them by the PH
I'd hate to use Microsoft's SQL server, but I feel like i've hit a
dead end with mysql.
If anyone can offer some advice on how to get mysql running on windows
ce, or can point me to some programmers who would be willing to port
the source code for me, please contact me.
-LiquidIce
[EMAIL PROTECTED
56 matches
Mail list logo
