Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varcar(21) for latitude,
and varchar(22) for longitude?
...Rene
It's not set, but I am streaming the LOG to the server, would max packet
impact this situation? Also, wouldn't I get a different error, i.e.
Packet Too Large?
From: Carlos Proal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 26, 2006 4:59 PM
To: Robert DiFalco
And whats the size of your "max_allowed_packet" variable ?
Carlos
On 4/26/06, Robert DiFalco <[EMAIL PROTECTED]> wrote:
>
> I am, the java heap is set to 2G. But I don't think it is my java
> process that is running out of memory, I believe it is the MySQL server.
>
>
> -Original Message---
I am, the java heap is set to 2G. But I don't think it is my java
process that is running out of memory, I believe it is the MySQL server.
-Original Message-
From: Carlos Proal [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 26, 2006 4:53 PM
Cc: mysql@lists.mysql.com
Subject: Re: Out of
Hi Robert, are you using the extended parameters to increase the jvm heap
memory ?
ie.
java -Xms256m -Xmx512m
Carlos
On 4/26/06, Robert DiFalco <[EMAIL PROTECTED]> wrote:
>
> Getting this error from JDBC while inserting a VERY large VARBINARY or
> MEDIUMTEXT field, ~250MB. I'm guessing th
I have a critical problem that I hope there is a simple solution for.
I've just spent a couple days converting a very messy "hack" to populate a
table using a much more elegant VIEW solution now.
Everything is going great, except now the whole point of this VIEW is so
that people using MS Access
Getting this error from JDBC while inserting a VERY large VARBINARY or
MEDIUMTEXT field, ~250MB. I'm guessing this is an error from the server?
Is there a way to have the server start streaming to disk sooner with a
LOB? Is there a property I'm not setting?
TIA,
R.
--
MySQL General Mailing L
Does anyone know where I mind find a table to look up alternate forms of
a certain given name? For example; if I give it Bob it gives me Robert
and if I give it Bill it gives me Will and William. Or if I give it
either Dick, Rick or Richard it gives me back the other two. Also, once
I have this
That is exactly the issue.
Also if you use the real address to determine the lat/lon instead of the zip
code, the result will be different.
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 6:55 PM
To: [EMAIL PROTECTED]; Daevi
I think I said that earlier, but the distance between two zip codes deal is
inaccurate, yet useful, for instance on a Classified Ads Web site.
As for the Zip+4, I do not know of any database that gives the latitude and
longitude for them specifically. But I am certain it has to exist.
The US Post
--- Patrick Aljord <[EMAIL PROTECTED]> wrote:
> On 4/26/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
> > I have a table confs like this:
> > id int 5 auto_increment primary key;
> > conf text;
> >
> > and another table conf_ip like this:
> > id int 5 auto_increment primary key;
> > conf_id int
yes it is true, you have to check if the constant CLIENT_MULTI_STATEMENT is
set or not.
basically this constant has for value 65536.
HTH
Alain
On 4/25/06, Juri Shimon <[EMAIL PROTECTED]> wrote:
>
> Hello Juri,
>
> Tuesday, April 25, 2006, 5:49:25 PM, you wrote:
>
> JS> mysql=mysql_init(NULL);
> J
On 4/26/06, Patrick Aljord <[EMAIL PROTECTED]> wrote:
> I have a table confs like this:
> id int 5 auto_increment primary key;
> conf text;
>
> and another table conf_ip like this:
> id int 5 auto_increment primary key;
> conf_id int 5; ==>foreing key of confs
> ip varchar 150;
>
ok, sorry all for
DBTools Software is pleased to announce the availability of the new
DBManager Professional 3.3.0 Enterprise Edition. This release brings a lot
of new features and lots of improvements and bug fixes. See the short list
below:
- New Visual Interface
- New Procedure Builder with support for Functions
--- Patrick Aljord <[EMAIL PROTECTED]> wrote:
> I have a table confs like this:
> id int 5 auto_increment primary key;
> conf text;
>
> and another table conf_ip like this:
> id int 5 auto_increment primary key;
> conf_id int 5; ==>foreing key of confs
> ip varchar 150;
>
> I would like to
> s
MySQL list,
I have a database on a server that contains English and Japanese text. I
have tried to ensure at every turn that all text encoding is in utf8.
On the web hosting server where the live site resides, everything is
working fine.
But on my testing environment at home, the Japanese t
David T. Ashley wrote:
Nigel wrote:
mod_php will persist the MySQL connection holding open any lock or
syncronisation token obtained through any of the three methods :
begin/commit, lock/unlock tables or get_lock/release_lock. PHP does
ensure that even in the event of timeouts or fatal e
The binary log will be available if you got setting the synronization
between server A and server B.
So to restore the db, server A can be use binary log in server B to
re-execute all the insert/update/delete/create/drop query in log. If log is
available since created the db then re-execute all th
Hi Payne,
Payne wrote:
Hey,
I got a box that is dying, it is currently running MySQL-Max, I want to
move the DB from it to a box that is running just plain jane MySQL, what
will happen and will it work.
I know, strange but I am not sure what the Max does.
we cannot tell either, as you do
clint lenard schrieb:
Hey guys,
Well, I was unable to find anything on Google and I don't expect to find a
miracle... but I figured "why not".
On Sunday morning I was trying to delete a Table through PHPMyAdmin and
well... I dropped the entire DB without backing it up before. Stupid
mistake, I
clint lenard schrieb:
Hey guys,
Well, I was unable to find anything on Google and I don't expect to find a
miracle... but I figured "why not".
On Sunday morning I was trying to delete a Table through PHPMyAdmin and
well... I dropped the entire DB without backing it up before. Stupid
mistake, I
Duzenbury, Rich wrote:
Hi all,
I've inherited an innodb database that is configured like:
innodb_file_per_table
innodb_data_file_path =
ibdata1:3000M;ibdata2:3000M;ibdata3:3000M;ibdata4:3000M:autoextend
Um, doesn't this allocate 12G that winds up being unused, since
innodb_file_per_table is se
Hi,
MySQL 5.1.9-beta, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at http://dev.mysql.com/downloads/ and mirror sites.
Note that not all
23 matches
Mail list logo
