mysql5.1新特性--misc1

cocolala

1, external-locking

# Enable external file level locking. Enabled file locking will have a
# negative impact on performance, so only use it in case you have
# multiple database instances running on the same files (note some
# restrictions still apply!) or if you use other software relying on
# locking MyISAM tables on file level.
#external-locking

--看來mysql也可以做到像oracle一樣，由多個(gè)實(shí)例訪問同一份數(shù)據(jù)文件
--通過外部的file lock來實(shí)現(xiàn)，會(huì)降低性能

When MySQL is compiled using MIT-pthreads, system locking is disabled by default for performance reasons. You can tell the server to use system locking with the --external-locking option. This is needed only if you want to be able to run two MySQL servers against the same data files, but that is not recommended, anyway.


2, 從源碼編譯二進(jìn)制文件時(shí)重新configure的注意事項(xiàng)
The solution to many problems involves reconfiguring. If you do need to reconfigure, take note of the following:
If configure is run after it has previously been run, it may use information that was gathered during its previous invocation. This information is stored in config.cache. When configure starts up, it looks for that file and reads its contents if it exists, on the assumption that the information is still correct. That assumption is invalid when you reconfigure.
Each time you run configure, you must run make again to recompile. However, you may want to remove old object files from previous builds first because they were compiled using different configuration options.
To prevent old configuration information or object files from being used, run these commands before re-running configure:
shell> rm config.cache
shell> make clean
Alternatively, you can run make distclean.
從源碼configure,make編譯成binary時(shí)
如果需要改變配置重新來一次，需要?jiǎng)h除config.cache,及老的二進(jìn)制對(duì)像文件

3, 對(duì)于myisam引擎的表,如果更改了表的字符集,需要用myisamchk修復(fù)表與索引數(shù)據(jù)，使一致!

If you change character sets after having created any tables, you must run myisamchk -r -q --set-collation=collation_name on every MyISAM table. Your indexes may be sorted incorrectly otherwise. This can happen if you install MySQL, create some tables, and then reconfigure MySQL to use a different character set and reinstall it.

本文來自ChinaUnix博客，如果查看原文請(qǐng)點(diǎn)：http://blog.chinaunix.net/u2/67276/showart_724674.html