I don't think this is indicative of a design issue. Some tables need
data removed more often than others, however Moon's Father brings up an
excellent point. If you CAN resolve this with a change in design, that
would be the best solution of course.
-Micah
On 11/17/2008 06:50 PM, Moon's Father wr
There is little performance hit due to this. It would only start to
affect performance when the overhead started to increase to the point
that it was a significant percentage of the total table size. Perhaps
someone else can ring in here with real numbers but I'd say it'd have to
be 10-20% of your
Maybe your tables were not properly designed.
On Tue, Nov 18, 2008 at 10:35 AM, sangprabv <[EMAIL PROTECTED]> wrote:
> Thanks for the reply, does this overhead reduce performance? And is
> there any tips to avoid this overhead? TIA.
>
>
> WM
>
>
> --
> MySQL General Mailing List
> For list archiv
Yeah, it's really a nice tool for me.
Thanks.
On Tue, Nov 18, 2008 at 5:44 AM, Saravanan <[EMAIL PROTECTED]> wrote:
> really nice tool.
>
> Thanks,
> Saravanan
>
> --- On Mon, 11/17/08, lakshmi pathi <[EMAIL PROTECTED]> wrote:
>
> From: lakshmi pathi <[EMAIL PROTECTED]>
> Subject: A tool
> To: my
Seems fine to me, i guess the problem is somewhere else.
Maybe you should try a full trace in Eclipse to detect the issue.
Carlos
jean claude babin wrote:
Hello,
I'm using Eclipse 3.3 and I use a model class HandlereplyModel.java to
insert values to a mysql database using mysql5.0 server.Whe
Thanks for the reply, does this overhead reduce performance? And is
there any tips to avoid this overhead? TIA.
WM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Mon, Nov 17, 2008 at 7:56 PM, sangprabv <[EMAIL PROTECTED]> wrote:
> Hi,
> I just want to know what things that cause table/db overhead? Because I
> have my tables always get overhead problem. And must run OPTIMIZE query
> every morning. Is there any other solution? TIA.
>
>
> Willy
What is hap
Deleted rows.
On 11/17/2008 04:56 PM, sangprabv wrote:
> Hi,
> I just want to know what things that cause table/db overhead? Because I
> have my tables always get overhead problem. And must run OPTIMIZE query
> every morning. Is there any other solution? TIA.
>
>
> Willy
>
>
>
--
MySQL Genera
Hi,
I just want to know what things that cause table/db overhead? Because I
have my tables always get overhead problem. And must run OPTIMIZE query
every morning. Is there any other solution? TIA.
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
Hello,
I'm using Eclipse 3.3 and I use a model class HandlereplyModel.java to
insert values to a mysql database using mysql5.0 server.When I run my
application, I got duplicate values everytime I enter a record.
my java class is :
import java.sql.Connection;
import java.sql.DriverManager;
import
really nice tool.
Thanks,
Saravanan
--- On Mon, 11/17/08, lakshmi pathi <[EMAIL PROTECTED]> wrote:
From: lakshmi pathi <[EMAIL PROTECTED]>
Subject: A tool
To: mysql@lists.mysql.com
Date: Monday, November 17, 2008, 1:25 PM
Hi all,
If you are using mysql in linux with ext3 file system,then this
Jerry Schwartz wrote:
> If all you want to do is to restrict a field to certain values, and aren't
> concerned with cascading operations, is a set more efficient than a foreign
> key?
>
> Regards,
>
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farming
> >> If all you want to do is to restrict a field to certain values, and
> >aren't
> >> concerned with cascading operations, is a set more efficient than a
> >foreign
> >> key?
> >
> >A Set or Enum?
> >
> >I can understand "enum"s, but sets are evil.
> >
> [JS] Why is that? I've been using sets, b
>-Original Message-
>From: Martijn Tonies [mailto:[EMAIL PROTECTED]
>Sent: Monday, November 17, 2008 12:13 PM
>To: 'mysql'
>Subject: Re: normalised designs: customer database
>
>
>
>> If all you want to do is to restrict a field to certain values, and
>aren't
>> concerned with cascading o
> If all you want to do is to restrict a field to certain values, and aren't
> concerned with cascading operations, is a set more efficient than a
foreign
> key?
A Set or Enum?
I can understand "enum"s, but sets are evil.
Martijn Tonies
Database Workbench Lite for MySQL - FREE developer tool f
If all you want to do is to restrict a field to certain values, and aren't
concerned with cascading operations, is a set more efficient than a foreign
key?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.6
Hi,
I am getting copies of your email...I don't know why...Can you fix this
problem..
Kind regards,
Matthew
- Original Message -
From: "Mark Goodge" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Monday, November 17, 2008 10:14 AM
Subject: Re: Optimizing nullable expiration dates
Norman
Norman Elton wrote:
I've got a table that tracks expiration dates. Currently, if the
record hasn't expired, the column is stored as NULL. In order to find
records that haven't expired, I search for "WHERE expire_at > NOW() OR
expire_at IS NULL". This seems dirty, and I suspect it makes my
index
I've got a table that tracks expiration dates. Currently, if the
record hasn't expired, the column is stored as NULL. In order to find
records that haven't expired, I search for "WHERE expire_at > NOW() OR
expire_at IS NULL". This seems dirty, and I suspect it makes my
indexes very angry.
I suppos
Hi
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website data. Basically we have 2 websites located in
the UK and US which share similar information, and we are going to be using
r
> >> I may just have had an insight over my morning coffee.
> >> How about turning things around and adding a FK -to the customers
table-
> >> on each of the customer type tables (companies, people, charities, etc)
?
> >>
> >> The customers table would have no idea if a customer is corporate or
>
>>> >The notion of a "variant record" exists in many programming languages.
>>> >Typically you have a selector to indicate which variant it is. There
is
>>> >nothing at all wrong with using the same sort of construct in a
database
>>> >table.
>>> >http://en.wikipedia.org/wiki/Variant_record
>
Tried increasing the "wait_timeout" variable and restart the instance?
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
Let us know -
1) your my.ini settings.
2) the options you are giving while taking the dump.
Regards,
Uma
On 11/17/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
>
>
23 matches
Mail list logo
