Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

2010-05-03 Thread Rob Wultsch
On Sat, May 1, 2010 at 11:12 PM, dan d...@tappin.ca 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 existing table of lat / long data representing unique boundaries

4- Question

2010-05-03 Thread Junior Ortis
Hi guys, i have a server with 20GB InnoDb on a single database and i use just one user for its. I use mysql 5.4 1- If i change my SCSI 15k RPM to a SSD i will increase my performance ? 2- What is the fast method to a backup to this InnoDB database ? And the more easy ? And how i restore its ?

Re: 4- Question

2010-05-03 Thread Rob Wultsch
On Sun, May 2, 2010 at 11:50 PM, Junior Ortis jror...@gmail.com wrote: Hi guys, i have a server with 20GB InnoDb on a single database and i use just one user for its. I use mysql 5.4 1- If i change my SCSI 15k RPM to a SSD i will increase my performance ? Umm, maybe. More information is

Re: mysql spatial functions (Was: Best index for searching on lat / long data i.e. decimal vs. float)

2010-05-03 Thread dan
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 wult...@gmail.com wrote: On Sat, May 1, 2010 at 11:12 PM, dan d...@tappin.ca wrote:

capacity planning.

2010-05-03 Thread raju.sakineti
HI everyone, could somebody help me on how to do capacity planning for mysql databases. if anyone have documentation please provide me. thanksregards varma

Re: capacity planning.

2010-05-03 Thread Rob Wultsch
On Mon, May 3, 2010 at 11:20 AM, raju.sakineti anjaneyara...@gmail.com wrote: HI everyone,             could somebody help me on how to do capacity planning for mysql databases. if anyone have documentation please provide me. thanksregards varma

mysql transaction log

2010-05-03 Thread Angelina Paul
Please help me to understand more about the mysql transaction log ( mysqlbinlog) file and its contents. Will it support only the innodb or all the storage engine types like MyISAM, InnoDB? Thanks, Arsh Paul