Not an expert, but:
2009/11/14 Krishna Chandra Prajapati prajapat...@gmail.com:
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
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
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: optimize table on live
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 to
OPTIMIZE TABLE table name
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 table name 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
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 running at
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
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.
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 LOCAL
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.
--
Jeremy D.
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 OPTIMIZE TABLE and replication?
Does running OPTIMIZE TABLE
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
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
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 FLUSH
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 TABLE and mySQL replication
On Fri
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:26:28PM -0500, Donny Simonton wrote:
Actually
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 change log.
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 an
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
]
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 (such as INSERT, UPDATE, DELETE
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