Jun 10 2008

Tales of the past III

Category: Gamesssmax @ 17:17:37



远古传说3【Tales of the Past III】 内嵌字幕中文版在线观看放出!感谢 卢西尼奥 翻译!

[ http://wow.17173.com/videofile/2007-12-14/20071214131111348.shtml ]


[ http://wow.17173.com/videofile/2007-08-21/20070821173626827.shtml ]

[ http://wow.17173.com/videofile/2006-06-26/20060626164030109.shtml ]

远古3视频全部音乐列表(fakejehuty 提供)
Pirates of the Caribbean 3 – 03 At Wit’s End
10 – In Search of the Grail
Theme – Good, The Bad, And The Ugly
Pirates of the Caribbean 3 – 11 I Don’t Think Now Is The Best Time
Saw Soundtrack – Final theme
Star Wars Episode II – Attack Of The Clones – 02 – Across The Stars (Love
Naruto OST – 08 Sadness and Sorrow
Naruto – Strong And Strike
Naruto – Main Theme
Warcraft 3 – Comradeship
Lord of The Rings – Main Theme
Pirates of the Caribbean 3 – 05 Up Is Down
Coco Lee – A Love Before Time (Mandarin)
01 – Moya
Metal Gear Solid 3 – Snake Eater (Soundtrack) – 211 – Norihiko Hibino – Last
Metal Gear Solid 3 – Snake Eater (Soundtrack) – 210 – Harry Gregson –
Williams – Lifes End
King Arthur Soundtrack – 05-Another Brick in Hadrian’s Wall
Nightwish – End Of All Hope

Jun 10 2008


Category: 技术ssmax @ 13:02:57

ibdata1这个垃圾文件除了reload整个database是没办法缩小的了,每个table用不同的索引文件看上去会舒服一点。。。 Using Per-Table Tablespaces

You can store each InnoDB table and its indexes in its own file. This feature is called “multiple tablespaces” because in effect each table has its own tablespace.

Using multiple tablespaces can be beneficial to users who want to move specific tables to separate physical disks or who wish to restore backups of single tables quickly without interrupting the use of the remaining InnoDB tables.

You can enable multiple tablespaces by adding this line to the [mysqld] section of my.cnf:


After restarting the server, InnoDB stores each newly created table into its own file tbl_name.ibd in the database directory where the table belongs. This is similar to what the MyISAM storage engine does, but MyISAM divides the table into a data file tbl_name.MYD and the index file tbl_name.MYI. For InnoDB, the data and the indexes are stored together in the .ibd file. The tbl_name.frm file is still created as usual.

If you remove the innodb_file_per_table line from my.cnf and restart the server, InnoDB creates tables inside the shared tablespace files again.

innodb_file_per_table affects only table creation, not access to existing tables. If you start the server with this option, new tables are created using .ibd files, but you can still access tables that exist in the shared tablespace. If you remove the option and restart the server, new tables are created in the shared tablespace, but you can still access any tables that were created using multiple tablespaces.


InnoDB always needs the shared tablespace because it puts its internal data dictionary and undo logs there. The .ibd files are not sufficient for InnoDB to operate.


You cannot freely move .ibd files between database directories as you can with MyISAM table files. This is because the table definition that is stored in the InnoDB shared tablespace includes the database name, and because InnoDB must preserve the consistency of transaction IDs and log sequence numbers.

To move an .ibd file and the associated table from one database to another, use a RENAME TABLE statement:

RENAME TABLE db1.tbl_name TO db2.tbl_name;

If you have a “clean” backup of an .ibd file, you can restore it to the MySQL installation from which it originated as follows:

  1. Issue this ALTER TABLE statement:


    This statement deletes the current .ibd file.

  2. Put the backup .ibd file back in the proper database directory.
  3. Issue this ALTER TABLE statement:

In this context, a “clean.ibd file backup means:

  • There are no uncommitted modifications by transactions in the .ibd file.
  • There are no unmerged insert buffer entries in the .ibd file.
  • Purge has removed all delete-marked index records from the .ibd file.
  • mysqld has flushed all modified pages of the .ibd file from the buffer pool to the file.

You can make a clean backup .ibd file using the following method:

  1. Stop all activity from the mysqld server and commit all transactions.
  2. Wait until SHOW ENGINE INNODB STATUS shows that there are no active transactions in the database, and the main thread status of InnoDB is Waiting for server activity. Then you can make a copy of the .ibd file.

Another method for making a clean copy of an .ibd file is to use the commercial InnoDB Hot Backup tool:

  1. Use InnoDB Hot Backup to back up the InnoDB installation.
  2. Start a second mysqld server on the backup and let it clean up the .ibd files in the backup.