4

currently I'm using PostgreSQL/PostGIS for a small spatial project. Last week the project manager asked me if we could migrate to MySQL with Spatial Extension.

I know MySQL but have no experience with the Spatial Extension. I heard that the extension is not very fast and might contain some bugs.

Now my question - is MySQL Spatial extension stable and fast enough to be considered for an online database with about 20000 spatial operations a day?

The operations are just the standard stuff like: - export to KML - point in polygon - overlapping polygon

The database has one GB of spatial data.

  • No the MySQL Spatial Extension is still in development. You will find your current POSTGIS version more stable and more spatial functions than the MYSQL Spatial. see mysqlperformanceblog.com/2013/10/21/… You can still test it on a test environment – Mapperz Feb 4 '14 at 21:01
  • @Mapperz: Care to (expand and) post that as an answer, please? – Martin F Feb 4 '14 at 21:10
  • Is "SOPD spatial operations per day" enough info? What about "CUPM concurrent users per minute" and "SOPM spatial operations per minute"? I'm not sure how I would use the different info -- i'm just wondering if there are more rigorous/standard benchmarks for assessing performance. – Martin F Feb 4 '14 at 21:16
  • It might help if we knew why the PM wanted to move away from PostGIS to another solution (in this case MySQL). I have trouble believing any experienced project manager would want to change infrastructure without a sound reason. What are you hoping to achieve? – BradHards Feb 4 '14 at 23:13
  • @martin f, I don't know which indicators are best for this question, I just wanted to provide a rough picture about the type and load of the implemented application. The SOPM should be around 100 and the 'CUPM'at about 30 in peak hours - so nothing serious. – ABX Feb 5 '14 at 8:08
0

Thanks Mapperz, the link helped to get a feeling about the status of the spatial plugin.

http://www.mysqlperformanceblog.com/2013/10/21/using-the-new-spatial-functions-in-mysql-5-6-for-geo-enabled-applications/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.