MySQL Forums
Forum List  »  Docs

Re: MySQL Date File Size's problem
Posted by: john chan
Date: August 26, 2005 02:02AM

1) Orginal Database

drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3223322624 Aug 25 17:08 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:08 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Jun 25 11:12 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 79 Aug 25 17:08 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 1373 Aug 25 17:08 localhost.localdomain.er
r
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pi
d
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Jun 23 18:42 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test
[root@localhost mysql]# df -d
df: invalid option -- d
Try `df --help' for more information.
[root@localhost mysql]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda6 37G 6.4G 29G 19% /
none 236M 0 236M 0% /dev/shm

2) Truncate table

total 3161220
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3223322624 Aug 25 17:39 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:39 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:39 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 144 Aug 25 17:39 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 1373 Aug 25 17:08 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Jun 23 18:42 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test


3) Restore table

drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3231711232 Aug 25 17:48 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:48 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:47 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 16850461 Aug 25 17:47 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 1373 Aug 25 17:08 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 17:46 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test

4) Truncate table

total 3185896
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3231711232 Aug 25 17:48 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:48 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:47 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 16850461 Aug 25 17:47 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 1373 Aug 25 17:08 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 17:46 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test
[root@localhost mysql]# ls -all


4) Restore table

total 3185896
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3231711232 Aug 25 17:58 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:58 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 17:58 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 16850526 Aug 25 17:58 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 1951 Aug 25 17:58 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 17:46 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test


5) Truncate table

total 3202368
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3231711232 Aug 25 18:00 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:00 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:00 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 33700843 Aug 25 18:00 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 1951 Aug 25 17:58 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 17:59 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test


6) Restore table

total 3210568
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3240099840 Aug 25 18:03 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:03 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:02 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 33700908 Aug 25 18:02 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 2529 Aug 25 18:02 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 17:59 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test

7) Truncate table

total 3227040
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3240099840 Aug 25 18:04 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:04 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:04 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 50551225 Aug 25 18:04 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 2529 Aug 25 18:02 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 18:03 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test

8) Restore table

total 3227040
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3240099840 Aug 25 18:06 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:06 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:06 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 50551290 Aug 25 18:05 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 3107 Aug 25 18:05 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 18:03 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test


9) Truncate table

total 3227040
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3240099840 Aug 25 18:06 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:06 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:06 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 50551290 Aug 25 18:05 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 3107 Aug 25 18:05 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 18:03 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test

[root@localhost mysql]# ls -all


10) Restore table

total 3243512
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3240099840 Aug 25 18:10 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:10 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:10 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 67401607 Aug 25 18:10 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 3107 Aug 25 18:05 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 18:09 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test

11) Truncate table

total 3251712
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3248488448 Aug 25 18:13 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:13 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:13 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 67401672 Aug 25 18:13 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 3396 Aug 25 18:12 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 18:09 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test

12) Restore table

total 3268184
drwxr-xr-x 5 mysql root 4096 Aug 25 17:08 .
drwxr-xr-x 15 root root 4096 Jun 23 14:48 ..
-rw-rw---- 1 mysql mysql 3248488448 Aug 25 18:15 ibdata1
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:15 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Aug 25 18:15 ib_logfile1
-rw-rw---- 1 mysql mysql 79 Jun 24 11:23 localhost-bin.000001
-rw-rw---- 1 mysql mysql 79 Jun 25 10:13 localhost-bin.000002
-rw-rw---- 1 mysql mysql 79 Jun 25 10:24 localhost-bin.000003
-rw-rw---- 1 mysql mysql 79 Jun 25 10:34 localhost-bin.000004
-rw-rw---- 1 mysql mysql 79 Jun 25 10:40 localhost-bin.000005
-rw-rw---- 1 mysql mysql 79 Jun 25 10:56 localhost-bin.000006
-rw-rw---- 1 mysql mysql 79 Jun 25 11:04 localhost-bin.000007
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000008
-rw-rw---- 1 mysql mysql 79 Jun 25 11:05 localhost-bin.000009
-rw-rw---- 1 mysql mysql 79 Jun 25 11:06 localhost-bin.000010
-rw-rw---- 1 mysql mysql 79 Jun 25 11:07 localhost-bin.000011
-rw-rw---- 1 mysql mysql 79 Jun 25 11:10 localhost-bin.000012
-rw-rw---- 1 mysql mysql 79 Jun 25 11:11 localhost-bin.000013
-rw-rw---- 1 mysql mysql 2750 Jun 25 11:28 localhost-bin.000014
-rw-rw---- 1 mysql mysql 79 Aug 14 03:08 localhost-bin.000015
-rw-rw---- 1 mysql mysql 84251989 Aug 25 18:15 localhost-bin.000016
-rw-rw---- 1 mysql mysql 368 Aug 25 17:08 localhost-bin.index
-rw-rw---- 1 mysql root 3396 Aug 25 18:12 localhost.localdomain.err
-rw-rw---- 1 mysql mysql 5 Aug 25 17:08 localhost.localdomain.pid
-rw-rw---- 1 mysql mysql 160 Jun 24 11:23 localhost-slow.log
drwx------ 2 mysql mysql 4096 Aug 25 18:14 mmgame
drwx--x--x 2 mysql root 4096 Jun 23 14:48 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 25 17:08 mysql.sock
drwxr-xr-x 2 mysql root 4096 Jun 23 14:48 test

Options: ReplyQuote


Subject
Views
Written By
Posted
4116
August 26, 2005 01:49AM
Re: MySQL Date File Size's problem
3356
August 26, 2005 02:02AM
2696
August 26, 2005 02:03AM
2556
August 26, 2005 06:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.