Hi Shain,
On 5/8/2017 1:53 PM, Shain Miley wrote:
Hello,
We have traditionally setup our mysql database servers with a mix of ssd and
spinning disk drives.
We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the
spinning disks (15 sas in Raid-1) for the index data, etc.
Am 08.05.2017 um 19:53 schrieb Shain Miley:
Hello,
We have traditionally setup our mysql database servers with a mix of ssd and
spinning disk drives.
We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the
spinning disks (15 sas in Raid-1) for the index data, etc.
I am
Hello,
We have traditionally setup our mysql database servers with a mix of ssd and
spinning disk drives.
We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the
spinning disks (15 sas in Raid-1) for the index data, etc.
I am wondering if going forward we should simply put
> On Apr 14, 2017, at 1:07 PM, shawn l.green wrote:
>
> That all depends. Do you...
Hi Shawn,
I thought I had replied to your response, but it looks like I didn’t.
Thank you for your email. It was a thorough response and the links were very
helpful, as well. I’ve settled on both DA
On 4/14/2017 3:11 PM, SSC_perl wrote:
I have creation date/time fields in my script that are formatted as
|MM|DD|hh|mm|ss. Short of changing the script, should I set the field type
in MySQL to DATETIME, or would it be better in terms of speed and efficiency to
set it as char(19)
I have creation date/time fields in my script that are formatted as
|MM|DD|hh|mm|ss. Short of changing the script, should I set the field type
in MySQL to DATETIME, or would it be better in terms of speed and efficiency to
set it as char(19)? Or would it not make a difference?
Tha
On 9/21/2015 9:03 AM, Richard Reina wrote:
I have a column name quarter which I need to have 5 possible inputs; 1, 2,
3, 4, or OT. Because of the OT possibility I am leaning towards ENUM.
Hence, I am also thus considering ENUM('first', 'second', 'third',
'fourth', 'overtime') as the input will
> From: Richard Reina
>
> I have a column name quarter which I need to have 5 possible inputs; 1, 2,
> 3, 4, or OT. Because of the OT possibility I am leaning towards ENUM.
> Hence, I am also thus considering ENUM('first', 'second', 'third',
> 'fourth', 'overtime') as the input will primarily be
I'm sure your enum is a fine option, but 0,1,2,3,4 would do the same thing.
And you could add a comment to the table to describe it if desired.
On Mon, Sep 21, 2015 at 8:03 AM, Richard Reina wrote:
> I have a column name quarter which I need to have 5 possible inputs; 1, 2,
> 3, 4, or OT. Becaus
I have a column name quarter which I need to have 5 possible inputs; 1, 2,
3, 4, or OT. Because of the OT possibility I am leaning towards ENUM.
Hence, I am also thus considering ENUM('first', 'second', 'third',
'fourth', 'overtime') as the input will primarily be used in written
descriptions. Is t
I have a very large table (~50GB) and periodically rows are purged
from it and I want to run OPTIMIZE TABLE to recover the space. But I
do not have enough space to run it. If I do run it the server hangs
and must be killed and restarted and the table is damaged and must be
repaired. I do this with
On Fri, 12 Dec 2014 10:31:53 +0100, Lucio Chiappetti wrote:
> I use nntp newsgroups, in a very simple threaded mode, I "subscribe"
> interesting groups and look at them once a day or sometimes more
> frequently. I skim through thread titles, expand the interesting ones,
> read the messages, then
they are no indexing usenet any longer which is a real problem because
of volumns of archival information on them from everything from SQL
theory to networking commands.
It is depressing
almost as depressing as the university library with stacks of books on
the floors pushed away to make ro
True; and before that there was yahoo groups, and others. Those are not
fora, however, merely web interfaces to mailing lists / newsgroups.
as a lurker on this list, I jump in. It is curious that newsgroups are
mentioned only en passant, and NNTP is not mentioned at all.
Still vastly prefer e
DEAR guys:
I think Email is good for search and I can download to my moible
device.
2014-12-11
I AM AN ORACLE FANS!
Skype:Frank.oracle
Email:xiangdong...@gmail.com
Name:东东堂
发件人：Mark Goodge
发送时间：2014-12-11 17:23
主题：Re: forum vs email
收件人："mysql"
抄送：
On 10/12/2014 23:
- Original Message -
> From: "Sándor Halász"
> Subject: Re: forum vs email
> Something more sophisticated than grouping messages by trimmed subject-lines?
> maybe involving such header lines as were used in the old netnews (if e-mail
> is
That's only a sin
On 10/12/2014 23:40, Reindl Harald wrote:
Am 10.12.2014 um 18:38 schrieb h...@tbbs.net:
2014/12/10 09:00 +0100, Johan De Meersman
One of the (for me, at least) defining features of a forum, is
that the subjects tend to be divided up into a tree structure, which
has it's own benefits
Am 10.12.2014 um 18:38 schrieb h...@tbbs.net:
2014/12/10 09:00 +0100, Johan De Meersman
One of the (for me, at least) defining features of a forum, is that the
subjects tend to be divided up into a tree structure, which has it's own
benefits
Something more sophisticate
2014/12/10 09:00 +0100, Johan De Meersman
One of the (for me, at least) defining features of a forum, is that the
subjects tend to be divided up into a tree structure, which has it's own
benefits
Something more sophisticated than grouping messages by trimmed subject-
Hi,
On 10/12/2014 10:09, Johan De Meersman wrote:
Hm. Typo3 is a CMS; I take it the integration you're speaking of is
specific to their support environment, and not part of the CMS?
Correct, TYPO3 is a CMS (also FOSS GPL2+) and the integration is indeed
not part of the CMS. See my other repl
Hi,
On 10/12/2014 09:02, Johan De Meersman wrote:
- Original Message -
From: "Jigal van Hemert"
Subject: Re: forum vs email [was: Re: table-for-column]
On typo3.org there used to be mailing lists only in a distant past.
Later on newsgroups were set up which communicat
- Original Message -
> From: "Johan De Meersman"
> Sent: Wednesday, 10 December, 2014 09:02:45
> Subject: Re: forum vs email [was: Re: table-for-column]
> Hmm. That sounds interesting, I'll have a look. I don't suppose the software
> is
> availabl
- Original Message -
> From: "Jigal van Hemert"
> Subject: Re: forum vs email [was: Re: table-for-column]
>
> On typo3.org there used to be mailing lists only in a distant past.
> Later on newsgroups were set up which communicate with the mailing lists
>
- Original Message -
> From: "Sándor Halász"
> Subject: Re: forum vs email
> I believ that one could both by e-mail and through a webbrowser comment on a
> Google group.
True; and before that there was yahoo groups, and others. Those are not fora,
however, me
On 12/9/2014 9:10 PM, h...@tbbs.net wrote:
2014/12/09 15:20 -0600, Peter Brawley
Nope.
And why not? Because no one bothered to implement it? Now I (for the first time?) looked at
"forums.mysql.com" and see more topics than on "lists.mysql.com". The former is
just more with-it,
2014/12/09 15:20 -0600, Peter Brawley
Nope.
And why not? Because no one bothered to implement it? Now I (for the first
time?) looked at "forums.mysql.com" and see more topics than on
"lists.mysql.com". The former is just more with-it, I guess.
I believ that one could both by e
On 2014-12-09 9:55 AM, Johan De Meersman wrote:
- Original Message -
From: "Sándor Halász"
Subject: Re: forum vs email
That is, this list, right? What does it lack (besides readers)?
This list interacts with the forums on mysql.com?
Nope.
PB
-
Every thread here m
- Original Message -
> From: "Sándor Halász"
> Subject: Re: forum vs email
> That is, this list, right? What does it lack (besides readers)?
This list interacts with the forums on mysql.com? Every thread here matches one
on there, and vice versa? (Honest question;
Just to pitch in, on this rather weird discussion.
I've been on the MySQL pretty much from day one. I started
on mSQL and transferred to MySQL when Monty took that corner.
I'm probably not the only one, lurking in the shadows.
On Sat, December 6, 2014 17:33, Reindl Harald wrote:
>
> Am 06.12.201
I have been a resident of this list for a very long time. In the early
days, this was the only place to get reliable information about what was
then a relatively obscure database system. Now, local and online bookstores
have shelves full of books, many of them authored by list regulars. We have
exp
Hi,
On 05/12/2014 20:54, Jan Steinman wrote:
From: Johan De Meersman
I've long wanted to - but never quite got around to - write a forum that
integrated a mailing list. Bar mail clients that don't handle list threads
well, it really doesn't seem such a difficult task.
There actually seem to
Am 06.12.2014 um 16:53 schrieb h...@tbbs.net:
2014/12/06 12:51 +0100, Johan De Meersman
I want:
* The entire post, and as little notification-type content as possible,
* headers and subjects so that mail clients that support threading will
thread everything from a single forum topic i
2014/12/06 12:51 +0100, Johan De Meersman
I want:
* The entire post, and as little notification-type content as possible,
* headers and subjects so that mail clients that support threading will thread
everything from a single forum topic in a mail thread and vice versa,
* and, most im
- Original Message -
> From: "Jan Steinman"
> Subject: Re: forum vs email [was: Re: table-for-column]
> There actually seem to be a lot of these around. I'm on several that send me
> email when there are new forum postings.
Yes, that bit is pretty standard
2014/12/04 22:56 -0500, shawn l.green
I guess this email-based peer-to-peer exchange is slowly disappearing into the
background like the old usenet newsgroups, eh?
And _I_ like using an off-line e-mail client, and not being bothered by going
through a webbrowser--but I suspect
> From: Johan De Meersman
>
> I've long wanted to - but never quite got around to - write a forum that
> integrated a mailing list. Bar mail clients that don't handle list threads
> well, it really doesn't seem such a difficult task.
There actually seem to be a lot of these around. I'm on seve
Hi,
I am trying to connect two mysql servers with different versions ( 5.1 &
5.5 ) . But in Mysql 5.1 i am facing strange issues.
Below testuser exists in both Mysql Versions :
mysql> select host,user,password from mysql.user where user='testuser';
+---++
Am 07.01.2014 13:48, schrieb Lukas Lehner:
> Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only
> interested in developer changes (not admin)
> Can I use development books for MySQL 5.0.0 [2003] and use the code an
> recent MariaDB and MySQL releases?
clearly yes
Hi
Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only
interested in developer changes (not admin)
Can I use development books for MySQL 5.0.0 [2003] and use the code an
recent MariaDB and MySQL releases?
- Original Message -
> From: "Rick James"
Hey Rick,
Thanks for your thoughts.
> * Smells like some huge LONGTEXTs were INSERTed, then DELETEd.
> Perhaps just a single one of nearly 500M.
I considered that, too; but I can see the on-disk size grow over a period of a
few months - it's
InnoDB, the LONGTEXT will usually be stored separately, thereby making a
full table scan relatively efficient.
> -Original Message-
> From: Johan De Meersman [mailto:vegiv...@tuxera.be]
> Sent: Friday, February 15, 2013 4:21 AM
> To: mysql.
> Subject: MyISAM table size vs a
Hey list,
I've got another peculiar thing going on :-) Let me give you a quick summary of
the situation first: we host a number of Drupal sites, each site and it's db on
separate VMs for reasons that are not important to this scenario. MySQL is
5.0.51a-24+lenny4-log (Debian); I don't have th
Hi!
> "Manuel" == Manuel Arostegui writes:
Manuel> 2012/9/19 Mark Haney
>> I hope this doesn't end in some kind of flame war. I'm looking to
>> optimize my tables (and performance in general) of the DB my web app is
>> using. I'm tweaking things a little at a time, but I'm curious as to
2012/09/19 13:44 -0700, Rick James
http://mysql.rjweb.org/doc.php/myisam2innodb
Also, InnoDB enforces foreign-key constraints, MyISAM not.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
; From: Manuel Arostegui [mailto:man...@tuenti.com]
> Sent: Wednesday, September 19, 2012 12:51 PM
> To: Mark Haney
> Cc: mysql mailing list
> Subject: Re: InnoDB vs. other storage engines
>
> 2012/9/19 Mark Haney
>
> > I hope this doesn't end in some kind of flam
2012/9/19 Mark Haney
> I hope this doesn't end in some kind of flame war. I'm looking to
> optimize my tables (and performance in general) of the DB my web app is
> using. I'm tweaking things a little at a time, but I'm curious as to what
> the rest of the MySQL list thinks about changing my st
I hope this doesn't end in some kind of flame war. I'm looking to
optimize my tables (and performance in general) of the DB my web app is
using. I'm tweaking things a little at a time, but I'm curious as to
what the rest of the MySQL list thinks about changing my storage engine
from InnoDB to
- Original Message -
> From: "Alex Schaft"
>
> From the user's perspective, they just need to know the process didn't
> hang. The count() query is more for getting memory requirements upfront.
> Can I handle it all, or do I need to break it down into pages?
Then just use the cursor-bas
On 2012/02/09 01:40 PM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
If I were to do a select count(*) from x where y prior to doing
select * from x where y to get a number of records, how would this impact
performance on the server itself? Would the first query be
- Original Message -
> From: "Alex Schaft"
>
> If I were to do a select count(*) from x where y prior to doing
> select * from x where y to get a number of records, how would this impact
> performance on the server itself? Would the first query be the one to
> do the most processing, with
Hi,
I'm currently using mysql_store_result to retrieve all records of a
query. This poses a problem however if say a couple of thousand records
get returned, and the user gets no feedback during the progress. I now
want to change this to mysql_use_result. The only catch is that you
don't know
We've been experimenting with the merge engine.
But suppose that instead of using the MERGE engine I instead modified my
code to UNION ALL the shards.
Would I get worse performance? In other words, besides the convenience,
does the MERGE engine have specific performance optimizations that mak
On 30/03/2011 09:05, Brent Clark wrote:
Hiya
Im wondering if someone could help me understand this. If you look at my
two queries below. By the ORDER BY one is using ` and the other ', as a
result, if you do an explain you will see that the top query does a
filesort, while the other does not.
On Wed, 30 Mar 2011 10:05:50 +0200
Brent Clark wrote:
> Hiya
>
> Im wondering if someone could help me understand this. If you look at my
> two queries below. By the ORDER BY one is using ` and the other ', as a
> result, if you do an explain you will see that the top query does a
> filesort,
Hiya
Im wondering if someone could help me understand this. If you look at my
two queries below. By the ORDER BY one is using ` and the other ', as a
result, if you do an explain you will see that the top query does a
filesort, while the other does not.
Would anyone know why.
mysql> explain
Take a look at mmm for mysql. Easy and robust.
sent from my mobile phone
On Mar 22, 2011 12:07 PM, "Adarsh Sharma" wrote:
> Dear all,
>
> I researched on a link that describes that Mysql to use with scalr for
> fault-tolerance and high availability.
>
>
http://scottmartin.net/2009/07/11/creating-
Dear all,
I researched on a link that describes that Mysql to use with scalr for
fault-tolerance and high availability.
http://scottmartin.net/2009/07/11/creating-a-virtual-datacenter-with-scalr-and-amazon-web-services/
Is it mandatory to use Scalr in our Mysql Production Servers.
What are t
In the last episode (Mar 10), Brent Clark said:
> Hiya
>
> I just found that I can run
> mysql db -e 'source exporteddbdata.sql'
>
> The question I would like to ask is. Is there a speed difference between
>
> mysql db < exporteddbdata.sql
> and
> mysql db -e 'source exporteddbdata.sql'
> (usi
Hiya
I just found that I can run
mysql db -e 'source exporteddbdata.sql'
The question I would like to ask is. Is there a speed difference between
mysql db < exporteddbdata.sql
and
mysql db -e 'source exporteddbdata.sql'
(using source)
Reason im asking is, I got a exported 5.4GB database file,
Yup, I'm doing clean tests,lshutdown, and reload mysql each test.
The raid setup is similar, Faster is raid1 with 10k harddisk, slower is raid
10 with 15k.
Metrics show
Old raid
Secuecial writting 1G: 533 mb/s (using dd if=/dev/zero of=1G bs=1024
count=102400)
Secuencial reading 1G: 500 mb/s
New
On Sun, Feb 13, 2011 at 11:40 PM, Andrés Tello wrote:
> I have a test process, which runs in the "old server" in 35 seconds, the new
> server runs the same process in 110.
>
> There is a change of version from mysql 4.1.22 to 5.1.22.
> We were stuck at 5.1.22 because higher version give us anothe
I have a test process, which runs in the "old server" in 35 seconds, the new
server runs the same process in 110.
There is a change of version from mysql 4.1.22 to 5.1.22.
We were stuck at 5.1.22 because higher version give us another issules like
encoding, case sensitivity...
I really belive th
>-Original Message-
>From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
>Meersman
>Sent: Thursday, November 25, 2010 3:29 AM
>To: Jerry Schwartz
>Cc: Brent Clark; mysql mailing list
>Subject: Re: localhost vs domain for connection string
>
&g
On Wed, Nov 24, 2010 at 4:44 PM, Jerry Schwartz wrote:
> [JS] This might or might not be enabled by default. I'm running on Windows,
> and I seem to remember having to change it.
>
> # Enable named pipe, bypassing the network stack
> enable-named-pipe
>
Windows' named pipes are not the same as u
>-Original Message-
>From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
>Meersman
>Sent: Wednesday, November 24, 2010 2:39 AM
>To: Jerry Schwartz
>Cc: Brent Clark; mysql mailing list
>Subject: Re: localhost vs domain for connection string
>
On Tue, Nov 23, 2010 at 7:55 PM, Jerry Schwartz wrote:
> >IIRC, "localhost" is seen by the client as a magic word to mean "use the
> >UNIX socket, not 127.0.0.1".
> >
> [JS] IF it is enabled in my.cnf.
>
Hmm, didn't know that bit. What's the option called ?
--
Bier met grenadyn
Is als mosterd
>-Original Message-
>From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
>Meersman
>Sent: Tuesday, November 23, 2010 6:19 AM
>To: Brent Clark
>Cc: mysql mailing list
>Subject: Re: localhost vs domain for connection string
>
>IIRC, "loc
> From: Brent Clark
>
> Is there a difference if someone had to make the connection string the a
> domain (hosts file entry makes the machine look at its ip) as opposed to just
> using localhost.
> If so would a performance hit be incurred?
Using 'localhost' will always be faster, although per
IIRC, "localhost" is seen by the client as a magic word to mean "use the
UNIX socket, not 127.0.0.1".
So, yes, that would make the connection not show up in netstat :-)
On Tue, Nov 23, 2010 at 11:11 AM, Brent Clark wrote:
> Hiya
>
> Is there a difference if someone had to make the connection str
Hiya
Is there a difference if someone had to make the connection string the a
domain (hosts file entry makes the machine look at its ip) as opposed to
just using localhost.
If so would a performance hit be incurred?
I have this client that has used the domain and in netstat im seeing
all th
You guys hear talk about NoSQL and here's a good article on the topic
especially as to how it pertains to mySQL...
http://www.linuxjournal.com/article/10770
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
I have checked Apache's log. There is no refused connection. And also with
MySQL I have set it to 999 connections and view the processes. Maximum
connection ever reached was only around 200. What I'm thinking now is. Is it
because of I use one time connection method? I mean every time the script
On Mon, 6 Sep 2010 06:36:02 -0400 (EDT), "Robert P. J. Day"
wrote:
> no, i don't want to start a flame war, i just want some feedback on
> a current list of mysql "drawbacks" WRT postgresql.
>
> in the context of a fully open-source, java based ECM product, there
> is a FAQ entry that summarize
no, i don't want to start a flame war, i just want some feedback on
a current list of mysql "drawbacks" WRT postgresql.
in the context of a fully open-source, java based ECM product, there
is a FAQ entry that summarizes why the developers would prefer their
users to use postgresql as opposed
On Thu, Sep 2, 2010 at 5:51 PM, wrote:
> Quoting Jangita :
>
>
>> Simply put: I want a solution that ensures that server 2 has all the data
>> at server 1 at any point in time; say server 1 suddenly fell into a pond :)
>> . I wouldnt want to open server 2 and find the last insert/update/delete
>>
On Thu, Sep 2, 2010 at 5:12 PM, Neil Aggarwal wrote:
> If server 1 and 2 are on the same local network, I would use
> a cluster.
>
As in NDB ? I've no personal experience with it - save for a sales talk by
MySQL guys some years back where we decided it was useless to us - but I
understand it has
Quoting Jangita :
Simply put: I want a solution that ensures that server 2 has all the
data at server 1 at any point in time; say server 1 suddenly fell
into a pond :) . I wouldnt want to open server 2 and find the last
insert/update/delete missing...
Ok so that rules out any asynchro
> Simply put: I want a solution that ensures that server 2 has all the
> data at server 1 at any point in time
If server 1 and 2 are on the same local network, I would use
a cluster. If they are located on physically separate networks,
I would use master-master replication.
Neil
--
Nei
On 02/09/2010 4:35 p, a.sm...@ukgrid.net wrote:
Clustering is a general term, do you know which one you are comparing
with replication? Clustering most typically refers to high availability
clustering or high performance clustering, which wouldnt
necessarily/normally imply any copy of the actual
On 02/09/2010 4:32 p, Johan De Meersman wrote:
On Thu, Sep 2, 2010 at 1:10 PM, Jangita mailto:jang...@jangita.com>> wrote:
...
Growth should be linear to the growth of customers, no ? :-)
I thought so too; but one customer = 1 customer record, plus all his
transactions, and also weirdly
Clustering is a general term, do you know which one you are comparing
with replication? Clustering most typically refers to high
availability clustering or high performance clustering, which wouldnt
necessarily/normally imply any copy of the actual data.
If you want a copy of your data on a
On Thu, Sep 2, 2010 at 1:10 PM, Jangita wrote:
> Hi Guys,
> We have a system that has been running along nicely for the past three
> months on a pc (4gb 1,8ghz,debian lenny pc). It is a telecom-financal
> system; slightly 2 hits per minute but growing exponentally as customers
> increase.
>
Grow
Hi Guys,
We have a system that has been running along nicely for the past three
months on a pc (4gb 1,8ghz,debian lenny pc). It is a telecom-financal
system; slightly 2 hits per minute but growing exponentally as customers
increase.
We have now bought two servers 12Gb RAM RAID blah blah; and
Hi,
I am doing some work on a nodejs/v8 bindings for libmysqlclient and
ran into some questions while working on the asynchronous part of the
interface.
http://github.com/kreetitech/node-mysql-libmysqlclient
The documentation says that:
"mysql_query() cannot be used for statements that contain b
Yes, that's it. I should be typing "STRAIGHT_JOIN" instead of "STRAIGHT
JOIN".
Thanks!
Mike Spreitzer
The relationship looks righteous enough but I note that you use
'straight join' in your expression, rather than 'straight_join' as
indicated in the manual
(http://dev.mysql.com/doc/refman/5.1/en/join.html).
Perhaps the message is a red herring and your trouble is elsewhere?
- michael dykman
On
Why is it that a field name that works fine for a JOIN is invalid in a
STRAIGHT JOIN?
mysql> show create table fldsndm;
+-+--
WW...
While uploading the database to a clean mysql, mysql 4.1.22 didn't even get
over 26 mb/s of writting speed, but I'm monitoring the speed mysql 5.5.3 is
reaching and can squeeze 100mb/s, averga I'm seeing like 35mb/s
22GB at mysql 4.1 lasted like 3 hours to fully load, this one I bel
It works great for me. After working out the bugs and adding the spatial
index I am now searching in the 0.05 second timeframe vs. minutes
otherwise.
Dan
On Sun, 2 May 2010 23:39:41 -0700, Rob Wultsch wrote:
>>>> >> >>> On Sat, May 1, 2
>>> >> >>> On Sat, May 1, 2010 at 11:12 PM, dan wrote:
>>> >> >>>
>>> >>
>>> >> Can any one help me with understanding the mysql spatial
>>> >> functions?
>>> >> I
>>> >> can
>>> >> only seem to find bits and pieces of how-to's etc.
>>> >>
>>> >> I have an exist
Ok... I am close I forgot an extra () in my POLYGON statement:
UPDATE `grid` SET lsd_poly = GeomFromText(CONCAT('POLYGON((',n,' ',e,',
',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,'))'));
(I also created a new GEOMETRY lsd_poly column rather than the poly POLYGON
one).
Now I nee
poly is a polygon but I have not added a spatial index yet.
Here's where it gets weird. I tried adding dummy data:
mysql> SET @bbox = 'POLYGON((0 0, 10 0, 10 10, 0 10, 0 0))';
Query OK, 0 rows affected (0.01 sec)
mysql> update grid set poly = GeomFromText(@bbox);
Query OK, 7876282 rows
Tried it but no luck:
mysql> UPDATE `grid` SET poly = GeomFromText(CONCAT('POLYGON(',n,' ',e,',
',s,' ',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')'));
Query OK, 0 rows affected (2 min 3.86 sec)
Rows matched: 7876282 Changed: 0 Warnings: 0
mysql> select poly from grid limit 10;
+--
I am still lost... I tried this:
UPDATE `grid` SET poly = PolygonFromText(CONCAT('POLYGON(',n,' ',e,', ',s,'
',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')'));
I had my delimiters mixed up and I know my CONCAT worked:
mysql> select CONCAT('POLYGON(',n,' ',e,', ',s,' ',e,', ',s,' ',w,', ',
Dan,
I think you are trying to create a polygon based on the values in
other columns in the same row. I think these other columns are named
`n` and so on.
Your mistake is that you are creating a text string, "POLYGON(..)"
and embedding column names inside it. That won't work. Those column
I have seen that but I am stuck at just populating my POLYGON column
(poly). I have tried this:
UPDATE `grid` SET poly = PolygonFromText('POLYGON(`n` `e`, `s` `e`, `s`
`w`, `n` `w`, `n` `e`)');
but my poly column just reports back NULL.
the n, e, s & w columns are decimal lat / long da
Can any one help me with understanding the mysql spatial functions? I can
only seem to find bits and pieces of how-to's etc.
I have an existing table of lat / long data representing unique boundaries
i.e. rectangles and I want to search the table to find the rectangle that
bounds a specific
On Sat, 01 May 2010 15:28:46 -0500, mos wrote:
>
> SELECT * FROM `grid`� force index(section) WHERE n > 49.012 AND s <
49.012
> AND e >
> 110.0244 AND w < 110.0244;
>
> It should give you the answer around 0.1 seconds. Give it a try. :-)
>
> Mike
It actually makes it worse by ab
On Fri, 30 Apr 2010 17:14:06 -0500, mos wrote:
> At 04:54 PM 4/30/2010, you wrote:
>
> Use Explain in front of your Select statement to see how many indexes it
is
mysql> explain SELECT * FROM `grid` WHERE n > 49.012 AND s < 49.012 AND e >
110.0244 AND w < 110.0244;
++-+-
At 04:54 PM 4/30/2010, you wrote:
I have a table with over 8 million rows of lat / long data all currently in
decimal(12,8) format (actually some in float(12,8)).
First question - should I have these all in decimal or float? I can't
think of any reason why I would actually do any math via mysq
1 - 100 of 1581 matches
Mail list logo
