RE: only myisam storage engine

2008-04-01 Thread rakesh.gupta1
Hi, Enter in my.cnf file [mysqld] skip-bdb skip-innodb Regards Rakesh -Original Message- From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 9:59 AM To: MySql Subject: only myisam storage engine Hi All, We have a linux box running debain, with 8 cpu and 8 GB RAM,

Perfomance of MYSQL

2008-02-19 Thread rakesh.gupta1
Hi, I am Using MySQL for GIS Data.I have to getting response time of each threads for retrival data by a JDBC Program with connection Polling . Here Initail Connection was 15. Maximum Connection was 50. My problem is that on 200 threads there response time is increasing abnormally ?. While

Need help to locate SetSRID(),Makebox2D(),Distance_Sphere()

2008-02-04 Thread rakesh.gupta1
Hi All I looking for the stated functions. Earlier I was using postGIS in that they are present i am wondering if I can get similar kind of method in MySql.I am Using Mysql 5.0.51a version. 1. I am trying to retrieve the distance between two geometries in the table using the following synta