an change size of InnoDB data and log files in my.cnf file.
But be careful. Use correct way.
http://www.innodb.com/ibman.php#Adding_and_removing
Mikhail.
- Original Message -
From: "Asif Iqbal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 23, 2004
On Fri, 23 Jan 2004, Mikhail Entaltsev wrote:
> Date: Fri, 23 Jan 2004 09:34:52 +0100
> From: Mikhail Entaltsev <[EMAIL PROTECTED]>
> To: Gregory Newby <[EMAIL PROTECTED]>, Asif Iqbal <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: data file too big
>
logs:
-bin.001
...
-bin.00N
Best regards,
Mikhail.
- Original Message -
From: "Gregory Newby" <[EMAIL PROTECTED]>
To: "Asif Iqbal" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 11:32 PM
Subject: Re: data file too big
>
I believe that this will flush those logs:
mysql> reset master;
-- Greg
On Thu, Jan 22, 2004 at 05:23:07PM -0500, Asif Iqbal wrote:
> Hi All
>
> My data file has all these files
>
> (root)@webrt:/usr/local/mysql/data# du -sh *
> 25K ib_arch_log_00
> 3.0Kib_arch_log_02
Hi All
My data file has all these files
(root)@webrt:/usr/local/mysql/data# du -sh *
25K ib_arch_log_00
3.0Kib_arch_log_02
3.0Kib_arch_log_04
101Mib_logfile0
101Mib_logfile1
1.9Gibdata1
1.5Gibdata2
2.0Kmy.cnf
70K mysql
2.0Knewdb
39M
