Not an expert, but:
2009/11/14 Krishna Chandra Prajapati :
> I would like to know how optimize table work internally. A table contains
> 200 millions records. Whether query performance will be faster after
> deletion of 30 million records from this table or not.
Use of OPTIMIZE TABLE varies from
Hi Ananda,
1. Long term solution: When you upgrade to MySQL 5.1 partition the table
e.g. by time. This approach was used for 10s of years in the other DBs.
http://dev.mysql.com/tech-resources/articles/performance-partitioning.ht
ml
http://dev.mysql.com/tech-resources/articles/mysql_5.1_partition
phiLLip
Paul DuBois <[EMAIL PROTECTED]>
11/03/2005 12:11 AM
To
[EMAIL PROTECTED], mysql@lists.mysql.com
cc
Subject
Re: optimize table on live database
At 14:08 -0500 11/2/05, [EMAIL PROTECTED] wrote:
Hello,
I've been looking for information related to best practice on how t
e? I don't
remember the particular tablesize at that time, but it could easily get
to be around 1 gig or more.
Any suggestions?
Your friendly neighborhood SA,
phiLLip
Paul DuBois <[EMAIL PROTECTED]>
11/03/2005 12:11 AM
To
[EMAIL PROTECTED], mysql@lists.mysql.com
cc
Subject
Re: o
At 14:08 -0500 11/2/05, [EMAIL PROTECTED] wrote:
Hello,
I've been looking for information related to best practice on how to
OPTIMIZE TABLE with out taking the database offline. I
understand that it is not good to run an optimize while the database is
being used. So what is a good way of handli
Hello.
Use OPTIMIZE NO_WRITE_TO_BINLOG syntax. See:
http://dev.mysql.com/doc/mysql/en/optimize-table.html
"Mike Debnam" <[EMAIL PROTECTED]> wrote:
> I issued a optimize table statement on my master which failed with a "lock
> wait timeout" message due to some competing queries runnin
Christopher M Bergeron <[EMAIL PROTECTED]> wrote:
> Does anyone know of any guidelines or references that I can refer to
> with regard to how long it takes to Optimize tables? I'm running on a
> 3GHz x86 [single] processor box with SCSI RAID and lots of ram. The
> Mysql db files are approx. 35G (u
On Fri, May 14, 2004 at 04:29:29PM -0500, Dan Nelson wrote:
> In the last episode (May 14), Jeremy Zawodny said:
> > On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
> > > Actually, if you are using 4.1.1 optimize table does get passed to
> > > the slave. This is from the 4.1.1 chan
Yes.
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 14, 2004 4:26 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'Jim'
> Subject: Re: OPTIMIZE TABLE and mySQL replication
>
> On Fri, May 14, 2004 at 03:2
It surprised me at first, but then I was actually happy about it.
Donny
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 14, 2004 4:26 PM
> To: Donny Simonton
> Cc: [EMAIL PROTECTED]; 'Jim'
> Subject: Re: OPTIMIZE
In the last episode (May 14), Jeremy Zawodny said:
> On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
> > Actually, if you are using 4.1.1 optimize table does get passed to
> > the slave. This is from the 4.1.1 change log.
> >
> > ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FL
On Fri, May 14, 2004 at 03:26:28PM -0500, Donny Simonton wrote:
> Actually, if you are using 4.1.1 optimize table does get passed to the
> slave. This is from the 4.1.1 change log.
>
> ANALYZE TABLE, OPTIMIZE TABLE, REPAIR TABLE, and FLUSH statements are now
> stored in the binary log and thus re
Jeremy Zawodny wrote:
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
Hi List,
What are some issues relating to using OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
passed on to the slaves?
It does not. The command doesn't replicate
[EMAIL PROTECTED]
> Sent: Friday, May 14, 2004 2:46 PM
> To: Jim
> Cc: [EMAIL PROTECTED]
> Subject: Re: OPTIMIZE TABLE and mySQL replication
>
> On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
> > Hi List,
> >
> > What are some issues relating to using OPTIMI
On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote:
> Hi List,
>
> What are some issues relating to using OPTIMIZE TABLE and replication?
> Does running OPTIMIZE TABLE on a master DB cause the optimizations to be
> passed on to the slaves?
It does not. The command doesn't replicate.
--
Jerem
In the last episode (May 14), Dan Nelson said:
> In the last episode (May 14), Jim said:
> > What are some issues relating to using OPTIMIZE TABLE and
> > replication? Does running OPTIMIZE TABLE on a master DB cause the
> > optimizations to be passed on to the slaves?
>
> Yes, unless you add the
In the last episode (May 14), Jim said:
> What are some issues relating to using OPTIMIZE TABLE and
> replication? Does running OPTIMIZE TABLE on a master DB cause the
> optimizations to be passed on to the slaves?
Yes, unless you add the "LOCAL" flag to optimize.
http://dev.mysql.com/doc/mysql/
On Tue, Feb 04, 2003 at 01:27:13PM +0200, Okan CIMEN wrote:
> Hi all,
>
> First of all , the version of mysql is 3.23.52. I am using When I do a
> truncate table on a MyIsam table, the show table command shows thatt there
> are no records but the table size is about 100 MBs.
>
> Afterwards, I run
PROTECTED]
Subject: Re: Optimize Table usage
On Sat, 4 Jan 2003 21:25:03 -0500, Dan Cumpian wrote:
>1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE
>TableName command?
From Delphi help: "Use ExecSQL to execute queries that do not
return a cursor to data (s
On Sat, 4 Jan 2003 21:25:03 -0500, Dan Cumpian wrote:
>1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE
>TableName command?
From Delphi help: "Use ExecSQL to execute queries that do not
return a cursor to data (such as INSERT, UPDATE, DELETE, and CREATE
TABLE)."
>2) The
On Mon, Nov 18, 2002 at 10:14:19PM -0700, Mark Stringham wrote:
> Howdy -
>
> I have heard that periodically optimizing tables can be helpful in the
> overall maintenance of the table space in the db. Is this correct and how
> often should it be done?
Depends how frequently the data in the table
21 matches
Mail list logo
