search

krandalf75 / MySQL-Spatial-UDF

MySQL Spatial User Defined Functions
http://krandalf75.github.io/MySQL-Spatial-UDF/
GNU General Public License v3.0
10 stars 4 forks source link

Crash due to memory leak? #7

Open biodiv opened 10 years ago

biodiv commented 10 years ago

When I call functions like ST_Centroid or ST_ConvexHull on smaller Polygons mysql crashes. Query:

SELECT count(*), AsText( mysql.ST_Centroid(coordinates)) 
FROM TABLE WHERE coordinates IS NOT NULL 
AND Within( coordinates, GeomFromText( 'POLYGON ((-22.5000000000000000 61.6063959999999966, -22.5000000000000000 55.7765729999999991, -33.7500000000000000 55.7765729999999991, -33.7500000000000000 61.6063959999999966, -22.5000000000000000 61.6063959999999966))' ) )

Is it possible to allocate more memory to those functions? I alreade increased the values in my.cnf but without success.

krandalf75 commented 10 years ago

Hi, I think that decreasing the values of my.cnf you give more options to the library to get more memory. How did you deduce that it was a memory problem ?

Have you made any test with small table ? Perhaps it's a problem with an specific geometry ..